Hi, The good news, I just launched the company's new OFBiz ERP platform! Yeehaw! The old applications are turned off and the company is running on OFBiz.
I just finished importing all the contacts from the old system into ofbiz last night. I'm running into a problem where when I try to enter a new Contact Mech, via party or facility, I get an error like the one below where an insertion is trying to be make with a contact_mech_id that already exists. I'm thinking that the system is not recognizing all the new contact_mech_ids in the database. In the error below it's trying to use 10050. The last id in the system is: 73067 I've tried rebooting but the result is the same. 10050 is in use with a perfectly acceptable piece of data. Anyone have any ideas how to remedy the problem or at least where to start? Would greatly appreciate any experience/brain power you could throw my way on this matter. Thanks much, Case The Following Errors Occurred: ERROR: Could not complete the Create Contact Mechanism [file:/usr/local/ofbiz/applications/party/script/org/ofbiz/party/contact/Con tactMechServices.xml#createContactMech] process [problem creating the newValue value: Exception while inserting the following entity: [GenericEntity:ContactMech][contactMechId,10050(java.lang.String)][contactMe chTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2008-01-02 15:19:39.82(java.sql.Timestamp)][createdTxStamp,2008-01-02 15:19:39.582(java.sql.Timestamp)][lastUpdatedStamp,2008-01-02 15:19:39.82(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-02 15:19:39.582(java.sql.Timestamp)] (while inserting: [GenericEntity:ContactMech][contactMechId,10050(java.lang.String)][contactMe chTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2008-01-02 15:19:39.82(java.sql.Timestamp)][createdTxStamp,2008-01-02 15:19:39.582(java.sql.Timestamp)][lastUpdatedStamp,2008-01-02 15:19:39.82(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-02 15:19:39.582(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "pk_contact_mech")))] calling service createContactMech in createTelecomNumber calling service createTelecomNumber in createFacilityTelecomNumber --- Case Torres Quantum Composers, Inc. [EMAIL PROTECTED] http://www.quantumcomposers.com
