Issue
While trying to obtain the version history of a document which has 1000 or more versions in it the following error message is displayed.
Error Code: 1501
SQL error.
Stack Trace com.xerox.docushare.db.DatabaseException: Reading property descriptions from DSProp_table table: ; nested exception is:
java.sql.SQLException: [Docushare][SQLServer JDBC Driver][SQLServer]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.
Reason / Cause
The error will occur whenever a user performs an operation that determines how many objects a user owns and the result of the operation determines the user owns more than 2100 objects in SQL or 1000 on Oracle. Example operations include Delete User or when trying to obtain the version history of a document.
Note: The limit varies according to the database used. For example, if the database is SQL server then the maximum limit is 2100, if the database is Oracle the maximum limit is 1000.
Solution
This issue has been resolved in DocuShare version 6.5.3.
Solution Published: May 4, 2011
Solution ID: 828