pzGetAppFieldValues appends whitelist multiple times
SummarypzGetAppFieldValues appends whitelist multiple times and ultimately throws the Java SQL exception.
Error Messagesjava.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
Steps to Reproduce
- Create field value whitelist of 180 field values.
- RunpzGetAppFieldValues six (6) or more times in succession.
Root CauseA 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.
Published April 19, 2017 - Updated May 4, 2017