Increasing the appropriate seq_id in the SequenceValueItem table and restarting ofbiz solved the problem.
Case Torres [EMAIL PROTECTED] > -----Original Message----- > From: Scott Gray [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 02, 2008 4:12 PM > To: [email protected]; [EMAIL PROTECTED] > Subject: Re: help trblshooting contact mech insert error > > I *think* you'll need to update the value in the > SequenceValueItem entity to 73070, ideally when importing you > should either let the system generate the ids or otherwise > stay below 10000 > > Regards > Scott > > On 03/01/2008, Case Torres <[EMAIL PROTECTED]> wrote: > > > > 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/conta > > ct/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 > > > > >
