IBM Support

IBM InfoSphere Information Server 11.7.1.4 SP2 Fix List

Fix Readme


Abstract

IBM InfoSphere Information Server 11.7.1.4 SP2 introduces APAR fixes addressed after release 11.7.1.4 SP1 for components of InfoSphere Information Server. Fix Pack 11.7.1.4 is cumulative and includes fixes released in previous Fix and Services packs of Information Server 11.7.1.

Content

The following sections list APARs fixed in 11.7.1.4 SP2 for InfoSphere Information Server.

Fixes added in IBM InfoSphere Information Server 11.7.1.4 SP2

Security Issues

Salesforce Known Issue Description
DT208807 Vulnerabilities in VMware Tanzu Spring framework
DT209601 Vulnerabilities in json-smart
DT213914 Vulnerabilities in jose4j
DT214041 Vulnerabilities in VMware Tanzu Spring boot
DT214383 IBM InfoSphere Information Server is affected by multiple vulnerabilities in Apache Tomcat (CVE-2023-28708, CVE-2023-24998)
DT214774 Vulnerabilities in Undertow
DT214828 IBM InfoSphere Information Server is affected by an information disclosure vulnerability (CVE-2023-33857)
DT214922 IBM InfoSphere Information Server is affected by a denial of service vulnerability in Apache Commons FileUpload and Tomcat (CVE-2023-24998)
DT215244 Vulnerabilities in Spring components
DT223616 IBM InfoSphere Information Server is vulnerable to cross-site request forgery
DT223736 DT224482 Vulnerabilities in Netty
DT223746 DT224479 DT224482 Vulnerabilities in Google Guava
DT224479 DT224482 DT224723 DT243360 Vulnerabilities in snappy-java
DT228820 Vulnerabilities in Node.js lodash module
DT228823 Vulnerabilities in VMware Tanzu Spring Security
DT237322 IBM Information Server Information Server is vulnerable due to improper input validation (CVE-2023-40699)
DT237657 IBM InfoSphere Information Server is vulnerable to cross-site scripting (CVE-2023-42009)
DT237658 IBM InfoSphere Information Server is vulnerable to information disclosure (CVE-2023-42019)
DT237701 Vulnerabilities in Node.js semver
DT238147 InfoSphere Information Server is vulnerable to cross-site scripting (CVE-2023-43015)
DT243162 DT244802 DT223805 Vulnerabilities in Eclipse Jetty
DT244593 Vulnerabilities in Apache Avro Java SDK
DT245372 Vulnerabilities in urllib3
DT246638 Vulnerabilities in Grafana
DT237987 IBM InfoSphere Information Server MS tier Ingress Controller sets short HSTS max age

Connectivity IBM/BigData

Salesforce Known Issue Description
DT213933 Hive Connector does not import metadata of a table when its name is a prefix of another table's name
DT215616 DB2 Connector used as partitioner with DB2 for IBM i database aborts with SQL0204N SYSCAT.TABLES is an undefined name
DT215622 DB2 Connector reads XML columns incorrectly from DB2 for IBM i and non-unicode databases
DT221894 DB2 Connector fails to insert or update XML column data in DB2 for IBM i and Db2 for z/OS databases
DT239514 DB2 Connector unnecessarily requires CREATE TABLE privilege when to use an external table to write into target table
DT239522 DB2 Connector loses precision of double type values when it writes data by using external table
DT242336 DB2 Connector used as partitioner fails to insert data into unpartitioned Db2 for z/OS table alias
DT242752 Big Buffer API limits precision of double values

Connectivity Non-IBM

Salesforce Known Issue Description
DT135056 DD-Driverset for socket close issue
DT208716 Upgrade of DataDirect OpenSSL libraries to version 1.1.1t
DT209187 In Oracle Connector, the table name used in the select query is not getting described when it is governed by a VPD policy
DT209748 ODBC Connector read jobs were failing after migration from ODBC plugin
DT211081 Job with Salesforce and Amazon S3 Connector fails with java.lang.NumberFormatException: For input string
DT209838 Scapi Bridge Patch for orc file format
DT209832 Incorrect Date written to orc file when CC_USE_LATEST_FILECC_JARS is set to orcstream
DT211218 Connection to AWS S3 fails when endpoint configuration is used in AmazonS3 Connector
DT214422 Certify JDBC Connector with IBM DataDirect PostgreSQL JDBC Driver version 6.0.0.001165
DT215430 Warning message, java.text.ParseException: Unparseable date: "" is seen during Bulk Load Operation in Salesforce Connector
DT222413 Hierarchical Data stage job fails with "CDIER0603E: The step cannot write to the /some/dir directory error" even though the OS user can create and write a file in the problem directory
DT222796 IBM DataDirect JDBC Driver for MongoDB aborts with exception "I/O Error Unsupported OP_QUERY command: listCollections" when attempting to connecting to MongoDB Database Version 6.0.5
DT189687 SAP ASE 16.0 SP04 PL03 branding name change in ODBC Connector
DT222145 ODBC Connector jobs that connect to PostgreSQL by using BatchMechanism=2 with boolean fields abort
DT222148 ODBC Connector connecting to Hive database does not return REMARKS in the metadata when UNCF=1 is set
DT222151 BulkLoad to SAP ASE jobs by using ODBC Connector having date field aborts with array size more than 1
DT222154 ODBC Connector is not returning the primary key columns of few tables when connected to DB2 zOS v12 database
DT222155 Accented character read from MySQL Database by using ODBC Connector is garbled after driver build - 07.16.0257 (B0536, U0382)
DT222158 ODBC Connector MySQL write or load jobs might fail with truncation errors after the driver is upgraded to version 8.0.
DT222162 Upgrade of libcurl to version 8.0.1 in the DataDirect ODBC Driver Set
DT222153 GreenPlum Connector jobs might abort with table not found error when standard_conforming_strings=off is set on GP Server
DT222795 Support SSL/TLSv1.2 in Teradata Connector
DT222659 Azure Storage Connector leaves files in temporary storage after job abort
DT241573 Web Services Pack job displays messages SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder" SLF4J: Defaulting to no-operation (NOP) logger implementation
DT240312 Teradata Connector Bulk load, Unicode Pass through not working
DT240317 Support SSL/TLSv1.2 for Teradata Connector in the Bulk mode
Data Flow Designer
 
Salesforce Known Issue Description
DT246987 Constant string mapped in Assembly Editor replaced with base64 representation
DT246988 Hierarchical Stage - After you add a new column, the stream does not reflect in the regroup step. The column is not visible or selectable in the regroup step
DT246989 Hierarchical Stage - In the regroup step, when child items or either moved or mapped to the parent item, all columns that contain the name of the selected columns are moved
DT246990 Hierarchical Stage - Output mapping is lost after XSD change
DT246991 Hierarchical Stage - Dialogue for validation is missing
DT246992 Hierarchical Stage - The document root in the JSON parser step does not get updated.
DT222632 DFD API readSequentialFile can access any file on the file system
DT223186 DFD OSH misses execute_mode = seq when Hierarchical Stage execution mode is either default_sequential or sequential

DataStage

Salesforce Known Issue Description
DSCore
DT198054 Improve job log retrieval performance for very long log entries
DT208713 Designer client hangs up with importing a particular COBOL copybook
DT171786 The table information used by the "Where Used" function is not always correctly updated by the SQL Builder
DT213225 The DSSendMail function generates a warning: "Variable "MimeBodyHdr" previously undefined. Empty string used."
DT214412 The localization handling for ClientSwitchService.exe simply doesn't work as designed for multi-byte character sets such as Japanese
DT213315 DSD.StageRun processes remain active after the job aborts
DT224294 Operations Console "Select Project Filters" fails for Hadoop - enabled projects
DT179117 "Cannot write record scheduser to UFD file" error in configuring user for scheduled jobs
DT209099 DSWaitForJob reports status = 99
DT213882 Non-default server component interprocess settings are not correctly set in parallel jobs at compile time
DT240246 Unhandled exception error from DataStage Designer SQL Builder
DT169489 Buffer overflow DataStage client - vmdsHTreeCtrl.ocx
DSEngine
DT211187 "Job control process has failed" reported immediately after job startup
DT196097 dstelnet reports Connection to host lost after user enters username and password

IMAM

Salesforce Known Issue Description
DT240339 Using the Cognos bridge to parse the entire Cognos folder structure takes too long and uses too many resources
DT214532 Missing '‎‪SqlQuery Details update' when import Store Procedure uses MITI bridges
DT241684 Using MITI Cognos Bridge in IMAM does not import columns inside a folder that is inside a table (or table view)
DT229002 IGC - Incorrect BI Collection Member description after import in IMAM
DT233498 Auto Discovery failed to import views

Information Analyzer and Auto Quality

Salesforce Known Issue Description
DT215161 Information Analyzer Project takes a long time to load
DT244372 Information Analyzer performance issue where data rules when run takes 2-6 minutes to submit engine
DT208269 Information Analyzer could not create rules or rule sets while using browsers Microsoft Edge and Google Chrome
DT214351 Wrong popup windows appear when the user clicks a 'Save' button twice
DT173886 Customer complains that the error "Invalid Property Type: JSONOBJECT" is thrown for every run of an Information Analyzer task.
DT214321 Customers are not able to create the Rule Definitions or Rules with the default functions in Thick Client
 
DT222571 Search in IA thin client for data rule returns only the rule definition, not the published rules
DT224081 Column Analysis or DQA fails for Snowflake data source with character data truncation errors
 
DT228207 The user can navigate to the project settings without having the Information Analyzer Project Administrator role
DT169980 Data rule scale function returns an incorrect result
DT225359 Cannot add one or more tables to existing schema
DT225563 Customer has data rule definitions and data rules that with associated governance rules.  When these rules are exported in the thin client and imported into another project or environment, the governance rule fails to be imported
DT228154 A simple user-defined table of data rule gets deleted when a data rule fails
DT209819 If a project is configured to a IADB other than Global, Data Rules and Rule Sets in IADB fail to delete
DT237063 Export rules are not downloading from new UI when we have Metric Data rules
DT237064 The users that have the IGC Administrator role and IA user role, can add users to the IA project
DT214421 View the EmailAddrValidFormat (rule set definition) from Published Rules >> 01 Personal Identity >> Email Address and click "Manage in project" --> It saves the rule set definition to the project

Information Governance Catalog (IGC)

Salesforce Known Issue Description
DT212586 Using Lineage Templates in Data Lineage Report breaks IGC UI
DT223556 Assigned asset with mismatch between count number and referenced assets
DT238757 SQL parser error in query that uses IIF function with blanks
DT245065 IGC Workflow Role Assignment does not display more than 1000 users or groups

Information Server Framework

Salesforce Known Issue Description
DT174701 After a user password is changed, if needed, use Disconnect all to terminate ongoing sessions of the user
DT222202 Upgrade Jackson libraries
DT224483 DirectoryCommand.sh does not update user information when "-update_user" option is specified in a file
DT225181 Address high memory usage in WebSphere due to quartz scheduler
DT236515 View data and Test connection operations fail after a client tier only installation is upgraded to 11.7.1.4
DT238204 Add a key in iisAdmin to disable the check for a null referrer

PX Engine

Salesforce Known Issue Description
DT229033 Fix warnings output that occur when transformers are compiled with pre-8.x version gcc compilers
DT215261 When constants are involved, the stage variable's nullability is not cleared, causing nulls to be used from previous records. This fix generates clear nulls when constant value is assigned to stage variables
DT212987 Parallel Transform function Conversion() returns original input instead of converting the input with the chosen code

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m50000000L32vAAC","label":"Patch Installer-\u003ECumulative Service - Fix Packs and Service Packs"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.1"}]

Document Information

Modified date:
12 December 2023

UID

ibm17069412