ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dhiraj Gupta (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OFBIZ-4600) When i used Person Tabel For new Record Creation
Date Fri, 02 Dec 2011 06:09:40 GMT
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

       

Mime
View raw message