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

Issue with the number of days in Purging and Archiving



When the date value calculation methodology based on the the number of days given, the Purging and Archiving process is interrupted.

Error Messages

There was a problem getting a list: code: 242 SQLState: S0003 Message: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Steps to Reproduce

  1. Configure Purge/Archive to purge specific work objects.
  2. Process Archival manually.

Root Cause

An issue in the custom application code or rules.


Issue is resolved with the below local change:

  1.  Open OOTB getArchivableItems ListView.
  2. Save getArchivableItems  ListView to application ruleset.
  3.  In the content tab of getArchivableItems ListView and check the “Covert Criteria values from Locale values?” check box .

Published October 11, 2016 - Updated October 8, 2020

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