Adding new company detail. ?

[jsmith_dev]

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')))

[Jacques Le Roux]

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.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')))
>

You need to give us more context, which version for instance?

Jacques

[Paul Foxworthy]

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 <[hidden email]>
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: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]

[Ratnesh Upadhyay-2]

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 <[hidden email]
> 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')))
>