Summary

PEGA0027 alert is missing data: SQL is blank Pega0027 alert message occurs indicating that a query returned a huge number of rows. The message includes the # of rows returned plus SQL. 

Error Messages

*Database RowSet list returned more than 25,000 rows: 163,157. SQL: *

Steps to Reproduce

Create a report such that it returns a huge number of rows.

Root Cause

A defect in Pegasystems’ code or rules. The code is written such that the SQL queries are invisible on the alert log.

Resolution

An enhancement request, FDBK-66638, is created for consideration by Pega Product Management.