APAR status
Closed as fixed if next.
Error description
With Cognos Analytics 11.2 Dashboard, use a filter within This tab on a Measure field REVENUE based on a DQM Framework Manager package against an Oracle relational data source having a column data type NUMBER (18,4) fails with the error ?Query Service internal error has occurred, please see the log for details.?
Local fix
Workaround ----------- a. Filter based on the Dashboard Field properties, however, require Dashboard edit access. b. Create a Data Set using FM DQM package or Data Module c. Alter Oracle table column as NUMBER (19,4) instead of NUMBER (18,4)
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Analytics 11.2.2 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH40405
Reported component name
COG FRAMEWRK MG
Reported component ID
5724W12FM
Reported release
B09
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-09-07
Closed date
2022-03-28
Last modified date
2022-03-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B09"}]
Document Information
Modified date:
29 March 2022