DEMANTRA FORCAST ENGINE FAILED ON ANALYZE MDP_MATRIX TABLE

(Doc ID 1059035.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.2.0.2 to 7.2.0.3 [Release 7.2]
Information in this document applies to any platform.
***Checked for relevance on 01-JUl-2013***


Symptoms



Engine failed with the following error (Note that this client is on Oracle Database 11g and Demantra v7202)

23:26:06:496 Generating the branch IDs...
23:27:01:933 WARNING Trying to reconnect: Provider=MSDAORA;Data Source=APS
23:28:27:027 ERROR ---------------------------------------------------------------
23:28:27:027 ERROR   DB_Connection::Execute threw an exception:
23:28:27:027 ERROR   ANALYZE TABLE mdp_matrix COMPUTE STATISTICS FOR TABLE FOR ALL INDEXES  FOR COLUMNS prediction_status SIZE 4, prop_changes SIZE 4,BRANCH_ID SIZE 10, do_aggri SIZE 4,do_fore SIZE 4
23:28:27:027 ERROR   - ErrorDescription: ORA-00603: ORACLE server session terminated by fatal error

23:28:27:027 ERROR   - ErrorNumber: 0x80004005 - Unspecified error


23:28:27:027 ERROR   - NativeErrorNumber: 603
23:28:27:027 ERROR ---------------------------------------------------------------
23:28:27:027 ERROR ExecuteSQL failed: ANALYZE TABLE mdp_matrix COMPUTE STATISTICS FOR TABLE FOR ALL INDEXES  FOR COLUMNS prediction_status SIZE 4, prop_changes SIZE 4,BRANCH_ID SIZE 10, do_aggri SIZE 4,do_fore SIZE 4
23:28:27:027 ERROR ---------------------------------------------------------------
23:28:27:027 ERROR Database Error [EngineManager.cpp,1312]
23:28:27:027 ERROR   - Source: Microsoft OLE DB Provider for Oracle
23:28:27:027 ERROR   - Description: ORA-00603: ORACLE server session terminated by fatal error
23:28:27:027 ERROR   - Message: Unspecified error
23:28:27:027 ERROR   - Error Number: 0x80004005 - Unspecified error

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