Posted: 7 Sep 2017 2:42 EDT Last activity: 16 Oct 2018 12:03 EDT
Unable to access page list type BLOB columns from report definition
We're getting this error when accessing page list type BLOB columns from a report definition.
When referring page list type property below error is generated. But local value list is not available to define pyStringType in report definition.
"Data type— The value Included Page for property pyStringType is not defined in the local value list."
Please suggest approach for this.
Below error is generated when accessing blob columns from a page property. From Activity we can access the same query using RDB-List method.
There was a problem performing a database query: There was a problem getting a list: code: 29532 SQLState: 99999 Message: ORA-29532: Java call terminated by uncaught Java exception: java.lang.ArrayIndexOutOfBoundsException DatabaseException caused by prior exception: java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.ArrayIndexOutOfBoundsException | SQL Code: 29532 | SQL State: 99999
Rule : step 32 of below pega activity getting failed.
Have you tried to refer the pagelist property by specifying the index?
You will not be able to call or report on the pagelist straightaway in the report definition. You will perhaps need to implement the index against the pagelist property. Please let me know if you need more information.
We can directly refer single value BLOB properties in the report definition. But SQL error generates for properties which lengthy text values. But form a list view we can access the same property without any issue.
Our scenario is to display all the properties in that particular list view. Putting the index will work to access a single list property.