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.
