Posted: 12 Oct 2015 16:33 EDT Last activity: 15 Oct 2015 10:38 EDT
ArrayIndexOutofBound error when running the report
We have just started using report definitions in our project. One of the report after migrating to production throwing below error when we try to run the report. Also it is happening when one of the properties we are trying to display has some value.
There was a problem getting a list: code: 29532 SQLState: 99999 Message: ORA-29532: Java call terminated by uncaught Java exception: java.lang.ArrayIndexOutOfBoundsException
We have seen this error internally in the past when the report contains too many unexposed columns either in select, filters or join columns causing Oracle to behave weirdly, throwing this exception. So as a follow up
1) How many unexposed columns are you referring to in your report definition? You can find the number of unexposed properties through usage of function "pr_read_from_stream" (or a variant of it) in the generated SQL. Please check the number of times this function is getting invoked.
2) Are those columns intended to be unexposed? Can you expose some or all of those columns in the DB table?
Thanks for the response Rajiv. We do have some unexposed properties in report definition. I have tried removed all of them except one. It was still failing. This is only happening in prodcution. When i remove that property it runs. And i cannot expose all the properties in the report.
UDFs were introduced in 6.2 SP2. If you upgraded to 6.3 SP1, you should have upgraded the UDFs though there might not be an easy way to check that. You can re-install the UDFs again to be sure you have the right version and check post that to see if your reports work.