IBM Support

IC89070: VARIOUS COGNOS REPORT ISSUES WHEN USING DB2 9.5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • There are 3 known issues that occur with Cognos-based reports
    when using TPC 5.1.1 with DB2 9.5.  These do not occur when DB2
    9.7 is used.
    
    #1
    Most Active Volumes Report displays error UDA-SQL-0353 due to a
    DB2 v9.5 limitation (61131)
    
    UDA-SQL-0353 An error was detected while processing the SQL
    request.[IBM][CLI Driver][DB2/LINUXX8664] SQL0206N
    "Union174.Volume_Utilization" is not valid in the context where
    it is used. SQLSTATE=42703
    
    RSV-SRV-0042 Trace
    back:RSReportService.cpp(779): QFException: CCL_CAUGHT:
    RSReportService::process()RSReportServiceMethod.cpp(265):
    QFException: CCL_RETHROW: RSReportServiceMethod::process():
    promptPagingForward_RequestRSASyncExecutionThread.cpp(788):
    QFException:
    RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
    (224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
    promptPagingForward_RequestRSASyncExecutionThread.cpp(838):
    QFException: CCL_RETHROW:
    RSASyncExecutionThread::processCommand():
    promptPagingForward_RequestExecution/RSRenderExecution.cpp(618):
    QFException: CCL_RETHROW:
    RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(278
    ): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly
    .cpp(77): QFException: CCL_RETHROW:
    RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(345
    ): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
    SReportPagesAssembly.cpp(176): QFException: CCL_RETHROW:
    RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cp
    p(295): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.c
    pp(300): QFException: CCL_RETHROW:
    RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(295):
    QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssemb
    ly.cpp(173): QFException: CCL_RETHROW:
    RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(2
    95): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssem
    bly.cpp(135): QFException: CCL_RETHROW:
    RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(
    345): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
    SDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyRSQueryMgr.cpp(1076):
    QFException: CCL_RETHROW:
    RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241):
    QFException: CCL_RETHROW:
    RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException:
    CCL_RETHROW:
    RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542):
    QFException: CCL_RETHROW:
    RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cp
    p(187): QFException: CCL_RETHROW:
    RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHand
    lerImpl.cpp(167): QFException: CCL_RETHROW:
    RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305):
    QFException: CCL_RETHROW:
    RSQFSession::DoRequestQFSSession.cpp(719): QFException:
    CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(717):
    QFException: CCL_CAUGHT:
    QFSSession::ProcessDoRequest()QFSSession.cpp(662): QFException:
    CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(637):
    QFException: CCL_RETHROW:
    QFSSession::ProcessDoRequest()QFSConnection.cpp(751):
    QFException: CCL_RETHROW:
    QFSConnection::ExecuteQFSQuery.cpp(213): QFException:
    CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4308):
    QFException: CCL_THROW: CoordinationPlanner
    
    
    #2
    Most Active Volumes Report displays error UDA-SQL-0353 due to a
    DB2 v9.5 limitation (62802)
    
    If in a adhoc report Storage Virtualizer Volume Grain Size,
    Storage Virtualizer Volume Warning Level columns are added with
    Storage Virtualizer Volume Physical Allocation Percentage
    report, error UDA-SQL-0144 is displayed due to a DB2 v9.5
    limitation.
    
    
    #3
    Hypervisor Disk SCSi Target when dragged in a report, in Query
    Studio gives an error
    
    Open resource model in query studio and go to:
    Hypervisor  Disks ->Paths and drag in the report Hypervisor Disk
    SCSi Target column and the following error will appear:
    
    UDA-SQL-0107 A general exception has occurred during the
    operation "prepare".[IBM][CLI Driver][DB2/LINUXX8664] SQL0440N
    No authorized routine named "VARCHAR" of type "FUNCTION" having
    compatible arguments was found. SQLSTATE=42884 RSV-SRV-0042
    Trace back:RSReportService.cpp(779): QFException: CCL_CAUGHT:
    RSReportService::process()RSReportServiceMethod.cpp(265):
    QFException: CCL_RETHROW: RSReportServiceMethod::process():
    reportEditQuerySpecification_RequestRSASyncExecutionThread.cpp(7
    88): QFException:
    RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
    (224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
    reportEditQuerySpecification_RequestRSASyncExecutionThread.cpp(8
    38): QFException: CCL_RETHROW:
    RSASyncExecutionThread::processCommand():
    reportEditQuerySpecification_RequestExecution/RSRenderExecution.
    cpp(618): QFException: CCL_RETHROW:
    RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(278
    ): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly
    .cpp(77): QFException: CCL_RETHROW:
    RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(345
    ): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
    SReportPagesAssembly.cpp(176): QFException: CCL_RETHROW:
    RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cp
    p(295): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.c
    pp(300): QFException: CCL_RETHROW:
    RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(295):
    QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssemb
    ly.cpp(173): QFException: CCL_RETHROW:
    RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(2
    95): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssem
    bly.cpp(135): QFException: CCL_RETHROW:
    RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(
    345): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
    SDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(6
    49): QFException: CCL_RETHROW:
    RSAssembly::createListIteratorAssembly/RSAssembly.cpp(702):
    QFException: CCL_RETHROW:
    RSAssembly::createListIteratorRSQueryMgr.cpp(1003): QFException:
    CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076):
    QFException: CCL_RETHROW:
    RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241):
    QFException: CCL_RETHROW:
    RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException:
    CCL_RETHROW:
    RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542):
    QFException: CCL_RETHROW:
    RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cp
    p(187): QFException: CCL_RETHROW:
    RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHand
    lerImpl.cpp(167): QFException: CCL_RETHROW:
    RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305):
    QFException: CCL_RETHROW:
    RSQFSession::DoRequestQFSSession.cpp(719): QFException:
    CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(717):
    QFException: CCL_CAUGHT:
    QFSSession::ProcessDoRequest()QFSSession.cpp(662): QFException:
    CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(637):
    QFException: CCL_RETHROW:
    QFSSession::ProcessDoRequest()QFSConnection.cpp(751):
    QFException: CCL_RETHROW:
    QFSConnection::ExecuteQFSQuery.cpp(213): QFException:
    CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4308):
    QFException: CCL_THROW: CoordinationPlanner
    

Local fix

  • Use DB2 9.7.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * TPC 5.1.1.0 users whose database repository is in DB2 9.5    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to fixing maintenance level when available.          *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is targeted for the following maintenance
    package:
    
    | fix pack | 5.1.1-TIV-TPC-FP0001 - target March 2013
    
    http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
    
    The target dates for future fix packs do not represent a formal
    commitment by IBM. The dates are subject to change without
    notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89070

  • Reported component name

    TPC

  • Reported component ID

    5608TPC00

  • Reported release

    511

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-13

  • Closed date

    2013-01-11

  • Last modified date

    2013-01-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • COGNOS
    

Fix information

  • Fixed component name

    TPC

  • Fixed component ID

    5608TPC00

Applicable component levels

  • R511 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"511","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
23 March 2022