[OFBiz] Users - Post Import woes

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[OFBiz] Users - Post Import woes

Fred Forester-2
Post Import woes

Hi All,

I just imported customer(party) data. I can view the customer info ok however updates fail on duplicate key errors.
after the import the max contactMechId is 575686. Not sure why ofbiz wants to insert with 10015.


I am here when I hit save

https://localhost:8443/partymgr/control/updatePostalAddress

The Following Errors Occurred:

    • ERROR: Could not complete the Create Contact Mechanism [createContactMech] process [problem creating the newValue value: Exception while inserting the following entity: [GenericEntity:ContactMech][contactMechId,10015(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2005-08-23 15:20:04.754(java.sql.Timestamp)][createdTxStamp,2005-08-23 15:20:04.746(java.sql.Timestamp)][infoString,null()][lastUpdatedStamp,2005-08-23 15:20:04.754(java.sql.Timestamp)][lastUpdatedTxStamp,2005-08-23 15:20:04.746(java.sql.Timestamp)] (while inserting: [GenericEntity:ContactMech][contactMechId,10015(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,2005-08-23 15:20:04.754(java.sql.Timestamp)][createdTxStamp,2005-08-23 15:20:04.746(java.sql.Timestamp)][infoString,null()][lastUpdatedStamp,2005-08-23 15:20:04.754(java.sql.Timestamp)][lastUpdatedTxStamp,2005-08-23 15:20:04.746(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL050819104902550' defined on 'CONTACT_MECH'.)))] calling service createContactMech in updatePostalAddress calling service updatePostalAddress in updatePartyPostalAddress


Thanx
Fred Forester


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Post Import woes

David E. Jones

Because you need to update the value(s) in the SequenceValueItem  
entity's table.

-David


On Aug 23, 2005, at 12:36 PM, Fred Forester wrote:

>
>
> Hi All,
>
> I just imported customer(party) data. I can view the customer info  
> ok however updates fail on duplicate key errors.
> after the import the max contactMechId is 575686. Not sure why  
> ofbiz wants to insert with 10015.
>
>
> I am here when I hit save
>
> https://localhost:8443/partymgr/control/updatePostalAddress
>
> The Following Errors Occurred:
>
> ERROR: Could not complete the Create Contact Mechanism  
> [createContactMech] process [problem creating the newValue value:  
> Exception while inserting the following entity:  
> [GenericEntity:ContactMech][contactMechId,10015(java.lang.String)]
> [contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,
> 2005-08-23 15:20:04.754(java.sql.Timestamp)][createdTxStamp,
> 2005-08-23 15:20:04.746(java.sql.Timestamp)][infoString,null()]
> [lastUpdatedStamp,2005-08-23 15:20:04.754(java.sql.Timestamp)]
> [lastUpdatedTxStamp,2005-08-23 15:20:04.746(java.sql.Timestamp)]  
> (while inserting: [GenericEntity:ContactMech][contactMechId,10015
> (java.lang.String)][contactMechTypeId,POSTAL_ADDRESS
> (java.lang.String)][createdStamp,2005-08-23 15:20:04.754
> (java.sql.Timestamp)][createdTxStamp,2005-08-23 15:20:04.746
> (java.sql.Timestamp)][infoString,null()][lastUpdatedStamp,
> 2005-08-23 15:20:04.754(java.sql.Timestamp)][lastUpdatedTxStamp,
> 2005-08-23 15:20:04.746(java.sql.Timestamp)] (SQL Exception while  
> executing the following:INSERT INTO OFBIZ.CONTACT_MECH  
> (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING,  
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was  
> aborted because it would have caused a duplicate key value in a  
> unique or primary key constraint or unique index identified by  
> 'SQL050819104902550' defined on 'CONTACT_MECH'.)))] calling service  
> createContactMech in updatePostalAddress calling service  
> updatePostalAddress in updatePartyPostalAddress
>
>
> Thanx
> Fred Forester
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

RE: [OFBiz] Users - Post Import woes

Fred Forester-2

Yup that did it.

thanx.
Fred

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
On Behalf Of David E. Jones
Sent: Tuesday, August 23, 2005 2:57 PM
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Post Import woes



Because you need to update the value(s) in the SequenceValueItem  
entity's table.

-David


On Aug 23, 2005, at 12:36 PM, Fred Forester wrote:

>
>
> Hi All,
>
> I just imported customer(party) data. I can view the customer info
> ok however updates fail on duplicate key errors.
> after the import the max contactMechId is 575686. Not sure why  
> ofbiz wants to insert with 10015.
>
>
> I am here when I hit save
>
> https://localhost:8443/partymgr/control/updatePostalAddress
>
> The Following Errors Occurred:
>
> ERROR: Could not complete the Create Contact Mechanism  
> [createContactMech] process [problem creating the newValue value:  
> Exception while inserting the following entity:  
> [GenericEntity:ContactMech][contactMechId,10015(java.lang.String)]
> [contactMechTypeId,POSTAL_ADDRESS(java.lang.String)][createdStamp,
> 2005-08-23 15:20:04.754(java.sql.Timestamp)][createdTxStamp,
> 2005-08-23 15:20:04.746(java.sql.Timestamp)][infoString,null()]
> [lastUpdatedStamp,2005-08-23 15:20:04.754(java.sql.Timestamp)]
> [lastUpdatedTxStamp,2005-08-23 15:20:04.746(java.sql.Timestamp)]  
> (while inserting: [GenericEntity:ContactMech][contactMechId,10015
> (java.lang.String)][contactMechTypeId,POSTAL_ADDRESS
> (java.lang.String)][createdStamp,2005-08-23 15:20:04.754
> (java.sql.Timestamp)][createdTxStamp,2005-08-23 15:20:04.746
> (java.sql.Timestamp)][infoString,null()][lastUpdatedStamp,
> 2005-08-23 15:20:04.754(java.sql.Timestamp)][lastUpdatedTxStamp,
> 2005-08-23 15:20:04.746(java.sql.Timestamp)] (SQL Exception while  
> executing the following:INSERT INTO OFBIZ.CONTACT_MECH  
> (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING,  
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was  
> aborted because it would have caused a duplicate key value in a  
> unique or primary key constraint or unique index identified by  
> 'SQL050819104902550' defined on 'CONTACT_MECH'.)))] calling service  
> createContactMech in updatePostalAddress calling service  
> updatePostalAddress in updatePartyPostalAddress
>
>
> Thanx
> Fred Forester
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users