If you are unable to create a new account, please email support@bspsoftware.com

 

UDA-SQL-0107 A general exception has occurred during the operation "attach".

Started by rontuibeo, 20 Sep 2011 01:07:12 AM

Previous topic - Next topic

rontuibeo

Hi,
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 WinXp SP3, Cognos 8.3 and OracleXE 10g.
I tried the tnsping and I get this:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jing1)(P
ORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (210 msec)

Any idea why I can't login to Oracle from Cognos?

Thanks.