Login  Register

When using person table for record creation

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

When using person table for record creation

dhiraj.g
145 posts
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
| More
Print post
Permalink

Re: When using person table for record creation

rrhati2010
67 posts
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
| More
Print post
Permalink

Re: When using person table for record creation

dhiraj.g
145 posts
Hi
how to create a Party Id ?





Dhiraj Gupta