Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Database Output template does not display all records



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.


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

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us