SQL-Error 6522 in report definition
SummaryWhen 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.
at System.Data.SqlServer.Internal.CXVariantBase.StringToWSTR(String pstrValue, Int64 cbMaxLength, Int32 iOffset, EPaddingePad)
Steps to ReproduceRun report definition on blob properties.
Root CauseA defect or configuration issue in the operating environment. By default Pega restricts some amount of data to be retrieved from blob.
ResolutionHere’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.
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