Question
10
Replies
511
Views
Posted: October 12, 2015
Last activity: October 15, 2015
Closed
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
Hi Abbai,
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?
-Rajiv