You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Mridul Pathak (JIRA)" <ji...@apache.org> on 2009/07/21 11:48:14 UTC
[jira] Created: (OFBIZ-2743) GenericEntityException in
createItemIssuanceRole when receiving PO in multiple attempts
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.
[jira] Closed: (OFBIZ-2743) GenericEntityException in
createItemIssuanceRole when receiving PO in multiple attempts
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya closed OFBIZ-2743.
--------------------------------------
Resolution: Fixed
Thanks Mridul!
Done at r796245(trunk) & r796247(RB9.04)
--
Ashish
> 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
> Assignee: Ashish Vijaywargiya
> 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.
[jira] Assigned: (OFBIZ-2743) GenericEntityException in
createItemIssuanceRole when receiving PO in multiple attempts
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya reassigned OFBIZ-2743:
------------------------------------------
Assignee: Ashish Vijaywargiya
> 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
> Assignee: Ashish Vijaywargiya
> 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.
[jira] Updated: (OFBIZ-2743) GenericEntityException in
createItemIssuanceRole when receiving PO in multiple attempts
Posted by "Mridul Pathak (JIRA)" <ji...@apache.org>.
[ 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.