IBM Support

IBM InfoSphere Information Server, Version 11.3.1.1 (fix pack 1) fix list

Fix Readme


Abstract

Summary of fixes included in the IBM InfoSphere Information Server, Version 11.3.1.1 (11.3.1 fix pack 1).

Content

The following list of APARs are included in InfoSphere Information Server, Version 11.3.1.1 (fix pack 1).

Please note that this list includes only those fixes contained in fix pack 1. For the list of APARs included in Information Server 11.3.0 and 11.3.1, refer to the following documents:
InfoSphere Information Server, Version 11.3 Fix List
InfoSphere Information Server, Version 11.3.1 Fix List

*Fixes that have an asterisk after the Fix ID may require post-install steps to activate. Please refer to the following document for details on how to activate those fixes:
InfoSphere Information Server Version 11.3 fixes that require post-installation steps




Balance Optimizer
APARDescription
JR50499 QUERY GENERATED BY BALOP HAS POOR PERFORMANCE DUE TO ORDER BY CLAUSES
JR50525 IN OPTIMIZED JOB, BDFS STAGE IS WRITING DATA TO A DECIMAL COLUMN USING SCIENTIFIC NOTATION
JR50617 BALOP FAILED TO INITIALIZE WHEN INSTALLED IN DIRECTORY CONTAINING SPACE.
JR50776 OPTIMIZED DATASTAGE JOB FAILS WITH TD ERROR: CODE 5758: THE SEARCH CONDITION MUST FULLY SPECIFY THE TARGET TABLE
JR50787 UNABLE TO USE JAVA USER DEFINED FUNCTION (UDF) IN DATASTAGE JOB WITHIN JAQL IN MAPREDUCE STAGE
JR50859 JAQL ParameterSet changed after running optimized job
JR50904 The ORDER BY CLAUSE OF the REMDUP STAGE HAS INCORRECT COLUMN ALIASES
JR51130 Not_XXX operators should be legitimate only in Teradata
JR51157 User name added to already qualified table name
JR51285 Image of optimized job created in the install location instead of user area
JR51474 Incorrect TimestampToDecimal and DateToDecimal mappings for Netezza

Connectivity
APARDescription
*JR37952 Jobs terminate abnormally with code dump when BCPLoad Plugin Stage is connecting to Sybase ASE Version 15 with OCS 15 Client
JR45943 New Function: Add DATA MASKING Stage to IIS 9.1
*JR46244 Teradata Connector using update operator in clean mode runs a RELEASE MLOAD on the target table
JR46555 DataDirect Sybase IQ Drivers on zLinux
*JR49502 ODBC connector bulkload jobs issue normal insert statement even when bulk load is enabled
JR50146 SAS operator jobs failing when processing large models
JR50287 ODBC Connector corruption of Non-Ascii data on Server Canvas
JR50351 Support for BigInsight hive in ODBC Connector
JR50452 Connectors on server canvas are generating a warning "while processing column...Value treated as NULL" in a reference context
*JR50463 Block connector view data when SQL contains an encrypted parameter
JR50579 Teradata Connector is fetching data with a different precision when there is mismatch in the scale part of Decimal datatype.
JR50681 ODBC Connector on server canvas producing incorrect year for some dates
JR50716 Teradata IA using dbc.resources with TDCC not available in TD 14.00 and later
JR50743 DB2 connector aborts when partitioning range is too narrow
JR50746 Bulk-metadata import from DB2 z/OS via IMAM using DB2 Connector fails to import history tables.
JR50817 Netezza Connector fails to load to a synonym with multiple schemas enabled
JR50844 After editing huge xsd in Assembly Editor , XML connector stage editor takes time to be responsive.
JR50855 Connector Migration Tool is not migrating the WHERE_CLAUSE and OTHER_CLAUSES from the Teradata API stage.
JR50856 Greenplum connector parallel unload intermittently hangs
JR50882 Unstructured Data Stage unable to handle XLS containing VB modules.
JR50944 An Oracle connector job aborts with ORA-01487 when using precisions greater than 43.
JR50966 Fix the Connector Migration Tool support for column derivations in the Teradata connector.
*JR50998 Import of metadata via IA and DB2 Connector resulting in empty column information.
*JR51005 Connectors on a server canvas are not honoring the scale part of a timestamp data in a target context.
JR51039 DB2 Common Connector Bulk Load corrupt date value when data contains invalid value
JR51042 An Oracle connector job performing bulk load using OCI Direct Path Load may result in empty NCLOB column.
JR51074 The Greenplum connector intermittently fails with a timeout error from GPFDIST.
JR51099 DSDB2 stage aborts when the count of the records is one, on the other hand, it completes when the count is more than one.
JR51171 XMLOutput stage is producing incorrect output on handling negative integers on PXCanvas
JR51175 Unable to run multiple-statements in BeforeSQL(node)/AfterSQL(node) property in DB2 Connector.
JR51208 DB2 UDBLoad plugin hangs while loading data into the database.
JR51215 Netezza Connector read job with user defined SQL crashes when columns are dropped
JR51240 Netezza Connector action column insert jobs load more records than input records
JR51283 Reading XML data using DB2 Connector results in an extra BOM character being appended.
JR51303 DB2 connector with bulk load option into mainframe is issuing truncate/alter table/delete in conductor process
JR51309 DB2 UDB Stage does not display warning messages when the count of rows is more than the array size
JR51364 Add Bulk Metadata Import (BMDI) support for Oracle connector.
JR51396 FTP Enterprise Stage connecting to SUN SFTP Server in the put mode does not work when -overwrite option is not set
JR51448 VIEW DATA of DB2 Connector executes BEFORE SQL (NODE) AND AFTER SQL (NODE) statements
JR51468 Memory leak was observed while using the Connectors on Server canvas and schema having Date Columns.
JR51492 ODBC Operator sparse lookup DB2 database job aborts when no rows are processed
JR51521 The Connector Migration Tool does not migrate User-Defined SQL statements correctly from Teradata API to Teradata connector.
JR51523 In Connectors Columns defined on the link cannot be moved up or down to change there order
JR51546 The Connector Migration Tool fails to migrate DB2 UDB jobs with long descriptions.
JR51562 Connectivity infrastructure updates for JR51486
JR51583 DB2 Connector writing NULL data to a reject link for a BINARY data-type column.
*JR51682 DS job behavior change between DS Ver 8.1 and 8.7 in DB2 connector when write mode is insert and there is PK constraint
JR51733 Connector stage editor holds reject link data even after the reject link is deleted from the job.
*JR51754 Enhancement of JDBC Connector to close conductor node's connection during player nodes running
JR51766 Connectivity Infrastructure update to support Cognos TM1 Connector and File Connector
JR51768 Deployment of Cognos TM1 Connector
JR51773 In MQ Connector, a wait time of 0 seconds is not being honored correctly while reading messages from the queue
JR51796 The Data Masking stage fails on zLinux when ODPP 9.1 is used.
JR51796 Data Masking stage fails on zLinux when ODPP 9.1 is used
JR51807 Unstructured Data Stage doesn't show correct columns with XLS file with charts
JR51811 Unable to use a DB2 codepage of 1208 in the DB2 CC Stage on the Server Canvas
JR51827 APAR JR51005 causes incorrect schema reconciliation errors (SE Bridge)
JR51863 Extra spaces seen after DB2 in DBVendor Property of STP plugin in Chinese locale.
*JR51866 To specify alternate log directory when WebEditor is invoked
JR51993 FTP Plugin not reading Japanese characters for Fixed-width columns
JR52116 Configuration window for Unstructured Data stage does not close xlsx file properly
JR5217611.3 Remediation for DOS vulnerability in XML4C
*To use this fix in your jobs, refer to InfoSphere Information Server Version 11.3 fixes that require post-installation steps
DataStage Core
APARDescription
JR30240Performance row stats in local containers
*JR43526EngMonApp error - This column type is not currently supported by this driver.
JR47753CFF stage erroneously emits warnings, these can cause job to abort
JR49511Runimporter.sh fails to import operation metadata
JR49633dsjob command fails when parameter length exceeds 4094 bytes in parameter file
JR49673dsadmin comand with envadd intermittently corrupts DSParams file if multiple updates occur
JR49714WLM / QUEUE MANAGEMENT: the update of a queue failed with IIS-DS-RESTAPI-00001 ERROR when using Spanish locale
JR49728Default InvocationID not being saved even after JR49340 applied
JR49966Running on non-english locales with one of these vb6xx.dll present leads to a problem coercing boolean values to strings
JR50062Column properties of stages. Apply button inactive when trying to modify the Generate properties and the null field
JR50084Compilation error when job parameters set using 'set to default' and default is empty
JR50142Inherited group role restricts user DS Admin role to operate (stop the job) in Ops Console
JR50194Problem using the Merge stage on server canvas
JR50209Parallel Maps list under Project NLS Settings shows empty when the APT_CONFIG_FILE is pointing to a wrong location.
JR50332EngMonApp error java.sql.SQLException: [IBM][Oracle JDBC Driver]Value can not be converted to requested type
JR50356Ops Console UI disables the buttons for Run, Stop, Reset when certain roles set
JR50360When a user has access to multiple projects with different roles, the Ops Console UI takes the first assigned role
JR50375ViewData of timestamps, dates or time columns in a sequential file stage varies if a char (or varchar) column
JR50458Connector Import wizard fails to import table definition in Connector import wizard when multiple tables are selected and an existing DataConnection is specified.
JR50459Issue with event file causes exception in EngMonApp log
JR50527Builtin ODBC stage in server job stored procedure update performs poorly at 8.7 compared with 7.5
JR50539Connector imports are failing because of locked objects in the session
JR50569Operations console, countdb incorrect calculation of dates, related to purgedb issue
JR50570Connector Stages display wrong editor in ReadOnly Jobs on Solaris
JR50593Getting popup error "Overflow" when saving job in designer client
JR50655Unable to import job(s) due to "Not enough storage is available to complete this operation" error.
JR50707Not able to import metadata using Connector Wizard. On data source location screen, database name field does not get populated
JR50758DataStage director slow response when number of jobs exceed 2000 and 500 or more invocations.
JR50770Unable to modify a table definition imported from COBOL file
JR51116DataStage link statistics to local container not showing up when complex job is running.
JR51153Solution needed for DataStage Scheduling on Windows 2012
JR51164The default value of job parameter is missing from job reports if the parameter is a list
JR51179Groups added in IS Console using add user or group dialog do not display in DataStage Administrator
JR51192Running multiple istool import commands in parallel on 9.1.2 fails with error 'value is not legal'
JR51224VB error from the the viewdata dialog
JR51296dsximportservice.sh fails to import a specific parameter set
JR51419Missing RT_SCnn entry in VOC causes job compile to fail
JR51592Connector Import Wizard error "the table definition 'x' cannot be found in the repository"
JR51638Cannot run certain jobs after compilation
JR51683"Runtime error 13" when setting environment variable default in Administrator when using French locales
JR51689Information Server reports errors in WebSphere systemout.log file for specific DataStage client action(s)
JR51731More than 128 parameter in a paramfile cause dsjob to abort
JR51765This parameter set was created from a data connection, but no longer has any data connection references
JR51958Performance issue loading Table when using REST API.
JR51986Sequential File stage fails with a combination of a Reject stage and a Filter
JR52127Four files in the DOJO distribution contain an XSS vulnerability. This patch updates multiple components including ISF, IA, DataClick, DQC, and Ops Console.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 11.3 fixes that require post-installation steps

DataStage Engine
APARDescription
JR50134On Suse Linux 11, uvsh reports a Segmentation fault when the TERM environment variable is set to putty-256color.
JR50283SyncProject can report corrupt RT_CONFIG files because the underlying fixtool executable incorrectly reports "No links exist to buffer."
JR50363The fnuxi and format.conv executables don't correctly convert the next split field of 64-bit dynamic files.
JR51501Operations console can report "Error opening Events sub-directory ... status=-10 ..." due to a problem in the OPENPATH BASIC statement.
istool
APARDescription
JR50630istool delete command does not work properly when the domain is using a non-default port.
JR51295istool DataStage export fails when DataStage folder name begins with underscore
Information Analyzer
APARDescription
JR43683 When using Information Analyzer, Ruleset output columns are lost when rule logic is changed and saved.
JR45758 Information Analyzer reports having chart, show garbage/corrupted text for Chinese locale.
JR45997 While using Information Analyzer, View Data Sample selection under Metadata Import should display sample data and not entire content of source.
JR49564 Failed Data Rules appear in Business Glossary but not in Information Analyzer
JR50329 IAADMIN fails to create data rule folder when the folder name contains a period '.' character.
JR50556 Counter operator is generating large temporary files in /tmp despite $TMPDIR, $TMP, and $TEMP settings.
JR50780 View Publish Analysis Results does not show value under column Nulls.
JR51094 Add support for Information Analyzer to use encrypted password with IAAdmin commands
JR51226 While performing Cross-Domain Analysis with Information Analyzer, drill down on virtual columns is not working.
JR51426 While performing Multi-Column Analysis with Information Analyzer, open key analysis fails with error when there are no results.
JR51549 Report for "Defined, Selected and Candidate Summary" of table Primary Key Analysis does not give the expected results
JR51567 Multi Column Primary Key analysis fails if user do not select at least 2 non-unique columns
JR51614 Cross Domain Analysis results do not contain the base/paired column details when using virtual tables or columns
JR51658 With filtering enabled, Open Key Analysis View is hanging.
JR51671 Information Analyzer reports fail in WAS ND environment
JR51674 Primary Key threshold changes not affecting new multi-column combinations
JR51675In Information Analyzer, any user is allowed to import or export projects regardless of whether they have IA Administrator privileges or not.
JR51868 After changing the project analysis settings in Information Analyzer, Virtual Table where clause is stripped off.
Governance Catalog
APARDescription
JR46236The IGC lineage services services error parsing Teradata views.
JR48478IGC users cannot be assigned as stewards if the id contains \ (backslash).
JR49678Enabling workflow with large amount of glossary data fails.
JR49692Users with Business Glossary Author roles can edit rules/policies, but they cannot edit the enumerated custom attributes.
JR49751XML files that were successfully imported in previous versions, failed in IGC.
JR49833The Lineage Automated Services does not detect relationships between DRS Stage and imported Database Tables.
JR49938Creating new terms, or deleting terms demonstrates poor performance, while Workflow is turned on.
JR50587Unable to import and overwrite BG terms without modifying the existing assigned assets information.
JR50665Automated lineage has exceptions parsing views from Netezza.
JR50741IGC is unable to bind tables and views due to the parsing SQL parsing issues.
JR50803Users get a “Java heap size out of memory exception” from the Business Glossary Eclipse plugin, when downloading a large set of glossary data.
JR50852The Blueprint Director Viewer fails to render published blueprints correctly.
JR50870IGC demonstrates slow performance while assigning stewards and publishing from workflow, when there are a large number of terms.
JR50916The istool glossary export/or import command fails when using encrypted passwords.
JR50924Workbench queries that use an “is not null” criteria fails.
JR50927The XML import does not assign BI report assets to terms as expected.
JR50945IGC shows  a link to a Data Rule Test execution that no longer exists in Information Analyzer.
JR50968The import XMLfails with “duplicate” exception when terms have same name, but are in different hierarchy.
JR51145Users are unable to edit the values of custom attributes for assets.
JR51400Glossary assets that are created in the development glossary are not published to catalog.
JR51404The BGA  word capture mechanism does not ignore the special characters from MS Word.
JR51407The "Implemented By" relationship between Design Table and Database Table is not visible in IGC.
JR51557Data lineage for DataStage jobs containing the oracle connector is unavailable for server jobs
JR51560IGC demonstrates slow performance when publishing from development glossary.
JR51584Display of context information gets truncated at times in IGC.
JR51585After publishing the glossary, some elements in the blueprint diagram are not shown in BPD viewer.
JR51635Business Glossary Anywhere only displays ten Category Detail terms but the web UI displays all Category Detail terms.
JR51717Design Foreign keys in physical modes not displaying correctly in IGC.
JR51842Lineage does not show RCPed columns.
JR51907Running Lineage indexing/publishing fails for logical tables (BI Collections).
JR51925Manually bound data sources are not displayed in IGC.
JR52042BGE users are unable to export term assignments when the server locale is not English.
Install
APARDescription
JR51203Suite Installer prerequisite checker reports failure for libXp.so.6 32 bit on Red Hat Linux
Information Server Framework
APARDescription
JR50424User and group role assignments are not preserved after converting from stand-alone LDAP to Federated user registry
JR50574Installation on Windows 2012 fails as RegasmTool.exe crashes when registering netrtsn.dll
JR50938Using Federated with attributes mapped, groups that contain nested groups fail to open in Web Console and roles are not inherited
JR51128Sharing User registry checkbox is not enabled. Operations console, WLM, DataClick, report credentials error
JR51360Intermittent "HTTP session is conflicted" error when logging out from Web console
JR51542Frequent XMETA deadlocks encountered when running Information Analyzer Metrics jobs
MMI
APARDescription
JR50048ERStudio- ImplementedBy RelationShip between Logical and Physical Model is not set
JR50049ERStudio Generates Platform Independent Physical Model
JR52264Dojo Toolkit contains an XSS vulnerability is another APAR which was included in FP1
Metadata Server
APARDescription
JR49915Serialized XML 1.1 causes "invalid XML character" error with Xerces parser
JR51752"Failed to deserialize an EObjectMemento" error thrown while importing metadata using Connector in DataStage
JR51967Unbalanced References Probe Reports False Positives
JR52020Provide istools API to set replaceInvalidChars Map to replace the invalid characters with the provided strings while exporting to XMI
Parallel Engine
APARDescription
JR49593 Hash operation during schema distribution causes long startup times
JR49750 Filter stage throws incorrect conversion warnings while processing latin characters
JR49794 PARALLEL TRANSFORMER INPUT LOOPING ISN'T WORKING WITH MORE THAN ONE OUTPUT LINK
JR50208 schema using null_field with null_field_sep does not handle empty strings.
JR50315 WHEN USING EXPORT (Sequential File Stage) WITH "File Update Mode = Append", COLUMN NAMES ARE APPENDED EVERY TIME THE JOB IS RUN
JR50572 APT_PM_PLAYER_MEMORY SOMETIMES DISPLAYS NEGATIVE NUMBERS IN DIRECTOR LOGS WHEN A JOB HANDLES HUGE MEMORY BLOCKS.
JR50575FATAL I/O ERROR IN JOB DOES NOT RESULT IN JOB ABORT
JR50772 During Parallel job shutdown Section leader sending SIGINT to -1
JR50943 PARALLEL TRANSFORMER STAGE DOES NOT COMPILE WHEN IT CONTAINS NULLABLE VECTOR
JR51101 Parallel Jobs fails for CFF stage with EBCDIC COMP-3 field and French locale
JR51166 Remove duplicate stage may give incorrect results if previous tsort stage sorts a superset of remove duplicate stage's keys
*JR51358 ON UNIX PLATFORMS APT_IMPORT_PATTERN_USES_FILESET=TRUE DOES NOT IMPORT FILES WHEN THE FILE NAMES CONTAIN SPACES
*To use this fix in your jobs, refer to InfoSphere Information Server Version 11.3 fixes that require post-installation steps
Workload Manager
APARDescription
JR47735PX jobs are not allowed to run though there are no queued jobs [o]


XML
APARDescription
JR49476Nested ListToGroup gets exception when child element has >1 instance
JR50644Applying ListToGroup on Switch Target is not fetching the right records
JR50910The invalid XML character message in the director log is not helpful to identify the record having bad character
JR51052Split input data into batches based on a batch key field
JR51143Null pointer exception for missing required element when Mandatory item missing Rule set to Reject and Items Not declared in schema to Fatal
JR51486XLXP Library used by XML parser could allow a remote attacker to obtain sensitive information
JR51929Clean up memory at the end of session in Assembly Editor UI service

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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.3;11.3.1.0;11.3.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21698520