Nalina Ravibiruthoji (Nalins_99)
Deloitte Consulting LLP
Pega Developer
Deloitte Consulting LLP
Nalins_99 Member since 2015 29 posts
Deloitte Consulting LLP
Posted: May 9, 2018
Last activity: May 14, 2018
Posted: 9 May 2018 14:57 EDT
Last activity: 14 May 2018 9:37 EDT

Report Definition error in retreiving large string data


We have to run a report definition on a data class, in which one of the property stores a RTE of 5000 characters. When RD is run we get the 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 5066 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)

We are not sure, where this size is specified and if we can change it or how to handle this?

When we run an activity Obj-Open-by-handle, we are getting back the content for the property.

Any help is appreciated. Thank you

User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.