OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-3482) proper default for party.preferredCurrencyUomId

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

[jira] Created: (OFBIZ-3482) proper default for party.preferredCurrencyUomId

Nicolas Malin (Jira)
proper default for party.preferredCurrencyUomId
------------------------------------------------

                 Key: OFBIZ-3482
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3482
             Project: OFBiz
          Issue Type: Bug
          Components: party
    Affects Versions: SVN trunk
         Environment: SVN retrieved on 02/15/10
            Reporter: Babu Sreekanth
            Priority: Minor


Currently, it is possible to create a Party without specifying preferredCurrencyUomId attribute. This cause FK violation, if try to create an invoice (see the exception report below). It looks like the defaults are not set correctly, as it uses the string "defaultCurrencyUomId".
         [currencyUomId,defaultCurrencyUomId(java.lang.String)]
Two solutions.
1. set the correct value from properties file
2. Make the preferredCurrencyUomId attribute mandatory during the creation of the Party.

Thanks,
Babu.

---- exception report ----------------------------------------------------------
Failure in create operation for entity [Invoice]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)
---- cause ---------------------------------------------------------------------
Exception: java.sql.SQLIntegrityConstraintViolationException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.iapi.error.StandardException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- stack trace ---------------------------------------------------------------
ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.

--
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-3482) proper default for party.preferredCurrencyUomId

Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-3482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Babu Sreekanth updated OFBIZ-3482:
----------------------------------

    Description:
Currently, it is possible to create a Party without specifying preferredCurrencyUomId attribute. This cause FK violation, if try to create an invoice (see the exception report below). It looks like the defaults are not set correctly, as it uses the string "defaultCurrencyUomId".
         [currencyUomId,defaultCurrencyUomId(java.lang.String)]
Two solutions.
1. set the correct 'default' value from properties file
2. Make the preferredCurrencyUomId attribute mandatory during the creation of the Party.

Thanks,
Babu.

---- exception report ----------------------------------------------------------
Failure in create operation for entity [Invoice]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)
---- cause ---------------------------------------------------------------------
Exception: java.sql.SQLIntegrityConstraintViolationException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.iapi.error.StandardException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- stack trace ---------------------------------------------------------------
ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.

  was:
Currently, it is possible to create a Party without specifying preferredCurrencyUomId attribute. This cause FK violation, if try to create an invoice (see the exception report below). It looks like the defaults are not set correctly, as it uses the string "defaultCurrencyUomId".
         [currencyUomId,defaultCurrencyUomId(java.lang.String)]
Two solutions.
1. set the correct value from properties file
2. Make the preferredCurrencyUomId attribute mandatory during the creation of the Party.

Thanks,
Babu.

---- exception report ----------------------------------------------------------
Failure in create operation for entity [Invoice]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)
---- cause ---------------------------------------------------------------------
Exception: java.sql.SQLIntegrityConstraintViolationException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.iapi.error.StandardException
Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
---- stack trace ---------------------------------------------------------------
ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.


> proper default for party.preferredCurrencyUomId
> ------------------------------------------------
>
>                 Key: OFBIZ-3482
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3482
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: SVN trunk
>         Environment: SVN retrieved on 02/15/10
>            Reporter: Babu Sreekanth
>            Priority: Minor
>
> Currently, it is possible to create a Party without specifying preferredCurrencyUomId attribute. This cause FK violation, if try to create an invoice (see the exception report below). It looks like the defaults are not set correctly, as it uses the string "defaultCurrencyUomId".
>          [currencyUomId,defaultCurrencyUomId(java.lang.String)]
> Two solutions.
> 1. set the correct 'default' value from properties file
> 2. Make the preferredCurrencyUomId attribute mandatory during the creation of the Party.
> Thanks,
> Babu.
> ---- exception report ----------------------------------------------------------
> Failure in create operation for entity [Invoice]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.))
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLIntegrityConstraintViolationException
> Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
> ---- stack trace ---------------------------------------------------------------
> ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.

--
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-3482) proper default for party.preferredCurrencyUomId

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

     [ https://issues.apache.org/jira/browse/OFBIZ-3482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Bakker closed OFBIZ-3482.
------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk
                   Release Branch 9.04

should be fixed in rev:Committed revision 910460.

thank you for reporting.

> proper default for party.preferredCurrencyUomId
> ------------------------------------------------
>
>                 Key: OFBIZ-3482
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3482
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: SVN trunk
>         Environment: SVN retrieved on 02/15/10
>            Reporter: Babu Sreekanth
>            Priority: Minor
>             Fix For: Release Branch 9.04, SVN trunk
>
>
> Currently, it is possible to create a Party without specifying preferredCurrencyUomId attribute. This cause FK violation, if try to create an invoice (see the exception report below). It looks like the defaults are not set correctly, as it uses the string "defaultCurrencyUomId".
>          [currencyUomId,defaultCurrencyUomId(java.lang.String)]
> Two solutions.
> 1. set the correct 'default' value from properties file
> 2. Make the preferredCurrencyUomId attribute mandatory during the creation of the Party.
> Thanks,
> Babu.
> ---- exception report ----------------------------------------------------------
> Failure in create operation for entity [Invoice]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting: [GenericEntity:Invoice][createdStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][createdTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][currencyUomId,defaultCurrencyUomId(java.lang.String)][invoiceDate,2010-02-16 02:11:43.31(java.sql.Timestamp)][invoiceId,INV1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2010-02-16 02:11:43.327(java.sql.Timestamp)][lastUpdatedTxStamp,2010-02-16 02:11:43.137(java.sql.Timestamp)][partyId,ABJ(java.lang.String)][partyIdFrom,BBJ(java.lang.String)][statusId,INVOICE_IN_PROCESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.))
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, RECURRENCE_INFO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLIntegrityConstraintViolationException
> Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.impl.jdbc.EmbedSQLException
> Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
> ---- cause ---------------------------------------------------------------------
> Exception: org.apache.derby.iapi.error.StandardException
> Message: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.
> ---- stack trace ---------------------------------------------------------------
> ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId).  The statement has been rolled back.

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