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:rocess()
RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod:rocess(): 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:rocessCommand(): 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:oRequest
scmd/QuerySessionProxy.cpp(47): QFException: CCL_CAUGHT: CFaultSavvyProxy:oRequest
RSQFSession.cpp(216): QFException: CCL_RETHROW: RSQFSession:oRequest
QFSSession.cpp(1479): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()
QFSSession.cpp(1477): QFException: CCL_CAUGHT: QFSSession:rocessDoRequest()
QFSSession.cpp(1444): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()
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
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:rocess()
RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod:rocess(): 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:rocessCommand(): 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:oRequest
scmd/QuerySessionProxy.cpp(47): QFException: CCL_CAUGHT: CFaultSavvyProxy:oRequest
RSQFSession.cpp(216): QFException: CCL_RETHROW: RSQFSession:oRequest
QFSSession.cpp(1479): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()
QFSSession.cpp(1477): QFException: CCL_CAUGHT: QFSSession:rocessDoRequest()
QFSSession.cpp(1444): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()
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