DEMANTRA FORCAST ENGINE FAILED ON ANALYZE MDP_MATRIX TABLE
(Doc ID 1059035.1)
Last updated on FEBRUARY 12, 2019
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |