Hi Juan, As per the logs it seems that a contactMech with Id "10002" has already been persisted in your database. You can fix it by setting up maximum count in SequenceValueItem entity for contactMech and restart the server to get the next sequence Id.
Thanks! Regards, Ratnesh Upadhyay HotWax Systems | www.hotwaxsystems.com On Mon, Jan 22, 2018 at 2:05 PM, Julian Smith <[email protected] > wrote: > 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. > Timestamp)] > (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][ > 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. > Timestamp)] > (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'))) >
