Hi Julian and Jacques, Problem was sequence numbers were too low after an import of data. Should be fine now.
Cheers Paul Foxworthy On 22 January 2018 at 19:39, Jacques Le Roux <[email protected]> wrote: > Le 22/01/2018 à 09:35, Julian Smith a écrit : > >> The Following Errors Occurred: >> >> Exception thrown while creating the "newValue" GenericValue: >> org.apache.ofbiz.entity.GenericEntityException: Error while inserting: >> [GenericEntity:ContactMech][contactMechId,10002(java.lang. >> String)][contactMechTypeId,WEB_ADDRESS(java.lang.String)][ >> createdStamp,2018-01-22 >> 19:30:51.839(java.sql.Timestamp)][createdTxStamp,2018-01-22 >> 19:30:51.788(java.sql.Timestamp)][infoString,https://blockfreight.com >> (java.lang.String)][lastUpdatedStamp,2018-01-22 19:30:51.839(java.sql. >> Timestamp)][lastUpdatedTxStamp,2018-01-22 19:30:51.788(java.sql.Timestam >> p)] >> (SQL Exception while executing the following:INSERT INTO CONTACT_MECH >> (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, >> ?, >> ?, ?, ?) ((conn=1857) Duplicate entry '10002' for key 'PRIMARY')) (Error >> while inserting: [GenericEntity:ContactMech][co >> ntactMechId,10002(java.lang. >> String)][contactMechTypeId,WEB_ADDRESS(java.lang.String)][ >> createdStamp,2018-01-22 >> 19:30:51.839(java.sql.Timestamp)][createdTxStamp,2018-01-22 >> 19:30:51.788(java.sql.Timestamp)][infoString,https://blockfreight.com >> (java.lang.String)][lastUpdatedStamp,2018-01-22 19:30:51.839(java.sql. >> Timestamp)][lastUpdatedTxStamp,2018-01-22 19:30:51.788(java.sql.Timestam >> p)] >> (SQL Exception while executing the following:INSERT INTO CONTACT_MECH >> (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, >> ?, >> ?, ?, ?) ((conn=1857) Duplicate entry '10002' for key 'PRIMARY'))) >> >> You need to give us more context, which version for instance? > > Jacques > > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
