ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Gray" <lekt...@gmail.com>
Subject Re: help trblshooting contact mech insert error
Date Thu, 03 Jan 2008 00:11:55 GMT
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 <Case@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/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.
> ctorres@quantumcomposers.com
> http://www.quantumcomposers.com
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message