Question

2
Replies
3062
Views
ShravyaS1954 Member since 2016 3 posts
Posted: 2 years ago
Last activity: 2 years 6 months ago
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.

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
Reporting
Moderation Team has archived post
Share this page LinkedIn