Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error when Drilling down a dimension in Analisys Studio

Status
Not open for further replies.

twinkle8

Technical User
Jan 8, 2008
7
ES
In Analisys Studio, in a CrossTab Report, with a row, a column and a measure when I try to drill down through a dimension the programs trhrows me the following exception:

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

The details are:

UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[Oracle][ODBC]Invalid cursor state.
RSV-SRV-0042 Trace back:
RSReportService.cpp(595): QFException: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(562): QFException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(179): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(612): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysisSpecification_Request
PPSAnalysis.cpp(149): QFException: CCL_RETHROW: PPSAnalysis::executeAnalysis
PPSAnalysis.cpp(141): QFException: CCL_CAUGHT: PPSAnalysis::executeAnalysis
core/RequestContext.cpp(525): QFException: CCL_RETHROW: RequestContext::handleRequest
core/RequestContext.cpp(518): QFException: CCL_CAUGHT: RequestContext::handleRequest
core/RequestContext.cpp(829): QFException: CCL_RETHROW: RequestContext::executeCommands
core/RequestContext.cpp(824): QFException: CCL_CAUGHT: RequestContext::executeCommands
scmd/QuerySessionProxy.cpp(49): QFException: CCL_RETHROW: CFaultSavvyProxy::DoRequest
scmd/QuerySessionProxy.cpp(47): QFException: CCL_CAUGHT: CFaultSavvyProxy::DoRequest
RSQFSession.cpp(216): QFException: CCL_RETHROW: RSQFSession::DoRequest
QFSSession.cpp(1479): QFException: CCL_RETHROW: QFSSession::processDoRequest()
QFSSession.cpp(1477): QFException: CCL_CAUGHT: QFSSession::processDoRequest()
QFSSession.cpp(1444): QFException: CCL_RETHROW: QFSSession::processDoRequest()
QFSConnection.cpp(771): QFException: CCL_RETHROW: QFSConnection::Execute
QFSQuery.cpp(115): QFException: CCL_RETHROW: QFSQuery::Execute v2
CoordinationQFSQuery.cpp(3643): QFException: CCL_THROW: CoordinationPlanner

I am using Oracle 8i and an ODBC Oracle Connection...
Anyone can help me?
Thanks,
Bea
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top