PE Engine Not Completing (Doc ID 1575471.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

Customer is on 7.3.1.4 running the engine in PE mode and the engine errors out
The engine runs fine when run in DP mode


The error that they get is

14:30:25:975 Machine localhost (ID: 0) receiving Branch: 5
14:32:04:179 Engine (ID: 1) on machine localhost finished to executing successfully.
14:33:17:804 14:33:17:804 ERROR
14:33:17:913 14:33:17:913 ERROR Database Error http://EngDatabase.cpp,1403
14:33:18:022 14:33:18:022 ERROR - Source: OraOLEDB
14:33:18:132 14:33:18:132 ERROR - Description: ROW-00060: Internal error: daputchunk,2w
14:33:18:241 14:33:18:241 ERROR - Message: Unspecified error
14:33:18:350 14:33:18:350 ERROR - Error Number: 0x80004005 - Unspecified error

14:33:18:460 14:33:18:460 ERROR 14:33:18:569 14:33:18:569 ERROR Caught exception in SetFieldValue()! IRL='4,1,21' AND KEY='0,0,0' AND (ENGINE_PROFILES_ID = 1) Type-BASEFORECAST
14:33:18:679 14:33:18:679 WARNING Caught exception at postprocessing IRL and IGL
14:33:18:788 14:33:18:788 ERROR Scan2a1 failed! BranchID=5. Node(s): , 3,15,901
14:33:18:897 14:33:18:897 ERROR Caught exception at DmScan2a1::Execute()
14:33:20:475 ERROR Engine (ID: 0) on machine localhost failed to execute Branch: 5 successfully. HRESULT=0x80004005 - Unspecified error


Verified the following

1. The engine_caches table exists and has data
desc engine_caches
Name Null Type -------- IRL NOT NULL VARCHAR2(100)
KEY NOT NULL VARCHAR2(100)
ENGINE_PROFILES_ID NOT NULL NUMBER(10)
BASEFORECAST BLOB
COEFFICIENTS BLOB

2. The RUNMODE parameter is set to 1
 

Solution

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