Discussion

.NET Framework error occurred during execution of user-defined routine or aggregate

Hi

 

Getting below error in Logs.. My Report definition has some not exposed properties. While reading blob Pega giving below error..

 

 

Please Advise. Thanks !

 

 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.Resize()
   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)
.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

November 22, 2013 - 5:02am

We have the same issue and raised an SR with pega. Solution on the way from Mars. Can anyone help me with fix for this?

November 22, 2013 - 7:05pm

Bhai, If you have same issue as mine... create exposed property instead of reading from Blob. Our DBAs were looked into this issue.. but finally they said one or more Blob is DB has some issue... they couldn't determine what bolb and what issue. Pega will put this on DB and DB guys will say this is Pega Issue.

 

December 9, 2014 - 12:31pm

anyone find solution for this ???

July 14, 2015 - 5:43am

Do we have solution for this?

I have report definitions in framework and two implementation layers with same proerties and database table configuration.

When I run a report present in one implementation layer, it gives me below error. However, it works fine for other implementation and framework layer report definitions.

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":