IBM Support

InfoSphere Information Server, Version 8.7 Fix Pack 1, Fix List

Fix Readme


Abstract

Summary of fixes included in IBM InfoSphere Information Server, Version 8.7 Fix Pack 1, with fixes grouped by components.

Content

The following list of APARs are included in Fix Pack 1 for InfoSphere Information Server, Version 8.7.

Before installing fix pack 1 check your Version.xml file to confirm if you installed any InfoSphere Information Server 8.7 patches which are not included in fix pack 1. If you have installed a patch that does not appear in this list, do not install Fix Pack 1 yet. Contact IBM Technical support to obtain a new patch which can be installed on top of Fix Pack 1 so that you do not experience loss of functionality as a result of applying the fix pack.

*For fixes that have an asterisk after the Fix ID, if you want to use them in your jobs, refer the post-install steps in the following technote:
InfoSphere Information Server Version 8.7 fixes that require post-installation steps





Special Patches included in InfoSphere Information Server, Version 8.7 Fix Pack 1

For convenience, the following table lists the Information Server 8.7 patches on the IBM Fix Central web site which have been included in Fix Pack 1. These are listed using the patch name which will appear in the Version.xml file, to make it easier to identify which of your patches are included in the fix pack.


Information Server 8.7 Fix Central Patches
Patch Name
Tiers
rollup_RU1_BG_all_8700​Services tier. ​
rollup_RU1_CMS_all_8700Services, Engine and Client tiers. ​
rollup_RU1_XMLStage_all_8700Services, Engine and Client tiers.​
rollup_RU1_OpsConsole_aix_8700Services and Engine tiers.​
rollup_RU1_OpsConsole_hpia_8700Services and Engine tiers.​
rollup_RU1_OpsConsole_solaris_8700Services and Engine tiers.​
rollup_RU1_OpsConsole_windows_8700Services and Engine tiers.​
rollup_RU1_OpsConsole_linux390_8700Services and Engine tiers.​
rollup_RU1_OpsConsole_Linux32_8700Services and Engine tiers.​
rollup_RU1_OpsConsole_Linux64_8700Services and Engine tiers.​
rollup_RU1_BGA_all_8700Client tier.​
patch_CC_Netezza_8700Services, Engine and Client tiers.



Fixed APARS included in InfoSphere Information Server, Version 8.7 Fix Pack 1


ASB Packs
Fix ID
Description
XML Output Stage throws transcoding Exception on AIX and RHE while writing Unicode data to an XML document
RowSplitter stage attempts to convert character data instead of just passing through.
XML Output Stage aborts in Chinese locale
Web Services Transformer Stage removes namespace prefix from soap body when both custom soap header and soap body are used.
Web Services meta-data importer throws errors while importing web service operations from a WSDL document.


Business Glossary
Users cannot assign a steward in BG to a user that does not have a first and last name
Business Glossary Browser and BG Anywhere present search results in a different order.
The incremental search capability of Business Glossary Anywhere performs poorly when there are many terms in the repository.
The keystroke word capture function of BGA does not capture the text properly.
Business Glossary workflow feature fails when publishing with a removed label, removing a value in batch edit, and publishing a term and category with the same name. In addition deleting an enumerated custom attribute value from BG causes the 'General Information' section of a term's dossier to break and the change is not reflected in the Term History. In addition note creation in BG is incorrectly case-insensitve.
BGA client performs very poorly with 75K+ terms
Right clicking on glossary asset from Cognos UI to open in BG does not work
JR43080
Add support to Business Glossary for IE 9


Blueprint Director
Blueprint Director would not connect to DataStage when the engine was not the same as the IS domain.


Component Installer
Component Installer dumps the trace data to the Installer log even though the trace is currently disabled.


Connectivity
Oracle enterprise Stage documentation incorrectly lists the Oracle data type mappings for SmallInt, Float, Real, Double, LongVarChar, and VarChar
After switching from SAS 8 to SAS 9 job fails if record is too small
Need unique bind file for DB2 Enterprise stage for every IS release.
Oracle server job has invalid character in sequential file output for a column defined as CHAR(1) in a lookup table
The INSTALL.LIBORCHORACLE script does not cater for ORACLE 11
Teradata Multiload stage fails to load when the input file is larger than 2 GB.
An error occurs when Customer tries to do a Browse of Salesforce.com metadata using parameters
Trying to load data into db2 table with partition job aborts with fatal error Table must exist before querying the node group
Add a Transfer Command property to the DB2 Connector Zload
Documentation Enhancement: Clarification to SQL Server Connectivity Guide that ODBC is the only option from Unix server.
DB2 Load using named pipe method appears to be hanging/failing
ODBC Connector insert (append/truncate) jobs with IS 8.5 FP1 throw table not found error
DB2 API Plugin treats all data truncation warnings similarly.
ORAOCI9 plugin pads spaces for a type of CHAR(N) when created in Oracle "CHAR" semantic
ORAOCI does not allow a TIMESTAMP where a DATE is expected
IWAY Enterprise stage returns error message STATEMENT CONTAINS UNKNOWN SCALAR FUNCTION 'REPLACE' ON LINE 4
Customer can't open Teradata Connector GUI, set DSIB for huge no of jobs on Production. Wants a work-around with environment var
The ROWID round robin partitioning inserts a ")" in the wrong place for Oracle Connector
ODBC Connector read jobs using range partition are failing with vague error when the table has 0 records in it.
Teradata API read jobs are failing on server canvas on a non-NLS Information Server installation.
Problem importing Oracle Metadata via Information Analyzer in V8.5.0.1.
Not able to add job properties in the new XML editor
Job continues to execute even after a fatal error message in ODBC EE sparse lookup jobs
Change in nullability behavior of output columns in DB2 Connector introduced with the APAR JR37511
DB2 CC CMT spec not setting default RecordCount value.
Performance issue with Sybase requiring changes to the Sybase ASE write operator to support waves
IS 8.1 FP2 on AIX, doing insert to DB2 using DB2 EE stage with Partitioning=DB2 will insert blank as null value.
Oracle Connector aborting when inserting Empty_Lob values
DB2CC write routes all the rows to one partition while writing to a table alias bringing down performance
Support for BIGINT type in DSCAPI on 64 bit platforms to support the range of values valid for the long type
View Data from stage editor throws a error message when Instance property is set as parameter for DB2 Connector.
Addition of runtime parsing in DB2 Connector to extract tablename from SQL Statements
TMSM integration for Teradata connector
Oracle Connector aborts when Lobs references used with PL/SQL.
Issues in low date values for Plugins after installing IS8.1FP2
JR40818
Oracle EE Upsert mode inserting incorrect data.
Job with multiple NETEZZA Stages updating the same table aborts randomly
Job aborts when DB2 Connector Stage has a partition type of "DB2 Connector" and is unable to fetch tablename using param
Oracle Connector not fully qualifying ALTER INDEX statement.
ODBC Connector jobs fail with locator query returned no rows when key columns are of type nvarchar
View Data fails for DB2 Connector Stage if unable to fetch the tablename from USER DEFINED SQL when using paramater for schema
Netezza Enterprise Stage jobs does not pick code page other than ISO-8859-1 in Update mode
DB2 Connector failed to reject a incorrect TIMESTAMP
Incorrect warning about nullability for non nullable string fields in Netezza EE stage
Job parameter values with national characters are not listed on the Insert Parameter dialog on XML Stage Assembly Editor
Test' connection on Connector Stage Editor fails when connection propeties are defined as parameters
Oracle Connector job fails with GLIBC detected error
Oracle Connector - Adding support for "Row not updated - Insert then Update mode"
DB2 Connector LOAD creates related message files in the incorrect location
Writing to a Informix XPS database using Informix IDS stage with option writeMode=truncate gives error
Reject error conditions are not shown checked on the GUI when they are updated to a new meaningful message
Performance degradation on MSOLEDB plugin on DataStage V7.1 compared to V8.5 when using WRITE mode
If the Update Batch has errors as well as warning then the logic processes the diag messages incorrectly and loses the first row
CMT Oracle error - Reject Row not updated by default
Oracle EE - Bulk load - Indexes rebuilt with Degree of Parallelism (DOP) value of 1
Unused Job Parameters in Oracle connector cause "View Data" to fail.
Oracle Connector - Bulk - Performance - Utilize Direct Path OCI method OCIDirPathColArrayRowGet
Memory leak in RUNAGENT process while using View Data or Test Connection
Connector Migration Tool (Oracle) - Migrating Oracle EE TableName property with value 'null'.
Reject Links for the Common Connector Stage have wrong columns or lack in necessary columns
ODBC-CC job fails for NVARCHAR column of length greater then 2000 is specified
ODBC Connecter MDI from Oracle DB is returning first character of DB name on unix.
ODBC Enterprise RTI (real time) upsert jobs with reject link abort with "Accessor already isSetup()" error message
The Teradata Connector Stage still issues metadata queries even if DataStage variable DS_NO_PROCESS_METADATA is enabled.
DB2 Connector fails to read the CLOB data-type from table in EBCDIC format on a DB2 Z/OS.
FASTTRACK fails to import the tables having Foreign Key dependency across the schemas
Oracle Connector - Read - Oracle Partitioning - Not parsing Select statement correctly when inserting PARTITION keyword
ViewData fails to identify the correct schema of the table when in Request Context
Oracle Connector - CAS operations failing an a specific version of Solaris
Netezza Connector throws unexpected exception executing the runlocally() function when working as output stage and transformer
Data with empty strings can intermittently cause errors with Oracle connector stage inserts
Netezza Connector used in target context with Write mode=Update, the connector incorrectly reports key columns as missing
Auto Commit Mode Correction in Lookup Context for ODBC Connector
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.7 fixes that require post-installation steps



DataStage
Change the InfoSrvEngine script to cleanup the Agent.pid and LoggingAgent.pid files
DataStage job log incorrectly reports error indicating variable previously undefined.
Transformer compilation error with Date columns when JR40172 applied.
Downgrade severity message to a warning in FP1 log, when finding dangling references to a project in XMeta repository.
Missing thumbnail images and logs exception while hovering mouse over multi-instance jobs
Use of FOR FETCH ONLY in SQL Builder causes job failures
SQL Builder does not handle lists of tables correctly
Performance statistics not shown for first input link to shared container in server job.
Intermittent failure when importing object using ISTools/ISManager: "Unexpected error importing runtime"
ODBC stage failing on custom update/insert SQL statements
MCM enhanced to exclude EXGRID.DLL from the switching model to prevent issues with other applications
DStageWrapper.sh doesn't handle quoted arguments correctly
DataStage job takes longer time to compile when using DB2 Connector stage
SQL Builder hangs and crashes when more than 15 columns are selected and dragged to "Selected Columns" List
Error happens during export when selecting project on select items dialog
When GROUP BY is set, cannot reopen SQL Builder with "An error occurred invoking the SQL Builder:"
Additionally log debug or trace level information from DSAuthentication service and DataStage Export Service
MetaData WorkBench data impact analysis reports are showing wrong results in MWB
Information tools will not run if Information Server has been installed into a directory containing a space in the path, such as "PROGRAM FILES".
Intermittently, dsjob can cause a core file to be generated when domain login is used. The job completes successfully.
When a job is reset the status is updated to 'has been reset' but the userstatus value is not cleared.
Terminator activity causes Parallel jobs to hang instead of abort
Trying to configure active/passive fail over using Linux cluster. Problems found with HA scripts
Job Monitoring data not shown for GRID job that has been queued for more than 5 minutes
The Masking Policy Editor in Data Masking Pack 8.5 does not work in Information Server 8.7.
Intermittently, DSWaitForJob incorrectly returns status 98 for a job which is already running
Receiving "Error exporting runtime data: No repository connection has yet been made" when exporting jobs using istools
Browser freezes in Operations Console when selecting multiple jobs in the Activity tab
Server ODBC stage does not check for comment lines in .odbc.ini
Information Server Manager not deleting executable on import
SQL Builder truncating text in the WHERE clause when it contains white spaces
Unable to compile newly imported Buildop in command line using DSCC, until the component is opened in Designer.
Designer closes when drag/drop column to Transformer stage
Multiple instances of DS Director show same domain name in the Project->Open dialog, but are associated with original domain.
Sharing Wizard to link against the parenting object not creating a new data file object containing that pathname
ABAP stage opens and compiles very slow
When using Data Connections to import MetaData, import will crash when re-importing an existing table
Importing a stored procedure from a Netezza database causes DSR.MetaGeta Cannot read result file DS_METATEMP record
View Data for Oracle Connector on server canvas should not be enabled.
Deploy the DSHARestart.vbs script for Windows IS installations that are configured for High Availability
Operations Console has performance and scalability problems when, for example, there are very large numbers of job runs
The Operations Console REST API and ODBQueryApp do not handle query tokens efficiently
Operations Console database timestamps can be incorrect when events occur across daylight saving time changes
The Operations Console EngMonApp process stops and can not be restarted successfully
Server routine SetUserStatus() not working in context of Basic transformer
Core files are intermittently generated by dsjob command.
dsexport sessions remain "Active sessions" as "Command Client" in Web Console
Designer Client hangs if an attempt is made to Stop a job whilst it is being initialized for a debug run
Parallel Debugger fails with the message 'Parallel debugger failed to enter checked state'
XML Output not maintaining references such that Impact Analysis results are not shown
Director client switching between projects fails with ACCESS DENIED when it should not
Ctrl+Enter no longer works in all other application that use the shortcut after viewing job log the Designer
Sybase Enterprise stage allows drawing of Reject link.
After installing JR38797 or 8.5fp2 Table Definition with Shared Data Collection is flagged as out-of-sync in some timezones
DSCheckSum should ignore transient files created by Parallel Transformer Deployment
Subdirectories for Operations Console events will be generated faster than expected in months Jan-Sep
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.7 fixes that require post-installation steps



DataStage Engine
DSParams file ownership changes to non-dsadm user
DS.TOOLS is not returning the full PID and results in locks not being released.
NLS portion of Information Server install can fail on RedHat 6.2
Environment variables are missing in the Administrator due to corruption of the DSParams file


DataStage Main Frame
DS job does not read PL/I copybook correctly - EBCDIC binary format - float data type


DataStage Parallel
Problem with functionality of Abs() and other parallel engine transformer functions while handling NULL
The CFF parallel stage displays an unexpected warning: "Ignoring the requested execution mode [par] .because of a conflict with the predefined mode of the operator.
APAR JR40656 Some I/O errors on Information Server 8.5.0.1 will report as fatal but will not cause jobs to fail
PARALLEL ENGINE PIVOT STAGE GIVES ERROR: POSSIBLE TRUNCATION OF VARIABLE LENGTH STRING.
ADD HADOOP FILE SYSTEM (HDFS) SUPPORT TO THE SEQUENTIAL FILE STAGE FOR USE BY THE NEW BIG DATA FILE SYSTEM (BDFS) STAGE
Records from a PX job deployed as an ISD service return out of order, so a response can have records from a different request.
PARALLEL ENGINE MAY PRODUCE LICENSING ERRORS ON JOB STARTUP.
Parallel jobs using shared memory for interprocess communication sometimes fail to start.
Parallel Engine Surrogate Key values can not exceed 32 bits
IF ELSE derivation in transformer stage give wrong results when Nullable columns are use with functions of more than 1 argument
Upgrade IS 8.5 and later to MKS toolkit 9.4FP1 with Hotfix CFS31959
Parallel Engine modify function uppercase_string() does not convert char 0xFF to uppercase 0xBE for charset ASCL_ISO8859-1
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.7 fixes that require post-installation steps



DataStage Tools
Unable to include External Folder files in a package if a DataStage project is created in non default location.
Jobs inside protected project can be deleted using ISM


FastTrack
FastTrack client throws "No More Handles Error" when working with large Mapping Specifications


Information Analyzer
Column Profile report fails on selecting large number of columns .
RULE SET EXCEPTION REPORT FAILS TO SHOW EXCEPTION ROWS WHEN OUTPUT INCLUDES COLUMNS/ATTRIBUTES OTHER THAN RULE VARIABLES.
INFORMATION ANALYZER - SINGLE QUOTES CAUSE AN ERROR WHEN ATTEMPTING TO SAVE VIRTUAL TABLE
"Edit Virtual Table" displays incorrect table name and WHERE clause when a Column name contains a space.
REST API FUNCTIONALITY TO VIEW EXCEPTION RECORDS FOR INDIVIDUAL RULES
ENHANCEMENT REQUEST: Limit the Data Rule Exception report to 10,000 exceptions.
Performance issue when creating a new Data rule or Data rule definition in a Project with many rules
Data Rule Exception Report does not display exception details if output column names are long
NEGATIVE PERCENTAGES APPEARING IN IA RULESET RESULTS
Adding columns to rule set output in clustered environment fails to add new columns in rule set output
UNABLE TO SAVE DATA RULES. NULL POINTER EXCEPTIONS ARE THROWN DUE TO NULL SESSION VARIABLE.
After source metadata is changed, Cross Domain Analysis screens continue to display stale Primary Key & Foreign Key definitions.
Job creation fails when a data rule uses certain types of joins with redundant key pairs.
INVALID XML CHARACTER ERROR USING IAADMIN.SH TO GET OUTPUT TABLEDATA.
A virtual column used in an outer join or in a in_reference_column test leads to a job failure
Data Rule Definition Expression is not always required, but the validation schema indicates it is
Tables / Columns sometimes do not show up in the EDM DataFields picker
CDA results are not shown for virtual columns.
THE KEY AND CROSS-DOMAIN ANALYSIS DOES NOT PRESENT THE FOREIGN KEY CANDIDATES CORRECTLY FOR A MULTIPLE COLUMN PRIMARY KEY.
USER WITH DATASTEWARD ROLE SHOULD BE LIMITED TO ACTIONS PERMITTED FOR THE ROLE
RANDOM ERRORS OCCURRING IN THE IA CLIENT. THESE ERRORS CAN OCCUR DURING VARIOUS BASIC ACTIONS.
MISSPELLING OF DROPDOWN ITEMS WHEN SETTING UP A REPORT "DATA RULE SUMMARY"
UNABLE TO REMOVE A REGISTERED TABLE IN PROJECT PROPERTIES. THE TABLE APPEARED WITH A RED ICON AS ITS METADATA HAD BEEN DELETED.
IAAdmin should show meaningful error messages when attempts are made to use invalid XML instead of throwing a Null Pointer Exception.
When viewing a term, custom attributes list should be sorted
Milliseconds are truncated for time stamp data values in Frequency Distribution tab
Information Analyzer:View details of a rule or ruleset for the old runs displays the current rule logic not the old rule logic
IAJob and IAAdmin execution is not using the project name specified on the command line
Virtual table Where clause operators and values are changing after saving


Documentation
DATASTAGE DOCUMENTATION IS MISSING SORT REQUIREMENTS FOR RANGE LOOKUPS
DATASTAGE API REQUIRES DOCUMENTATION UPDATE
Correct the documentation for the DecimaltoDecimal() function default
Doc needs revision for decimal the setting [p+4, s+4] as 'Default to Decimal Output' in aggregator stage
DOCUMENTATION: DSADMIN -CREATEPROJECT PROJECTNAME -LOCATION PATHNAME. THE PATHNAME MUST INCLUDE THE NAME OF THE PROJECT.
Provided a list of all reserved words in Information Server DataStage tranformers


Information Services Director
ISD does not return all rows if a job stop notification arrives while the job is still sending data,
ISD returns duplicate data if the job instance is not running when the request arrives.


Information Services Framework
Add Group Information To DataStage Credential Mapping Documentation
Information Server Installation Hangs If DB2 Configured For Oracle Compatibility
Values Overlap On Chart Axis In Reports With Excessive Data Points
Add Documentation For Files And Directories That Need Occasional Clean Up
No indication that permissions are invalid when using ORLogging and first user to run jobs does not have dstage as primary group.
Timestamp Sometimes Not Populated Correctly in Active Users In A Session Report
Cannot View Details In Scheduling Views Display Because Column Is Not Re-sizeable
WebSphere Initialization Hangs in ReportingAdmin when >3000 Completed Report Records Exist
No XSS Input Validation in the Simple and Advanced Search Fields in Web Console Reporting interfaces
Steps in Documentation Are Incorrect for "Configuring IBM InfoSphere Information Server To Use PAM"
AppServerAdmin Script needs to be updated to deal with XMeta Stage Password


Metadata Common Services
When a PK in deleted in source db, reimport of tables with IEM OR istools results in com.ascential.xmeta.exception.data.DeleteViolatesRestrictRuleException
Setting the implementation relationship in Repository Management between LogicalModel and PhysicalModel or LogicalModel and DataSchema fails in Oracle.
While deleting or importing metadata, IA, DS or Fasttrack tools fail with UnauthorizedAccessException
Ability to import Logical Data Model duplicate objects using istool with -lm option
When a primary key is deleted or some of the columns of a primary key are deleted for a referenced table in the source, then the re-import of the table fails.
REST API to expose common metadata assets from Xmeta repository.
PDR reimport in IA by adding new fields fails with com.ascential.xmeta.exception.data.ImportConstraintViolationException


MMI
Statistics Pane shows message, "sorry, an error occurred", after importing one of the Industry Standard Models
JR43054
Add support to InfoSphere Metadata Asset Manager Web UI for IE9
Browse assets passes 'on' as the value of boolean parameters instead of 'True/False'


Metadata Server
Import of isx and dsx files using istool fails with ConcurrentModificationException
XML file export from BG admin fails to import with com.ascential.xmeta.exception.usage.ObjectNotTrackedException
BG import fails with ArrayIndexOutOfBoundsException.


Metadata Workbench
MWB throws an error when the download link is clicked in the expression part of the Business Intelligence report's lineage.
Support for user-defined SQL statement to insert data based upon a select statement
Job lineage is broken if schema is not specified on custom SQL.
MWB automated-services cannot parse custom SQLs with environment variables in parameter sets
Display of term history is incorrect in Metadata Work Bench.
Automated services support for Netezza stage
Extended Mapping does not support source/target of "Stored Procedure".
MWB Automated services fail with error when parsing views with 'Interval' expression
MWB hangs while attempting to export Query Result to XLS when two tabs have same name and length of tab name is less than 3 characters
Description field in MWB BI Report is not able to display more than 254 characters
MWB Automated Services will not inspect data flow through a Reject Link when data is written to a sequential file or database.
Unable to apply criteria of "IS NULL" to custom query.
MWB automated services do not map oracle ENT stage custom SQL if schema not specified
MWB query for term mapping specifications display incorrect results.
MWB fails with Class com.unicorn.util.extendedException when trying to bind the source stage to a table.
MWB fails with Client.CouldNotDecode error when expanding the DataStage job for Data Lineage
Automated services fail to parse the custom SQL with the construct 'CURRENT NODE'.


QualityStage
Match stage crashes (error code 132) when using weight cutoff overrides
Match Frequency truncating some Japanese strings
Match and Match Frequency stages are not handling with UTF16 surrogate-pair characters properly
Standardize fails for some CONCAT and PREFIX PAT actions
Canceling from MNS or WAVES stage editors causes run error
Rule Set development handbook contains Reference and Bookmark not found - missing sample data
Standardize stage can be affected by Redhat 6.2 glibc memcpy issue


XML Pack 3.0
On importing a XML Schema into the Schema Library Manager, not all schema elements are visible in the library.
Cannot view the job parameters inside the XML stage Assembly Editor
When the XML file has unexpected elements for the schema definition having xs:all , then the XML Stage is not parsing the file properly.
When the XML Stage is run in parallel mode, Composer Step does not consider the node number while naming the Output XML file.
When extra tags are present in the XML file, the invalid XML file is not rejected properly.
When Parallel Parsing feature is used in XML Stage, temporary files are not deleted from the scratch disk
XML Stage does not clear the scratch directory.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.7 fixes that require post-installation steps




[{"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":"8.7.0.1;8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21585489