COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: sdf on 26 Aug 2014 04:43:04 AM

Title: Cannot open report for one user only. [solved]
Post by: sdf on 26 Aug 2014 04:43:04 AM
Hi Guys,

Would like to seek help. One of our users reportedly is encountering error when opening a report.
The user was able to run the report before without problems.

PLease take a look at this logs and see if you can point out anything.

Thanks!


Quote
26-17:03:12.674-#26  Original Error: PDS-PPE-0216 Invalid security information provided. Unable to open ((Security)).  RSV-SRV-0042 Trace back:  RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()  RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysis_Request  RSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkException  RSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): reportEditAnalysis_Request  RSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysis_Request  PPSAnalysis.cpp(180): QFException: CCL_RETHROW: PPSAnalysis::executeAnalysis  PPSAnalysis.cpp(172): QFException: CCL_CAUGHT: PPSAnalysis::executeAnalysis  core/RequestContext.cpp(547): QFException: CCL_RETHROW: RequestContext::handleRequest  core/RequestContext.cpp(540): QFException: CCL_CAUGHT: RequestContext::handleRequest  core/RequestContext.cpp(598): QFException: CCL_RETHROW: RequestContext::establishContext  core/RequestContext.cpp(593): QFException: CCL_CAUGHT: RequestContext::establishContext  scmd/QuerySessionProxy.cpp(59): QFException: CCL_RETHROW: CFaultSavvyProxy::DoRequest  scmd/QuerySessionProxy.cpp(57): QFException: CCL_CAUGHT: CFaultSavvyProxy::DoRequest  QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()  QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()  QFSSession.cpp(688): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()  QFSXQEModelChecker.cpp(72): QFException: CCL_RETHROW: QFSXQEModelChecker::IsModelPointingToTheNewStack()  BmtRtmBuilderImp.cpp(650): QFException: CCL_RETHROW: BmtRtmBuilderImp::CreateConversionScript  BmtActionsHelper.cpp(500): QFException: CCL_RETHROW: BmtActionsHelper::DoAction  BmtActionsHelper.cpp(500): QFException: CCL_RETHROW: BmtActionsHelper::DoAction  QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()  QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()  QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()  QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()  MPCAPPDS.cpp(159): QFException: CCL_RETHROW: MPCAPPDS::ProviderConnect  MPCAPPDS.cpp(437): QFException: CCL_RETHROW:   MPCAPPDSCube.cpp(572): QFException: CCL_THROW: MPCAPPDSCube::SetCubeSecurity





Feds
Title: Re: Cannot open report for one user only.
Post by: MFGF on 26 Aug 2014 04:48:50 AM
Quote from: feds on 26 Aug 2014 04:43:04 AM
Hi Guys,

Would like to seek help. One of our users reportedly is encountering error when opening a report.
The user was able to run the report before without problems.

PLease take a look at this logs and see if you can point out anything.

Thanks!






Feds

Hi,

it sounds like the user or group the user belongs to is not defined in the Transformer model for the cube.

https://www-304.ibm.com/support/docview.wss?uid=swg21343326

Alternatively, are there any odd characters in the security names?

http://www.cognoise.com/index.php?topic=13199.0

MF.
Title: Re: Cannot open report for one user only.
Post by: sdf on 27 Aug 2014 03:04:42 AM


Just checked the cube and found that the model used was a backup where the particular user is not yet assigned to.
It seems like someone might have restored the previous backup of our model when we had power interruption a few days back.

Thanks MF.