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.