APAR status
Closed as program error.
Error description
When trying to expand a hierarchy dimension on a package published in Dynamic Query mode in either Analysis or Report Studio, that contains the '&' character. We receive the following error message:?XQE-QRY-0406 At least one invalid member reference was encountered in the query "<fully qualified path to offending MUN>"??Expanding Details section:?RSV-SRV-0042 Trace back: RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysisSpecification_Request RSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): reportEditAnalysisSpecification_Request RSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysisSpecification_Request PPSAnalysis.cpp(180): QFException: CCL_RETHROW: PPSAnalysis::executeAnalysis PPSAnalysis.cpp(172): QFException: CCL_CAUGHT: PPSAnalysis::executeAnalysis core/RequestContext.cpp(547): QFException: CCL_RETHROW: RequestContext::handleRequest core/RequestContext.cpp(540): QFException: CCL_CAUGHT: RequestContext::handleRequest core/RequestContext.cpp(799): QFException: CCL_RETHROW: RequestContext::interpretActions core/RequestContext.cpp(794): QFException: CCL_CAUGHT: RequestContext::interpretActions scmd/QuerySessionProxy.cpp(59): QFException: CCL_RETHROW: CFaultSavvyProxy::DoRequest scmd/QuerySessionProxy.cpp(57): QFException: CCL_CAUGHT: CFaultSavvyProxy::DoRequest QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2 XQEConnector.cpp(552): QFException: CCL_THROW: XQEConnector::HandleMissingMembers ??We do not receive this error message if the package is published in Compatible mode.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix Pack * * 2 * * or Upgrade to IBM Cognos Business Intelligence 10.2 * * Refresh Pack 1 or Upgrade to IBM Cognos Business * * Intelligence 10.2 Fix Pack 1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM70160
Reported component name
COG8 BI ANALY S
Reported component ID
5724W12AS
Reported release
A11
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-08-02
Closed date
2013-03-28
Last modified date
2013-09-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
COG8 BI ANALY S
Fixed component ID
5724W12AS
Applicable component levels
RA11 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
06 March 2023