When using person table for record creation

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

When using person table for record creation

dhiraj.g
The Following Errors Occurred:

ERROR: Could not complete the Create New Enquiry [file:/home/pks/Desktop/Dhiraj%20Docs/workspace3/apache-ofbiz-10.04/applications/enquiry/script/org/ofbiz/enquiry/EnquiryServices.xml#createEnquiry] process [problem creating the newEntity value: Error while inserting: [GenericEntity:Person][createdStamp,2011-12-10 20:29:13.213(java.sql.Timestamp)][createdTxStamp,2011-12-10 20:29:12.708(java.sql.Timestamp)][firstName,bnmbnm(java.lang.String)][lastName,mbnmbnmbn(java.lang.String)][lastUpdatedStamp,2011-12-10 20:29:13.213(java.sql.Timestamp)][lastUpdatedTxStamp,2011-12-10 20:29:12.708(java.sql.Timestamp)][salutation,mbmb(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PARTY_ID' cannot accept a NULL value.))]
Dhiraj Gupta
Reply | Threaded
Open this post in threaded view
|

Re: When using person table for record creation

rrhati2010
Hi Dhiraj,

Please study the DB relations first before writing DB queries.You need to create a new PartyID then only you can create a row in Person entity.

Regards
RRH
RRH
Reply | Threaded
Open this post in threaded view
|

Re: When using person table for record creation

dhiraj.g
Hi
how to create a Party Id ?





Dhiraj Gupta