Error Connecting RRDI to DB2 database alias
I am running RRDI on RHEL5 linux with a db2 database on a repote server
I am getting the following error when setting up the data-warehouse db connection
Does anyone have any ideas on how to resolve?
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
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-0107 A general exception has occurred during the operation "attach".
SQL10007N Message "0" could not be retrieved. Reason code: "3".
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1545): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
Unlike a similar post the RPTUSER does not have an @ in the password
Would having installed DB2 client after the RRDI install cause this issue?
I am getting the following error when setting up the data-warehouse db connection
Does anyone have any ideas on how to resolve?
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
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-0107 A general exception has occurred during the operation "attach".
SQL10007N Message "0" could not be retrieved. Reason code: "3".
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1545): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
Unlike a similar post the RPTUSER does not have an @ in the password
Would having installed DB2 client after the RRDI install cause this issue?
2 answers
The following trouble shooting note I think is pointing me in the proper direction
Rational Reporting for Development Intelligence requires a 32-bit database client on 64-bit platforms. Install the 32-bit database client and restart WebSphere Application Server.
I am using a 64 bit Rehat 5 OS, when I attempted to install a 32 bit version of DB2 the installer said it was unsupported.
Where can I get a 32 bit db2 client that will run on redhat 5 64
Rational Reporting for Development Intelligence requires a 32-bit database client on 64-bit platforms. Install the 32-bit database client and restart WebSphere Application Server.
I am using a 64 bit Rehat 5 OS, when I attempted to install a 32 bit version of DB2 the installer said it was unsupported.
Where can I get a 32 bit db2 client that will run on redhat 5 64