Nalins_99 Member since 2015 29 posts
Deloitte Consulting LLP
Posted: 2 years ago
Last activity: 2 years 4 months ago

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