Support Article
Database Output template does not display all records
SA-85154
Summary
A database Output template table is configured such that the Campaign output is written to the table. While executing the Campaign, the batch output table displays the current number of records. However, when the records are moved to the database table, only 501 records display.
Error Messages
Not Applicable
Steps to Reproduce
Create a Campaign to write to the database output table with multiple records.
Root Cause
A defect in Pegasystems’ code or rules: Specific to MS SQL server database.
Resolution
Perform the following local-change:
Set the pyReportParamPageName.pyMaxRecords = 0 property in the InsertFinalizedRecords activity (which invokes the pxRetrieveReportData report definition which limits the total records).
Published August 15, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.