[
https://issues.apache.org/jira/browse/OFBIZ-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mridul Pathak updated OFBIZ-2743:
---------------------------------
Attachment: OFBIZ-2743.patch
Here is the patch for the fix.
> 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
>
> Attachments: OFBIZ-2743.patch
>
>
> 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.
