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, EPaddingePad)


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


0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.