IBM Support

InfoSphere Information Server, Version 8.5 Fix Pack 2, Fix List

Fix Readme


Abstract

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

Content

The following list of APARs are included in Fix Pack 2 for InfoSphere Information Server, Version 8.5. Note that although fix pack 2 is cumulative service and contains all fixes from both fix pack 1 and fix pack 2, this fix list is not cumulative. To see the list of fixes from fix pack 1, refer to InfoSphere Information Server, Version 8.5 Fix Pack 1, Fix List

Before installing fix pack 2 check your Version.xml file to confirm if you installed any InfoSphere Information Server 8.5 patches which are not included in fix packs 1 and 2. If you have installed a patch that does not appear in these lists, do not install Fix Pack 2 yet. Contact IBM Technical support to obtain a new patch which can be installed on top of Fix Pack 2 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 to InfoSphere Information Server Version 8.5 fixes that require post-install steps.






Fixed APARS included in InfoSphere Information Server, Version 8.5 Fix Pack 2


ASB Packs
Fix ID
Description
XML Output Stage throws a transcoding exception on AIX when writing data to an XML Document
The nullable checkbox is not checked when importing nullable elements in XML Meta Data Importer.
XML Output Stage generates duplicate row when SINGLE ROW output mode option is used.
Performance issue in XML Input Stage due to improper schema caching.
Three fixes for the XML Input stage:
  1. XML Input Stage needs the xml table definitions to be reloaded when NULLs and Empty values handling is turned on for 75x jobs that are imported into 85x.
  2. Fix for XMLInput Stage issue with Nulls and Empty values not being processed correctly when the corresponding checkboxes are selected.
  3. Fix for XMLInput Stage issue with transformation error mappings.
XML Input Stage throws the error "The prefix x is not declared" while parsing an XML document with the namespace prefix x.


Business Glossary
Fix ID
Description
Failure to import customer BG XML export file
Business Glossary Anywhere client issues thousands of login attempt failures when users password expires.
Business Glossary XML Import fails to create assignment to BI Report Members and they will not be linked to terms
Viewing permissions in BGB not working correctly for systems configured to use LDAP and Saving welcome text on BGAdmin not working
Add additional context to the BI assets displayed in the BG dossier to match Metadata Workbench presentation


Metadata Workbench
Fix ID
Description
Error in Automated Services when reading the MetaData from DS Jobs
Failed to parse certain Non-ANSI constructs and comments in views
MetaData WorkBench Automated Services unable to link non-ANSI constructs. Items noted are specific to Teradata
The Namespace of the BI collection being stored in the database, sometimes contains extra characters that are not being passed in
Out of memory and parsing issue in Automated Services
Incomplete Lineage on three consecutive stage columns that do not have a source stage column
Impact Analysis breaks over Transformer stage that contains a Stage Variable
Data Lineage does not work over DB2 Bulk Load Stage that is set to "Bulk Load"
When browsing BI Reports and models cannot set business name field for BI model, BI report or BI collection
Issue in viewing the lineage report from business glossary with BG-basic user and suite user.


Information Server Framework
Fix ID
Description
Provides JRE that fixes Oracle security vulnerability CVE-2010-4476
View Log from IS Console intermittently fails on systems where only Information Analyzer is installed.
A % character in user's password causes problems.
Fixed benign error message displayed by DirectoryCommand on -ADD_USERS_GROUPS command execution.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.5 fixes that require post-install steps



FastTrack
Fix ID
Description
Export/Import CSV issues when some source column contains lookup field.
Generating job from FastTrack resulted in java.lang.NullPointerException when some of the mappings contain lookup columns.


Connectivity
Fix ID
Description
Jobs terminate abnormally with core dump when BCPLoad Plugin Stage is connecting to Sybase ASE Version 15 with OCS 15 Client.
Websphere MQ Connector excessively uses resources while monitoring the WORK Queue Depth
DB2 API stage: If the stage column length is different than the database column length the Designer crashes if you click View Data
In the DB2 Enterprise Stage special characters in the tablename causes the db2Upsert job to fail
DB2 Connector job using Write mode as 'User defined SQL' aborting when a DB2 Warning is encountered
"Clean-up on failure" option in the DB2 Connector does not work when the DB2 is a remote windows database.
Generated SQL fails in DB2 Connector if the tablename contains the "@" character
DB2 Connector jobs are failing connecting to DB2 V8 databases
DB2 Enterprise Stage Load Job failed with error code SQL0911N with reason code 68
DB2 Connector Schema is set to NULL if the design schema is set to NULL.
DB2 Connector fails to create datafile of more than 2 GB size on Linux platform
DB2 UDB Plugin Job aborts with Abnormal Termination when the load statement exceeds 1024 size.
Informix CLI Plugin stage: Jobs fail if the source stage reads from two databases or if the table name is more than 28 characters
Resolution of a number of Informix-CLI issues
Server job having InformixCLI plugin with user-defined update statement is causing "Character to numeric conversion error" errors.
The behavior of decimal datatype in DB2API Plugin Stage is different[when compare to 52 and 753] when the data contains leading spaces in it.
The MQ Client plugin libraries are not getting copied during the installation of the plugin on Linux64 platform.
After upgrading MQ Series from 7.0 to 7.0.1.4, the previously functional MQ Connector stage failed to connect with error MQRC_SSL_CONFIG_ERROR
Netezza operator support for "Delete and Insert" upsert mode and for storing temporary work tables in a different database
Stored Procedure stage connecting to DB2 truncates integer data to 8 digits
Sybase IQ Enterprise Stage doesn't delete control file when reading empty tables.
SybaseOC gives intermittent memory related issues
SAS Enterprise operator reads DATES as NULL on 64 bit platforms
ODBC Connector update jobs fail while connecting to SQL Server when the schema has datetime fields
IQBULK12 Plugin Stage performance issue on Solaris Platform when DATE datatype is used.
ODBC EE for certification with DB2 Connect v9.7 and Oracle11g on Solaris Platform
Certification of Stored Procedure Plugin Stage with Oracle 11gR2
ODBC Connector jobs connecting to MS SQL Server and updating table with smalldatetime column fails with 'Invalid scale value'.
ODBC Connector gives invalid string or buffer length error while connecting to Sybase IQ using SQLAnywhere drivers.
Connector Migration Tool fails to connect to SSL-configured Information Server 8.5 due to the following exception: javax.security.auth.login.LoginException: java.lang.ClassNotFoundException: Cannot find the specified class com.ibm.websphere.ssl.protocol.SSLSocketFactory
ODBC Connector incorrectly creates a table with varchar datatype when the schema in the columns tab is set to nvarchar.
Stored Procedure Plugin Stage running against Sybase 15.X aborts when trying to get locator information.
Plugin Stages on Server Canvas abort with the error message "Pin1 not initialized" on HP-IA platform.
ODBC Connector Job aborts with "Datetime field overflow" error with MS SQL server when the date value is 9999-12-31.
ODBC Upsert with reject link fails with 'glibc detected *** malloc(): memory corruption' error message
Teredata Multiload job hang which cause 32,000 + locks on the SYS.MESSAGE file.
Enhancement for Teradata Connector for Adding new startmode property 'auto'.
Connectors should log SQL statements and values at point of failure
Teradata Multiload stage fails to load when the input file is larger than 2 GB.
FTP Plugin: If First Line Column Names is set and uses the Tab character as a column delimiter, it does not appear in the output
Teradata API Plugin Stage throws "Transaction ABORTed due to deadlock" as Info type and as a result, the DataStage job does not abort.
Using large schemas in XML Connector Assembly Editor hangs the connector stage editor.
FTP Plugin job sometimes aborts with Access Violation when the input file contains multi-byte characters.
Importing the tables having foreign key dependency across the schemas fails due to java.lang.NullPointerException.
ODBC CC Jobs failing with SQLBindParameter errors when the table has datetime fields.
Add LDAP authentication support to the Teradata connector.
FTP Plugin Stage does not allow ASCII NULL to be passed in Numeric data type.
An error occurs when customer tries to do a browse of Salesforce Connector metadata using parameters.
Oracle Connector parameters are sometimes replaced by the runtime values.
Connector stages: For non-English installations, if the Lookup type is set to Sparse, the type is not saved and reverts to Normal
XML Assembly Editor is not able to process column names with "national" characters.
Lookup type combobox does not dropdown the list 'normal' and 'sparse' on non-english Windows OS.
On the Parallel Canvas DB2 API Plugin Job does not abort for SQL ERROR SQL1476N.
Char extended by UNICODE is giving spurious truncation warning message for DB2 Plugin Stage, post 81 critical patch v3. Issue seen on UTF-8 DB2 database.
For Informix CLI Plugin Stage, when the job has the first column as "DATE" datatype, then the job runs in continuous loop.
XML stage with multi-links and no input link aborts
Login Error with Salesforce Connector when using a long password.
Re-importing the tables after removing the primary key from the source database fails due to lower bound constraint violation.
XML Stage fails to create schema for columns provided through Runtime Column Propagation.
Connector jobs on server canvas abort on non-english locales
On 64-bit IS, reading a SAS number field as integer gives the result null even though the value is not null in SAS.
ODBC Operator aborts with invalid precision value connecting to MS SQL Server with nvarchar more than 2000 length.
Sybase Enterprise stage job does not abort on primary key violation errors while bulk loading to Sybase IQ.
View Data with Netezza Operator fails when the user defined SQL Statement contains comments in between.
ODBC Operator sparse lookup jobs fail with Added field has duplicate identifier(): error message
ODBC Operator does not abort even after throwing a fatal error.
Datastage Job Property for Default Timestamp Format String is not used for some implicit timestamp conversions in a job.
Data Truncation is observed in DRS-Oracle Stage after IS81 FP2 is installed.
TDMLoad read jobs are performing slow on IS 8.1 as compared to DS 75x2 when the schema has string fields.
When the Debug mode is set, FTP EE Stage displays the password in the debug trace logs.
Support of UTF16LE NLS Map for the FTP Enterprise Stage in the Put Mode.
XMLOuput stage emitting spurious errors about character conversions from UTF-8 to Unicode.
Merge Stage in server canvas gives incorrect results based on Data supplied.
When using a Connector on a Server Canvas, incorrect warning messages about UTF-8 conversion are displayed in the logs.
Low Date values (less than Dec 31st 1967 ) are being modified in XML Stage for 64 bit platforms.
On connector stage editor loading a database connection in which the connection strings are parameters or from parameter set is failing.
TDMLoad Plugin write jobs are showing a decrease in performance in the IS 8.1 FP1 release as compared to older releases when the schema has string datatypes.
When Teradata Plugin Jobs are migrated to Teradata Connector in IS 8.5 it throws the error "array index out of bounds".
Error when passing nullable date to stored procedure stage
Copyright character[xA9] is causing issue when using UTF8 in Sybase IQBulk stage
Allow overriding nullability of resultant fields in ODBC Operator Sparse lookup schema
Even when the partitioned reads are enabled in the ODBC Connector, the read jobs are running sequentially.
Sybase EE Stage performance issue as compared to ODBC Stage.
ODBC Connector write jobs with timestamp fields fail with precision errors connecting to MS SQL Server 2008
ODBC Connector insert (append/truncate) jobs with IS 8.5 FP1 throw table not found error
SybaseOC sometimes generates undesired select statements and commit statements after every record.
Link numbers are missing in the DTS GUI link ordering page.
Request to support retry logic with the database connector stages
DRS Plugin DB2 error received: [DATADIRECT][ODBC SQL Server Driver] Invalid SQL Data Type : SQLBINDPARAMETER: Failed to Bind a Parameter
View data fails in Oracle OCI9 stage when custom SQL containing column aliases is used for lookup
Job with Oracle Connector stage fails to access the remote database table
Request for environment variable to remove warning in the Oracle connector when a reject link is attached
The mouseover text in the Designer client for ARRAYSIZE field of the Oracle Connector incorrectly lists 0 as a valid option
Oracle EE Read fetch errors not resulting in job abort
Oracle Enterprise Stage accesses the METASTAGE_LOC table even though METASTAGE is never initialized
MS OLE Plugin aborting for large array sizes
The date handling on ORAOCI for IS8.1 is t different than that on DS 5.2
ORA-01000 error received with isolation level=READ ONLY
DRS OCI Stage truncating last character
Oracle Connector aborting if more than one partitioned exists for an index.
Oracle Connector - Read partitioner not parsing special characters correctly. Resulting in ORA-00923
With Arraysize not equal to 1, "UPDATE EXISTING ROWS" or "INSERT NEW" causes abnormal termination
Oracle enterprise returning sequential read data on all partitions instead of partition table data
Oracle Connector - CMT - Indate Oracle EE jobs are migrating to Delete
DRS Plugin stage adding extra null characters to the end of NCHAR and NVARCHAR column when inserting into Oracle
Oracle Connector performance and character corruption issues because Incorrect bind charset form used.
Connector Migration Tool - Stop migrating $PROJDEF, $UNSET, and $ENV Parameter/Environment variable values.
Oracle connector problem with the parser that finds table names when the table aliases are also in the SQL.
Oracle EE does not load data when using APT_ORACLE_NO_FIFOS
Oracle Connector bulk load to a table with HANGUL column fails if variable CC_ORA_NLS_LANG_ENV is set to true
Oracle Connector METADATA errors importing table definitions for materialized views
Oracle Enterprise Read stage Filter clause with line comments may cause ORA-00907: missing right parenthesis. Regression from APAR JR36403.
Performance improvements for Oracle Connector Bulk Load
DRS ODBC plugin is not working correctly with INSERT NEW ROWS ONLY AND ARRAYSIZE=1
DRS Oracle not aborting or warning when MESSAGE ORA-01722 is encountered
Column name is an Oracle reserved work in 8.5
Updated the Connector Access Service to retrieve smaller part of repository tree to prevent java.lang.OutOfMemoryError in WebSphere when DataStage Designer client imports metadata via connectors.
Oracle EE - SQL*Loader file name collisions causing job abort.
DRS ODBC stage is not inserting records with Max length NVARCHAR columns
Oracle connector does not throw any warnings when truncating LONGVARBINARY data and "FAIL FOR DATA TRUNCATION" is set to true.
New environment variable to override default behavior of "drop unmatched fields" property in Oracle Connector
Export operator cannot have partitioner if there is only one node. Work around Export operator bug in Ora EE by removing partitioners when on one node.
Numerically bound columns (INTEGER, ETC) are not retrieved by DRS ODBC on Zlinux
Oracle Connector METADATA import is not working properly
Multiple issues with Oracle Connector View Data functionality
Need BIGINT datatype support for DRS plugin ODBC/MSSQL on MS SQL Server 2005
Oracle connector rewrites the Update statement with a duplicate Ordinal Parameter Returns Clause
Oracle EE stage printing duplicate informational log messages.
Oracle Connector with RCP describing columns as VARCHAR(N) instead of VARCHAR(N*MB) or NVARCHAR(N)
Public synonyms not working in Oracle Connector partitioner or bulk load
Using more than one SQL Server EE write stage in the same job fails.
Processing node status not passed to the conductor process in Common Connectors
Oracle Connector: The rowid round robin partitioning inserts the right parenthesis at the wrong place.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.5 fixes that require post-install steps.



Balanced Optimization
Fix ID
Description
8.5 AIX 6.1 Balanced Optimizer producing incorrect SQL
After SQL query in the Teradata Connector is lost after optimization in BalOp
Optimized job using BalOp aborts with error message "RDBMS code 2618: Invalid calculation: division by zero", SQL query generated seems incorrect.
Incorrect result after optimization of a job which uses the function DaysSinceFromDate()


DataStage Tools
Fix ID
Description
Unable to include External Folder files in a package if a DataStage project is created in non default location
Unable to save changes to existing package manager. Error: object id locked by another user


DataStage
Fix ID
Description
Server job aborts when multiple user-defined SQL statements are used in the ODBC stage
Mapping error occurs with a particular input file in which there are no un-mapped characters.
NLS Mapping error with correct records
Oracle number type column metadata imported by ODBC plugin is loaded as decimal(38,10) to ODBC enterprise stage.
Encrypted parameters can be displayed in the log using certain commands and execsh
Column lineage doesn't work when range lookup is used
Director crashes when performing a find in a log file with more than approx 30k rows: runtime error 6, overflow
Job comparisons fails when properties contain embedded xml
DSDesign /r and DSDesign /saveASBmp didn't include link marking in the generated bitmap.
Error calling subroutine DSR_LOG in Director when navigating in the performance analysis window
User password containing character '}' is truncated by the server ODBC stage MetaData Import on Windows
Server job has container error ds_ipcopen() - error in open
After comparing jobs, runtime error happens if clicking view on comparison result.
Multi-instance jobs report status=99
/nodependents does not work for /job /xml
Server sequential file stage issue if quote is extended ascii
Server job using MQ and inter-process active-to-active links hangs and doesn't stop when requested
Repository pane in DataStage Designer on Windows 7 does not list project tree structure
Incorrect warning messages are displayed when a Data Connection is loaded into a Connector Stage in the Designer
DSD.uvopen unable to open file warning message generated in job reset
DataStage loading of previously imported table definitions into any stage taking too much time.
Suite installer for Windows does not correctly install system dlls
Set defaults option may corrupt encrypted parameters
DataStage server job logs warnings DSD.ipcclose: line 80, bad file descriptor.
A switch is required to turn off the automatic creation of environment variables by dscmdimport tool
Pivot Parallel stage property for "pivot type" needs upgrading from 8.1 version as internal value for "horizontal" has changed
Duplicate columns are not caught during export. this causes subsequent import errors in istool
Abnormal termination of stage message when stage is reset
Core file is created when sending large attachments
Message handler cannot suppress the message due to incorrect message id -1
If several users log into Remote Desktop with different credentials the Designer may fail to start
Sequencer job wait for file activity stage waits indefinitely close to 23:59:59
ISTools import holds Folder sessions locks when it doesn't need to
DSJOB -local -jobstatus ..... does not wait for the job to complete before returning to the command line
Wrapped stagetype .op file corrupt after deploying ISTools package
LD_library_path for the Parallel job is built incorrectly
Server job finished with warning IIS-DSTAGE-RUN-E-0187
Unable to launch properties for uservariable stage
Cross project compare dialog window in the DataStage Designer client hangs on startup if dialog was maximized in prior session
Importing environment variables removes any non-default values from existing environment variables
The active DB2 instance is already set to a value
DataStage Designer throws a misleading error server and client version mismatch
DataStage Designer partitioning icons are missing on link marking
Jobs failing with the error 'warning: variable dslink2.SQLstate' never assigned a value.
Parallel compiler does not create -linkxmlproperties when there is a single link
When sharing sequential file table definitions, the attach point of the files is incorrect
DSJOB command on Solaris outputs invalid Japanese characters when the locale is set to ja_jp.utf-8
Job upgrade has hit a null pointer exception when trying to optimize flow variables
Routine code running in Windows 7 client shows "#" when "\" is entered.
OMD files writing to the old install path rather than 8.5 install path
Parallel job compilation fails when basic transformer has basic function
Parameter substitution is not occurring when code compiled using director batch feature
Column order reverts back in transformer after exporting the job to dsx file.
Warning message - program "dsjobrun": line 403, variable "tempname" previously undefined.
Status 99 errors occur when a timeout is received resetting a job
Server WISD Job logs warning message - (DSSocketNotify): OpenSocket returned 16
MappingException is thrown during the save of a FastTrack generated job design after applying patch JR39833
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.5 fixes that require post-install steps.



DataStage Engine
Fix ID
Description
Fix for job-compilation issues when the environment-variable: DSE_PID_SIGNATURE is set.
Fix for core-dump-issue, when formatting with Text-justification, on NLS-enabled DataStage.
Fix to Prevent corruption problem in oversized buffers, after adding a block at the end of the file.
JR39769
Fixed privilege escalation vulnerability for Engine tier.
Fix for ODBC-metadata-import on 64-bit-DataStage, when using Classic Federation ODBC driver.
JR40442
Corrected issue with security patch JR39769.


DataStage Mainframe
Fix ID
Description
DataStage Mainframe rel 8.1 job CFF stage comp-3 field with low values cause S0C7 abend. Job worked with DataStage 7.5.2.
Problem with JCL code generation using IIS 8.1 FP1 clients on Italian Windows installation.
SCD stage surrogate key config for DBSequence will not retain the information entered.
Import of "Cobol File definitions": PIC 9(4) is generated without 'unsigned' attribute  ({zoned, default=0} instead of {default=0, zoned, unsigned} )


Information Analyzer
Fix ID
Description
Large projects have performance issues in Project Properties, Home page statistics, Column Analysis screens.
There is no indication to the user that Virtual Columns with an empty Field Separator do not support Drill down operations.
IA Client installation needs the DataStage client to be installed to resolve missing jar.
Opening the Data Class tab while viewing Column Analysis details causes an Application Error.
In a data rule, expressions "date()-365" and "date()+365", return "NULL" instead of the result indicated in the documentation.
Application error is displayed when opening the Domain and Completeness tab in situations where percentage values in the screen are extremely small.
Distinct on exception records in output of a data rule does not work when the function "sum" is used on the requested output.
Enhancement to add a new trend analysis chart that displays Number of Rows Met/Not met over time. Currently, IA supports a chart that displays Percentage values.
In Identify Flat Files->Update preview, data values with leading spaces are displayed incorrectly
Rule variable values are limited to the Maximum Integer value (214783647).
In the Data rule dropdown list of available functions, "in_reference_column" should always be in English and should not be translated.
The Data Rule function, "tostring", does not work with %i and %u formats.
Incorrect warning in Identify Flat File when adding a table to an empty QETXT.INI file
Export of a project name containing spaces, treats each part as a separate project.
Various UI screens encounter problems displayimg data related to deleted metadata. If the metadata is deleted after Column Analysis and other IA functionality has been used against that metadata, then a number of UI screens encounter issues, for example "Unable to load Resources file".
Issues importing into 8.5 rules that were exported from 8.1.2.
The Data Rule function "is_date" is not validating correctly.
The Rule set exception report does not report a field in certain situations if the rule variable name is not the same as the table's column name, or the output includes a column that is not bound to a rule variable, or if a column is selected out of the Statistics and Attributes screen.
Some users of Information Analyzer 8.5 Fix Pack 1 could encounter one or more of the following issues due to a threading problem
  1. Analysis and Data quality jobs fail with Connection failure on port 2809.
  2. When a file is "Added" in "Identify Flat File->Display Flat Files", a FileIOException is thrown, and the logs indicate a JACC Authorization error.
  3. Blank screen while closing View Data Sample until Data Sources are displayed. Sometimes, orbtrc exception files are created in the Information Analyzer client directory.
  4. Data rule execution details and exception tables are not displayed and logs indicate a null session id.
  5. Unable to add the same rule definition more than once to a rule set definition. Session Exceptions in the log.
  6. Data Store, Schema Not Populating on Generate Schema Definition for Generating a PDR.
  7. Import of a project fails with a message indicating that the file is invalid, and logs indicate a Null session Id.
  8. CORBA exception in client log when trying to associate a Term to a column in View Analysis Summary Details.
  9. In "Identify Flat File", removing a previously imported file from the "Select File to Import" list produces an Application Error indicating an IO Exception.
  10. Saving a new Transformation value in the Frequency Distribution tab of "Open Column Analysis", produces a Service Access Exception. A login exception indicates CORBA COMM_FAILURE.
  11. IA client hangs on clicking refresh button in rule definition creation screen.
  12. Orbtrc file is generated in the client directory on closing out of View Sample from Data sources palette, in various Data rules views, and Global Logical variables view.
  13. While creating reference tables, exceptions are seen in the orbtrc file related to null session IDs.
  14. Exception while viewing rule set execution details.
  15. When 'Enable drill down security' is unchecked and then rechecked, an orbtrc file containing an Exception is created.
  16. Orbtrc file is created during Drill down operations in "Open Column Analysis".
  17. Clicking on View in Business Glossary button produces an EntryPointInstantiationException and a CORBA exception.
  18. Accessing the Metadata Import view, or expanding a Data Store hierarchy is slow.
  19. In Run Column Analysis screen, in the Connections configuration grid, if DB2 connector is selected and a database source provided but username and password are left blank, then clicking on "Test Connection" creates an orbtrc file.
  20. Orbtrc file is created when the Column Analysis is selected, after clicking on each of the tabs in Overview->Project Properties.
The Cross Domain Analysis report is generated for all column pairs even if specific pairs were selected during the analysis.
The Column Profile report fails if a large number of columns were selected for the report.
If source metadata is changed and re-imported, the User Interface does not correctly reflect the current defined metadata properties.
If a large number of Glossary terms have been defined, the User interface screen does not repaint when a rule is opened, or a new rule is created.
Virtual table is not created when using the HTTP/CLI API if the base table contains a period in the name. No error is returned even though the virtual table is not created.
JR40397
Inaccurate access on IA Reports.


Parallel Engine
Fix ID
Description
Add ability in parallel engine to specify node pools for MMAP files created by TSORT and LOOKUP processes.
Enhancement: support re-try logic with database connector stages.
When using the preserved type for the datatype Integer in the Information Server 8.1 Aggregator stage, the job aborts.
Parallel JOIN stage does not return correct records for descending keys if APT_NO_SORT_INSERTION is defined.
Surrogate Key Stage generates spurious message: RUNLOCALLY() DID NOT REACH EOF ON ITS INPUTDATA SET 0.
Preserve Partioning (+PP) flag on the output links of a LOOKUP create operator causes parallel job to fail.
Parallel Engine can not load lookup tables bigger than 2GB, even on 64bit version
Heap allocation error using parallel engine transform SAVEDINPUTRECORD and GETSAVEDINPUTRECORD functions.
After migrating from Information Server 8.0.1 to 8.5, some jobs show a partition warning for the lookup stage.
PX Datasets compressed using pcompress do not retain the actual values. When uncompressed some field are empty.
Information Server 8.5 jobs with transform null handling functions fail.
Allow Information Server 8.5 to start multiple resource trackers on the same server through jobmoninit
Assigning DSJOBSTARTTIMESTAMP to datatype TIMESTAMP (with microseconds), is removing the microseconds part from TIMESTAMP.
Information Server jobs using the the transformer looping feature are failing with "FAILURE DURING EXECUTION OF OPERATOR LOGIC"
Resource Tracker gets TUXX-00002 internal error randomly when it starts up
DataStage function IsValid("int64",column) has different results in DataStage 7.5 and Information Server 8.5 and 8.1.
In Information Server 8.5, jobs with transformer stages which have a column defined as varchar and nullable get corrupt data.
On 64-bit IS, reading a SAS number field as integer gives the result null even though the value is not null in SAS.
A job that reads from multiple data sets and uses a copy stage to distribute the data from each data set to multiple funnel stages hangs intermittently.
Parallel jobs that use the Netezza stage show a status of Running even though the job has finished
Character delimiters are not working in parallel transformer Field() function
Using LastRowInGroup function in Transformer stage with VarChar column has corrupted data
Oracle EE loads data successfully with "APT_ORACLE_NO_FIFOS=0", but it does not load any data with setting "APT_ORACLE_NO_FIFOS=1".
Parallel jobs are not starting in MPP mode when ssh is used for communication.
JOIN stage produces inconsistent results after application of fix pack 1 on 8.5.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.5 fixes that require post-install steps.



Information Services Director
Fix ID
Description
An ISD import fails if the agent name specified in the data file is not configured on the target system.
The ISDAdmin command line tool is unable to update the value of an encrypted job parameter.
If an import of an ISD runtime application fails, the ISD application still remains deployed in WebSphere.
After importing an ISD application using ISDImportExport and the omitpassword option, you cannot set the provider password.
A NullPointerException is thrown when importing a runtime application which has a job parameter that has a null value.
After changing the information provider job in ISD Console, it switches back to the original job. 


MetaBrokers and Bridges
Fix ID
Description
Default behavior for isSigned to be made false
Unable to import Physical Model from DM1 using Embarcadero Bridge
Constraint violation exception when importing a Cognos model after importing the physical schema metadata
MITI Bridge issue importing Cognos MetaData to MWB
Problem with IS8.5 import using the check for duplicates option
Conversion of type Smallint and Tinyint is not correct because both converted to Smallint unsigned
Fix to OBIEE BRIDGE 6.1.0 to address UDML Import issues
Not able to export physical model to the Metadata Server with error "POSTPROCESSOR FAILED"
Unable to export RDA/IDA physical data model to Metadata repository using MetaBrokers and Bridges for IDA
IDA centric import of Glossary mode is not generating LDM
Business Objects Repository 11.x import finds duplicates but unable to determine where to find these duplicates in BO


Metadata Common Services
Fix ID
Description
Although the first report import associates to the model, subsequent reports cause the association to be lost.
ISTool export fails for the report definitions ending with a backslash


Metadata Server
Fix ID
Description
Connector migration tool used for ODBC stages from IS 8.1 Jobs to IS 8.5 fail with "IndexOutOfBounds" error.
ORA-01424 error encountered intermittently during Information Analyzer MetaData import


QualityStage
Fix ID
Description
Add a new environment variable to allow disable of distribute-component in all QualityStage stages.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.5 fixes that require post-install steps.



XML Pack
Fix ID
Description
The DataStage job image in the Repository of the DataStage Designer shows the "plug-in" icon rather than the actual XML Stage3 icon. *
The XML Stage cannot be re-opened, when the schema used in it has user-defined patterns.
XML Stage connector GUI is unable to save and open jobs where large xml schemas have been used , causing DataStage Designer to freeze.
National Characters are not displayed correctly in the Input and Output Steps of the XML Stage.
A job fails to run when XML Stage has no input links and has multiple output links.
On importing certain schemas into the Schema Library Manager, all elements of the schema are not visible.
*To use this fix in your jobs, refer to InfoSphere Information Server Version 8.5 fixes that require post-install steps.



Blueprint Director
Fix ID
Description
Corrected fix pack packaging issue for Blueprint Director component.


Install
Fix ID
Description
Notices and copyright files missing in IS 85 Installer
JR40875
Patches JR40442 and JR39769 did not install correctly unless engine and service tiers on same machine.
DS PLUGIN EDITORS: Drop-down list is not shown for property for which default value is not set in StageDsc.xml.


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

Document Information

Modified date:
16 June 2018

UID

swg21568101