Wednesday Apr 25, 2012

Partial Database Schema Update

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.

Regards!

Sunday Apr 15, 2012

Tired of Downloading Your Entire Schema? How About a Partial Download?

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:

https://communities.oracle.com/portal/server.pt/community/demantra_solutions/231

Regards!   Jeff

Wednesday Apr 04, 2012

Need to Determine the Engine Status?

If you need to establish the status of the engine, begin with this SQL:

select status, engine, engine_version,fore_column_name
from dm.forecast_history

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.


 

Tuesday Apr 03, 2012

Add-ons for Firefox - Java Plugin has been blocked JRE versions below 1.6.0_31 or between 1.7.0 and 1.7.0_2

As of 3-APR-12 some Firefox versions automatically block all Java plugins which are Java versions less than 1.6.0_31.

7.3.0.2 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 7.3.0.2
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.

About

This blog delivers the latest information regarding performance and install/upgrade. Comments welcome

Search

Archives
« April 2012 »
SunMonTueWedThuFriSat
1
2
5
6
7
8
9
10
11
12
13
14
16
17
18
19
20
21
22
23
24
26
27
28
29
30
     
       
Today