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
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.
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
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
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