Support Article
Cannot execute report definition
SA-4358
Summary
When attempting to run a report definition rule the following error is produced:
(nList.Assign_WorkBasket.Action) ERROR servername1|clientname1 UserName1 - in db exception 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.IndexOutOfRangeException: Index was outside the bounds of the array.
System.IndexOutOfRangeException:
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at com.pega.pegarules.data.udf.directstreamreader.FixedCacheMap.put(String aKey, CachedDirectStream aStream)
at com.pega.pegarules.data.udf.directstreamreader.UserDefinedFunctions.pr_read_from_stream(String aProperty, String aInsKey, SqlBinary aBlob)
Error Messages
(nList.Assign_WorkBasket.Action) ERROR servername1|clientname1 UserName1 - in db exception 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.IndexOutOfRangeException: Index was outside the bounds of the array.
System.IndexOutOfRangeException:
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at com.pega.pegarules.data.udf.directstreamreader.FixedCacheMap.put(String aKey, CachedDirectStream aStream)
at com.pega.pegarules.data.udf.directstreamreader.UserDefinedFunctions.pr_read_from_stream(String aProperty, String aInsKey, SqlBinary aBlob)
.
Steps to Reproduce
This issue only appears to impact certain reports - those that require information from the BLOB to execute.
Root Cause
The root cause of this problem is defect/misconfiguration in the PRPC operating environment.
Resolution
This issue is resolved through the following local change: The User Defined Functions (UDFs) were corrupt and needed to be regenerated. Administrators recreated the UDF files (pr_read_from_stream) and others from the PRPC distribution media.
Published January 31, 2016 - 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.