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 September 28, 2016 - Updated October 11, 2016

Have a question? Get answers now.

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