Mailing-List: contact dev-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ofbiz.apache.org
Date: Fri, 2 Dec 2011 06:09:40 +0000 (UTC)
From: "Dhiraj Gupta (Created) (JIRA)" <jira@apache.org>
To: dev@ofbiz.apache.org
Message-ID: 
 <1294887273.34037.1322806180021.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Created] (OFBIZ-4600) When i used Person Tabel For new
 Record Creation
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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.20=
7(java.sql.Timestamp)][firstName,ghjghj(java.lang.String)][lastName,jghjghj=
(java.lang.String)][lastUpdatedStamp,2011-12-10 12:24:58.963(java.sql.Times=
tamp)][lastUpdatedTxStamp,2011-12-10 12:24:58.207(java.sql.Timestamp)][part=
yId,10040(java.lang.String)][salutation,hjghjg(java.lang.String)] (SQL Exce=
ption while executing the following:INSERT INTO OFBIZ.PERSON (PARTY_ID, SAL=
UTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNA=
ME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMB=
ER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NA=
ME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, PASSPORT_EXPIR=
E_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, EMPLOYMENT_STATUS_ENUM_ID, R=
ESIDENCE_STATUS_ENUM_ID, OCCUPATION, YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLO=
YER, 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 'PER=
SON_PARTY' for key (10040).  The statement has been rolled back.))
please Sort out this error=20


Thanks
 Dhiraj=20


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs: https://issues.apache.org/jira/secure/ContactAdministrators!default.jsp=
a
For more information on JIRA, see: http://www.atlassian.com/software/jira