[jira] [Created] (OFBIZ-10124) Key conflict error for new Telecom Contact Mech record after ContactMech import

[Nicolas Malin (Jira)]

Timothy Boyden created OFBIZ-10124:
--------------------------------------

             Summary: Key conflict error for new Telecom Contact Mech record after ContactMech import
                 Key: OFBIZ-10124
                 URL: https://issues.apache.org/jira/browse/OFBIZ-10124
             Project: OFBiz
          Issue Type: Bug
    Affects Versions: Release Branch 16.11
         Environment: Windows 10 Professional x64. Java 8 JDK 152. MS SQL 2017 Linux Docker image.
            Reporter: Timothy Boyden
         Attachments: ContactMech_TelecomNumber_KeyConflict_AfterImport_error-2017-12-23-2.log

I imported 10 Party, 40 ContactMech, 10 PostalAddress, and 22 TelecomNumber records from another install of OFBiz, same release (16.11.03). I added a new Party, and a new PostalAddress ContactMech record no problem. I went to add a TelecomNumber ContactMech record for the same new Party, and received a key conflict error. I hit save again and could see that the error messages were incrementing the ContactMech key through all of the imported record's Id keys. After the 41st attempt to save the record, the Telecom record finally saved. It would seem the mechanism that the TelecomNumber ContactMech type uses to detect the next ContactMech key is not reading the SEQUENCE_VALUE_ITEM table to get the next key. Log attached.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)