Fix Readme
Abstract
IBM InfoSphere Information Server 11.7.1.4 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.3 Service Pack 4.
Content
The following sections list APARs fixed in 11.7.1.4 for InfoSphere Information Server. 11.7.1.4 contains all fixes from 11.7.1.3 SP4.
Fixes in 11.7.1.3
Fixes added in IBM InfoSphere Information Server 11.7.1.4
Fixes added in IBM InfoSphere Information Server 11.7.1.4
Connectivity IBM/BigData
| APAR | Description |
| JR64803 | Kafka Connector does not inherit Kafka server's secure connection settings for schema registry with SCRAM-SHA-256/512 |
| JR64872 | Db2 Connector executes unnecessary queries to DB2 for z/OS when operating in read mode |
| JR65098 | Db2 Connector fails with error SQL0581N: The data types of CASE expression or DECODE function are not compatible |
Connectivity Non-IBM
| APAR | Description |
| JR64032 | DRS connector is not working as expected (no default commit) when connector has 'Before SQL' statement |
| JR64043 | Crash seen in ODBC Trace binary when SQL statement contains number of characters |
| JR64063 | JDBC Driver for MongoDB gives connection failure when there are special characters in the database name |
| JR64074 | ODBC connector does not return back SQL query error when array size is small |
| JR64067 | Allow creation of 0-byte files in AWS s3 using S3 Connector |
| JR64085 | File Connector Read jobs give warning while reading file in ORC Format |
| JR64153 | Support LDAP authentication in IBM DataDirect JDBC Driver for MongoDB |
| JR64117 | IGC Parsing errors when Teradata connector converts invalid xml chars to question mark |
| JR63818 | Stored procedure job that works on IS 11.3 fails on IS 11.7 with Invalid cursor state |
| JR64105 | Read Delimited file correctly when escape character Is used just before delimiter |
| JR64109 | Test connection fails if password has even number of pound characters |
| JR64185 | Upgrade of DataDirect OpenSSL libraries to version 1.1.1l |
| JR64089 | Oracle connector job aborts with failure code 139 if the value for username or password job parameter is empty and CC_ORA_NLS_LANG_ENV=TRUE |
| JR64259 | Handle public synonyms in case of cross schema references |
| JR64297 | Support Reject links for Parquet File Format in the File Connector |
| JR64329 | Disable batch errors mode during piecewise write operation in PL/SQL statements |
| JR64187 | Provide option in File Connector that uses Native HDFS FileSystem to pass config options to HDFS Native Client |
| JR64366 | SCAPI Bridge patch to support parallelism in merge modes of BigQuery connector |
| JR64367 | Support parallelism for merge modes in BigQueryCC |
| JR64368 | Support Load, Custom SQL and Before/After SQL in Redshift CC |
| JR64336 | Exception reading Excel files having NOTE/Comments with xmlbeans 3.0.0 and Apache POI 3.14 |
| JR64400 | Optimize select statement used during metadata import of Redshift Connector |
| JR64409 | ADLS Connector read jobs that use Excel and JSON file formats fail with property mismatch error |
| JR64467 | Oracle Connector is creating invalid control file for Manual Load mode for Parallel Jobs |
| JR64488 | IBM DataDirect JDBC Driver for Cassandra Upgrade of Jackson databind jar in DataDirect Cassandra JDBC Driver |
| JR64576 | Log warning when Oracle connector cannot describe the user defined select statement |
| JR64670 | Extend SCAPI Bridge to add GenericS3 Connector Support |
| JR64674 | Implement GenericS3 Connector |
| JR64688 | Oracle connector is not able to resolve cross schema private synonym to the corresponding table name |
| JR64706 | SCAPI Bridge patch to support part size properties in GenericS3 Connector |
| JR64721 | ODBC Connector insert then update jobs abort connecting to PostgreSQL database |
| JR64768 | Salesforce Connector Bulk API 2.0 Support |
| JR64880 | Improve performance of metadata import when using Snowflake Connector |
| JR64845 | Upgrade of DataDirect OpenSSL libraries to version 1.1.1n |
| JR64891 | TDMLoad load jobs are failing when run in concurrent mode |
| JR64900 | Salesforce Connector with OAUTH 2.0 Authentication and proxy server gives Connection timed out error |
| JR64916 | Map binary columns in the table to binary fields in the Datastage job |
| JR64940 | Oracle Connector generates incorrect select statement when doing partitioned reads |
| JR64945 | Data loss reported when multiple BigQuery connector stages are used in the job |
| JR64989 | DataDirect odbc driver for Sybase ignores legitimate error database and just hangs |
| JR64999 | Parquet file created with FileCC, datatype decimal, precision 18 or less gives error when Hive uses it to create a Hive Table |
| JR65023 | ODBC-CC read jobs fails after upgrading IIS 11.7.1.3.SP4 |
| JR64973 | Hierarchical Stage: REST step throws invalid xml error when xml response body contains fewer than 4 characters in the first line |
| JR64854 | REST step fails with java.lang.nullpointerexception when logging is disabled |
| JR64776 | Hierarchical Stage: Job aborts with "error instantiating class com.ibm.e2.util.logging.jul.E2JULLogger" |
| JR64855 | Hierarchical Stage intermittently drops records without throwing any error message due to timing issues in Task Scheduler |
| JR64873 | Hierarchical Stage: In REST Step, provide an option to stop automatic redirection of a REST call |
| JR65015 | New warning message is observed in Oracle Connector after upgrading to 117FP3+ SP4. |
Data Flow Designer
| APAR | Description |
| JR64911 | Issues with insecure direct object references |
| JR63610 | DataStage Flow Designer affected by OS Command Injection |
| DT134319 | DataStage Flow Designer affected by JQuery vulnerabilities |
| DT134303 | CSRF issue with Flow Designer |
| DT160842 | Jetty vulnerability in DFD |
DataStage
| APAR | Description |
| DSCore | |
| JR64679 | Job status fixes and improvements |
| JR64932 | Project location checks on admin client |
| JR64832 | SyncProject.sh -Restore doesn't work on UNIX |
| R64806 | In the Operations Console, the month part of a date is displayed incorrectly on charts, in "Engine started" information and in the calendar picker |
| JR60749 | Job runs sort improvements |
| JR62407 | Cross Project Comparison not showing difference in Expression values for User Variables Activity stage |
| JR64957 | Job Sequencer GUI stages in Designer fail following installation of 11.7.1.3 SP4 |
| JR64990 | DB2 script templates for DSODB registered incorrectly |
| JR64775 | While using XMLInput plugin on parallel canvas, the job is aborting with SIGABRT |
| JR64772 | Tracing and code improvements for column table reference setting |
| DT139683 | Characters removed from dsjob -ljobs output |
| DT133806 | DataStage Designer crashes when a job is printed, with no default printer available |
| DT139296 | PSIRT 372046 Stack traces in ops console API reported as a vulnerability |
| DSEngine | |
| JR64175 | Sequence jobs can't be compiled |
| JR64251 | Sequence jobs abort with WRITE failure from check point routine |
| JR61572 | DSEngine on Windows would use global namespace for shared memory segments |
| JR64975 | After Engine Tier Reboot, Unable To Login To Datastage, Receive 81002 Error |
Information Analyzer / Auto Quality
| APAR | Description |
| JR64140 | Incorrect row counts for numeric data type violations in Information Analyzer Thin Client |
| JR64371 | Column Analysis Failure on DB2 xml datatype formats |
| JR64161 | Information Analyzer Data rules exported to CSV file show incorrect format |
| JR65033 | Unable to retrieve users and groups in Information Analyzer when the list is huge |
| JR64677 | Unable to rules from command line when the rule name has a comma (,) in it |
| JR65008 | Fix the missing BenchMark Settings Issue on importing Information Analyzer Project |
| JR64253 | Column Analysis and Data Quality Analysis failing for huge parquet files having maximum columns with Heap size errors that use the file connector |
| JR64903 | Information Analyzer Thin Client (Classic) is using an older version of "jquery-ui.min.js" |
| JR65017 | Information Analyzer Data Rules fail with error - "decimal(38,0)" is not valid |
| DT142886 | Hadoop data rule bundles not executing in bundle format |
| DT148708 | Vulnerability with moment.js |
| DT143723 | Vulnerability CVE-2022-33980 in usage of Apache Commons |
| DT145201 | Data quality threshold in card is inconsistent with that in the detail tab of analysis (Data Quality) |
Information Governance Catalog (IGC)
| APAR | Description |
| JR65022 | IGC Classic UI not working after navigation to main page through IGC title banner click |
| JR64839 | Data file asset is incorrectly parsed when imported from OMD and path contains forward slashes and file name contains backslashes |
| JR64970 | Steward cannot be edited when Workflow is enabled |
| JR64673 | Unable to see domain reference for relevant ERWin entity attribute |
| JR64948 | Rest API flows import is slow |
Information Server Framework and Installation
| APAR | Description |
| JR65074 | InfoSphere Information Server is affected by an improper access control vulnerability |
| JR65048 | Administration console is vulnerable to stored cross site scripting |
| JR65003 | A vulnerability in JDOM affects InfoSphere Information Server |
| JR64998 | A vulnerability in Apache Ant affects InfoSphere Information Server |
| JR64991 | A vulnerability in Apache Commons collections affects InfoSphere Information Server |
| JR64978 | Administration console hangs while opening Users and Groups |
| JR64675 | Multiple vulnerabilities in Eclipse Jetty affect IBM InfoSphere Information Server |
| JR64311 | Unable to access Workflow details in the Administration tab of Information Governance Catalog |
| JR64347 | In some installation sequences, while patching to 11.7.1.3 the customer's configuration information in WebSphere Liberty is lost |
| JR64377 | During a Fix pack or Service pack installation, execution of the iisAdmin script fails as characters are misinterpreted. For example, /a is erroneously changed to /7. |
| JR64476 | Information Server is affected by a vulnerability in Dojo Toolkit CVE-2021-23450 |
| JR64529 | Insecure path attribute in Information Server cookie |
| JR64743 | Information Server is vulnerable to cross-site scripting |
| JR64760 | Upgrade Spring used in Information Server |
| JR64765 | Information Server is vulnerable to privilege escalation |
| JR64468 | A vulnerability in Apache log4j affects InfoSphere Information Server (CVE-2021-44832) |
| JR64446 | A vulnerability in Apache log4j affects InfoSphere Information Server (CVE-2021-45046 CVE-2021-45105) |
| JR64358 | A vulnerability in Apache log4j affects InfoSphere Information Server (CVE-2021-44228) |
| JR64083 | Information Server is affected by multiple vulnerabilities in XStream |
| DT160237 | InfoSphere Information Server is affected by a session management vulnerability |
Microservices Tier
| APAR | Description |
| DT188781 | Information Server Microservices tier components are vulnerable to openssl (CVE-2022-1292, CVE-2022-2068 and CVE-2022-2097) |
PX Engine
| APAR | Description |
| JR64663 | Add one more character to get a unique file name when cannot create a regular file name |
| DT13987 | Disable dangerous Jobmon XML parsing options |
| JR65027 | Add retry logic for transformer checksum and binary files |
[{"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"}]
Was this topic helpful?
Document Information
Modified date:
29 November 2023
UID
ibm16618799