Dear all,
Something goes wrong with my analysis report today, while i didnt change anything on Cognos Framework before today. The erorr state like this:
RQP-DEF-0177 An error occurred while performing operation 'sqlUpdateAttach' status='-9'.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Invalid object name 'user_session'. (SQLSTATE=42S02, SQLERRORCODE=208)
RSV-SRV-0042 Trace back:
RSReportService.cpp(610): QFException: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(520): QFException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(173): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(570): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysisSpecification_Request
PPSAnalysis.cpp(258): QFException: CCL_RETHROW: PPSAnalysis::executeAnalysis
PPSAnalysis.cpp(250): QFException: CCL_CAUGHT: PPSAnalysis::executeAnalysis
core/RequestContext.cpp(521): QFException: CCL_RETHROW: RequestContext::handleRequest
core/RequestContext.cpp(514): QFException: CCL_CAUGHT: RequestContext::handleRequest
core/RequestContext.cpp(799): QFException: CCL_RETHROW: RequestContext::executeCommands
core/RequestContext.cpp(794): QFException: CCL_CAUGHT: RequestContext::executeCommands
scmd/QuerySessionProxy.cpp(49): QFException: CCL_RETHROW: CFaultSavvyProxy::DoRequest
scmd/QuerySessionProxy.cpp(47): QFException: CCL_CAUGHT: CFaultSavvyProxy::DoRequest
QFSSession.cpp(1424): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1422): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1393): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSConnection.cpp(750): QFException: CCL_RETHROW: QFSConnection::Execute
QFSQuery.cpp(112): QFException: CCL_RETHROW: QFSQuery::Execute v2
CoordinationQFSQuery.cpp(3471): QFException: CCL_THROW: CoordinationPlanner
What's wrong with my report?
Hi,
It sounds like your connection to the database cannot be established. Is it possible that the database signon to SQL Server has been changed?
MF.
Thanks a lot for your reply :)
I didnt change anything also on the database.
When i try to test the connection on data source (at Tools-directory-data source), it succeeded, but when i try to run metadata wizard (on framework manager), it s erorr :(
so wht must i do? im new at Cognos..
To MF
I finally can fix it :). i replace the data source with the new one.
Thanks a lot :D