Troubleshooting
Problem
User runs a standard report. User receives an error message.
Symptom
The exact error will vary depending on version of Cognos BI/Cognos Analytics and Controller.
Example (Controller 10.1.0):
Status:
Failure
Message:
QE-DEF-0285 The logon failed.
Log Data:
QE-DEF-0285 The logon failed.QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: SQLNCLI.1:servername:databasename:SQLlogin UDA-SQL-0031 Unable to access the "SQLNCLI.1:servername:databasename:SQLlogin" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0532 Data Source is not accessible: "grbfincont01".UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. (SQLSTATE=08001, SQLERRORCODE=14)
Failure
Message:
QE-DEF-0285 The logon failed.
Log Data:
QE-DEF-0285 The logon failed.QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: SQLNCLI.1:servername:databasename:SQLlogin UDA-SQL-0031 Unable to access the "SQLNCLI.1:servername:databasename:SQLlogin" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0532 Data Source is not accessible: "grbfincont01".UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. (SQLSTATE=08001, SQLERRORCODE=14)
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller 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.
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21627740