If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

UDA-SQL-0283 Metadata describing Error

Started by saragose, 26 Aug 2013 02:43:29 PM

Previous topic - Next topic

saragose

Hi Guys,
I'm writing a fairly complex report. It calls a number of different procs which return to me cursors with the values needed. These procs can be called more than once by this report.
I've been working on this report for a week, and thought that it ran without error. Only when I started testing it with multiple examples did it start giving me errors.
Oddly, I've tried deleting most of the components and adding them back one at a time, and the errors went away, till I tried another example, so seems to cache the values based on what we send to the procs.
I've tried updating the procs in framework manager and even deleting them, but I still get errors. However, I get no error when I ask the framework manager for a sample. Also, I've had the proc email me the query, and the query runs without a hitch, there are no nulls or special characters.
When I run the report, I get the error RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
However, on the server, I pulled this error from cogserver.log:
Original Error: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0283 Metadata describing "T1.SON_ID" does not match results from the database.
RSV-SRV-0042 Trace back:
RSReportService.cpp(595): QFException: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request
RSASyncExecutionThread.cpp(562): QFException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(179): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): pagingLastPage_Request
RSASyncExecutionThread.cpp(612): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): pagingLastPage_Request
Execution/RSRenderExecution.cpp(584): QFException: CCL_RETHROW: RSRenderExecution::execute
Execution/RSRenderExecution.cpp(856): QFException: CCL_RETHROW: RSRenderExecution::processActiveDocuments
Assembly/RSDocAssemblyDispatch.cpp(235): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSLayoutAssembly.cpp(135): QFException: CCL_RETHROW: RSLayoutAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSPageAssembly.cpp(247): QFException: CCL_RETHROW: RSPageAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSTableRowAssembly.cpp(136): QFException: CCL_RETHROW: RSTableRowAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(333): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssembly
RSQueryMgr.cpp(1007): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator
RSQueryMgr.cpp(1169): QFException: CCL_RETHROW: RSQueryMgr::createIterator
RSQueryMgr.cpp(1455): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
RSQueryMgr.cpp(1442): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
RSQueryMgrExecutionHandlerImpl.cpp(156): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
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

The cursor and metadata errors stood out for me, but I'm in over my head.
I appreciate any insight that anyone might have.

Thanks,
Eric