IBM Support

Cognos Analytics 11.0.13 Interim Fix 1 and Cognos Analytics 11.1.7 Interim Fix 3

Download


Abstract

This interim fix resolves an issue introduced in IBM Cognos Analytics version 11.0.13 IF1060 and 11.1.7 IF1007 where a report could return incorrect data or an error.

Download Description

Affected reports involve queries that require joins where the join...
  • may be defined between query subjects in a model or between queries in a report
  • includes a reference to a vendor specific function passing literal (constant) values such as 'ABC', 123
  • and the function is referenced in a detail filter or is part of the relationship (join) definition
Possible side effects are:
1) A column in the report returns the data of another column instead of the expected data.
2) An error about data type incompatibility is thrown, such as:
XQE-GEN-0002 An unexpected exception occurred: com.cognos.xqe.data.values.IntegerValue incompatible with com.cognos.xqe.data.values.IExtract
3) A SQL error about a column name not being valid is thrown. Some examples:
-com.ibm.db2.jcc.am.SqlSyntaxErrorException: "C3" is not valid in the context where it is used
-[Amazon](500310) Invalid operation: column "c3" does not exist in query1, query2, unnamed_join;
4) Local processing may start occurring, which could lead to this error:
XQE-PLN-0098 The vendor specific function "<function_name>" is not supported.

Prerequisites

Review the system requirements for the product in the IBM Cognos Analytics 11.x Installation and Configuration Guide. This document is available from the IBM Cognos Analytics Knowledge Center.

[{"PRLabel":"Knowledge Center","PRLang":"English","PRSize":"1 B","PRPlat":{"label":"Windows","code":"PF033"},"PRURL":"https://www.ibm.com/support/knowledgecenter/SSEP7J"}]

Installation Instructions

The installation process for 11.0.13 has changed, and now uses the same installer as Cognos 11.1.
Please download the "11.0.13_Install_Document" which is available in each of the Fix Central (FC) links in the download section below.

Download Package

It is recommended that you install the latest generally available interim fix.

On
[{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 AIX ","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"3.98 GB","DNPlat":{"label":"AIX","code":"PF002"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-AIX64-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 Linux pSeries","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"3.81 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-Linuxppc64-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 Linux p LE ","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"3.65 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-Linuxple64-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 Linux x86","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"4.02 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-Linuxi38664-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 Linux zSeries","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"3.81 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-zLinux64-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 Solaris","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"3.77 GB","DNPlat":{"label":"Solaris","code":"PF027"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-Solaris64-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.0.13 IF1 Windows","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"4.43 GB","DNPlat":{"label":"Windows","code":"PF033"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.0.13&platform=All&function=fixId&fixids=11.0.13-BA-CA-Win64-IF001&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.1.7 IF3 AIX ","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"6.65 GB","DNPlat":{"label":"AIX","code":"PF002"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.1.7&platform=All&function=fixId&fixids=11.1.7-BA-CA-AIX64-IF003&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.1.7 IF3 Linux pSeries","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"6.49 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.1.7&platform=All&function=fixId&fixids=11.1.7-BA-CA-Linuxppc64-IF003&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.1.7 IF3 Linux p LE","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"6.31 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.1.7&platform=All&function=fixId&fixids=11.1.7-BA-CA-Linuxple64-IF003&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.1.7 IF3 Linux x86","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"6.75 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.1.7&platform=All&function=fixId&fixids=11.1.7-BA-CA-Linuxi38664-IF003&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.1.7 IF3 Linux zSeries","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"6.65 GB","DNPlat":{"label":"Linux","code":"PF016"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.1.7&platform=All&function=fixId&fixids=11.1.7-BA-CA-zLinux64-IF003&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null},{"DNLabel":"Cognos Analytics Server 11.1.7 IF3 Windows","DNDate":"22 Jan 2021","DNLang":"Language Independent","DNSize":"7.3 GB","DNPlat":{"label":"Windows","code":"PF033"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=Cognos&product=ibm/Information+Management/Cognos+Analytics&release=11.1.7&platform=All&function=fixId&fixids=11.1.7-BA-CA-Win64-IF003&downloadMethod=http&source=fc","DNURL_FTP":"","DDURL":null}]
[{"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 January 2021

UID

ibm16350229