When i used Person Tabel For new Record Creation
------------------------------------------------
Key: OFBIZ-4600
URL: https://issues.apache.org/jira/browse/OFBIZ-4600
Project: OFBiz
Issue Type: Bug
Reporter: Dhiraj Gupta
I have Developed new module enquiry in ofbiz. I created a form. I am trying to
create record using person table through form . It gives the following Error.
Message: Error while inserting: [GenericEntity:Person][createdStamp,2011-12-10
12:24:58.963(java.sql.Timestamp)][createdTxStamp,2011-12-10
12:24:58.207(java.sql.Timestamp)][firstName,ghjghj(java.lang.String)][lastName,jghjghj(java.lang.String)][lastUpdatedStamp,2011-12-10
12:24:58.963(java.sql.Timestamp)][lastUpdatedTxStamp,2011-12-10
12:24:58.207(java.sql.Timestamp)][partyId,10040(java.lang.String)][salutation,hjghjg(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PERSON' caused a
violation of foreign key constraint 'PERSON_PARTY' for key (10040). The
statement has been rolled back.))
please Sort out this error
Thanks
Dhiraj
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
