Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
US
Posted: Feb 28, 2018
Last activity: Mar 12, 2018
Last activity: 12 Mar 2018 10:41 EDT
Closed
Solved
An error occured on executing the query for the report definition
Hi All,
While i was running the report in Production, i see the below error. Can anyone please tell me whats the issue.
Show More
Hi All,
While i was running the report in Production, i see the below error. Can anyone please tell me whats the issue.
Error:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 6522 SQLState: S0001 Message: A .NET Framework error occurred during execution of user-defined routine or aggregate "pr_read_from_stream": System.Data.SqlServer.TruncationException: Trying to convert return value or output parameter of size 2894 bytes to a T-SQL type with a smaller size limit of 2000 bytes. System.Data.SqlServer.TruncationException: at System.Data.SqlServer.Internal.CXVariantBase.StringToWSTR(String pstrValue, Int64 cbMaxLength, Int32 iOffset, EPadding ePad) . DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error occurred during execution of user-defined routine or aggregate "pr_read_from_stream": System.Data.SqlServer.TruncationException: Trying to convert return value or output parameter of size 2894 bytes to a T-SQL type with a smaller size limit of 2000 bytes. System.Data.SqlServer.TruncationException: at System.Data.SqlServer.Internal.CXVariantBase.StringToWSTR(String pstrValue, Int64 cbMaxLength, Int32 iOffset, EPadding ePad) . | SQL Code: 6522 | SQL State: S0001
Show Less