Support Article

pzGetAppFieldValues appends whitelist multiple times



pzGetAppFieldValues appends whitelist multiple times and ultimately throws the Java SQL exception.

Error Messages

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Steps to Reproduce

  1. Create field value whitelist of 180 field values.
  2. RunpzGetAppFieldValues six (6) or more times in succession.

Root Cause

A defect in Pegasystems’ code or rules

activity pzGetAppFieldValues takes the field value whitelist and appends each entry to the pagelistRecordFieldValuesList. It then uses that pagelist to create a comma-delimited string to pass to the report definition to be used as filter criteria. If that string has more than 1000 field values in it, the query fails with the error ORA-01795. The RecordFieldValuesList is not being cleared at the start of the activity; therefore, every time it is called the list grows by 180 until it exceeds 1000. Then the whole query fails.


Apply HFix-33933.

Published April 19, 2017 - Updated May 4, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.