Demantra 12.2.2 Engine Failed With ORA-00904: "TIME_RELATED": Invalid Identifier

Last updated on JUNE 23, 2017

Applies to:

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