By JeffG-Oracle on Apr 25, 2012
The Non Invasive Partial Schema Export Utility Extracting Partial Schema Dumps for Analysis (Doc ID 1448266.1) is now available in a patch.
Using MOS, download checkin 13930627.
Proceed to document 1448266.1, Demantra Non Invasive Partial Schema Export Utility Extracting Partial Schema Dumps for Analysis. In this document you will find instructions and 2 SQL scripts. Give it a try. If you have a problem, feel free to post to this BLOG or the community located at:
If you need to establish the status of the engine, begin with this SQL:
select status, engine, engine_version,fore_column_name
The status of an engine run is stored in the FORECAST_HISTORY table, in the “status” field. We can also find in that table the FORE_COLUMN_NAME field. This field includes the name of the column in SALES_DATA in which the relevant forecast is stored.
Here are the possible statuses:
-1, -2 : The engine failed in the initialization phase. Which means, before the engine manager created the engines.
0 : The engine stopped in the optimization phase. Which means, after the engines were created.
1: The engine finished the run successfully.
2: Forecast was never calculated for the relevant column that is mentioned in FORE_COLUMN_NAME.
As of 3-APR-12 some Firefox versions automatically block all Java plugins which are Java versions less than 1.6.0_31.
220.127.116.11 AND ALL OF 7.3.1
Therefore every user that has a problem and is running with a Demantra that supports Java higher than 1.6.0_19 can upgrade their Java plugin to 1.6.1_31. Demantra 18.104.22.168 and all versions of 7.3.1 support it.
OLDER VERSION of DEMANTRA
Anyone who has a problem while running on an older Demantra version that does not support Java versions newer than 1.6.0_19 cannot use Firefox with Demantra. Instead they can either use Windows Internet Explorer (IE) without a Java upgrade or they can upgrade their Demantra. If they upgrade to the latest Java version then the Demantra plugin will not work - not with Firefox and not with IE.
This blog delivers the latest information regarding performance and install/upgrade. Comments welcome