OFBiz › OFBiz - User

help trblshooting contact mech insert error

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 4 messages Options
CaseT
Reply | Threaded
Open this post in threaded view
♦
♦
|

help trblshooting contact mech insert error

CaseT
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.
[hidden email]
http://www.quantumcomposers.com
Scott Gray
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: help trblshooting contact mech insert error

Scott Gray
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 <[hidden email]> 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/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.
> [hidden email]
> http://www.quantumcomposers.com
>
>
CaseT
Reply | Threaded
Open this post in threaded view
♦
♦
|

RE: help trblshooting contact mech insert error

CaseT
In reply to this post by CaseT
I found from searching google that it's a table and will update the column.
Thanks again Scott.
 

Case Torres
[hidden email]

 


  _____  

From: Case Torres [mailto:[hidden email]]
Sent: Wednesday, January 02, 2008 4:16 PM
To: 'Scott Gray'
Subject: RE: help trblshooting contact mech insert error


Thanks for responding so quickly Scott.
Can you tell me where do I find the "SequenceValueItem entity"? Also, do you
know if there are some docs explaining the workings of this entity?
 
Thanks again,
 

Case Torres
[hidden email]

 


  _____  

From: Scott Gray [mailto:[hidden email]]
Sent: Wednesday, January 02, 2008 4:12 PM
To: [hidden email]; [hidden email]
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 <[hidden email]> 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/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.
[hidden email]
http://www.quantumcomposers.com 




CaseT
Reply | Threaded
Open this post in threaded view
♦
♦
|

RE: help trblshooting contact mech insert error [SOLVED]

CaseT
In reply to this post by Scott Gray
Increasing the appropriate seq_id in the SequenceValueItem table and
restarting ofbiz solved the problem.

Case Torres
[hidden email]

 

> -----Original Message-----
> From: Scott Gray [mailto:[hidden email]]
> Sent: Wednesday, January 02, 2008 4:12 PM
> To: [hidden email]; [hidden email]
> 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 <[hidden email]> 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.
> > [hidden email]
> > http://www.quantumcomposers.com
> >
> >
>

Free forum by Nabble Edit this page