Support Article
SQL-Error 6522 in report definition
SA-38584
Summary
When running the report definition with unexposed properties getting an SQL error.
Error Messages
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 3422 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)
Steps to Reproduce
Run report definition on blob properties.
Root Cause
A defect or configuration issue in the operating environment. By default Pega restricts some amount of data to be retrieved from blob.
Resolution
Here’s the explanation for the reported behavior:
This is a common issue faced by most users when trying to fetch huge amount of data in a report definition specifically when extracting from blob column. Below is one similar article shared for users on Oracle database.
https://pdn.pega.com/support-articles/error-while-running-report-definition-post-upgrade
However the recommended suggestion is to optimize the property and use so that we do not face any performance impact but in this case cannot be done as it is Out-of-the-box (OOTB) property.
Property pyJavaSource is under Rule-Parse-Transform class. Rule-Parse-Transforms are deprecated from Pega 7 onwards.
Published October 2, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.