COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => ReportNet Administration => Topic started by: swathi4cognos on 13 Mar 2007 09:41:16 AM

Title: Unable to access the datasource
Post by: swathi4cognos on 13 Mar 2007 09:41:16 AM
Hi All,

Im new to this group and wanna tips from u ppl for a couple of queries related to C8 security.

Whenever i try to access the cognos connection link of the cognos connection portal  its giving me
"The search path "storeID("")" is invalid"

i.e., CM-REQ-4078 The function "storeID" has an invalid argument.  

and the other one is..

whenever i try to excute the reportstudio report its giving me the following error
The database not found

RSV-SRV-0042 Trace back: RSReportService.cpp(624): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(168): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request RSASyncExecutionThread.cpp(520): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(175): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_Request RSASyncExecutionThread.cpp(570): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request Execution/RSRenderExecution.cpp(507): QFException: CCL_RETHROW: RSRenderExecution::execute Execution/RSRenderExecution.cpp(713): QFException: CCL_RETHROW: RSRenderExecution::processActiveDocuments Assembly/RSDocAssemblyDispatch.cpp(229): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(135): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(289): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(248): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(236): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(248): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(115): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(248): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(289): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSAssembly.cpp(487): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(722): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(787): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(955): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1516): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1499): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand QFSSession.cpp(1423): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1421): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1392): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(731): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(112): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(1306): QFException: CCL_RETHROW: QE CoordinationQFSQuery.cpp(3177): QFException: CCL_RETHROW: CoordinationQFSQuery::ProviderPrepare QFSQuery.cpp(49): QFException: CCL_RETHROW: QFSQuery::Prepare OLAPPlannerQFSQuery.cpp(1090): QFException: CCL_RETHROW: OPQFSQuery::ProviderPrepare() OLAPPlannerQFSQuery.cpp(1089): QFException: CCL_CAUGHT: OPQFSQuery::ProviderPrepare() OLAPPlannerSignon.cpp(763): QFException: CCL_THROW: OPSignon::ThrowFault806()

This is all happening for the members who are not system administrators.i.e., for the report admins..
Tried by giving the permissions for the datasource,packages and all but still the same error.

Could you people please help me out ..its really urgent ...

thanks in advance,
swathi
Title: Re: Unable to access the datasource
Post by: swathi4cognos on 15 Mar 2007 06:19:34 AM
could someone please reply to this??
Title: Re: Unable to access the datasource
Post by: CogDT on 16 Mar 2007 07:55:01 AM
Check out KB#: 1020129 - Unable to Logon to Cognos Connection