Author Topic: 'SQLOpenResult' status='-28'.  (Read 49 times)

0 Members and 1 Guest are viewing this topic.

Offline JusticeLeague

  • Sr. Member
  • *
  • Posts: 354
  • Karma: +1/-0
    • View Profile
'SQLOpenResult' status='-28'.
« on: February 18, 2010, 05:23:33 AM »
Can somebody share some information regarding this error?.

I've been encountering this for quite sometime now and dont know how to resolve this.. any idea?


UDA-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(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(740): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(614): QFException: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(251): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(63): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(284): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(154): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(108): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSAssembly.cpp(610): QFException: CCL_RETHROW: RSAssembly::createListIterator Assembly/RSAssembly.cpp(651): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(953): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(1020): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1173): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1484): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1471): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(172): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQFSession.cpp(250): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(665): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(663): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(612): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(573): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(738): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(176): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3853): QFException: CCL_THROW: CoordinationPlanner

Techronnati | where technology never sleeps

'SQLOpenResult' status='-28'.
« on: February 18, 2010, 05:23:33 AM »

Mountain View

Offline rpmolecule

  • Full Member
  • *
  • Posts: 228
  • Karma: +1/-0
  • Seize the Day!
    • View Profile
Re: 'SQLOpenResult' status='-28'.
« Reply #1 on: April 03, 2010, 09:05:34 AM »
I get this often... mainly the result of the sql loading... your queries must be so complex, the server cannot retrieve the data on spot..


Offline sandeep.pamarati

  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-1
    • View Profile
Re: 'SQLOpenResult' status='-28'.
« Reply #2 on: April 03, 2010, 09:06:05 AM »
Hi,

What are you trying to do when you got this error?


Offline rpmolecule

  • Full Member
  • *
  • Posts: 228
  • Karma: +1/-0
  • Seize the Day!
    • View Profile
Re: 'SQLOpenResult' status='-28'.
« Reply #3 on: April 03, 2010, 09:09:24 AM »
hi sandeep.

one workaround i do is to make the query simple... i test the query using the view tabular format.... if it became successful then i run the report after... but if the view tabular format i still get this error.. i adjust the query properties.... look for the Database Only vs Local Limited Processing in Cognos 8 Reports... this might do the trick..

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
103 Views
Last post August 07, 2014, 03:18:32 AM
by Transformer10
1 Replies
117 Views
Last post November 19, 2008, 07:04:47 AM
by Corps
0 Replies
99 Views
Last post November 24, 2008, 01:45:10 AM
by Corps
2 Replies
411 Views
Last post April 06, 2017, 05:37:22 AM
by CyborgRepublic

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.