IBM Support

IBM InfoSphere Information Server 11.7.1.3

Fix Readme


Abstract

IBM InfoSphere Information Server 11.7.1.3 contains all APAR fixes addressed after 11.7.1.0 for components of InfoSphere Information Server. This document lists the fixes that were addressed after 11.7.1.1 Service Pack 2 and 11.7.1.2.


Content

The following sections list APARs added new in 11.7.1.3 for InfoSphere Information Server.
Fix Pack 3 contains all fixes from 11.7.1.1 SP1 and 11.7.1.1 SP2.

*Fixes that have an asterisk by the Fix ID might require post-install steps to activate. Refer to the following document for details on how to activate those fixes:
InfoSphere Information Server Version 11.7 fixes that require postinstallation steps


Fixes added in IBM InfoSphere Information Server 11.7.1.3

Connectivity IBM/BigData

APAR Description
JR63984 Db2 Connector generates incorrect partitioning clause when Db2 for z/OS table has multiple partitioning columns
JR63938 Db2 Connector has Enable quoted identifiers option disabled for Bulkload write mode
JR63858 Db2 Connector uses inconsistent template definitions for bulk loading into Db2 for z/OS using SFTP transfer
JR63854 Db2 Connector that uses custom SQL reports table not found error with incorrect schema name
JR63743 Data Masking output for text columns does not use the same character set as the input data
JR63823 Kafka Connector logs superfluous connection information while receiving End Of Wave marker

Connectivity Non-IBM

APAR Description
JR62614 Datadirect MongoDB JDBC Driver returns null when reading Decimal128 data
JR63390 ODBC Connection to ProgreSQL with SCRAM-SHA-256 authentication might fail
JR63677 ODBC Trace file is overwritten on Windows platform that uses the VMtrc00.dll file on every new connection
JR63700 SCAPI Bridge patch to support skipping AfterSQL on job failure in BigQuery connector
JR63623 Upgrade of DataDirect OpenSSL libraries to version 1.1.1k
JR63689 BigQuery Connector continues to execute "AfterSQL" even after job failure.
JR63739 ODBC Connector on UNIX platforms does not display full error message when user-defined SQL statement throws error
JR63852 Salesforce Connector support for Salesforce API version 52.0
JR63907 Oracle CC read job hangs when partitioned reads are enabled
JR63921 Support custom Null Value during LOAD in Snowflake Connector
JR63942 IBM Datadirect JDBC Driver for Cassandra cannot connect to Cassandra DB version 6.7.3
JR63693 Hierarchical Stage: REST Step fails with handshake_failure after ClientHello
JR63719 Hierarchical stage unable to receive the content type "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
JR63758 Hierarchical Stage aborts with java.lang.IllegalArgumentException when the local param value contains '$'
JR64017 Hierarchical Stage: Job aborts with "ProblemDuringClassResolutionAndInstantiation cause
JR63587 Hierarchical Stage: Designer Client fails to launch assembly editor when xmlui.properties file is read-only
JR63822 Support fail on error properties for Before/After SQL statements in BigQuery CC
JR63991 SCAPI Bridge patch to log merge breakdown statistics in BigQuery connector
JR63881 SCAPI Bridge patch to increase read timeout in Google Cloud Storage
JR63794 SCAPI Bridge patch to support deep insert functionality in OData connector
Data Flow Designer
APAR Description
JR63596 Server side request forgery in InfoSphere Flow Designer
JR63610 Improper certificate validation in InfoSphere Data Flow Designer
       - Cross site scripting issue in DFD where in the XFrame options presented a vulnerability

DataStage

APAR Description
DSCore
JR63566 IBM InfoSphere Information Server can be vulnerable to XXE and XML Bombs (CVE-2021-38948)
JR63777 IBM InfoSphere Information Server can be vulnerable to XSS due to missing HttpOnly attribute in cookies (CWE 614)
JR63402 Ops Console: Checkboxes in Run Job dialog (Limits section) do not work
JR63939 Following an abort of a Parallel Job, the Stage/Link status values on the Director Job Monitor screen might show as "STOPPED
JR63952 Add option to revert JR62349 behavior for message handler compilation
JR61485 When DSODB is set up on SQL Server, Operations Console shows "Failed (synchronized)" status for many jobs even though they completed successfully
JR63550 Parallel job fails with "Unable to run job - -2"
DSEngine
JR63519 Job sequence fails with code=-99
JR61889 DSE*_impersonation.sh scripts change uvconfig ownership to root/root
JR62570 Dsrpcd is limited to 5 pending connections
JR60976 DSEenable_autostartup.sh not working on SLES 12

Information Analyzer / Auto Quality

APAR Description
JR63472 Information Analyzer - SQL Statement disappears in the virtual table definition
JR63990 Rule execution on sql virtual table is failing for column having data type as varchar(-2) as defined on the source
JR63760 Column Analysis and Data Rules fail with "Character Data Truncation." error
JR63959 Rule expression for 'If Then' changes in Data Rule definition
JR64000 Information Analyzer thin-client note caching issue
JR63999 Error when user selects the check-box, and then tries to edit a rule in Information Analyzer Quality UI
JR63792 Poor Performance with IA Data RuleSets Jobs
JR63944 Dropdown is closed when clicking scrollbar in automation rule
JR63892 IAAdmin delete execution history command throws null pointer exception
JR64106 Information Analyzer Rule definition variable does not show upper case
JR64397 Information Analyzer Data Rule logic test fails on a browser with spanish locale.

Information Governance Catalog (IGC)

APAR Description
JR64224 Not possible to remove OPENIGC assets
JR64022 IIS MS tier Kafka logs are flooded with "Failed Authentication" messages
JR64027 Lineage not detected for jobs that use database objects names in square brackets
JR64006 Custom attributes inheritance issue if applicable to DB schema and table
JR63985 Enterprise search with asset synchronization issue
JR64001 Custom attribute modification fails if any predefined value contains single quotation character
JR63966 SQL Parser error for query that uses IIF functions
JR63937 SQL Parser error for query that uses current registers
JR63842 PROCESSENVVARIABLES script is broken after upgrading to IS11711SP1
JR63827 Registering new OPENIGC bundle fails with NPE when refreshing cache
JR63789 OPENIGC export for large number of assets requires many resources
JR63631 Lineage does not mark asset as truncated with stop icon when graph is clipped
JR63014 Opening term details on IGC NewUI takes long when term has many assigned assets
JR62498 Microservices tier pre-checks fail when IPV6 is disabled
JR63934 Running data lineage fails for many objects when fetching preferred equivalent assets

Information Server Framework

APAR Description
JR63729 Upgrade XStream
JR63774 Upgrade sigar
JR63905 Information Server is vulnerable to Insecure Third-Party Domain Access
JR63887 Information Server can be vulnerable to Cross-site request forgery
JR63901 Information Server security hardening
JR63833 Information Server is vulnerable to cross-frame scripting
JR63876 Information Server is affected by a vulnerability in Modernizer
       - Upgrades to Administration console

Install

APAR Description
JR62937
Windows uninstaller should remove only related entries inservices file

Metadata Asset Manager (IMAM)

APAR Description
JR63729 Upgrade XStream to v1.4.17
JR64044 MS SSASRS data sets are not unique in representation issue
JR64051 Cognos Views are represented as tables in IGC
JR64108 Add the support to delete in OPENIGC
JR64111 A database function(TO_DATE()) is imported as a table
JR64273 Correct the OpenIGC Root folder representation

PX Engine

APAR Description
JR63992 Add keep_sign option for APT_IMPORT_DECIMAL_IGNORE_SIGNED.
JR63982 Parallel jobs fail intermittently with a BadPointer exception while trying to load the score for the job. Rerunning the job is successful.
JR64014 When compression is enabled for sort scratch files by defining APT_TSORT_SCRATCH_COMPRESSION, it is requiring huge memory while merging.
JR64088 Provide an option to down grade Error/Warning messages to Inform by using an environment variable.

[{"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:
14 June 2023

UID

ibm16506469