Erorr on my Analysis Studio Report, somebody help me please.. :(

[doremifasolasi]

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?

[MFGF]

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.

[doremifasolasi]

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..

[doremifasolasi]

To MF

I finally can fix it :). i replace the data source with the new one.
Thanks a lot :D