Fix Readme
Abstract
Summary of fixes included in IBM InfoSphere Information Server, Version 9.1.2, with fixes grouped by components
Content
The following list of APARs are included in InfoSphere Information Server, Version 9.1.2. Please note that 9.1.2 is cumulative service thus contains all fixes from 9.1 fix pack 1. However, the fix list itself is not cumulative. To see the list of fixes included from fix pack 1, refer to the following document:
InfoSphere Information Server, Version 9.1 Fix Pack 1, Fix List
Before installing this maintenance level, check your Version.xml file in the InformationServer directory to confirm if you have installed any InfoSphere Information Server 9.1 patches which are not included in 9.1.2. If you have installed a patch that does not appear in either this 9.1.2 fix list or the 9.1 fix pack 1 fix list, then do not install the 9.1.2 upgrade yet. Contact IBM Technical support to obtain a new patch which can be installed on top of 9.1.2 so that you do not experience loss of functionality as a result of applying this update.
*For fixes that have an asterisk after the Fix ID, if you want to use them in your jobs, refer to the following document:
InfoSphere Information Server Version 9.1 fixes that require post-install steps.
Rollup Patches included in InfoSphere Information Server, Version 9.1.2
For convenience, the following table lists special patches included in 9.1.2 which may have been installed prior to 9.1.2. They 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 9.1.2 Rollup Patches | |
Patch Name | Description |
rollup_RU1_imam_all_9100-9101 | Metadata Asset Manager Rollup Patch 1 |
rollup_RU2_imam_all_9100-9101 | Metadata Asset Manager Rollup Patch 2 |
rollup_RU1_mib_win_9100-9101 | Metadata Integration Bridges Rollup Patch 1 |
rollup_RU2_mib_win_9100-9101 | Metadata Integration Bridges Rollup Patch 2 |
rollup_RU1_MWB_all_9100-1 | Metadata Workbench Rollup Patch 1 |
Fixed APARS included in InfoSphere Information Server, Version 9.1.2
ASB Packs | |
Fix ID | Description |
XML Input Stage throws the error "When reusing the Grammar, no internal subset is allowed" when DTDs are used. | |
XML Importer replaces underscore(_) with double underscore(__) in column names while saving the table definition. | |
WSDL Importer unable to import the web service definitions when there are multiple schemas with the same target namespace. | |
XML Input Stage job aborts on non-NLS environment while processing output link column information. | |
WSDL Importer does not create all the elements in the web service input and output table definitions. |
Business Glossary | |
Fix ID | Description |
XML import of data exported from 8.7 with custom attributes fails | |
Export of development glossary is not happening with the short notation -dev | |
BG 9.1 RU1 Undefined error occurred when browsing categories. | |
Add comment button to gui - Dossier and asset list. Add to WorkflowResource a service that assigns a comment "event" to assets, using history log | |
Workflow development log and workflow role enhancements | |
Installing the BG plugin causes the "show related" IDA option to disappear |
Connectivity | |
Fix ID | Description |
Cannot access Sybase table with column name greater than 30 characters | |
Netezza Connector server canvas jobs hang intermittently on windows platform when they process zero rows | |
Bulk-load on a partitioned database fails to insert all the rows when graphic is used as a partitioning key | |
A DB2 API stage containing a '?' in user-defined SQL migrated to a DB2 Connector using CMT fails to run on a Server Canvas. | |
MQ Connector read jobs are failing with the following MQ error MQRC_WRONG_MD_VERSION intermittently | |
JR44954 | ODBC Operator locks system catalog before first wave with DB2 9.5 or prior database in RTI jobs. |
Informix-EE read stage adds extra spaces for varchar column. | |
Connector Stage Editor freezes or takes longer time to open with certain complex SQL queries | |
DB2EE supports CLOB datatype with max limit to 60K bytes in load operators. | |
ODBC Connector fails to populate referenced table and column information in MDI from Netezza Database | |
Support for VARBINARY and ST_GEOMETRY types in Netezza Connector | |
DB2 Connector doesn't check whether the table is in Load Pending state before initiating clean-up | |
Teradata Connector performance is slower in Write Mode for processing big decimal data | |
Teradata Connector - read job fails with Framework returned error for conversion from string to calendar | |
Netezza Operator doesn't log all the ODBC Error messages | |
IMAM using DB2 Connector to import, fetches non-existing duplicate columns from tables whose names are separated by wild-character | |
"Test" and "View Data" from connector stage editor fail when using job parameters whose value have character ']' in it. | |
ODBC EE job failed with error String data code page conversion failed. Error in parameter 1. (0) | |
Connector jobs on server canvas throws arithmetic overflow warning even after the values gets loaded correctly | |
New Function: Add Data Masking Stage to Information Server 9.1 | |
In DB2API, the "Delete and Insert" to a table, does not log error in the event of non existing columns. | |
View Data on table having bool type is failing in Netezza Connector | |
CMT is not populating User-Defined SQL statement from TDMload to Connector on Server Canvas. | |
CMT- Populating Macro Database Value in Teradata CC based on the TDMLoad Stage Properties | |
CMT - Does not replace Plugin format of Column variables to Orchestrate format in User defined SQL | |
Connection closed abnormally messages are seen in the Sybase IQ logs while connecting through Sybase Enterprise stage. | |
DB2 API plugin throws invalid warning messages regarding data truncation | |
Metadata import from Sybase through IA is failing | |
Connectors on server canvas fails to load string representation of calendar data. | |
DB2Z operator generating wrong load statement when a single partition is being targeted. | |
DB2 Connector in DB2 for z/OS (a) Hangs/slow loading partitioned table, (b) Does not read partitioned table in parallel | |
Connector Migration Tool not migrating Direct=False from Oracle EE environment variable APT_ORACLE_LOAD_OPTIONS. | |
Oracle Connector bulk load job abends during job termination | |
The OCI Plugin SQLBUILDER tool is generating incorrect SQL query in regards to a date column | |
Move rowid range partition calculation from player nodes to snapshot in conductor node | |
Oracle OCI bulk load plugin may hang or crash | |
PL/SQL Oracle Connector job aborts with ORA-01460 message when using the 9.1 Big Buffer feature | |
Oracle Operator returns error: Undefined Symbol: CLOCK_GETTIME with Oracle 11G R2 Client | |
Oracle Connector job with large schema/arraysize fails with APT_BADALLOC when using Big Buffer API | |
Enabled "importing views" in the Oracle Connector for InfoSphere Metadata Asset Manager | |
Oracle Connector Import Wizard fails for importing synonyms | |
Initialization of Oracle Connector crashes when there are large values in NLS_DATABASE_PARAMETERS variable | |
Warning messages in Oracle Operator removed | |
Oracle CC fails when ROWID or ROWNUM pseudo-columns used in WHERE clause | |
Oracle Connector not maintaining degree of parallelism when rebuilding indexes. | |
Memory allocation failed for 8,000,000 bytes when doing View Data in Oracle Connector | |
Sybase DRS stage for IS 8.7 has been compiled with Sybase SDK 12.5 while support matrix says that IQ 15.3 is certified | |
Oracle EE should migrate to OraCC with Parallel Clause set to Preserve Degree of Parallelism | |
Connector Migration Tool - Upgrade mode - Error when XMLProperty Value encountered. | |
Regression on Sybase DRS Plugin caused by upgrade to Sybase OCS-15 API with patch for APAR JR46025. |
Balance Optimizer | |
Fix ID | Description |
If link names in the original job have more than 30 characters, running an optimized job raises the message 'ORA-00972-ERROR: IDENTIFIER IS TOO LONG' | |
Job with user defined SQL having select statement like "select *..." is failing to create right optimized SQL | |
8701 Job with user defined SQL fails to optimize due to different case sensitivities of column names in user query and stage level column names | |
Job Optimization of JAQL QUERY GENERATION > STAGE > OUTPUTS, generates unnecessary JAQL statements. | |
Job Optimizer can not optimize a job if it contains table names constructed with job parameters | |
DataStage Job optimization does not generate correct SQL when a job include the Remove Duplicates stage. | |
Optimizer fails to populate generated target JAQL query to the final target HDFS file when a dummy Copy stage is pushed into a target BDFS stage. | |
DataStage Balanced Optimization performance enhancement request regarding JAQL queries |
DataStage | |
Fix ID | Description |
Output Message Id with dsjob -logdetail | |
DataStage support for explicit partitioning for binary keys | |
The RT_STATUS# file periodically get corrupted | |
EngMonApp error - This column type is not currently supported by this driver. | |
Multiple lookup tables allow duplicate entries (allow_dups) | |
DSAppWatcher.sh script incorrectly assumes dsenv does not produce output. Leading to incorrect hostname in DSODB.HOST table | |
Incorrect row counts displayed in Operations Console under heavy load | |
A call to an OLE server has failed, or a runtime error occurred within the old server itself | |
Performance improvements for the Designer Canvas control. | |
dsjob -linvocations behaves differently across platforms | |
Issue with quoting in the pxrun.sh script in deployment packages | |
Compile error does not occur even if there are stages have the same name | |
Decimal become unsigned and packed decimal after imported via Orchestrate | |
Using the non-default port can cause a situation that allows unintended access to a DataStage project | |
Incorrect 0 row counts reported for successful parallel job run | |
Parameter Set: encrypted field value is not always displayed as "****" | |
DataStage dataset view data returns all records instead of user defined set. | |
Allow the ability to shut off "Saving Job Designs" for the administrative user. | |
A Job instance id may be omitted from the DataStage job log view (ctrl-L) when operational metadata is being generated | |
Request to shorten DSAttachJob minimum timeout when unable to obtain lock | |
Parallel jobs with Basic transformer fail intermittently with dspipe_init() errors. | |
Problem with DSX Export where not all jobs exported and no errors reported | |
DSAdmin command with -envset option takes a significant amount of time to complete | |
Custom job control code supports implicit inheritance of ParameterSet values, this doesn't work when controlled job has an invocation id. | |
Import of pre-7.5 jobs onto 8.x system through DSXImportService looses lookup stage derivations | |
Increase SyncProject timeout to handle very large projects | |
Notification of job status change after compile is being lost, resulting in Director status view showing incorrect status | |
Stage variable links in Designer do not render correctly when a stage variable at top of table references a column further down | |
The osh part of parallel jobs require different PATH/LIBPATH settings from before/after subroutines and job control code. | |
dsjob returns status 97 when WLM server returns the wrong information. | |
Suppress and demote MetaData mismatch warnings of column.type, column.scale, column.precision | |
Clear Job Status causing error "Cannot find any process number for stages in job . . ." | |
Hash file stage cannot backup a file if the directory path value contains a trailing "/". | |
Simultaneous compilation of parallel jobs, which use overlapping sets of parallel routines, may deadlock | |
The istool 'odbadmin -purgedb -upto nn days' does not work if nn is greater than 25 | |
Stage icons are replaced with the icon of unknown-plugpin in a local container after closed in Designer | |
DataStage: Error "The current user does not have the required DataStage roles set up" | |
After upgrade to 9.1, object search button not working. | |
Change the order in which Ops Console lists the file systems | |
8.5 and later login dialog is not resizable | |
RT_STATUS for multi-instance jobs not getting cleared when auto-purge clears job logs | |
dsjob linkinfo option has rowcount defined as intger limiting its range | |
Server routine is not working when it was called via sequencer | |
DSGetLinkInfo(DSJ.INSTROWCOUNT) returns 0 row count when called from parallel job AfterJob subroutine | |
Problem saving jobs with new installation of DataStage 9.1 clients running on non-English locales | |
Data can be being corrupted when moved between different data types without issuing a warning justification | |
Job Sequence fails at 9.1 that worked in previous versions. |
DataStage Engine | |
Fix ID | Description |
Porting of Unidata-stage to Linux-64-bit | |
DataStage Jobs are running with NT Authority/SYSTEM credentials, when run via "dsjob" command without supplying credentials, on Windows Server 2008. | |
DataStage job log may have garbled environment variable values | |
ICONV("ÅSA","S") is returning ?00 |
DataStage MainFrame | |
Fix ID | Description |
Mainframe job fails when compiling in mainframe after being generated with 8.7. |
DataStage Parallel Engine | |
Fix ID | Description |
IS 8.7 PX job fails with error code 139 (core dump) when OSH_PRINT_SCHEMAS is enabled. | |
The parallel engine copy-orchdist does not copy the files used by XML (Java) Stage | |
ASCL Charset maps disappear in the list of NLS parallel maps after a custom map is registered on Windows. | |
Parallel Engine sometimes fails to propagate partitioning keys properly from a key-based operator to downstream operators | |
Parallel framework is incorrectly clearing the preserve partitioning flag when an operator reads from a persistent dataset | |
Multiple-output parallel transformer looping jobs incorrectly send cached input records to output link with constraints | |
Jobmon does not work on French Locale installations. | |
Parallel jobs which use End of Wave and which contain the pivot operator fail when APT_DISABLE_COMBINATION is FALSE | |
The parallel pivot stage gives a warning "STRING '00:00:00'FOR TIMESTAMPS DOES NOT MATCH THE ACTUAL FORMAT" when the timestamp has a microseconds. | |
Parallel Engine Slowly Changing Dimension (SCD) stage can create incorrect duplicate records when OLD_BOUNDED_LENGTH is enabled. | |
Rapidly repeating the same parallel job can cause job failures with the message "FAILURE DURING SCORE LOAD WITH APT_ARCHIVE::BADPOINTER" when loading temporary files. | |
Parallel transformer stage does incorrect evaluation of derivations which contain complex usage of functions inside IF conditions. | |
Parallel transformers with many stage variables and complex derivations may compile with incorrect NULL checking code. | |
Buffer operator failed to write all data and didn't abort the job. |
FastTrack | |
Fix ID | Description |
'DiscoverMore' and 'Statistics' features fail with NullPointerException when BG term used in the Mapping Specification is deleted | |
Improper parsing of CSV while export and import MappingSpecifications with columns having comma(,) in FastTrack | |
Server name is not persistent on update for Oracle Connector in FastTrack Source Configuration | |
Database Connections created from DataStage are visible in FastTrack but not usable | |
FastTrack incorrectly exports MappingSpecification to CSV when all columns are not selected for export |
Information Analyzer | |
Fix ID | Description |
Column Profile report fails on selecting large number of columns | |
Column Analysis performance is impacted when Virtual Column has "," or "." or "-" or "/" or ":" or "" as field separator. | |
Using CLI to output a Rule set execution history, generates a csv file that does not contain any results | |
Null pointer exception with edit column details During Identify Flat Files | |
Information Analyzer does not allow more then 30 characters in the output column names of Data Rules and Rule Set | |
Supporting database alias for DB2 IADB | |
Expected Foreign Key pair in Cross Domain Analysis not found | |
Rule Set is incorrectly validated when output definition parameter is blank or null. | |
Using IAAdmin to move projects does not bring over the long and short descriptions for folders, sub-folders, and rule artifacts | |
Metrics Exported into a XML File Using IAADMIN does not include non-default folder information | |
Database connection leakage against Netezza source database while running Column Analysis | |
Repeated Use Of IAAdmin.sh with getOutputTable option generates empty result in the output | |
Remove schema reconciliation warning messages during IA data rule execution | |
Importing datarule spread over different folders and subfolder from Information Analyzer console fails with exception | |
Date data type column showing wrong value in IAAdmin getOutputTable command output | |
IAAdmin.sh with getOutputTable option results in out of memory. | |
Metric job fails when expression has an exponential value | |
IAAdmin -create/-update command throws Null Pointer Exception . |
Install | |
Fix ID | Description |
Modify cluster.jacl within suite installer to start WebSphere Application Server cluster with ripple start instead of plain start |
Information Services Director | |
Fix ID | Description |
In the ISD View Services Catalog page, the top right hand corner links to Home | Information Services Catalog are incorrect | |
Enable and disable operations do not work properly after restart of ASB Agent |
Information Server Framework | |
Fix ID | Description |
ASB Agent Startup exhausts sessions if the Agent port is already in use. | |
Remove the need for WebSphere monitor role grant to 'ALL AUTHENTICATED' and 'EVERYONE' groups | |
Change to allow CORBA ALL AUTHENTICATED to be read only after install completes. | |
When configured for PAM and multiple users have the same UID in PASSWD file, only one of these users is shown in Web Console | |
Enable and disable operations do not work properly after restart of ASB Agent | |
Cross-site scripting vulnerabilities in Information Server Web Console | |
Large IA reports contain corrupt output when format type is XLS | |
JR48433** | IS Installation, UUI and AppServerAdmin -db fail on 9.1.2.0 for certain versions of WebSphere. |
Information Server Tools | |
Fix ID | Description |
When two or more DataStage servers using different port number are connected to Information Server, the Information Server Manager selects the wrong port number and causes failure in import, export and deployment. | |
Information Server Manager has problems accessing the repository when two DataStage engines are running on the same server. |
Metadata Asset Manager and Metadata Integration | |
Fix ID | Description |
Error when importing Data Models after installing 91Fp1 | |
Correct the TypeCode for numeric and number data type. | |
ODBC Metabroker Oracle Privileges | |
Import from BOBJ generates incorrect report name for Desktop-Intelligence reports using Repository based bridge. | |
Error importing Leap Data | |
Cognos Import Issues in 8.4 | |
IMAM ODBC MB fails to import DB2 DSN | |
Error Previewing large data thru IMAM when SQL Server is XMETA DB | |
IEM: ODBC import fails with 'unknown error', when importing metadata from DB2 on zOS while processing foreign keys. | |
OBI Server Bridge creates Alias instances without mandatory relationship to MainObject | |
Import of an LDM file into XMETA repository using IMAM / MBB fails due to invalid attributes. |
Metadata Workbench | |
Fix ID | Description |
Metadata Workbench stitching message from CLI is incorrect | |
Support for data Lineage to be shown for "Before/After SQL Statements in DataStage Jobs. (9.1) | |
DBCS query string is broken when a custom query is saved with "publish query" option. | |
Relationship between Report or Report Field and Database Table or Column not displayed | |
CSV export output fields formatted incorrectly | |
Error parsing SQL statements from DS Job and DB View | |
PROCESSENVVARIABLES.SH fails when the env variables value is greater than 255 characters | |
Database tables written in user defined SQL. table name property value in DataStage are not showing up in the data lineage of the job | |
Loading of a report of the same name as existing repot to a new BI Server and Folder moves the report to new location | |
Tem History results are not sorted correctly | |
Enhancement to support lineage for DataStage jobs with write mode - UPDATE | |
istool workbench query command is failing while running the query | |
ProcessEnvVariables.sh throws an error when run on Unix | |
Column level Lineage also returns results from Table | |
Lineage Report Error, out of memory | |
DBCS characters are corrupted in PDF files generated by "Save text" in Metadata Workbench. | |
Cannot include DB Views within Extension Mapping Documents |
Metadata Common Services | |
Fix ID | Description |
Duplicate ClassDescriptors are created when using IS 9.1 on Oracle |
QualityStage | |
Fix ID | Description |
Standardize NYSIIS not handling single 'S' and 'Z' properly | |
Error 52 (bad file name or number) when opening the Match Designer |
XML Pack | |
Fix ID | Description |
Assembly Editor Display issue on the polish machine that is configured to be in English. | |
JOB ABORTS WITH "DUPLICATE NODE" ERROR | |
The value of @@choiceDiscriminator is wrong in Parser output |
Migration, Backup, and Restore Tool | |
Fix ID | Description |
SRD tasks get executed when no Quality Stage is installed | |
backup_database.bat fails on Windows systems that cannot handle paths with mixed separators, i.e. C:\foo/bar\test/ |
Serviceability & ISALite | |
Fix ID | Description |
ISALite General Health Checker fails on Solaris 8.7 | |
ISALite General Health Checker returns erroneous configuration errors for Tests CDIHC1025i or CDIHC1013i in some situations from WebSphere Application Server 6.1 or above. |
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21640382