Need to Determine the Engine Status?

Posted by user702295 on Oracle Blogs See other posts from Oracle Blogs or by user702295
Published on Wed, 4 Apr 2012 07:44:31 -0500 Indexed on 2012/04/04 17:36 UTC
Read the original article Hit count: 230

Filed under:

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.


 

© Oracle Blogs or respective owner

Related posts about /General Performance