Can Not Save Worksheet Data - ORA-01843: not a valid month, ODPM-70173: Error SQL, ODPM-10303: The application could not process your update request (Doc ID 1315588.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to save worksheet data, the following error occurs.

ERROR
-----------------------
ODPM-10303: The application could not process your update request - encountered
configuration inconsistencies. Please contact your system administrator. More information is available in application log files.



The collaborator.log file show a error like :
2011-04-19 08:36:31,834 GMT+03:00 [Update_3] ERROR update.sql: ODPM-70173: Error SQL:
CREATE TABLE T_UPDATE_387_1303112233285 NOLOGGING CACHE AS
SELECT SALES_DATA.ITEM_ID
,SALES_DATA.LOCATION_ID
,SALES_DATA.SALES_DATE

...
AND ((SALES_DATA.SALES_DATE >= TO_DATE('01-04-2009','mm-dd-yyyy')
AND SALES_DATA.SALES_DATE <= TO_DATE('30-04-2009','mm-dd-yyyy')))
..
2011-04-19 08:36:31,834 GMT+03:00 [Update_3] ERROR update.sql: ODPM-70125: Failed to create temp update table. Update Data: Id: 1303129948557, User: dm,
WS: 13400, Update Table: SALES_DATA, Combination:
L425M9L428M19L429M43L430M318L424M5643 SELECT
...

2011-04-19 08:36:31,834 GMT+03:00 [Update_3] ERROR update.sql:
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: com.demantra.applicationServer.appServerExceptions.FailedToExcuteBatch: java.sql.BatchUpdateException: error occurred during batching: ORA-01843: not a valid month


This is the same for nls_date_format from db_params as 'dd-mm-yyyy hh24:mi:ss' or as 'mm-dd-yyyy hh24:mi:ss'


STEPS
1. open a worksheet
2. update a series value
3. click on Save Data

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms