Demantra 12.2.2 Engine Failed With ORA-00904: "TIME_RELATED": Invalid Identifier (Doc ID 1617132.1)

Last updated on JUNE 23, 2017

Applies to:

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

Goal

Customer is on 12.2.2 and they mention that when they run the engine they get the following


03:58:00:446 Engine (ID: 0) on machine localhost failed on Branch: -1
03:58:02:774 Engine (ID: 0) on machine localhost was successfully created and initialized
03:58:07:740 03:58:07:740 ERROR
03:58:07:850 03:58:07:850 ERROR DB_Command::Execute threw an exception:
03:58:07:959 03:58:07:959 ERROR SELECT factor_id , 0, TIME_RELATED, fill_causals FROM causal_factors WHERE (ENGINE_PROFILES_ID = 1) AND (short_val = 1 or long_val = 1 or daily_val =1 or monthly_val = 1 or non_seasonal_val = 1) ORDER BY factor_id
03:58:08:068 03:58:08:068 ERROR - ErrorDescription: ORA-00904: "TIME_RELATED": invalid identifier

03:58:08:178 03:58:08:178 ERROR - ErrorNumber: 0x80040e14 - Undefined Error.
03:58:08:287 03:58:08:287 ERROR - NativeErrorNumber: 904
03:58:08:396 03:58:08:396 ERROR - ErrorDescription: One or more errors occurred during processing of command.
03:58:08:506 03:58:08:506 ERROR - ErrorNumber: 0x80040e14 - Undefined Error.
03:58:08:615 03:58:08:615 ERROR - NativeErrorNumber: 0
03:58:08:724 03:58:08:724 ERROR Error loading global causal factors.
03:58:08:834 03:58:08:834 ERROR 03:58:08:943 03:58:08:943 ERROR Database Error http://EngShell.cpp,334
03:58:09:052 03:58:09:052 ERROR - Source: Microsoft OLE DB Provider for Oracle
03:58:09:162 03:58:09:162 ERROR - Description: ORA-00904: "TIME_RELATED": invalid identifier
03:58:09:271 03:58:09:271 ERROR - Message: IDispatch error #3092
03:58:09:380 03:58:09:380 ERROR - Error Number: 0x80040e14 - Undefined Error.
03:58:09:490 03:58:09:490 ERROR 03:58:12:802 ERROR Engine (ID: 0) on machine localhost failed to execute Branch: -1 successfully. HRESULT=0x80004005 - Unspecified error


A describe on the causal_factors table shows column time_related does not exist

desc causal_factors
Name Null Type
-------- FACTOR_ID NOT NULL NUMBER(5)
FACTOR_NAME VARCHAR2(15)
SHORT_VAL NUMBER(1)
LONG_VAL NUMBER(1)
COMMENTS VARCHAR2(80)
FACTOR_TYPE VARCHAR2(10)
LOCAL_FUNCT VARCHAR2(2000)
DAILY_VAL NUMBER(1)
MONTHLY_VAL NUMBER(1)
NON_SEASONAL_VAL NUMBER(1)
FILL_CAUSALS NOT NULL NUMBER(1)
SHAPE_INDICATOR NUMBER(1)
OMIT_SEASONAL NUMBER(1)
IGNORE NOT NULL NUMBER(1)
TRANSPOSE_FUNCTION VARCHAR2(2000)
ENGINE_PROFILES_ID NOT NULL NUMBER(10)

Here's the output of version details_history:
"VERSION" "BUILD" "SP" "UPGRADE_DATE"
"12.2.1" "15" "0" 27-NOV-13
"12.2.2" "11" "0" 09-DEC-13
 

Solution

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