IBM Support

Connect to Cognos data source fails with QE-DEF-0285 the logon failed message

Troubleshooting


Problem

Attempts to Connect to Cognos data source using IBM Rational Reporting for Development Intelligence (RRDI) or in IBM Rational Insight result in error "RQP-DEF-0068 Unable to connect ... ".

Symptom

Steps to reproduce:


1. Navigate to http://<cognos-server>:<cognos-port>/reporting.


2. Click Launch > IBM Cognos Administration.


3. Go to Configuration tab.


4. In Actions section click More... and Test Connection. This results to the following error message on the screen:

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:

testDataSourceconnection
UDA-SQL-0031 Unable to access the "testDataSourceconnection" 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-0107 A general exception has occurred during the operation"attach".

Error while trying to retrieve text for error ORA-01804








The same error message appears in <RRDI-server>\cognos\cogserver.log file.

Cause

ORACLE_HOME environmental variable not properly set or not set at all

Environment

Linux
RRDI 2.0.1 or newer

Rational Insight 1.1.1 or newer

Resolving The Problem

  1. Locate the following line.

    export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}

  2. Add additional two lines to <RRDI-install>/setup/tool/startServer.sh file.

    export ORACLE_BASE=/<Oracle-install>/product
    export ORACLE_HOME=/<Oracle-install>/product/11.2.0/

    Where <Oracle-install> is your installation location of the Oracle database.

[{"Product":{"code":"SSRL5J","label":"Rational Insight"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Report Design and Report Management","Platform":[{"code":"PF016","label":"Linux"}],"Version":"1.1.1;1.1.1.1;1.1.1.2;1.1.1.3;1.1.1.4;1.1.1.5;1.1.1.6;1.1.1.7","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSAVQ5","label":"Rational Reporting for Development Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Report Server","Platform":[{"code":"PF016","label":"Linux"}],"Version":"2.0.1;2.0.3;2.0.4;2.0.5;2.0.6","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
29 September 2018

UID

swg21638503

Page Feedback