Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.55 KB | None | 0 0
  1. 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
  2. .execute#164
  3. 10-18:05:57.791 | Thread-6 | INFO | Departure_Date set in OrderRequest: 17935060 - com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processCreate#
  4. 781
  5. 10-18:05:57.801 | Thread-6 | ERROR | performing rollback, due exception: - com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage#111
  6. 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
  7. 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
  8. DER_HEADER WHERE OH_ID=?; END;". - com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage#112
  9. 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
  10. _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;".
  11. at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:569)
  12. at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740)
  13. at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539)
  14. at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
  15. at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
  16. at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2640)
  17. at com.ssp.persistence.jbo.server.BaseApplicationModuleImpl.postChanges(BaseApplicationModuleImpl.java:79)
  18. at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.splitOrderRequest(ProcessorOrder.java:899)
  19. at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processCreate(ProcessorOrder.java:829)
  20. at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processTransfer(ProcessorOrder.java:246)
  21. at com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage(TransServiceHandler.java:91)
  22. at com.ssp.wms.modules.generic.handler.AQHandler$AQMessageExecutor.run(AQHandler.java:119)
  23. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
  24. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
  25. at java.lang.Thread.run(Thread.java:595)
  26. ## Detail 0 ##
  27. java.sql.SQLException: ORA-20001: Active order header exists for order type 150 and transport unit 18240128
  28. ORA-06512: at "PWX.OH_CHK", line 88
  29. ORA-06512: at "PWX.OH_AIUS_OT_CODE_PAGE_TU", line 3
  30. ORA-04088: error during execution of trigger 'PWX.OH_AIUS_OT_CODE_PAGE_TU'
  31. ORA-06512: at line 1
  32.  
  33. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
  34. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
  35. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
  36. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
  37. at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:217)
  38. at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:968)
  39. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1189)
  40. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3369)
  41. at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3453)
  42. at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4421)
  43. at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
  44. at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740)
  45. at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539)
  46. at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
  47. at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
  48. at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2640)
  49. at com.ssp.persistence.jbo.server.BaseApplicationModuleImpl.postChanges(BaseApplicationModuleImpl.java:79)
  50. at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.splitOrderRequest(ProcessorOrder.java:899)
  51. at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processCreate(ProcessorOrder.java:829)
  52. at com.ssp.wms.modules.hcomtransfer.manager.processors.ProcessorOrder.processTransfer(ProcessorOrder.java:246)
  53. at com.ssp.wms.modules.hcomtransfer.handler.TransServiceHandler.handleAQMessage(TransServiceHandler.java:91)
  54. at com.ssp.wms.modules.generic.handler.AQHandler$AQMessageExecutor.run(AQHandler.java:119)
  55. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
  56. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
  57. at java.lang.Thread.run(Thread.java:595)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement