Database Software

Hi All,

I've experienced some strange errors while running workflow with large data (around 2.5 milions of records). I'm working with OWB 11.1, Oracle Workflow 2.6.4 on Linux (everything on the same server).
Everything gets created and deployed via OMB script correctly (it has passed tests on the other server with the same configuration but with smaller amount of records - around 500.000).
When I execute process flow (which is loading 2 mappings) I get:

RPE-01008 : Recovery of this request is in progress.

Dimensions and a simpler mapping is loaded correctly, looks like the more complicated mapping (table function + aggregator) hangs up.

Piece of log file with NullPointerException:

2009/11/26-17:31:28-CET [35ECFE07][] Thin driver connection time - 39 millisecond(s)
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Initializing execution for auditId= 332 parentAuditId= null topLevelAuditId=332 taskName=WH_PF
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Attempting to create adapter 'class.RuntimePlatform.0.NativeExecution'
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Attempting to create native operator 'class.RuntimePlatform.0.NativeExecution.ProcessFlow'
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
- RPE-01003: An infrastructure condition prevented the request from completing.
- ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException

at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.getWorkflowContext(NativeOWFProcessOperator.java:761)
at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.execute(NativeOWFProcessOperator.java:228)
at oracle.wh.runtime.platform.adapter.rtp.NativeExecutionAdapter.execute(NativeExecutionAdapter.java:43)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:70)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
at java.lang.Thread.run(Thread.java:595)
Caused by: oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
- ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException

at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:249)
at oracle.wh.runtime.platform.service.controller.AdapterContextImpl.getStore(AdapterContextImpl.java:219)
at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.getWorkflowContext(NativeOWFProcessOperator.java:751)
... 6 more
Caused by: java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
at sqlj.runtime.ExecutionContext$OracleContext.oracleExecuteQuery(ExecutionContext.java:1591)
at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:219)
... 8 more
oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
- ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException

at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:249)
at oracle.wh.runtime.platform.service.controller.AdapterContextImpl.getStore(AdapterContextImpl.java:219)
at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.getWorkflowContext(NativeOWFProcessOperator.java:751)
at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.execute(NativeOWFProcessOperator.java:228)
at oracle.wh.runtime.platform.adapter.rtp.NativeExecutionAdapter.execute(NativeExecutionAdapter.java:43)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:70)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
at sqlj.runtime.ExecutionContext$OracleContext.oracleExecuteQuery(ExecutionContext.java:1591)
at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:219)
... 8 more
java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
at sqlj.runtime.ExecutionContext$OracleContext.oracleExecuteQuery(ExecutionContext.java:1591)
at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:219)
at oracle.wh.runtime.platform.service.controller.AdapterContextImpl.getStore(AdapterContextImpl.java:219)
at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.getWorkflowContext(NativeOWFProcessOperator.java:751)
at oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator.execute(NativeOWFProcessOperator.java:228)
at oracle.wh.runtime.platform.adapter.rtp.NativeExecutionAdapter.execute(NativeExecutionAdapter.java:43)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:70)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
at java.lang.Thread.run(Thread.java:595)
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Initializing execution for auditId= 332 parentAuditId= null topLevelAuditId=332 taskName=WH_PF
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] oracle.wh.runtime.platform.service.controller.RecoveryInProgress: RPE-01008: Recovery of this request is in progress.
at oracle.wh.runtime.platform.service.controller.AdapterContextImpl.initialize(AdapterContextImpl.java:1575)
at oracle.wh.runtime.platform.service.controller.ExecutionContextImpl.initialize(ExecutionContextImpl.java:1508)
at oracle.wh.runtime.platform.service.controller.ExecutionController.initialize(ExecutionController.java:32)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:50)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:83)
at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
at java.lang.Thread.run(Thread.java:595)
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Attempting to create adapter 'class.RuntimePlatform.0.NativeExecution'
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Attempting to create native operator 'class.RuntimePlatform.0.NativeExecution.ProcessFlow'
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Native execution operator initiating recovery by recoverable operator oracle.wh.runtime.platform.operator.owf_process.NativeOWFProcessOperator
2009/11/26-17:31:28-CET [35ECFE07][REP_OWNER.DEMO] Thin driver connection time - 67 millisecond(s)


Any Idea ?
Please help.
B.