My Oracle Support Banner

DEMANTRA FORCAST ENGINE FAILED ON ANALYZE MDP_MATRIX TABLE (Doc ID 1059035.1)

Last updated on FEBRUARY 03, 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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.