GenericEntityException in createItemIssuanceRole when receiving PO in multiple
attempts
---------------------------------------------------------------------------------------
Key: OFBIZ-2743
URL: https://issues.apache.org/jira/browse/OFBIZ-2743
Project: OFBiz
Issue Type: Bug
Components: product
Affects Versions: Release Branch 4.0, Release Branch 9.04
Reporter: Mridul Pathak
Priority: Minor
Fix For: Release Branch 4.0, Release Branch 9.04
Following error log is generated:
2009-07-21 14:28:07,284 (http-0.0.0.0-8443-2) [
ServiceEcaRule.java:151:INFO ] Running Service ECA Service:
updateIssuanceShipmentAndPoOnReceiveInventory, triggered by rule on Service:
receiveInventoryProduct
2009-07-21 14:28:07,436 (http-0.0.0.0-8443-2) [
PrimaryKeyFinder.java:142:INFO ] Returning null because found incomplete
primary key in find: [GenericEntity:Shipment]
2009-07-21 14:28:07,542 (http-0.0.0.0-8443-2) [
GenericDelegator.java:843:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [ItemIssuanceRole]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ItemIssuanceRole][createdStamp,2009-07-21
14:28:07.437(java.sql.Timestamp)][createdTxStamp,2009-07-21
14:28:07.099(java.sql.Timestamp)][itemIssuanceId,10003(java.lang.String)][lastUpdatedStamp,2009-07-21
14:28:07.437(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-21
14:28:07.099(java.sql.Timestamp)][partyId,ADMIN(java.lang.String)][roleTypeId,PACKER(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ITEM_ISSUANCE_ROLE (ITEM_ISSUANCE_ID, PARTY_ID, ROLE_TYPE_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have
caused a duplicate key value in a unique or primary key constraint or unique
index identified by 'SQL090721135155730' defined on 'ITEM_ISSUANCE_ROLE'.)).
Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting:
[GenericEntity:ItemIssuanceRole][createdStamp,2009-07-21
14:28:07.437(java.sql.Timestamp)][createdTxStamp,2009-07-21
14:28:07.099(java.sql.Timestamp)][itemIssuanceId,10003(java.lang.String)][lastUpdatedStamp,2009-07-21
14:28:07.437(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-21
14:28:07.099(java.sql.Timestamp)][partyId,ADMIN(java.lang.String)][roleTypeId,PACKER(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ITEM_ISSUANCE_ROLE (ITEM_ISSUANCE_ID, PARTY_ID, ROLE_TYPE_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have
caused a duplicate key value in a unique or primary key constraint or unique
index identified by 'SQL090721135155730' defined on 'ITEM_ISSUANCE_ROLE'.))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO
OFBIZ.ITEM_ISSUANCE_ROLE (ITEM_ISSUANCE_ID, PARTY_ID, ROLE_TYPE_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have
caused a duplicate key value in a unique or primary key constraint or unique
index identified by 'SQL090721135155730' defined on 'ITEM_ISSUANCE_ROLE'.)
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException
Message: The statement was aborted because it would have caused a duplicate key
value in a unique or primary key constraint or unique index identified by
'SQL090721135155730' defined on 'ITEM_ISSUANCE_ROLE'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
