COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: honest_kool on 27 Jul 2010 10:47:58 PM

Title: Error Message While Joining Two Queries in CrossTab
Post by: honest_kool on 27 Jul 2010 10:47:58 PM
Hi Friends,

Please do need full it's urgent. I'm having DMR model and created 2 queries and by using join option i joined dat two queries after while i'm running the report i'm getting the error message is..Plz plz plz plz plz plz plz plz help me to come out of dis
 

GEN-ERR-0016

      The 'fn:tuple' function is not supported in the context in which it is used.

     Details
GEN-ERR-0009 Data source type(s) '' - Function 'realDataMode' is not supported in 'NoDataModeProvider'.GEN-ERR-0009 Data source type(s) 'OR' - Function 'fn:tuple' is not supported in 'RelationalQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'manyDimensions' is not supported in 'TabularOperationProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'subQuery' is not supported in 'TabularFuncProvider'.GEN-ERR-0011 The pattern 'manyDimensions' is not supported in 'RelationalQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'realDataMode' is not supported in 'NoDataModeProvider'.GEN-ERR-0009 Data source type(s) 'OR' - Function 'fn:tuple' is not supported in 'RelationalQueryProvider'.GEN-ERR-0011 The pattern 'providerQuery' is not supported in 'OlapQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'subQuery' is not supported in 'TabularFuncProvider'.GEN-ERR-0009 Data source type(s) 'OR' - Function 'fn:tuple' is not supported in 'RelationalQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'realDataMode' is not supported in 'NoDataModeProvider'.GEN-ERR-0009 Data source type(s) 'OR' - Function 'fn:tuple' is not supported in 'RelationalQueryProvider'.GEN-ERR-0011 The pattern 'providerQuery' is not supported in 'OlapQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'subQuery' is not supported in 'TabularFuncProvider'.GEN-ERR-0009 Data source type(s) 'OR' - Function 'fn:tuple' is not supported in 'RelationalQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'realDataMode' is not supported in 'NoDataModeProvider'.GEN-ERR-0009 Data source type(s) 'OR' - Function 'fn:tuple' is not supported in 'RelationalQueryProvider'.GEN-ERR-0011 The pattern 'providerQuery' is not supported in 'OlapQueryProvider'.QFS-ERR-0130 The query is not supported.RSV-SRV-0042 Trace back:RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(241): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(287): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(160): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(122): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1051): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1211): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1511): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1498): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(251): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(688): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(686): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(643): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(619): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery