The exception throwed in backend is something like:
RROR: parsing file: ERROR parsing Entity Xml file:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:Person][createdStamp,2011-04-28
11:09:55.29(java.sql.Timestamp)][createdTxStamp,2011-04-28
11:09:55.288(java.sql.Timestamp)][lastUpdatedStamp,2011-04-28
11:09:55.29(java.sql.Timestamp)][lastUpdatedTxStamp,2011-04-28
11:09:55.288(java.sql.Timestamp)][partyId,_NA_(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID,
SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX,
NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL,
MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT,
MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER,
PASSPORT_NUMBER, PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE,
COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION,
YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_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 'PERSON_TXCRTS' defined on
'PERSON'.))
----
If I remove the CARD_ID_IDX index (the unique index on Person.cardId), then
it works.
btw, in fact, if I use run-install command to re-create the database and
import all demo data, ton of such kind "duplicate key value" exception was
thrown out.
