IBM Support

Prompt for DB2 datasource credentials loops when running report in IBM Cognos Analytics

Troubleshooting


Problem

Prompt for CQM DB2 datasource credentials loops when running report in IBM Cognos Analytics even with verified correct user name and password.
The datasource tests successfully with the same credentials.

Cause

Flipper service is not configured properly

Resolving The Problem

Add FQDN of the server in Subject Alternative Names in Cryptography - Cognos in Cognos Configuration

Add entries for the server IP address and its FQDN name and the server IP address and its hostname in /etc/hosts of the Linux server

Restart Cognos

Document Location

Worldwide

[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d6aAAA","label":"Cognos Connection Portal"}],"ARM Case Number":"TS005615399","Platform":[{"code":"PF016","label":"Linux"}],"Version":"11.1.1"}]

Document Information

Modified date:
10 May 2021

UID

ibm16451237