Hi Team, 

Earlier i had configured few connections with DMC but we are not seeing those connections now. But when I try to add a connection getting below error. 

HWCCON0043E: Failed to create connection profile ca4conlabd015-AUDDB01 because One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "IBMCONSOLE.PROFILE" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.27.25.

------------------------------
Raju Bhupatiraju
------------------------------

#Db2

Hi Raju

Thanks for reaching out. There are 2 items mentioned in your description. One is the previous connections added in the DMC are missing. 2nd is the error when adding new connection. It looks something wrong with the connection profile data kept in repository database. I will let dev to take a quick look to see if any suggestion on debugging this case.
At the same time, I would recommend you to open a support case and provide related log as guided. It will be more efficient for log file transfer via support system rather than here in community.

​​

------------------------------
Su Li Hou
------------------------------

Original Message:
Sent: Fri December 11, 2020 01:54 AM
From: Raju Bhupatiraju
Subject: Unable to add connection

Hi Team, 

Earlier i had configured few connections with DMC but we are not seeing those connections now. But when I try to add a connection getting below error. 

HWCCON0043E: Failed to create connection profile ca4conlabd015-AUDDB01 because One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "IBMCONSOLE.PROFILE" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.27.25.

------------------------------
Raju Bhupatiraju
------------------------------

#Db2

Hi Raju

May I know any news regarding to this topic? Any case opened to track it?
​

------------------------------
Su Li Hou
------------------------------

Original Message:
Sent: Mon December 14, 2020 03:00 AM
From: Su Li Hou
Subject: Unable to add connection

Hi Raju

Thanks for reaching out. There are 2 items mentioned in your description. One is the previous connections added in the DMC are missing. 2nd is the error when adding new connection. It looks something wrong with the connection profile data kept in repository database. I will let dev to take a quick look to see if any suggestion on debugging this case.
At the same time, I would recommend you to open a support case and provide related log as guided. It will be more efficient for log file transfer via support system rather than here in community.

​​

------------------------------
Su Li Hou

Original Message:
Sent: Fri December 11, 2020 01:54 AM
From: Raju Bhupatiraju
Subject: Unable to add connection

Hi Team, 

Earlier i had configured few connections with DMC but we are not seeing those connections now. But when I try to add a connection getting below error. 

HWCCON0043E: Failed to create connection profile ca4conlabd015-AUDDB01 because One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "IBMCONSOLE.PROFILE" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.27.25.

------------------------------
Raju Bhupatiraju
------------------------------

#Db2