Simulation Engine Is Showing Error (Doc ID 1288919.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms



Version 7.3.0 1

The simulation engine runs indefinitely and posts the below errors in the log file.
But while running the forecast in batch mode, the forecast is generated successfully.
As for the batch run, the customer gets a notification that the batch engine is finished.

When manually running the violating SQL, no records are retrieved:
SELECT USER_ID, ANALYTICS, START_DATE, SQL_FROM, SIM_TABLE_NAME, STATUS, QUERY_ID, AUTO_ACCEPT, SIM_FIELD FROM SIMULATION_Q WHERE ID = 3038


Even select * from simulation_q did not retrieve any records.

The simulation ran fine until 1/14/11. No noticeable changes were detected, not by the client, nor by Support.
OWC uploaded.

GALAGA_Engine2k_01_14_11_15_19_02.rtf (14-Jan-2011 11:29:03 PM)

File creation date time: Fri Jan 14 15:19:02 2011

15:19:02:219 Logger General Level: message, UserLevel: message
15:19:02:219 Initiating Database connection...
15:19:02:219 Database connection string: Provider=MSDAORA;Data Source=rfl2t User: DEMANTRA73
15:19:02:719 Database connection initiated successfuly.
15:19:14:297 Writing output to forecast column: FORE_0. Using InitParams tables: INIT_PARAMS_0 AND INIT_PARAMS_1 As override
15:19:14:313 Loading XML Schema...
15:19:17:125 Maximum forecast level after adjustment = 4
15:19:17:125 Minimum forecast level after adjustment = 2
15:19:17:125 Parameter AllowNegativeBU not found, using 0 as default
15:19:17:125 Parameter BulkLoaderCommitSize not found, using 50000 as default
15:19:17:125 Parameter DistributedUpdates not found, using 0 as default
15:19:17:141 Parameter MaxMultiNodeDistance not found, using 0 as default
15:19:17:141 Parameter ShiftPromoMaxValue not found, using 0 as default
15:19:17:141 Parameter UseMatlabEngine not found, using 0 as default
15:19:17:141 Parameter UseNewSP not found, using 1 as default
15:19:17:141 Parameter UseNewSplit not found, using 1 as default
15:19:17:141 Parameter UseOldIterator not found, using 0 as default
15:19:17:141 Parameter UseOldProport not found, using 1 as default
15:19:17:141 Parameter def_delta_d not found, using 0 as default
15:19:17:141 Parameter def_delta_w not found, using 0 as default
15:19:17:141 Parameter exit_sqls not found, using 0 as default
15:19:17:141 Parameter sales_data_table not found, using sales_data as default
15:19:17:141 Parameter sales_data_table_engine not found, using sales_data_engine as default
15:19:17:141 Parameter simCancelCheckInterval not found, using 2 as default
15:19:17:141 Parameter use_mdp_model_information not found, using 0 as default
15:19:17:750 Oracle Demantra Windows Forecast Engine (ID: 0) Version 7.3.0 (351) running in DP mode.
15:19:17:750 Using promotion matrix table: PROMOTION_MATRIX
15:19:17:750 Max Memory to use: 100 MB
15:19:17:829 Refreshing InitParams tables for simulation: INIT_PARAMS_0 AND INIT_PARAMS_99 As override
15:19:17:829 ERROR ---------------------------------------------------------------
15:19:17:829 ERROR DB_Command::Execute threw an exception:
15:19:17:829 ERROR SELECT USER_ID, ANALYTICS, START_DATE, SQL_FROM, SIM_TABLE_NAME, STATUS, QUERY_ID, AUTO_ACCEPT, SIM_FIELD FROM SIMULATION_Q WHERE ID = 3038
15:19:17:829 ERROR - ErrorDescription: Data type is not supported.
15:19:17:829 ERROR - ErrorNumber: 0x80004005 - Unspecified error


15:19:17:829 ERROR - NativeErrorNumber: 0
15:19:17:829 ERROR - ErrorDescription: Oracle error occurred, but error message could not be retrieved from Oracle.
15:19:17:829 ERROR - ErrorNumber: 0x80004005 - Unspecified error


15:19:17:829 ERROR - NativeErrorNumber: 0
15:19:17:829 ERROR - ErrorDescription: Unspecified error
15:19:17:829 ERROR - ErrorNumber: 0x80004005 - Unspecified error


15:19:17:829 ERROR - NativeErrorNumber: 0
15:19:17:829 WARNING Failed to create simulation request info, Details: Data type is not supported.
15:19:17:829 Sending Http Notification:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
15:19:17:891 creating Simulation Mdp_matrix table
15:19:17:891 ERROR ---------------------------------------------------------------
15:19:17:891 ERROR DB_Command::Execute threw an exception:
15:19:17:891 ERROR SELECT upper(sql_from),upper(sql_from_pe) FROM simulation_q WHERE id = 3038 and user_id = 1313
15:19:17:891 ERROR - ErrorDescription: Data type is not supported.
15:19:17:891 ERROR - ErrorNumber: 0x80004005 - Unspecified error


15:19:17:891 ERROR - NativeErrorNumber: 0
15:19:17:891 ERROR - ErrorDescription: Oracle error occurred, but error message could not be retrieved from Oracle.
15:19:17:891 ERROR - ErrorNumber: 0x80004005 - Unspecified error


15:19:17:891 ERROR - NativeErrorNumber: 0
15:19:17:891 ERROR - ErrorDescription: Unspecified error
15:19:17:891 ERROR - ErrorNumber: 0x80004005 - Unspecified error


15:19:17:891 ERROR - NativeErrorNumber: 0
15:19:17:891 ERROR ---------------------------------------------------------------
15:19:17:891 ERROR Database Error [EngCreateMdpMat.cpp,245]
15:19:17:891 ERROR - Source: Microsoft OLE DB Provider for Oracle
15:19:17:891 ERROR - Description: Data type is not supported.
15:19:17:891 ERROR - Message: Unspecified error
15:19:17:891 ERROR - Error Number: 0x80004005 - Unspecified error


15:19:17:891 ERROR ---------------------------------------------------------------
15:19:17:891 ERROR Simulation failed, Details: Data type is not supported.
15:19:17:907 WARNING Failed to locate QueryID=0 in Queries Table
15:19:17:907 Sending Http Notification: httpxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
15:19:17:938 Current Peak Memory Usage :162 MB

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms