ORA 01843 not a valid month when archiving data in CA Service Catalog

Document ID : KB000072491
Last Modified Date : 13/04/2018
Show Technical Document Details
Issue:
The following error appears when archiving data in CA Service Catalog:

ORA-01843: not a valid month
ORA-06512: at line 7

 
Environment:
CA Service Catalog running on Oracle databases
Cause:
Oracle client is installed in Spanish language.
Spanish will use a different date format which causes the issue to occur.
Resolution:
Install Oracle client in English in a machine and then use SQL Developer (or similar) in the same machine.
To run the procedures to archive and purge data from the database.

Further details about Archive and Purge:
https://docops.ca.com/ca-service-management/17-1/en/administering/administering-ca-service-catalog/archive-and-purge-historical-data

To install Oracle client:
https://docs.oracle.com/cd/E11882_01/install.112/e47959/install.htm