You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2026/05/20 15:45:00 UTC
[jira] [Commented] (OFBIZ-13416) Error in Quick Ship Entire Order - ShipmentStatus related issue
[ https://issues.apache.org/jira/browse/OFBIZ-13416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18082359#comment-18082359 ]
ASF subversion and git services commented on OFBIZ-13416:
---------------------------------------------------------
Commit 0b42ca182de259951b1e5e3625ef816a7fd1d82e in ofbiz-framework's branch refs/heads/trunk from Ashish Vijaywargiya
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=0b42ca182d ]
OFBIZ-13416 - We are seeing the following error on the console while performing the steps shown below:
-- Place a sales order from ecommerce or backend order application
-- Quick Ship Entire Order. On console you will see the below error:
2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| [[ASync service finished...- total:0.0,since last(ASync service sta...):0.0]] - 'order / createShipmentStatus'
2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/createShipment] finished in [385] milliseconds
2026-05-20 19:44:56,394 |OFBiz-JobQueue-0 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:199)
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:117)
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:903)
at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76)
at org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:378)
at org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:124)
at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:429)
at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:244)
at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:77)
at org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:77)
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:106)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
2026-05-20 19:44:56,395 |OFBiz-JobQueue-0 |GenericDelegator |E| Failure in create operation for entity [ShipmentStatus]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])). Rolling back transaction.
> Error in Quick Ship Entire Order - ShipmentStatus related issue
> ---------------------------------------------------------------
>
> Key: OFBIZ-13416
> URL: https://issues.apache.org/jira/browse/OFBIZ-13416
> Project: OFBiz
> Issue Type: Bug
> Components: order
> Reporter: Ashish Vijaywargiya
> Assignee: Ashish Vijaywargiya
> Priority: Major
> Fix For: Upcoming Branch
>
>
> We are getting the following error in OFBiz.
>
> 2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceEcaCondition |I| From Field (estimatedArrivalDate) is not found in context for createShipment, defaulting to null.
> 2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceEcaCondition |W| doRealCompare returned null, returning false
> 2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceEcaRule |I| Running Service ECA Service: createShipmentStatus, triggered by rule on Service: createShipment
> 2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| [[ASync service started...- total:0.0,since last(Begin):0.0]] - 'order / createShipmentStatus'
> 2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| [[ASync service finished...- total:0.0,since last(ASync service sta...):0.0]] - 'order / createShipmentStatus'
> 2026-05-20 19:44:56,390 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/createShipment] finished in [385] milliseconds
> 2026-05-20 19:44:56,394 |OFBiz-JobQueue-0 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
> java.lang.Exception: rollback called in Entity Engine SQLProcessor
> at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372)
> at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:199)
> at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:117)
> at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
> at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:903)
> at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76)
> at org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:378)
> at org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:124)
> at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:429)
> at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:244)
> at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:77)
> at org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:77)
> at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:106)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
> at java.base/java.lang.Thread.run(Thread.java:840)
> 2026-05-20 19:44:56,395 |OFBiz-JobQueue-0 |GenericDelegator |E| Failure in create operation for entity [ShipmentStatus]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])). Rolling back transaction.
> 2026-05-20 19:44:56,395 |OFBiz-JobQueue-0 |TransactionUtil |I| Transaction rollback only not set, rollback only is already set.
> 2026-05-20 19:44:56,398 |OFBiz-JobQueue-0 |EntityAutoEngine |E| Error doing entity-auto operation for entity [ShipmentStatus] in service [createShipmentStatus]: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])) (Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])))
> org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])) (Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])))
> at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:927)
> at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76)
> at org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:378)
> at org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:124)
> at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:429)
> at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:244)
> at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:77)
> at org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:77)
> at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:106)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
> at java.base/java.lang.Thread.run(Thread.java:840)
> Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240]))
> at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:235)
> at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
> at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:903)
> ... 11 more
> Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])
> at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:446)
> at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:230)
> ... 14 more
> Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:520)
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
> at org.h2.message.DbException.get(DbException.java:223)
> at org.h2.message.DbException.get(DbException.java:199)
> at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:309)
> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:250)
> at org.h2.table.Table.fireConstraints(Table.java:1208)
> at org.h2.table.Table.fireAfterRow(Table.java:1226)
> at org.h2.command.dml.Insert.insertRows(Insert.java:188)
> at org.h2.command.dml.Insert.update(Insert.java:135)
> at org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:77)
> at org.h2.command.CommandContainer.update(CommandContainer.java:139)
> at org.h2.command.Command.executeUpdate(Command.java:306)
> at org.h2.command.Command.executeUpdate(Command.java:250)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:213)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:172)
> at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
> at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
> at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:441)
> ... 15 more
> 2026-05-20 19:44:56,400 |jsse-nio-8443-exec-7 |ServiceEcaCondition |W| doRealCompare returned null, returning false
> 2026-05-20 19:44:56,401 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/checkCanChangeShipmentStatusPacked] finished in [1] milliseconds
> 2026-05-20 19:44:56,401 |jsse-nio-8443-exec-7 |ServiceEcaCondition |W| doRealCompare returned null, returning false
> 2026-05-20 19:44:56,403 |OFBiz-JobQueue-0 |UtilProperties |I| ResourceBundle ServiceErrorUiLabels (en_GB) created in 0.005s with 37 properties
> 2026-05-20 19:44:56,403 |OFBiz-JobQueue-0 |ServiceUtil |E| {errorMessage=Error doing entity-auto operation for entity ShipmentStatus in service createShipmentStatus: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])) (Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240]))), responseMessage=error}
> 2026-05-20 19:44:56,403 |OFBiz-JobQueue-0 |ServiceDispatcher |E| Error in Service [createShipmentStatus]: Error doing entity-auto operation for entity ShipmentStatus in service createShipmentStatus: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])) (Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])))
> 2026-05-20 19:44:56,403 |OFBiz-JobQueue-0 |TransactionUtil |E| [TransactionUtil.rollback]
> java.lang.Exception: Stack Trace
> at org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:328)
> at org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:304)
> at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:578)
> at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:244)
> at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:77)
> at org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:77)
> at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:106)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
> at java.base/java.lang.Thread.run(Thread.java:840)
> 2026-05-20 19:44:56,403 |OFBiz-JobQueue-0 |TransactionUtil |I| Transaction rolled back
> 2026-05-20 19:44:56,403 |OFBiz-JobQueue-0 |ServiceDispatcher |T| Sync service [order/createShipmentStatus] finished in [13] milliseconds
> 2026-05-20 19:44:56,404 |OFBiz-JobQueue-0 |GenericServiceJob |E| Async-Service failed.
> java.lang.Exception: Error doing entity-auto operation for entity ShipmentStatus in service createShipmentStatus: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])) (Error while inserting: [GenericEntity:ShipmentStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:44:56.39(java.sql.Timestamp)][shipmentId,10000(java.lang.String)][statusDate,2026-05-20 19:44:56.39(java.sql.Timestamp)][statusId,SHIPMENT_INPUT(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Referential integrity constraint violation: "SHPMNT_STTS_SHMT: OFBIZ.SHIPMENT_STATUS FOREIGN KEY(SHIPMENT_ID) REFERENCES OFBIZ.SHIPMENT(SHIPMENT_ID) ('10000')"; SQL statement:
> INSERT INTO OFBIZ.SHIPMENT_STATUS (STATUS_ID, SHIPMENT_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-240])))
> at org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80)
> at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:106)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
> at java.base/java.lang.Thread.run(Thread.java:840)
> 2026-05-20 19:44:56,408 |jsse-nio-8443-exec-7 |Log |I| [IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment line 97] order item ship grp inv res info: [GenericEntity:OrderItemShipGrpInvRes][createdDatetime,2026-05-20 19:42:05.474(java.sql.Timestamp)][createdStamp,2026-05-20 19:42:05.474(java.sql.Timestamp)][createdTxStamp,2026-05-20 19:42:04.059(java.sql.Timestamp)][currentPromisedDate,null()][inventoryItemId,9001(java.lang.String)][lastUpdatedStamp,2026-05-20 19:42:05.802(java.sql.Timestamp)][lastUpdatedTxStamp,2026-05-20 19:42:04.059(java.sql.Timestamp)][orderId,WSCO10000(java.lang.String)][orderItemSeqId,00001(java.lang.String)][priority,2(java.lang.String)][promisedDatetime,null()][quantity,5.000000(java.math.BigDecimal)][quantityNotAvailable,null()][reserveOrderEnumId,INVRO_FIFO_REC(java.lang.String)][reservedDatetime,2026-05-20 19:42:05.474(java.sql.Timestamp)][sequenceId,null()][shipGroupSeqId,00001(java.lang.String)]
> 2026-05-20 19:44:56,415 |jsse-nio-8443-exec-7 |Log |I| [IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment line 149] qtyForShipmentItem: 5
> 2026-05-20 19:44:56,415 |jsse-nio-8443-exec-7 |ServiceEcaCondition |W| doRealCompare returned null, returning false
> 2026-05-20 19:44:56,416 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/checkCanChangeShipmentStatusPacked] finished in [1] milliseconds
> 2026-05-20 19:44:56,416 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/createShipmentItem] finished in [1] milliseconds
> 2026-05-20 19:44:56,419 |jsse-nio-8443-exec-7 |UtilProperties |I| ResourceBundle DefaultMessagesUiLabels (en_GB) created in 0.002s with 0 properties
> 2026-05-20 19:44:56,421 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/createOrderShipment] finished in [1] milliseconds
> 2026-05-20 19:44:56,422 |jsse-nio-8443-exec-7 |ServiceEcaCondition |W| doRealCompare returned null, returning false
> 2026-05-20 19:44:56,422 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/facilityGenericPermission] finished in [1] milliseconds
> 2026-05-20 19:44:56,422 |jsse-nio-8443-exec-7 |ServiceDispatcher |T| Sync service [order/checkCanChangeShipmentStatusPacked] finished in [1] milliseconds
> 2026-05-20 19:44:56,422 |jsse-nio-8443-exec-7 |ServiceEcaRule |I| Running Service ECA Service: checkCreateStockRequirementQoh, triggered by rule on Service: createItemIssuance
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)