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

Issues with RRDI 2.0 setup on AIX

Questions
Tags
Users
Badges
Murali Dhandapani
(116●9●8) Jul 30 '12, 10:32 p.m.
I could deploy RRDI 2.0 successfully on AIX. When I perform the RRDI 2.0 setup at stage 6 ( Build and Deploy Reporting Components) I get the following database error.

CRRRA3018E: The RIDW data source connection in Cognos failed to connect. Check if the database client is installed correctly or additional configurations are needed.

A warning occurred while deploying the reporting components.
  • Add Rational Reporting style files to the reporting components
  • Package the reporting components as an EAR file
  • Update the report server configuration
  • Deploy the EAR file to the specified application server
  • Wait for the report server to initialize and set the Rational Reporting style
A warning occurred while deploying the reporting components.
hide details
CRRRA3018E: The RIDW data source connection in Cognos failed to connect. Check if the database client is installed correctly or additional configurations are needed.


I am deploying RRDI 2.0 on single server and have installed  DB2 9.7 ESE , DB2 9.7 client. Following are the installation logs. What else is needed to resolve the issue. ?

bash-3.00# ls | grep rsp
db2client.rsp
db2ese.rsp
db2rtcl.rsp
bash-3.00# cat db2client.rsp
*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 7/30/12 5:47 PM
*-----------------------------------------------------
*  Product Installation
LIC_AGREEMENT       = ACCEPT
PROD       = CLIENT
FILE       = /opt/IBM/db2/SCV9.7
INSTALL_TYPE       = TYPICAL
*-----------------------------------------------
*  Das properties
*-----------------------------------------------
*-----------------------------------------------
*  Installed Languages
*-----------------------------------------------
LANG       = EN
bash-3.00# cat db2ese.rsp
*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 7/30/12 5:16 PM
*-----------------------------------------------------
*  Product Installation
LIC_AGREEMENT       = ACCEPT
PROD       = ENTERPRISE_SERVER_EDITION
FILE       = /opt/IBM/db2/SCV9.7
INSTALL_TYPE       = TYPICAL
*-----------------------------------------------
*  Das properties
*-----------------------------------------------
* ----------------------------------------------
*  Instance properties
* ----------------------------------------------
INSTANCE       = inst1
inst1.TYPE       = ese
*  Instance-owning user
inst1.NAME       = db2inst2
inst1.GROUP_NAME       = db2iadm1
inst1.HOME_DIRECTORY       = /home/db2inst2
inst1.PASSWORD       = 380575433623913639007836874154965434540229743715820655632                                                                                                                     338336730327463774578645623866
ENCRYPTED       = inst1.PASSWORD
inst1.AUTOSTART       = YES
inst1.SVCENAME       = db2c_db2inst2
inst1.PORT_NUMBER       = 50006
inst1.FCM_PORT_NUMBER       = 60016
inst1.MAX_LOGICAL_NODES       = 4
inst1.CONFIGURE_TEXT_SEARCH       = NO
*  Fenced user
inst1.FENCED_USERNAME       = db2fenc2
inst1.FENCED_GROUP_NAME       = db2fadm1
inst1.FENCED_HOME_DIRECTORY       = /home/db2fenc2
inst1.FENCED_PASSWORD       = 72240516769534065423955477443229636220894700055638                                                                                                                     0067630457132465477530707253455300709
ENCRYPTED       = inst1.FENCED_PASSWORD
* Contact  properties
CONTACT       = contact1
contact1.CONTACT_NAME       = db2inst2
contact1.EMAIL       = db2inst2@islswestest5.in.ibm.com
contact1.PAGER       = false
contact1.NEW_CONTACT       = YES
contact1.INSTANCE       = inst1
*-----------------------------------------------
*  Installed Languages
*-----------------------------------------------
LANG       = EN
bash-3.00# ls | grep rsp
db2client.rsp
db2ese.rsp
db2rtcl.rsp
bash-3.00# cat db2rtcl.rsp
*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 7/30/12 5:57 PM
*-----------------------------------------------------
*  Product Installation
LIC_AGREEMENT       = ACCEPT
PROD       = RUNTIME_CLIENT
FILE       = /opt/IBM/db2/SCV9.7
INSTALL_TYPE       = TYPICAL
*-----------------------------------------------
*  Das properties
*-----------------------------------------------
*-----------------------------------------------
*  Installed Languages
*-----------------------------------------------


0 votes

5 answers
7,900 views
0 votes

5 answers

Permanent link
li yaqiang
(194●2●3) Jul 31 '12, 12:00 a.m.
The main reason of that warning message is that the DB2 32 bits client ODBC driver file can not be found in the Websphere server LIBPATH environment in the AIX. You should add the DB2 32 bits client lib path to the LIBPATH environment in the [profile name]/bin/startServer.sh file.

0 votes

Permanent link
Murali Dhandapani
(116●9●8) Jul 31 '12, 12:11 a.m.
I get this error while running the rrdi setup...  so when do we need to update the path.... is it before running RRDI 2.- setup..

Need some clarity on this.

0 votes

Permanent link
Murali Dhandapani
(116●9●8) Jul 31 '12, 12:32 a.m.
I completed the RRDI 2.0 setup by clicking Finish with the above warning.

Now,

I ran bash-3.00# source /home/db2inst2/sqllib/db2profile

and also set the following path.

bash-3.00# export LIBPATH=$LIBPATH:/home/db2inst2/sqllib/lib32
bash-3.00# echo $LIBPATH
/usr/lib:/lib:/home/db2inst2/sqllib/lib64:/home/db2inst2/sqllib/lib32


Stopped RRDI2.0 WAS profile

./stopServer.sh RationalReportingServer
and started again
 ./startServer.sh RationalReportingServer

And now when I tested the Data Source Connections, it succeeded without any issues  :)

Thanks a lot yaqiang . You are a Don!!.. :)





0 votes

Permanent link
Ahmad Syahid
(1) Sep 27 '13, 7:47 a.m.
Would you mind to update solving method for this issue, if it's running on windows ??
Since I have the same problem , but It happened in Windows OS.

Thanks and Regards,

Syahid

0 votes

Comments
Murali Dhandapani
Sep 27 '13, 8:54 a.m.

I used AIX 64bit and DB2 64 bit ESE. But RRDI required 32 DB2 client.

I installed 32 bit DB2 client and set the environment with 32bit path as above.

Later started RRDI.. things worked. Nothing much done other than this.

Permanent link
Ahmad Syahid
(1) Sep 27 '13, 9:09 a.m.
Recently I noticed this statement in RRDI Installation :

Note: WebSphere Application Server must be installed prior to running this setup. If you install the 32 bits Rational Reporting, please use the 32 bits WebSphere Application Server. If you install the 64 bits Rational Reporting, please use the 64 bits WebSphere Appilcation Server.

SO, I thought it's best to use the same environment for both.

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
× 403

Question asked: Jul 30 '12, 10:32 p.m.

Question was seen: 7,900 times

Last updated: Sep 27 '13, 9:09 a.m.

Confirmation Cancel Confirm