IBM Support

Connection to Cognos Analytics 11 package datasource prompts for database password and loops

Troubleshooting


Problem

Connection to CA 11 DQM(Dynamic Query Mode) package datasource from Transformer 10.2.2 prompts for database password and loops, reprompting for the credentials. Altough the database signon information is stored it reprompts and even after providing the right credentials it still keeps reprompting till you hit cancel.

Symptom

Below is the screenshot of the new model creation wizard that gets invoked after creation of new model. The datasource signon information although provided accurately(and saved in datasource connection signon) keeps looping and reprompting for credentials.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Transformer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg22006860