Getting logon failed error when trying to access any package based on oracle

[midhl]

Hi All,

When I am trying to access a package getting a Logon Failed error and this error is getting displayed for all the packages which use Oracle as the database however there are packages which use cube as data sources and they are working fine.

For your information all these packages were working fine till yesterday.
As per our knowledge no changes have been done to get this error all of a sudden.

Also when I am trying to create a new data source in cognos using oracle as database getting the same error irrespective of the schema used. However its working fine when I used cube as a data source

Checked the database independently for different schemas by logging in with the credentials and it was working fine . So this issue seems to be while linking Oracle with Cognos 8.3

Why is it that when I am trying to add a data store and click the test, I get this error:
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".
RSV-SRV-0042 Trace back:
RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportTestDataSourceConnection_Request
RSQueryMgr.cpp(1786): QFException: CCL_RETHROW: RSQueryMgr::testDataSource
RSQueryMgr.cpp(1475): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
RSQueryMgr.cpp(1462): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
RSQueryMgr.cpp(1437): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
RSQFSession.cpp(186): QFException: CCL_RETHROW: RSQFSession::DoRequest
QFSSession.cpp(610): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(608): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1481): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2049): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(804): QFException: CCL_THROW: QE


I am using Win 2000 server , Cognos 8.3 and Oracle  10g. Could somone please help me.

Thanks in advance

[blom0344]

Did you install the Oracle middleware /client on the Cognos server? What about tnsnames.ora?  Why would a working cube connection have any meaning with regards to Oracle connectivity?


Did the Oracle connection stop working overnight?  By default the authorization id would map to the schema in the Oracle instance. How did you test the connectivity to the Oracle database?