[OFBiz] Users - Post Import woes
Locked
[OFBiz] Users - 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.
I am here when I hit save https://localhost:8443/partymgr/control/updatePostalAddress The Following Errors Occurred:
Thanx
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
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 |
RE: [OFBiz] Users - Post Import woes
|
|
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 |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |