Support Article

pzGetAppFieldValues appends whitelist multiple times

SA-36742

Summary



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

The
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.

Resolution



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.