OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-2743) GenericEntityException in createItemIssuanceRole when receiving PO in multiple attempts

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 4 messages Options
Nicolas Malin (Jira)
Reply | Threaded
Open this post in threaded view
♦
♦
|

[jira] Created: (OFBIZ-2743) GenericEntityException in createItemIssuanceRole when receiving PO in multiple attempts

Nicolas Malin (Jira)
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.

Nicolas Malin (Jira)
Reply | Threaded
Open this post in threaded view
♦
♦
|

[jira] Updated: (OFBIZ-2743) GenericEntityException in createItemIssuanceRole when receiving PO in multiple attempts

Nicolas Malin (Jira)

     [ 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.

Nicolas Malin (Jira)
Reply | Threaded
Open this post in threaded view
♦
♦
|

[jira] Assigned: (OFBIZ-2743) GenericEntityException in createItemIssuanceRole when receiving PO in multiple attempts

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ 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.

Nicolas Malin (Jira)
Reply | Threaded
Open this post in threaded view
♦
♦
|

[jira] Closed: (OFBIZ-2743) GenericEntityException in createItemIssuanceRole when receiving PO in multiple attempts

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ 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.

Free forum by Nabble Edit this page