Content Manager Issue in RI using DB2
Hi,
I below error while connecting to Content manager using db2 in Rational Insight: Content Manager failed to connect to the content store. The connection string is "jdbc:db2://9.184.14.158:50000/RICM:retrieveMessagesFromServerOnGetMessage=true;fullyMaterializeLobData=false;". Please help out from this ISSUE |
6 answers
Is your content store database:
1. local or on a remote system 2. using the database alias RICM Can you connect to your RICM database from the DB2 command line? If so, have you installed the DB2 database libraries in Cognos (see step 3)? http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m0/topic/com.ibm.rational.raer.install.doc/topics/t_postreq_reportalserver_db2isdw_repservISwas.html Lawrence |
Is your content store database: I am having the same problem trying to connect to the Content Store on a Linux install using DB2 and I can conect to the DB from the CLI and have added the files as suggested above. Is there anything else I can check? |
|
Hi Alan,
For future posts, in general it's best to start a new topic rather than resurrect an old one like this. (The last post here was almost a full year ago.) You'll likely get a better response that way. However, it turns out I was still monitoring this topic so... Can you provide any further information? Do you have DB2 and Insight installed on the same system? Did you install the content store (RICM) database automatically or manually? Can you confirm that the installation succeeded by checking the log files? What specific error message shows when attempting to connect in the Cognos configuration tool? |
Hi Alan, Hi Lawerence, I will keep in mind creating new topics for future reference. I have installed DB2 9.7 and Insight 1.0.1.1 on a Red Hat Linux 5.7 Virtual Machine. I installed the RICM db manually and it completed successfully. I can connect to RICM using the DB2 Client with the userid setup in Insight. The error I get when Testing the connection from Insight is: ERROR ] The database connection failed. Content Manager failed to connect to the content store. The connection string is "jdbc:db2:RICM:retrieveMessagesFromServerOnGetMessage=true;fullyMaterializeLobData=false;". |
|
Hi Alan,
RHEL 5.7 is not a supported platform for Insight 1.0.1.1. However, I do not know of any specific reason why Insight will not run on this version of the OS. I don't see any server details in your connection string. Did you provide them in the configuration? Also, just because the RICM database exists doesn't mean that it is necessarily populated correctly. Can you confirm that the RICM database was created successfully by checking the log files? |
Hi Alan, Hi Lawerence, OK, the log files were inconclusive from the install because I manually ran the creation of RICM using the install.sh script to guide me. The reason for doing that is that the script failed trying to create the tablespaces stating that "A database connection does not exist" When I ran the commands manually the database appeared to create without a problem. However as there obviously was a problem I have deleted the RICM db and tried the script again. I get the same error on the tablespaces although the createDB.log tells me the database was created successfully. Should I adapt the script to try to connect to the database prior to the creation of tablespaces or run the commands manually from that point? |
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.