[
https://issues.apache.org/jira/browse/OFBIZ-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Bakker resolved OFBIZ-4600.
--------------------------------
Resolution: Not A Problem
please use jira only for errors in the standard ofbiz versions.
If you have a question use the mailing list.
> 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