When i used Person Tabel For new Record Creation

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

When i used Person Tabel For new Record Creation

dhiraj.g
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
Dhiraj Gupta