I am using tempo records on entity has more than 2000 rows when tried retrieve i

aasuliman over 9 years ago

I am using tempo records on entity has more than 2000 rows when tried retrieve it i have error i does not display any thing

error massage :

[http-/0.0.0.0:8080-8] ERROR org.hibernate.util.JDBCExceptionReporter - The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.

Discussion posts and replies are publicly visible

0 vinishaan over 9 years ago

Hi aasuliman,

Can you please refer this link. Hope this will be helpful to you.
forum.appian.com/.../e-132389
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandhinir over 9 years ago

Hi, If you have used the filters using "IN" operator, then you will get this error. It is due to the configuration on the SQL Server side, and the maximum is 2100:Please find the below link for more details.
msdn.microsoft.com/.../ms143432.aspx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aasuliman over 9 years ago

thank you chandhinir ..I am using "IN" Operator ....

is there to create records with datastore have more than 5000 rows?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandhinir over 9 years ago

You can create the record as entity backed record type by setting the proper filters in the record.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aasuliman over 9 years ago

I did not get your idea clearly.

I am using record with entity backed and the error happen when the default filter that contains IN operator try to apply on all 5000 rows

Can you give exampleb please
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandhinir over 9 years ago

Passing the data to the "IN" operator will cause the above error. To resolve the issue, We created a new view based on the requirement and filtered the data from records using "=" operator which will pass only one data to the filters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aasuliman over 9 years ago

thank you chandhinir ....
can you give me an example how can we use "=" opreator to filter records
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandhinir over 9 years ago

Please look into the below link how to use the record filters.
forum.appian.com/.../Record_Design.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aasuliman over 9 years ago

I have read this link..it does not show how can use "=" operator...as you now in default filter you can not passing the record id ,so you can not use "=" operator
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel