Hi We are getting the below exception when a report definition is being executed. Caused by SQL Problems.Problem #1, SQLState 99999, Error code 29532: java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.ArrayIndexOutOfBoundsException When browsed through the PDN, I got an article related to the same issue. https://community.pega.com/support/support-articles/ora-29532-javalangarrayindexoutofboundsexception This states that there is some issue with the UDF that tries to read the data from the blob and the resolution is given as recompile the java classes for pegadata and pegarules. The problem is we are facing this only in two lanes of the JVM and in the remaining lanes it is working good. It would be helpful if someone explain on the detailed procedure on how to resolve this. 1. Which java classes to be recompiled 2. How we need to recompile this(via SMA or through oracle). steps to do the same(path,location etc.) Thanks in Advance Naveen Raja
***Edited by Moderator Marissa to reference Support Article***
Based on the above description It seems you are running a report definition with unoptimized columns..Can you please confirm are all the properties are exposed or not.If not then please try to optimize the property.You will be getting guardrail warnings please go through it and resolve it.
Trace the use case and get the sql query from it.Execute the same query over db using managemnet studio.
Hopefully issue will be resolved after exposing columns.