Demantra 7301: Simulation Requests Fail On Linux Engine Install ORA-32116 ORA-03127 (Doc ID 1280318.1)

Last updated on APRIL 16, 2015

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.1 to 7.3.0.1 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

When attempting to run the Simulation Engine installed on Linux the following error occurs.

ERROR
-----------------------
08:58:58:405 Oracle Demantra Unix Forecast Engine (ID: 0) Version 7.3.0 ( 7.3.0.1  (545) )  running in DP mode.
08:58:58:405 Using promotion matrix table: PROMOTION_MATRIX
08:58:58:405 Max Memory to use: 1000 MB
08:58:58:463 Refreshing InitParams tables for simulation: INIT_PARAMS_0 AND INIT_PARAMS_99 As override
08:58:58:467 Sending Http Notification: http://<host_server_name>:<port>/demantra/SimulationServlet?userId=387&queryId=13303&simulationId=1416&status=2
08:58:58:513 creating Simulation Mdp_matrix table
08:58:58:517 ERROR ---------------------------------------------------------------
08:58:58:517 ERROR   DumpClob threw an exception. Error: 32116 ORA-32116: Buffer size is less than amount specified

08:58:58:517 ERROR ---------------------------------------------------------------
08:58:58:518 WARNING Caught exception at EngCreateMdpMat::GetSimulationqPopulationCLOB
08:58:58:518 ERROR ---------------------------------------------------------------
08:58:58:518 ERROR   DB_OracleConnection::Execute threw an exception. Error: 3127 ORA-03127: no new operations allowed until the active operation ends

08:58:58:518 ERROR ---------------------------------------------------------------
08:58:58:518 WARNING DropDBObject() failed to drop object: MDP_1416_387_small
08:58:58:518 MDP min create sql: CREATE TABLE MDP_1416_387_small AS SELECT  mdp_matrix.* FROM   AND do_aggri = 1 AND (prediction_status = '1' OR prediction_status = '97'  OR (prediction_status = '98' AND aggri_98=1)  OR (prediction_status = '99' AND aggri_99=1))
08:58:58:518 ERROR ---------------------------------------------------------------
08:58:58:518 ERROR   DB_OracleCommand::Execute threw an exception. Error: 3127 ORA-03127: no new operations allowed until the active operation ends

08:58:58:518 ERROR   SQL :CREATE TABLE MDP_1416_387_small AS SELECT  mdp_matrix.* FROM   AND do_aggri = 1 AND (prediction_status = '1' OR prediction_status = '97'  OR (prediction_status = '98' AND aggri_98=1)  OR (prediction_status = '99' AND aggri_99=1))
08:58:58:518 ERROR ---------------------------------------------------------------
08:58:58:518 ERROR ---------------------------------------------------------------
08:58:58:518 ERROR Database Error [EngCreateMdpMat.cpp,236]
08:58:58:519   - Source:
08:58:58:519   - Description:  Failed to Execute Oracle Command
08:58:58:519   - Error Number:
08:58:58:519 ---------------------------------------------------------------
08:58:58:519 ERROR Simulation failed, Details:  Failed to Execute Oracle Command
08:58:58:519 ERROR ---------------------------------------------------------------
08:58:58:519 ERROR   DB_OracleCommand::Execute threw an exception. Error: 3127 ORA-03127: no new operations allowed until the active operation ends

08:58:58:519 ERROR   SQL :update simulation_q set status = :1 where id = :2
08:58:58:519 ERROR ---------------------------------------------------------------
08:58:58:520 ERROR Caught exception at: CEngWrapper::Execute()



STEPS
1. Invoke engine in simulation mode.
2. Run simulation request
3. NAV: Demantra collaborator workbench > Open a worksheet > select a member > make changes to history using "override" option and run Simulation request.

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