Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 10-18:05:57.787 | Thread-6 | INFO | [execute()] - Executing statement[BEGIN null := HCOM_ALZAPR.checkActiveBox(p_boxNumber=>18180, p_checkType=>0); END;] - com.ssp.wms.pcsdb.plsql.PlSqlExecutorAdfImpl
- .execute#164
- 10-18:05:57.791 | Thread-6 | INFO | Departure_Date set in OrderRequest: 17935060 - com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processCreate#
- 781
- 10-18:05:57.801 | Thread-6 | ERROR | performing rollback, due exception: - com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage#111
- 10-18:05:57.802 | Thread-6 | ERROR | [handleAQMessage] - JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO ORDER_HEADER(OH_ID,ORQ_ID,OT_ID,TU_ID,OH_STATUS,ORD
- ER_CODE,PAGE,TUT_CODE,TU_CODE,HOST_ACK) VALUES (?,?,?,?,?,?,?,?,?,?);SELECT TUT_CODE, DT_CREATED, DT_CHANGED, USER_CREATED, USER_CHANGED, PROGRAM_CREATED, PROGRAM_CHANGED INTO ?, ?, ?, ?, ?, ?, ? FROM OR
- DER_HEADER WHERE OH_ID=?; END;". - com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage#112
- oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO ORDER_HEADER(OH_ID,ORQ_ID,OT_ID,TU_ID,OH_STATUS,ORDER_CODE,PAGE,TUT_CODE,TU_CODE,HOST
- _ACK) VALUES (?,?,?,?,?,?,?,?,?,?);SELECT TUT_CODE, DT_CREATED, DT_CHANGED, USER_CREATED, USER_CHANGED, PROGRAM_CREATED, PROGRAM_CHANGED INTO ?, ?, ?, ?, ?, ?, ? FROM ORDER_HEADER WHERE OH_ID=?; END;".
- at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:569)
- at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740)
- at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539)
- at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
- at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
- at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2640)
- at com.ssp.persistence.jbo.server.BaseApplicationModuleImpl.postChanges(BaseApplicationModuleImpl.java:79)
- at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.splitOrderRequest(ProcessorOrder.java:899)
- at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processCreate(ProcessorOrder.java:829)
- at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processTransfer(ProcessorOrder.java:246)
- at com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage(TransServiceHandler.java:91)
- at com.ssp.wms.modules.generic.handler.AQHandler$AQMessageExecutor.run(AQHandler.java:119)
- at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
- at java.lang.Thread.run(Thread.java:595)
- ## Detail 0 ##
- java.sql.SQLException: ORA-20001: Active order header exists for order type 150 and transport unit 18240128
- ORA-06512: at "PWX.OH_CHK", line 88
- ORA-06512: at "PWX.OH_AIUS_OT_CODE_PAGE_TU", line 3
- ORA-04088: error during execution of trigger 'PWX.OH_AIUS_OT_CODE_PAGE_TU'
- ORA-06512: at line 1
- at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
- at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
- at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:217)
- at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:968)
- at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1189)
- at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3369)
- at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3453)
- at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4421)
- at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
- at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740)
- at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539)
- at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
- at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
- at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2640)
- at com.ssp.persistence.jbo.server.BaseApplicationModuleImpl.postChanges(BaseApplicationModuleImpl.java:79)
- at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.splitOrderRequest(ProcessorOrder.java:899)
- at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processCreate(ProcessorOrder.java:829)
- at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processTransfer(ProcessorOrder.java:246)
- at com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage(TransServiceHandler.java:91)
- at com.ssp.wms.modules.generic.handler.AQHandler$AQMessageExecutor.run(AQHandler.java:119)
- at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
- at java.lang.Thread.run(Thread.java:595)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement