Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Unable to open Console on BLUDB (Db2 on Cloud free plan)

    Posted Thu April 01, 2021 07:17 PM

    When opening the console , getting error when opening the console for BLUDB ( DB2 on cloud Free plan)

    {"trace":"c199a44cce39bb87f9b3fb85186e287d","errors":[{"code":"authentication_failure","message":"HWCSEC0016E: Authentication failed for SSO. This may caused by failed to generate access token in console side using existing credentials.","target":{"type":"","name":""},"more_info":""}]}

    Is the issue because the password has been updated? The password in the service credentials does not match the updated password .

    How to resolve the issue so that I can access the console ?

    I would also like to down the SSL certificate , for which I need to access the console too.

    Thanks!






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Unable to open Console on BLUDB (Db2 on Cloud free plan)

    Posted Sat April 03, 2021 04:19 PM

    Same here, tried deleting and recreating the db2 service multiple times. No luck.

    {"trace":"5870690f97de8a739ba6702f689c83b3","errors":[{"code":"authentication_failure","message":"HWCSEC0016E: Authentication failed for SSO. This may caused by failed to generate access token in console side using existing credentials.","target":{"type":"","name":""},"more_info":""}]}






    #Db2
    #Support
    #SupportMigration


  • 3.  RE: Unable to open Console on BLUDB (Db2 on Cloud free plan)

    Posted Mon April 05, 2021 10:46 PM

    I`m having the same problem.

    {

    "db": "BLUDB",

    "dsn": "DATABASE=BLUDB;HOSTNAME=dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net;PORT=50000;PROTOCOL=TCPIP;UID=pnn99090;PWD=8vkq38;",

    "host": "dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net",

    "hostname": "dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net",

    "https_url": "https://dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net",

    "jdbcurl": "jdbc:db2://dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net:50000/BLUDB",

    "parameters": {

    "role_crn": "crn:v1:bluemix:public:iam::::serviceRole:Manager"

    },

    "password": "8vkq38",

    "port": 50000,

    "ssldsn": "DATABASE=BLUDB;HOSTNAME=dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net;PORT=50001;PROTOCOL=TCPIP;UID=pnn99090;PWD=8vkq38;Security=SSL;",

    "ssljdbcurl": "jdbc:db2://dashdb-txn-sbox-yp-dal09-11.services.dal.bluemix.net:50001/BLUDB:sslConnection=true;",

    "uri": "db2://pnn99090:8vkq38%404dn410482:50000/BLUDB",

    "username": "pnn99090"

    }






    #Db2
    #Support
    #SupportMigration


  • 4.  RE: Unable to open Console on BLUDB (Db2 on Cloud free plan)

    Posted Tue June 22, 2021 03:33 PM

    Same error what was resolution?

    {"trace":"76517e16a401979062ec2884f92d3909","errors":[{"code":"authentication_failure","message":"HWCSEC0016E: Authentication failed for SSO. This may caused by failed to generate access token in console side using existing credentials.","target":{"type":"","name":""},"more_info":""}]}






    #Db2
    #Support
    #SupportMigration