Custom Reporting --- Failed to log into data warehouse RIDW
I've just installed the Custom Reporting tool for RQM on my linux machine with my own WAS server. The web application is running ok, but I can't seem to connect to the data warehouse database RIDW. I have checked the userid and password in the jdbc connection string 'jdbc:db2://localhost:50001/RIDW' and the db2 port address. I already use the same jdbc connection details for the Content Manager database RICM and that is working fine.
The DB2 aliases are correct. However, I still get the following error message when I test the connection. Any ideas why ? I have checked the internet, IBM and Cognos websites for likely causes but none of the remedies have helped. Thanks for your advice D QE-DEF-0285 The logon failed. QE-DEF-0321 The userID or password is either missing or invalid. 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-0129 Invalid login information was detected by the underlying database. SQL1013N The database alias name or database name "RIDW" could not be found. SQLSTATE=42705 BME-EX-0144 Trace back: BmtPlayTransaction.cpp(744): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction BmtActionsHelper.cpp(475): QFException: CCL_RETHROW: BmtActionsHelper::DoAction QFSSession.cpp(603): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(601): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1417): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection() Source/QE_RsApi.cpp(2064): QFException: CCL_RETHROW: QE Source/QEI_ConnectionFault.cpp(807): QFException: CCL_THROW: QE |
7 answers
I also meet the same error,anybody help!
I've just installed the Custom Reporting tool for RQM on my linux machine with my own WAS server. The web application is running ok, but I can't seem to connect to the data warehouse database RIDW. I have checked the userid and password in the jdbc connection string 'jdbc:db2://localhost:50001/RIDW' and the db2 port address. I already use the same jdbc connection details for the Content Manager database RICM and that is working fine. |
So, you probably know this but it warrents mention that you're not using the default db2 port it looks like, the default is 50000. Could you post your entire connection string? Did you try connecting without using the signon and using the text boxes on the test connection page instead?
|
So, you probably know this but it warrents mention that you're not using the default db2 port it looks like, the default is 50000. Could you post your entire connection string? Did you try connecting without using the signon and using the text boxes on the test connection page instead? Hi, Yes, the db2 port is correct 50001 as mentioned I already use this port for the Content manager connection with a similar string which works ok. I have tried all different signon variations including specifying the userid and passed on the connection page. Here is the full string from the web interface. I assume the %s will be filled in with the correct password by the application: - ^User ID:^?Password:;LOCAL;D2;DSN=RIDW;UID=%s;PWD=%s;jdbc:db2://localhost:50001/RIDW@ASYNC=0@0/0@COLSEQ= /etc/services entry for db2inst2 :- db2c_db2inst2 50001/tcp db2inst2 config entry for the service is :- db2inst2@dpayne:~> db2 get dbm cfg | grep SVCE TCP/IP Service name (SVCENAME) = db2c_db2inst2 I do appreciate this is a tricky one to resolve. Thanks D |
|
Are there any useful logs or debug options that I can use to fix or diagnose this problem ?
Thanks D |
|
the primary Cognos log is in /cognos/logs/cogserver.log. you could also check out the ri_jdbc.log file in Documents and Settings/current user/logs/ri_jdbc.log
|
the primary Cognos log is in /cognos/logs/cogserver.log. you could also check out the ri_jdbc.log file in Documents and Settings/current user/logs/ri_jdbc.log Thanks for the advice. The cogserver.log shows no errors just initialization messages. I don't have a ri_jdbc.log, is that a windows only file ( I'm on SuSE linux). Thanks D |
the primary Cognos log is in /cognos/logs/cogserver.log. you could also check out the ri_jdbc.log file in Documents and Settings/current user/logs/ri_jdbc.log Thanks for the advice. The cogserver.log shows no errors just initialization messages. I don't have a ri_jdbc.log, is that a windows only file ( I'm on SuSE linux). Thanks D Any updates on this old topic? I met the same issue |
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.