Troubleshooting
Problem
When testing the Framework Manager data source in a project, we are getting these errors below. The Framework Manager project is using Compatible query mode.
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: ABCDE
UDA-SQL-0031 Unable to access the "ABCDE" 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: "XXX_ABCDE".
ORA-12154: TNS:could not resolve the connect identifier specified
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: ABCDE
UDA-SQL-0031 Unable to access the "ABCDE" 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: "XXX_ABCDE".
ORA-12154: TNS:could not resolve the connect identifier specified
Framework Manager is working fine for other projects and other data sources.
We have confirmed that the Oracle 32-bit client for Oracle 12 which matches the Oracle database version, is already installed on the machine where Framework Manager is installed. We know that Framework Manager requires the 32-bit Oracle client.
We have also confirmed that both the ODBC and the JDBC data source connections for this data source test successfully within Cognos Administration > Configuration > Data Sources. Since this Framework Manager project uses compatible query mode, it is not using the JDBC connection which is only for dynamic query mode.
What is causing these errors to occur?
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl4NAAS","label":"Modeling-\u003EFramework Manager"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)","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"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation 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:
14 January 2026
UID
ibm16254013