RE: help trblshooting contact mech insert error [SOLVED]

[Case Torres <Ca...@casetorrestech.com>]

Increasing the appropriate seq_id in the SequenceValueItem table and
restarting ofbiz solved the problem.

Case Torres
case@casetorrestech.com

 

> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com] 
> Sent: Wednesday, January 02, 2008 4:12 PM
> To: user@ofbiz.apache.org; Case@casetorrestech.com
> 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 <Ca...@casetorrestech.com> 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.
> > ctorres@quantumcomposers.com
> > http://www.quantumcomposers.com
> >
> >
>