Support Article

Issue with the number of days in Purging and Archiving

SA-28568

Summary



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.

Resolution

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.