[
https://issues.apache.org/jira/browse/OFBIZ-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux closed OFBIZ-4600.
----------------------------------
Assignee: Hans Bakker
> 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
> Assignee: Hans Bakker
>
> 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
