getting Error 'SqlOpenResult' status='-28' in RRDI
![]()
while running a report though cognos reporting studio, for a specific iteration value below error appearing whereas for other iteration value it is running well. Please help.
getting Error 'SqlOpenResult' status='-28' in RRDIUDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SOR-0005 Unable to write the file.RSV-SRV-0042 Trace back:RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(670): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(291): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(358): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(358): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSResultSetIterator.cpp(1479): QFException: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE |
Accepted answer
![]()
Hello Ayan,
UDA-SOR-0005 seems to hint to the fact that you are out of disk space on the RRDI server. See the following cognos technotes: (TR2934) UDA-SOR-0005 Unable to write the file. http://www-01.ibm.com/support/docview.wss?uid=swg21506970 Error when running report: UDA-SOR-0005 Unable to write the file.. https://www-304.ibm.com/support/docview.wss?uid=swg21338861 Best Regards, Francesco Chiossi Ayan Paul selected this answer as the correct answer
|
5 other answers
![]()
Thanks for your answer. I am seeing a file (named uda32513313519083467) present in that location with 10gb space. which I am trying to remove but can't be able to do that. Please help.
|
![]()
Hello Ayan,
the following technote explains the reason you get those large uda files: What are UDA Temp Files? http://www-01.ibm.com/support/docview.wss?uid=swg21358858 If you are not able to remove the file, it might be still in use by the report server. You can try stopping the RRDI WAS profile and deleting the file. Best Regards, Francesco Chiossi |
![]()
Hello Ayan,
i don't think there's a way to limit the size of the temporary files. You can only set them to be created to a different disk or partition, so that if it's going to fill up at least it won't affect the rest of the server; see the procedure here: How to change the default location of the TEMP folder in ReportNet or Cognos 8 http://www-01.ibm.com/support/docview.wss?uid=swg21339784 As for identifying the culprit report, looks for those working on large data sets, several joins, large returned results... When you find the one that generate the large temp file, you can try to simplify it. Best Regards, Francesco Chiossi |