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: 269
/General Performance
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