Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRDI- Configuring Cognos datawarehouse with Oracle fails.

Questions
Tags
Users
Badges
Naresh MedaJagannath
JAZZ DEVELOPER (11●1) Sep 28 '11, 2:33 a.m.
I am configuring RRDI with Oracle database. Test connection fails when i am configuring Cognos data source connection for the data warehouse.

have tried the following steps to resolve but still unable to solve the issue.

1.Changing the port number of the database and creating the listener for the same.

2.Setting path in environment variables for PATH, ORACLE_HOME, CRN_ROOT

PATH :C:\oracle\product\10.2.0\db_1\BIN;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin\classic;C:\oracle\product\10.2.0\db_1\bin;C:\Program Files\IBM\Java60\jre\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;c:\program files (x86)\ibm\gsk8\lib;C:\IBM\ITM\bin;C:\IBM\ITM\bin\dll;C:\IBM\ITM\InstallITM;C:\IBM\ITM\TMAITM6

ORACLE_HOME:C:\oracle\product\10.2.0\db_1\bin

Note:Also tired by giving path of ORACLE_HOME without bin.
****
CRN_ROOT: C:\Program Files (x86)\IBM\RRDI\cognos\templates\ccs\xslt\crn

3.Adding latest driver file into RRDI location
("C:\Program Files (x86)\IBM\RRDI\AppServer\profiles\RationalReport\installedApps\svtw2k3x64-48Node02Cell\IBM Cognos 8.ear\p2pd.war\WEB-INF\lib")

4.All permissions for the user is granted in Cognos configuration tool and Oracle.

5.Created entry of user DSN and System DSN in odbcad32.exe.

6.Verified the port numbers of the listener configured.

7.Verified the entries in tnsnames.ora file.

The following Error message is displayed
**********************************
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:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "RIDW".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1548): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE


0 votes

6 answers
11,769 views
0 votes

6 answers

Permanent link
Michael Fox
JAZZ DEVELOPER (616●4●3) Sep 29 '11, 11:12 a.m.
I am configuring RRDI with Oracle database. Test connection fails when i am configuring Cognos data source connection for the data warehouse.

have tried the following steps to resolve but still unable to solve the issue.

1.Changing the port number of the database and creating the listener for the same.

2.Setting path in environment variables for PATH, ORACLE_HOME, CRN_ROOT

PATH :C:\oracle\product\10.2.0\db_1\BIN;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin\classic;C:\oracle\product\10.2.0\db_1\bin;C:\Program Files\IBM\Java60\jre\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;c:\program files (x86)\ibm\gsk8\lib;C:\IBM\ITM\bin;C:\IBM\ITM\bin\dll;C:\IBM\ITM\InstallITM;C:\IBM\ITM\TMAITM6

ORACLE_HOME:C:\oracle\product\10.2.0\db_1\bin

Note:Also tired by giving path of ORACLE_HOME without bin.
****
CRN_ROOT: C:\Program Files (x86)\IBM\RRDI\cognos\templates\ccs\xslt\crn

3.Adding latest driver file into RRDI location
("C:\Program Files (x86)\IBM\RRDI\AppServer\profiles\RationalReport\installedApps\svtw2k3x64-48Node02Cell\IBM Cognos 8.ear\p2pd.war\WEB-INF\lib")

4.All permissions for the user is granted in Cognos configuration tool and Oracle.

5.Created entry of user DSN and System DSN in odbcad32.exe.

6.Verified the port numbers of the listener configured.

7.Verified the entries in tnsnames.ora file.

The following Error message is displayed
**********************************
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:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "RIDW".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1548): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE



Are you using a 64 bit Oracle? If so, you need to get and install the 32 bit client.

0 votes

Permanent link
Ming Cheung
(41●3●3) Sep 30 '11, 10:22 a.m.
Hi Mike,

I saw the same issue when using the 32-bit client connecting to 64-bit Oracle. The issue might be the installation directory, it looks like it is installed in "Program Files (x86)" which may have restrictions placed on it by the OS.

I have not been able to verify this, but you can try uninstalling and installing it under another directory, like C:\IBM\RRDI.



I am configuring RRDI with Oracle database. Test connection fails when i am configuring Cognos data source connection for the data warehouse.

have tried the following steps to resolve but still unable to solve the issue.

1.Changing the port number of the database and creating the listener for the same.

2.Setting path in environment variables for PATH, ORACLE_HOME, CRN_ROOT

PATH :C:\oracle\product\10.2.0\db_1\BIN;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin\classic;C:\oracle\product\10.2.0\db_1\bin;C:\Program Files\IBM\Java60\jre\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;c:\program files (x86)\ibm\gsk8\lib;C:\IBM\ITM\bin;C:\IBM\ITM\bin\dll;C:\IBM\ITM\InstallITM;C:\IBM\ITM\TMAITM6

ORACLE_HOME:C:\oracle\product\10.2.0\db_1\bin

Note:Also tired by giving path of ORACLE_HOME without bin.
****
CRN_ROOT: C:\Program Files (x86)\IBM\RRDI\cognos\templates\ccs\xslt\crn

3.Adding latest driver file into RRDI location
("C:\Program Files (x86)\IBM\RRDI\AppServer\profiles\RationalReport\installedApps\svtw2k3x64-48Node02Cell\IBM Cognos 8.ear\p2pd.war\WEB-INF\lib")

4.All permissions for the user is granted in Cognos configuration tool and Oracle.

5.Created entry of user DSN and System DSN in odbcad32.exe.

6.Verified the port numbers of the listener configured.

7.Verified the entries in tnsnames.ora file.

The following Error message is displayed
**********************************
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:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "RIDW".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1548): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE



Are you using a 64 bit Oracle? If so, you need to get and install the 32 bit client.

0 votes

Permanent link
Michael Fox
JAZZ DEVELOPER (616●4●3) Oct 03 '11, 11:20 a.m.
Hi Mike,

I saw the same issue when using the 32-bit client connecting to 64-bit Oracle. The issue might be the installation directory, it looks like it is installed in "Program Files (x86)" which may have restrictions placed on it by the OS.

I have not been able to verify this, but you can try uninstalling and installing it under another directory, like C:\IBM\RRDI.



I am configuring RRDI with Oracle database. Test connection fails when i am configuring Cognos data source connection for the data warehouse.

have tried the following steps to resolve but still unable to solve the issue.

1.Changing the port number of the database and creating the listener for the same.

2.Setting path in environment variables for PATH, ORACLE_HOME, CRN_ROOT

PATH :C:\oracle\product\10.2.0\db_1\BIN;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin\classic;C:\oracle\product\10.2.0\db_1\bin;C:\Program Files\IBM\Java60\jre\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;c:\program files (x86)\ibm\gsk8\lib;C:\IBM\ITM\bin;C:\IBM\ITM\bin\dll;C:\IBM\ITM\InstallITM;C:\IBM\ITM\TMAITM6

ORACLE_HOME:C:\oracle\product\10.2.0\db_1\bin

Note:Also tired by giving path of ORACLE_HOME without bin.
****
CRN_ROOT: C:\Program Files (x86)\IBM\RRDI\cognos\templates\ccs\xslt\crn

3.Adding latest driver file into RRDI location
("C:\Program Files (x86)\IBM\RRDI\AppServer\profiles\RationalReport\installedApps\svtw2k3x64-48Node02Cell\IBM Cognos 8.ear\p2pd.war\WEB-INF\lib")

4.All permissions for the user is granted in Cognos configuration tool and Oracle.

5.Created entry of user DSN and System DSN in odbcad32.exe.

6.Verified the port numbers of the listener configured.

7.Verified the entries in tnsnames.ora file.

The following Error message is displayed
**********************************
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:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "RIDW".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1548): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE



Are you using a 64 bit Oracle? If so, you need to get and install the 32 bit client.
The following has been posted in a similar work item. Hopefully it will help:

"I don't know your oracle client is thin one(140M just unzipped) or fat one(1G need install). Both could be work even Oracle client and server on different system.RICM for report server and RIDW for report both could be connected
for thin one:
1.Set ORACLE_HOME and PATH to your client folder(mine is C:\software\instantclient_11_2).
2.write the "tnsnames.ora" and "listener.ora"(for RIDW) and copy them to the created folder /network/admin.(whole path:C:\software\instantclient_11_2\network\admin)
3.I want to mentioned if you change the environment variables,we should restarted the RRDI to see the result.
4.Configure the RICM: copy odbc5.jar to "cognos\webapps\p2pd\WEB-INF\lib" and "IBM Cognos 8.ear/p2pd.war/WEB-INF/lib if need.
Check the RICM in cognos configuration manager could be connected and RIDW could be connected in data source connection from cognos page.
Fat one much easier.but they both need create listener and service naming in oracle server."

0 votes

Permanent link
Michael Fox
JAZZ DEVELOPER (616●4●3) Oct 03 '11, 11:30 a.m.
Hi Mike,

I saw the same issue when using the 32-bit client connecting to 64-bit Oracle. The issue might be the installation directory, it looks like it is installed in "Program Files (x86)" which may have restrictions placed on it by the OS.

I have not been able to verify this, but you can try uninstalling and installing it under another directory, like C:\IBM\RRDI.



I am configuring RRDI with Oracle database. Test connection fails when i am configuring Cognos data source connection for the data warehouse.

have tried the following steps to resolve but still unable to solve the issue.

1.Changing the port number of the database and creating the listener for the same.

2.Setting path in environment variables for PATH, ORACLE_HOME, CRN_ROOT

PATH :C:\oracle\product\10.2.0\db_1\BIN;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin;C:\Program Files (x86)\IBM\RRDI\jdk\jre\bin\classic;C:\oracle\product\10.2.0\db_1\bin;C:\Program Files\IBM\Java60\jre\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;c:\program files (x86)\ibm\gsk8\lib;C:\IBM\ITM\bin;C:\IBM\ITM\bin\dll;C:\IBM\ITM\InstallITM;C:\IBM\ITM\TMAITM6

ORACLE_HOME:C:\oracle\product\10.2.0\db_1\bin

Note:Also tired by giving path of ORACLE_HOME without bin.
****
CRN_ROOT: C:\Program Files (x86)\IBM\RRDI\cognos\templates\ccs\xslt\crn

3.Adding latest driver file into RRDI location
("C:\Program Files (x86)\IBM\RRDI\AppServer\profiles\RationalReport\installedApps\svtw2k3x64-48Node02Cell\IBM Cognos 8.ear\p2pd.war\WEB-INF\lib")

4.All permissions for the user is granted in Cognos configuration tool and Oracle.

5.Created entry of user DSN and System DSN in odbcad32.exe.

6.Verified the port numbers of the listener configured.

7.Verified the entries in tnsnames.ora file.

The following Error message is displayed
**********************************
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:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "RIDW".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1548): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE



Are you using a 64 bit Oracle? If so, you need to get and install the 32 bit client.
The following has been posted in a similar work item. Hopefully it will help:

"I don't know your oracle client is thin one(140M just unzipped) or fat one(1G need install). Both could be work even Oracle client and server on different system.RICM for report server and RIDW for report both could be connected
for thin one:
1.Set ORACLE_HOME and PATH to your client folder(mine is C:\software\instantclient_11_2).
2.write the "tnsnames.ora" and "listener.ora"(for RIDW) and copy them to the created folder /network/admin.(whole path:C:\software\instantclient_11_2\network\admin)
3.I want to mentioned if you change the environment variables,we should restarted the RRDI to see the result.
4.Configure the RICM: copy odbc5.jar to "cognos\webapps\p2pd\WEB-INF\lib" and "IBM Cognos 8.ear/p2pd.war/WEB-INF/lib if need.
Check the RICM in cognos configuration manager could be connected and RIDW could be connected in data source connection from cognos page.
Fat one much easier.but they both need create listener and service naming in oracle server."
You might also check this post in the Rational Insight forum. RRDI should work the same as Insight.
https://jazz.net/forums/viewtopic.php?t=18967

0 votes

Permanent link
Naresh MedaJagannath
JAZZ DEVELOPER (11●1) Oct 04 '11, 2:29 a.m.
Hi All,
I tried all the suggestions mentioned below and still i see no changes. I have to try and see if reinstalling in different location works. Will update if that works.

0 votes

Permanent link
Naresh MedaJagannath
JAZZ DEVELOPER (11●1) Oct 12 '11, 2:40 a.m.
Hi All,
I tried all the suggestions mentioned below and still i see no changes. I have to try and see if reinstalling in different location works. Will update if that works.


Hi All,
I was able verify this, uninstalling and installing it under another directory, like C:\IBM\RRDI worked.
Thanks Foxm

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,617

Question asked: Sep 28 '11, 2:33 a.m.

Question was seen: 11,769 times

Last updated: Sep 28 '11, 2:33 a.m.

Confirmation Cancel Confirm