[jira] [Created] (OFBIZ-4600) When i used Person Tabel For new Record Creation
Locked
[jira] [Created] (OFBIZ-4600) When i used Person Tabel For new Record Creation
 
|
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 |
[jira] [Resolved] (OFBIZ-4600) When i used Person Tabel For new Record Creation
|
|
[ 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 |
[jira] [Closed] (OFBIZ-4600) When i used Person Tabel For new Record Creation
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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 |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |