It's all about the answers!

Ask a question

How do I fix the error "ORA-01843: not a valid month" on the RRC ETL Purge Job?

Francesco Chiossi (5.7k1719) | asked Mar 28 '14, 7:40 a.m.
In IBM Rational Insight, when running the RM_ODS4.0.5_FullLoad the Purge Job fails with the following error:

[PROGRESS   - 13:55:14] Procedure Node 105 'purge'; reported the following:
DM-DBM-0400 UDA driver reported the following on connection Rational Data Warehouse:
UDA-SQL-0107 A general exception has occurred during the operation "execute immediate".
ORA-01843: not a valid month
[PROGRESS   - 13:55:14] Procedure Node 105 'purge'; failed

One answer

permanent link
Francesco Chiossi (5.7k1719) | answered Mar 28 '14, 7:41 a.m.
This is caused by an incorrect timestamp format setting in the oracle client configuration.

To solve the error you need to specify the NLS_TIMESTAMP_FORMAT variable for the Oracle client systems.

1) In the Windows machine where the IBM Cognos Data Manager client is installed,  set the following operative system environment variable:

2) On the IBM Rational insight ETL server set the following WAS environment entries of the ETL Server profile:
Note: on Linux without NLS_LANG explicitely set the NLS_TIMESTAMP_FORMAT is not picked up.

Your answer

Register or to post your answer.