Fixes are available
Fix Pack 5.1.1.2 (September 2013) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.5 (July 2014) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.8 (July 2015) for Tivoli Storage Productivity Center
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
Document Information
Modified date:
23 March 2022