When using person table for record creation

Posted by dhiraj.g on Dec 02, 2011; 9:55am
URL: http://ofbiz.116.s1.nabble.com/When-using-person-table-for-record-creation-tp4146023.html

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