Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Unable to add connection

    Posted 12/11/20 01:55 AM
    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


  • 2.  RE: Unable to add connection

    Posted 12/14/20 03:01 AM
    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
    ------------------------------



  • 3.  RE: Unable to add connection

    Posted 01/12/21 04:28 AM
    Hi Raju

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

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

    Original Message


Related Content