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.))]

[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

[dhiraj.g]

Hi
how to create a Party Id ?