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.
Rule-Obj-Report-Definition! xRetrieveReportDatap| Pega-Reporting:07-10-23
Referred articles.
https://pdn.pega.com/support-articles/ora-29532-when-attempting-run-report-definition
https://pdn.pega.com/support-articles/report-definition-code-29532-sqlstate-99999-message-ora-29532
https://pdn.pega.com/community/pega-product-support/question/arrayindexoutofbound-error-when-running-report
https://pdn.pega.com/troubleshooting-ora-29541-log-error-when-running-report-directstreamreader-could-not-be-resolved
**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.
Virtusa Consulting UK
GB
Hi,
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.
Virtusa
LK
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.
Pegasystems Inc.
IN
Please find this discussion thread which is probably in line to what you want. :
https://collaborate.pega.com/question/how-show-page-lists-report-definition