Fix Readme
Abstract
Summary of fixes included in IBM InfoSphere Information Server, Version 8.1 Fix Pack 2 with fixes grouped by components.
Content
IBM development has compiled this list of fixed APARS which are included in Fix Pack 2 for Information Server, Version 8.1. Check your Version.xml file to ensure that all of your installed patches are on this list prior to installing Fix Pack 2. If you have a patch that does not appear on this list, please do not install Fix Pack 2. 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.
Roll-up Patches included in InfoSphere Information Server, Version 8.1 Fix Pack 2
For convenience, we have collected tables of the roll-up patches which are included in Fix Pack 2. 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. The individual APARs will still appear in the tables below.
Information Server Roll-up Patches | |
Patch Name | Description |
| rollup_ISF_ISD_ru1_{platform}_8101 | Information Services Director / ISF rollup patch |
| rollup_CC_ru1_{platform}_8101 | Connector rollup patch |
| rollup_DataStage_ru1_{platform}_8101 | DataStage rollup patch |
Information Server fix packs are cumulative, and thus all fixes from Fix Pack 1 are also included in Fix pack 2. The issues first corrected in Fix Pack 1 can be viewed via the following link:
InfoSphere Information Server, Version 8.1 Fix Pack 1, fix list
Fixed APARS included in InfoSphere Information Server, Version 8.1 Fix Pack 2
DataStage Fixes | |
Fix ID | Description |
| Jobs abort with -14 errors | |
| The "Save as" for Complex Flat File stage does not bring up "Save Table Definition As" screen. Also the table definition does not show up until a new session of Designer is open. | |
| When user-defining very long SQL statements (about 40 rows long and up) in OCI stages, the job terminates abnormally. | |
| DSD.RUN PROCESSES NOT GOING AWAY | |
| SAP R3 6501 - iDoc Load PX jobs aborting | |
| THE \ CHARACTER IS NOT RECOGNIZED WHEN PARAM PASSED USING SHARED CONTAINER | |
| When resetting a job by DSjob command, it takes about 1 minute longer | |
| Using istool from command line with -replace causes error. | |
| CANNOT CHANGE ORACLE ENTERPRISE STAGE AFTER DATA CONNECTION APPLIED WITHOUT LOSING CONNECTION INFO | |
| Performance Analysis uses wrong registry key | |
| Imported stage type records not imported to UV repository | |
| JOB SEQUENCE CAN FAIL INTERMITTENTLY WHEN RUNNING A JOB USED "RESET IF REQUIRED, THEN RUN" OPTION | |
| WHEN MANY INSTANCES OF A JOB ARE RUN CAUSING THE SYSTEM TO BE UNDER HEAVY LOAD AND AUTO-PURGE IS ENABLED, RESULTING 99 ERRO | |
| USERNAME LOST DURING RUNTIME WHEN USING INFORMIX EE STAGE | |
| RE-IMPORTING WITH ISTOOL -REPLACE FAILS AFTER A JOB RUNNING ONCE | |
| Support for mainframe file access pack | |
| DSJOB -RUN -JOBSTATUS" RETURNED "21" | |
| CANNOT GENERATE REPORT FOR ODBC CONNECTOR STAGE JOB | |
| LACK OF "PERFORMANCE STATISTICS" RESULTS. | |
| CHANGE THE SDKSEQUENCES FILE CREATION TO TYPE 30 FILES | |
| INVALID CREDENTIAL ERROR IMPORTING MODEL | |
| lookup compilation does not generate osh correctly | |
| UNABLE TO DELETE IMPORTED JOB IN NEWLY CREATED PROJECT | |
| SYBASE OC STAGE GAVE ERROR FOR UNSIGNED INTEGER | |
| MCM fails to function | |
| A WRONG 'CREATE TABLE" SQL STATEMENT IS GENERATED | |
| CANNOT CREATE NEW PROJECTS WITH NON-DEFAULT SHORT DATE FORMAT | |
JR34844 | CUSTOMER NEEDS SEPARATE ADMINS FOR DIFFERENT PROJECTS |
| DSXIMPORTSERVICE.SH SCRIPT INSERTING UNIX TERMINATORS | |
| EXCEPTION OCCURS ON DESIGNER WITH A PARTICULAR OPERATION. | |
| REPEATEDLY OPENING AND CLOSING STAGE EDITORS WILL EVENTUALLY CAUSE THE DESIGNER TO CRASH IN VARIOUS DIFFERENT WAYS. | |
| FREEZE WHEN CLICKING "VIEW DATA" ON ORACLE CONNECTOR STAGE | |
| IT TAKES LONG TIME TO OPEN A FOLDER OF TABLE DEFINITIONS INSQLBUILDER. | |
| DATASTAGE DESIGNER CRASHES WHILE COMPILING A LARGE SEQUENCE JOB. | |
| IN DATASTAGE DESIGNER, THE SHARED TABLE WIZARD SOMETIMES FAILSTO PICK THE HIGHEST RATED TABLE MATCH | |
| MULTIPLE-JOB COMPILE ACTION BRINGS UP "ERROR ACCESSING FILE CONTAINING COMMANDLINE" AND/OR PROJECT LOGON DIALOG. | |
| dsjob XML report is truncated | |
| MULTIPLE JOB COMPILE CREATES LARGE CORE DUMP | |
| COMPILE ERRORS WHEN LARGE NUMBER OF PARAMETER SETS USED | |
| MASTER SEQUENCE WHEN A SCHEDULED RUN IS STARTED AND THE PREVIOUS RUN IS STILL BUSY. | |
| UNSUPPORTED OPERATION WAS REACHED VIEWING PROPERTIES OF TDMLOAD | |
| DESIGNER CRASHES WHEN QUERY IS TOO LARGE IN FIELD PRE/POSTINSERT QUERY IN SYBASE IQ LOAD STAGE. | |
| JOB COMPARE CRASHES DESIGNER | |
| INFORMATION SERVER: ISSUE CHANGING SCHEDULED JOB WHEN JOB IS SCHEDULED MULTIPLE TIMES. | |
| ISSUES SCHEDULING WITH TYPE "NEXT" WITH DAY LESS OR EQUAL TO CURRENT DAY. THIS MAKE DS TRIGGER THE JOB IMMEDIATELY. | |
| SCD ERROR - 'PRECOMPILATION FAILED' WHEN NUMBER OF THE COLUMN EXCEED 117 COLUMNS. | |
| CFF STAGE HANGS ON COMPILE IF THERE IS AN EMPTY GROUP COLUMN IN THE SCHEMA. | |
| ISTOOLS FAILS IF PACKAGES CONSISTS OF MAINFRAME JOBS.. | |
| IT'S NOT POSSIBLE TO DEFINE AN EBCDIC DECIMAL UNSIGNED WITH THE COLUMN META DATA EDITOR | |
| DSSEARCH COMMAND IS NOT NAVIGATING SUB-CATEGORIES CORRECTLY | |
| PROBLEM WITH SERVER JOB SEQUENTIAL FILE STAGE PROCESSING WITH LARGE COLUMN SIZE | |
| SOMETIMES THE DATASTAGE JOBS MULTIPLE INSTANCES ARE NOT INSTANCIATED. | |
| NONNUMERIC DATA WHEN NUMERIC REQUIRED. ZERO USED. | |
| USING DSJOB TO RESET A FAILED JOB GIVES ERROR -14, BUT THE JOB IS RESET SUCCESSFULLY | |
| DSXImportService did not import Server job exe correctly | |
| UNABLE TO PULL IN COLUMNS LIST USING SQL BUILDER WITHIN ORACLEOCI 9 | |
| PROBLEM USING THE DATASTAGE IS 8.1 CLIENTS USING REGIONAL SETTING TO HEBREW | |
| CUSTOMER CAN NOT COMPILE A PARTICULAR JOB WITH "COM.IBM.RMI.RAS.UTILITY (INITIALIZATION FAILURE)" MESSAGE | |
| Job sequences call DSMakeJobReport after every job run, even if they never use the returned report string | |
| UNABLE TO LOAD "PROXYSERVERPASSWORD" PROPERTY FROM DATACONNECTIONS IN SALESFORCE CONNECTOR STAGE | |
| Deleting columns in CFF stage, saving, and then reopening the job, columns come back. | |
| Unable to view data in PX without write permission for project | |
| INFORMATION SERVER 8.0.1 - UNABLE TO USE THE DSADMIN COMMAND TO CREATE A PROJECT WITH USERID OTHER THAN DSADM. | |
| UNABLE TO READ BYTE ORDER MARK - ERROR 0 | |
| USER WITH OPERATOR ROLE MODIFIES VARS OF OTHER PROJECTS | |
| DIFF SERVER AND CLIENT TIMES ZONES GIVES COMPILE MESSAGE | |
| IMPORT NOT HANDLING JAPAN CHARACTERS PROPERLY. | |
| Added 1 column to Oracle EE job but it is not reported on generated report | |
| ONCE MODIFY FILTER WITHIN SEQUENTIAL STAGE, THE REJECTED COLUMN AND LINK ARE MISSING. | |
| JobMon stats showing double the values it should | |
| BASIC ROUTINE CALLED IN PX JOB THAT RUNS ANOTHER PX JOB ABORTS. | |
| Mainframe jobs not compiling correctly | |
| HEBREW LOCALE CAUSES GUI ERRORS IN IS 8.1 | |
| ODBC WARNING DSD.BCIPUT CALL TO SQLEXECUTE FAILED. | |
| The command dsjob -logdetail -wave 0 sometimes returns entire job log | |
| ENV VARIABLES ARE BEING GENERATED DIFFERENTLY IN OSH BETWEEN 7.5 | |
| Memory leak in Resource Tracker. | |
| Include environment variable parameters' checkbox to the resolve parameters dialog | |
| Parallel WISD job leaves behind some IPC files depending how it is stopped | |
| SCD stage modification errors occur | |
| 8.1 DSCC HANGS WHEN SHARED CONTAINER IS MISSING FROM JOB. | |
| Job compare function seems to compare different annotations | |
JR36622 | Customer would like to restrict access to engine commands from DS Administrator |
| Unable to generate report or use compare tool for parallel jobs containing an Oracle Connector stage. | |
| Error "Unknown error reading record schema" when using Dataset tool with a user who does not have correct permission | |
JR36749 | The login passwords of DataStage Director clients may be exposed in certain circumstances |
| dsjob calls seems to be slightly longer in a DataStage NLS environment | |
| A value of "Abort After Rows" in a parallel transformer stage is ignored and a job continues to work when it is > 32767 | |
| Description of DB2 CC stage is NOT shown in a report generated by the Designer | |
| Parallel job hangs in ACG grid environment | |
| User can not see all of BuildOp screen if they are not allowed write permission; no scroll bar | |
| Pipes in file directory names causes Designer to freeze intermittently | |
| Add environment variable DS_USE_SERVER_AUTH_ONLY for dsjob command | |
| Transformer compilation error not showing the correct error message | |
| Mismatch of the repository/folder view between Designer and Director occurs with a particular operation | |
| RTI job returns empty rows and no error if ODBC connection is lost before job finishes | |
| Incorrect output by dsjob -report DETAIL | |
| A sequence job does not correctly report its userstatus on a restart | |
| Problem with Sequential file stage after install of the Oracle OCI patch JR36720 | |
| UNABLE TO IMPORT SERVER JOBS THROUGH COMMAND LINE DSXIMPORTSERVICE.SH | |
| PROBLEM WITH SLOWLY CHANGING DIMENSION STAGE (SCD) OF PARALLEL JOBS IN DATASTAGE 8.1 | |
| Missing dependent items when building the package from IS Manager. Please open an APAR if a fix is needed. | |
| Build history disappears on renamed packages | |
| File RT_BP310 has not been deleted from directory | |
| SOCKET IN CLOSE_WAIT STATUS ASSOCIATED TO WISD JOB DEPLOYED | |
| DIRECTOR HANGING AND JOBS APPEARING AS RUNNING EVEN IF THEY HAVE TERMINATED. | |
| DATASTAGE JOBS ABORT WITH: "CANNOT OPEN FILE "&PH&" WHEN INFORMATION SERVER IS INSTALLED ON OCSF2 FILE SYSTEM. | |
| DATASTAGE 64BIT HASHED FILES OTHER THAN TYPE 30 CANNOT GROW LARGER THAN 2 GB. | |
| JOB HANG, WAITING FOR SORT FILE LIKE "/TMP/SORT41174AA". | |
| INTERMITTENT JOB CRASHES WHERE A /TMP/SELECT* FILE GROWS TOO LARGE | |
| RUNNING DSJOB AGAINST REMOTE SERVER IN CLUSTER ENVIRONMENT RESULTS IN FAILURE AND "STATUS CODE = 81016" | |
| PATCH NEEDED TO SUPPRESS WARNING MESSAGE FROM DB2: SQL0513W THESQL STATEMENT WILL MODIFY AN ENTIRE TABLE OR VIEW | |
| FMTDP() MAY CAUSE ABNORMAL TERMINATION. | |
| RUNNING BATCH JOB THAT DOES A CLOSE WITH NO FILE VARIABLE CAUSES THE T30 SEMAPHORE TO LOCK. IMPORTING DSX FILES DO THE SAME TH | |
| A job aborted on a hash file stage for reference | |
| While overwritten-importing a job or while deleting a job, the following error happens: Error while deleting job AAAAA | |
| Remove warning messages from DB2ZLoad | |
| FP1 EXPORT CANNOT BE IMPORTED ISSUE | |
| UNABLE TO RECOMPILE DATASTAGE JOB AFTER CHANGING METADAT, ERRORSWITH "MAPPING FAILED TO COPY ATTRIBUTES: JOBDEFN -> DSJOBDEFN | |
JR32407 | INFORMATION SERVER 8.1; PARALLEL JOB STARTUP FAILS CALLING SETRLIMIT WITH VERY LARGE VALUE. |
| SERVER JOB WITH INTERPROCESS ROW BUFFERING ENABLED WILL CORE IF RESET IMMEDIATELY AFTER ABORT. | |
| "VIEW DATA" REQUIRES ALL PARAMETERS THAT ARE DEFINED IN THE JOB TO BE ENTERED. | |
JR34519 | PATCH REQUEST FOR ECASE86905/119581 ON WINDOWS DS753 |
| ADD "MAPPING" TAB TO THE WAVE GENERATOR STAGE | |
JR35365 | MULTI INSTANCE JOB : SESSION ID DOESN'T WORK ANYMORE AFTER SWITCHING TO A DIFFERENT PROJECT IN DIRECTOR. |
Connectivity Fixes | |
Fix ID | Description |
| Sybase job not aborting where it should | |
| DB2EE is padding varchar datatype | |
| DB2 ENTERPRISE EDITION STAGE USES COSTLY QUERIES THAT MAY LEAD TO LOCKING ISSUES | |
| OCI PLUGIN PROBLEM READING MORE THAN 1 CLOB IN A TABLE. IT EFFECTS VIEW DATA AND OUTPUT. | |
| STP stage aborts with CLI_NO_DATA | |
| ENHANCE THE FTP EE STAGE TO SUPPORT TECTIA SFTP | |
| DB2 ERROR MESSAGES ARE SUPPRESSED UNEXPECTEDLY | |
| DB2 ENTERPRISE STAGE ISSUE WHEN USING STAGE PROPERTIES USE DEFAULT SERVER = TRUE RESULTS IN JOB FAILURE | |
| DS STAGETYPES NOT POPULATED TO UV REPOSITORY WHEN IMPORTING DSX PROJECTS. | |
| Connector stage aborts intermittently | |
| FOR NETEZZA, ALLOW THE UPSERT METHOD TO DELETE DATA IN THE TARGET TABLE, LIKE SIMILAR STAGE IS DOING, I.E. DB2, ODBC | |
| MQ DOESN'T RECEIVE CORRECTLY THE HEADER MESSAGE | |
| CLI0111E NUMERIC VALUE OUT OF RANGE | |
| ABNORMAL TERMINATION OF DS SERVER JOB WITH ORAOCI9 STAGE READING WHEN READING CLOB | |
| USING DB2 API STAGE - RECEIVE WARNING MESSAGE IN JOB. | |
| ORA-01406 ERROR IN READING LITERAL | |
| DB2 CONNECTOR USING BULK LOAD FAILING | |
| DRS job abort on 64 bit system | |
| LOW DATA VALUES MODIFIED IN XML STAGE | |
| DB2 CONNECTOR STAGE FAULTY ERROR REPORTING | |
| DB2 CONNECTOR STAGE HAS PROBLEM WITH PARSEING UNDERSCORE. IT TREATS "_" AS A DELIMITER. | |
| NEED TO SUPPORT FOR -B FOR BATCH SIZE IN BCP FOR SYABSE ENTERPRISE STAGE. | |
| UNWANTED WARNING MESSAGE WHEN CLEARING TABLE IN DB2. | |
| Teradata load aborts if number of rows in table exceeds 2.1 billion | |
| DB2 LOAD OPERATOR CAUSE SQL6107N ON SOME PART KEY NAMES | |
| Teradata has a limit on how many CLI FLOAD/MLOAD/FEXPORT jobs can run in parallel | |
| ENHANCEMENT REQUEST TO HAVE DATASTAGE WORK WITH EXGRID.DLL .00. | |
| STP STAGE DOES NOT ABORT NOT EXECUTE THE STORED PROCEDURE WHEN NO LINKS ATTACHED ON PARALLEL CANVAS | |
| Performance degradation | |
| MERGE STAGE ON SERVER CANVAS HAS UNPREDICTABLE BEHAVIOR | |
| DataStore value is not populated in the Locator section when importing table definitions with ORAOCI9 Plug-in | |
| JAPANESE CHARACTERS IN GRAPHIC DATA TYPE ARE GARBLE WHEN GETTING THEM FROM DB2 EE STAGE | |
| CANNOT IMPORT IQ 12.7 TABLE DEFINITION USING SYBASE OC PLUGIN | |
| IMPORTING TABLE DEFINITION WITH ORCHESTRATE SCHEMA DEFINITION RETURNS LOCATOR INFORMATION BEING FILLED IN WITH UNKNOWN. | |
| WARNING MESSAGE GENERATED BY LOOKUP STAGE: CONVERTING A NULLABLE SOURCE TO A NON-NULLABLE RESULT. | |
| COPYRIGHT CHARACTER [0XA9] IS CAUSING ISSUE WHEN USING UTF8 IN ORAOCI PLUGIN | |
| WHEN DOUBLE-CLICKING DB2 CONNECTOR STAGE AFTER PUTTING IT ON DS, EXCEPTION OCCURS. | |
| UPDATE PERFORMANCE OF ODBC CC IS SLOW | |
| ODBC CONNECTOR LOGS SOME OF THE FATAL ERRORS AS WARNINGS AND DO NOT ABORT THE JOB | |
| Character data is corrupted when doing bulk load with Oracle Connector | |
| OUT OF INDEX ERROR WITH MIGRATION TOOL | |
| VIEW DATA IN ORAOCI9 STAGE DISPLAYS A 5-DIGIT NUMERIC FOR DATE | |
| Special characters # and $ not preserved in imported Oracle table definition | |
| TMHOUT AN ERROR.P/UDBPIPEXXXXX FILE IS NOT DELETED | |
| UNABLE TO INSERT A RECORD INTO THE TABLE DUE TO ORA-01722: NOMBRE NON VALIDE | |
| DRS JOB RUN WARNING DSD_GENERATEEVENTS.B:LINKREPORT NOT | |
| MESSAGES FROM SYBASE ARE GARBLED | |
| ALLOW TERADATA EE STAGE TO OPTIMIZE THE SESSION-USAGE. | |
| Row not rejected for foreign key constraint violation in bulk load mode | |
| RUNTIME SCHEMA OVERRIDES DESIGN TIME SCHEMA, EVEN WITH RCP OFF | |
| PROBLEM WITH DB2 BULK LOAD COMMON CONNECTOR IS 8.1 ROLLUP 2 | |
| PARALLEL JOB ABORTS WITH: DBNAME: UNSUPPORTED DATA TYPE[SYBUTILS.C:2239] | |
| DS LINUX 752 EE JOB UTILISING TPUMP SIGSEGVS. | |
| TERAWRITE DOES NOT ABORT FOR FATAL MESSAGE | |
| TERADATA CONNECTOR ISSUES | |
| INFORMATION SERVER 8.1: ORACLE OCI BULK LOADER IS FAILING USING MANUAL LOAD WHEN LOADING OVER 2 GB DATA | |
| Bad format string for the default timestamp value in oralookup causing fatal error. | |
| Oracle connector slower than Oracle operator for CHAR columns on AIX | |
| CUSTOMER IS GETTING ERROR WHEN CALLING STORED PROCEDURE FROM PRE-INSERT COMMAND IN SYBASE IQ BULKLOAD STAGE. | |
| MQ SERIES CLIENT INSTALL GETS LINKED TO SERVER MODULES. | |
| SYBASEEE CAN'T USE MULTI CHARACTERS AS FIELD DELIMITER | |
| PERFORMANCE ISSUE WHEN USING ORACLE EE OPERATOR AS SPARSE LOOKUP | |
| ENHANCE SERVICEABILITY BY ADDING PATCH INFORMATION TO DIRECTOR LOG FILE. PRINT LOG MESSAGE WITH APAR NUMBER OF THE PATCH. | |
| ENHANCE SERVICEABILITY BY ADDING ORACLE NLS SETTINGS TO DIRECTOR LOG FILE. PRINT LOG MESSAGE WITH ORACLE NLS SETTINGS. | |
| ENHANCE SERVICEABILITY BY ADDING CUSTOMER'S ORACLE VERSIONS TO DIRECTOR LOG FILE. PRINT LOG MESSAGE WITH ORACLE VERSIONS. | |
| COMMON CONNECTOR FRAMEWORK ADD SERIALIZE MODIFIED PROPERTY FOR HIDDEN JOB ID | |
| Provide a more detailed/unique error message id when job crashes. | |
| HEAP ALLOCATION FAILURE IN THE Connectivity IBM STAGE WHEN THE ROWBUFFER COUNT MESSAGE OPTION IS USED. | |
| Connectivity Informix STAGE FAILS WITH "OPERATOR TERMINATED ABNORMALLY:RECEIVED SIGNAL SIGABRT" AFTER APPLYING FIX PACK. | |
| ORACLE OPERATOR V81 AIX LINKED WITH 9I | |
| INCORRECT NUMBER OF MESSAGES RETRIEVED FROM MQ QUEUE USINGMULTI-CONFIG FILE VIA Connectivity IBM IS 8.1 | |
| Provide means to switch off row status processing for ODBC upsert with insert only and reject link | |
| ODBC EE WRITE WITH CREATE OR REPLACE MODE ABORTS THE JOB CONNECTING TO dBASE/FoxPro/Clipper FOR A CHAR FIELD | |
| Job abort randomly after the message for rejected row is logged | |
| STP DO NOT GET LOCATOR INFORMATION WHEN DS_NO_PROCESS_METADATAIS SET | |
| CONNECTOR MIGRATION TOOL UDBLOAD -> DB2CONNECTOR STAGE. PARAMETER PARTDBCONFIG=NO IS NOT MIGRATED CORRECTLY. | |
| CONNECTOR MIGRATION TOOL MIGRATING DB2 API STAGE WITH A DATA CONNECTION THAT HAS AN ATTACHED PARAMETER SET CAUSES ERROR. | |
| Job status includes warnings on job sequence log events even though job finished OK. | |
| CONNECTOR MIGRATION TOOL MIGRATING A DB2 API STAGE WITH "DO NOT CREATE TARGET TABLE" PRODUCES DB2 CONNECTOR WITH "CREATE" ACT | |
| OP. TO DELETE RECORDS IN NETEZZA TABLE WITH ODBC CC IS VERY SLOW WITH IS81+FP1. | |
JR35652 | ORACLE EE REJECT ENHANCEMENT WHICH ALLOWS USER-DEFINED REJECT CODES. |
| INFORMATION SERVER 8.1 - UNABLE TO IMPORT METADATA (DB2 PLUGIN)FROM MULTIPLE DB2 DATABASES | |
| IS DB2 CONNECTOR MIGRATION TOOL FAILS TO RECOGNIZE DATASTAGE ON REMOTE MACHINE | |
| STP-ORACLE PLUGIN ABORTS :"ORA-01480: TRAILING NULL MISSING FROM STR BIND" INSERTING EXACTLY 4000 CHARS INPUT DATA | |
| DB2 CONNECTOR'S LOADING FUNCTION , ENHANCEMENT REQUEST INCLUDING MESSAGE HANDLING | |
| A JOB DOES NOT ABORT EVEN IF DB2LOAD STAGE IN A JOB FAILS. | |
| STP STAGE FAILS FOR SOME STORED PROCEDURES IN WHICH SQLNUMRESULTRETURN 0 | |
| DB2 CONNECTOR STAGE, BULK LOAD OPTION BULK LOAD WITH LOB OR XML COLUMNS=FALSE. CHARACTER 0X00 LOADS AS 0X20. | |
| Oracle connector fails to bind parameters from PL/SQL anonymous block | |
| CORRELATION ID IS SET TO AN EMPTY STRING WHEN THE Connectivity IBMROW BUFFER COUNT IS SET AND MESSAGE OPTIONS ARE SET TO "Y" | |
| ERROR DELETING FILE IN 'DIRECTORY FOR DATA AND COMMAND FILES' | |
| INFORMATION SERVER 8.1 - UNABLE TO DO VIEW DATA FROM DB2CONNECTOR STAGE | |
| INFORMIXEE - JOB PARAM OF PASSWD CAN'T BEGIN WITH NUMBER | |
| PATCH PROD00132952 REQUEST FOR CCRP2 ENVIRONMENT | |
| DB2 COMMON CONNECTOR: MULTIBYTE CHARACTERS ARE CORRUPTED IN LOADING TO DB2 FOR Z/OS | |
| TERADATA ERROR "CODE 302:CLI2:BADBUFRQ(302):INVALID BUFFER SIZE" | |
| INFORMIX ENTERPRISE STAGE DOES NOT SHOW THE INFORMIX ERROR CODE AND MESSAGE IN JOB LOG. | |
| STP TERADATA SESSION DOES NOT CLOSE SOMETIMES WHEN THE JOB ABORTS | |
| TENACITY SETTING IS NOT WORKING WITH TDEE AT INFORMATION SERVER 8.1. | |
| View data not working for DRS stage with DB2 on zLinux. | |
| CANNOT GET "NUMBER OF ROW ..." INFORMATION IF USING DB2 CONNECTOR STAGE | |
| INFORMATION SERVER 8.1 DRS STAGE UTILIZING ODBC SQL SERVER DRIVER FAILS WITH "INVALID TIME FORMAT" ON SOLARIS | |
| CFF STAGE IN PARALLEL JOB CRASHES WHEN TAB KEY IS USED TO DEFINE A NEW COLUMN IN THE RECORDS TAB. | |
| IN CFF STAGE WHEN REMOVE LEVEL NUMBER THE EDITOR GOT RUNTIME ERROR AND SETTING NULLABLE ATTRIBUTE FAILED WHEN USING EDITOR | |
| ENHANCEMENT REQUEST TO SUPPORT SYBASE IQ V15 FOR SYBASE EE,SYBASE OC,BULK LOAD | |
| FLEXIBLE SETTING OF THE NUMBER OF EXECUTION NODES FOR DB2 CC | |
| DS_NO_DB2CLI_WARNINGS TO SUPPRESS ALL LOCAL WARNINGS | |
| ODBC ENTERPRISE JOB ABORTS WITH FAILURE IN OPERATOR LOGIC WHEN BIGINT COLUMN HAS UNSIGNED EXTENDED PROPERTY SET | |
| CODE ERROR CAUSING LOADER TO SKIP INDEX MAINTENANCE. | |
| CERTIFY InfoServer v81 ORACLE EE STAGE for ORACLE 11gR2 on HP-Itanium platform. | |
| WARNING MESSAGES FOR REFERENCE LOOKUP NOT SUPPRESSED IN DRS STAGE WITH DB2 | |
| CFF STAGE DOES NOT PRESERVE ROW ORDER IN A MULTI-NODE CONFIGURATION | |
| READING LARGE XMLTYPE VALUES FAILS WHEN RUNTIME COLUMN PROPAGATION IS USED | |
| OPTIMIZE THE NUMBER OF CONNECTIONS USED BY THE ODBC CONNECTOR | |
| PROBLEM WITH MESSAGE LOGGING CAUSING DESIGNER TO CRASH AFTER DOING A "VIEW DATA" IN DB2 API STAGE. | |
| JOB RANDOMLY FAILED WITH ERROR "THE CALL TO SQLLDR FAILED; THE RETURN CODE = 3" WHEN USING ORAEE -> LOAD | |
| WARNING MESSAGE FOR THE USER ID THAT DOES NOT HAVE PRIVILEGE. | |
| PROBLEM DATA TRUNCATION USING SQL SERVER 2005 | |
| PROBLEM WITH DB2 API SERVER JOB RUNNING ON IS 8.1 FP1 WITH WARNINGS AND NOT ABORTING | |
| THE ORACLE CONNECTOR STOPS THE JOB WHEN IT FETCHES TRUNCATED DATA FROM THE DATABASE | |
| Multiple issues with Connector Migration Tool. | |
| MQ ISSUES | |
| WAVE GENERATOR STAGE DOES NOT SUPPORT VARBINARY COL TYPES FOR 'SPLIT DUPLICATE KEYS' MODE | |
| MULTIPLE ISSUES WITH DTS STAGE | |
| DB2 CONNECTOR STAGE 8.1 FP1 IN UPSERT MODE WITH ARRAY SIZE > 1 NUMBER OF WARNING MESSAGES IS INCORRECT FOR REJECTED ROWS. | |
| RECORD WILL NOT ROLL BACK IF NOT FOUND ERROR 100 | |
| IF DSN CONTAINS TRAILING SPACES, USER WILL GET "DATASOURCE NAME NOT FOUND" MSG WHILE CONNECTING TO ODBC DSN FROM ODBC CONNECT | |
| INFORMATION SERVER 8.0.1 - NEED OPTION TO MAP NUMBER TO INTEGER | |
| DB2 EE STAGE GENERATES ERROR: THE STATEMENT NAMED IN THE EXECUTE STATEMENT IS NOT IN A PREPARED STATE | |
| NETEZZA EE STAGE ABORTS WHEN THE CREATE EXTERNAL TABLE COMMAND EXCEEDS 5000 CHARS IN IT | |
| STATIC LOOKUP DON'T WORK WHEN MORE THAN ONE TABLE IS BEING LOOKED UP | |
| DB2 LOAD USING NAMED PIPE METHOD APPEARS TO HANGING | |
| Added InfoCenter documentation for DB2 Connector and Distributed Transaction stages, and PDF document for Oracle Connector stage. | |
| DESCRIPTION IS GENERATED INTO THE SELECT CLAUSE INSTEAD OF THE COLUMN NAME | |
| THE DTS CONNECTOR KEEPS ORACLE CONNECTIONS OPEN ON THE CONDUCTOR NODE | |
| WHEN USING THE NETEZZA STAGE CLIENT DOESN'T WANT TO DEFINE IN THE ODBC.INI FILE | |
| NUMERIC LITERAL IN SELECT LIST CAUSES CORE DUMP | |
| MULTIPLE ORAWRITE STAGES IN JOB CORRUPT WORK FILES AND JOB FAILS | |
| CONNECTOR MIGRATION TOOL, CAUSING THE Connectivity IBM TO NOT HAVE A COLUMN DEFINED WITH A LENGTH. | |
| DRS PLUGIN RUNNING VIEW DATA CONNECTING TO SYBASE ON SOLARIS ABENDS WITH CORE DUMP. | |
| EXTEND SYBASEOC STAGE GUIS USER DEFINED SQL LIMIT TO 64 KB. | |
| LINK NUMBERS ARE MISSING IN THE DTS GUI LINK ORDERING PAGE. | |
| REQUEST TO ADD SUPPORT OF CS_LONGCHAR_TYPE IN THE SYBASEOC PLUGIN STAGE | |
| ERROR ORA-1461 INSERTING INTO A VARCHAR WHEN 10G CLIENT CONNECTS TO 9I SERVER | |
| AFTER INSTALL OF THE ORACLE OCI PATCH JR36720, JOB WITH SEQUENTIAL FILE ABORTS WITH AN ABNORMAL TERMINATION. | |
| CANNOT USE LARGE USER DEFINED SQL STATEMENT IN DB2 COMMON CONNECTOR. IT'S LIMITED TO 30,000 CHARACTERS IN DB2 CC GUI. | |
| Memory leak occurs for any job that reads from Oracle | |
| Memory leak when read mode is 'Move to work queue' | |
| ODBC Connector jobs fail with error "Invalid character value. Error in parameter 1" when the decimal field is used as a key column. | |
| WHEN RUN IDOC LOAD JOBS IN A MULTIPLE INSTANCE JOB, ALL THE JOBS ABORT WITH SIGSEGV SIGNAL TERMINATION. | |
| DATASTAGE SAP R3 PACK VERSION 6.5 BAPI ACTIVE EXTRACT JOB ON IS 8.1 RETURNS CORRUPTED DATA AFTER FP1 INSTALL | |
| MEMORY LEAK WITH UNICODE IN DSCAPI | |
| IS 8.1 FP1 IS MISSING THE HELP PAGE FOR THE DB2 CONNECTOR, DISTRIBUTED TRANSACTION STAGE, AND ALSO SAMPLE DTS JOBS. | |
| Oracle OCI plug-in (ORAOCI9) job aborts with "Insert rows must be the update action to clear the table" | |
| Failing Oracle OCI plug-in (ORAOCI9) server job migrated from DS 7.5.3 to IS 8.1 | |
| Oracle OCI plug-in (ORAOCI9) job: when SQL type is TIMESTAMP and scale=0, generated SQL is TO_DATE but run time is TO_TIMESTAMP | |
DataStage Parallel Engine Fixes | |
Fix ID | Description |
| Can not specify File Pattern in Sequential File Stages if search string includes white spaces | |
| Need PX job to process special characters from source text File and maintains special characters to target EBCDIC file | |
| Default Trim string function behaves differently with IS 8.1 NLS when compared to DS 7.5.2. | |
| IsValid("uint32,-799 ") gives the wrong results | |
| Using the "dont_quote_nulls" schema property with the DataStage Parallel Engine DB EE stage can result in degraded performance when processing string data values. | |
| Job compilation is slow, inconsistent but jobs that sometimes take 15secs to compile can take up to 30mins, | |
| PX Job doesn't abort despite fatal error raised by filter stage IS 8.0.1 | |
| IIS-DSEE-TFUU-00009 ENCODING CONVERSION ERR WHEN TRYING TO READ DATA FROM A TABLE WHICH NAME IS JAPANESE DOUBLE BYTE | |
| Need an extra property on Dataset stage for Missing Columns Action. | |
| UPDATED DOC FOR IBM INFOSPHERE INFORMATION SERVER V8.1 IS AVAILABLE (4Q2009) | |
| After installing patches JR30015 and JR33177 the function Trim is not working properly. | |
| Job mon app was crashing when a java NumberFormatException was thrown while trying to parse a floating point number which had a comma as a decimal | |
| CANNOT COMPILE A PARALLEL JOB WITH A TRANSFORMER WITH A REJECT LINK. | |
| PX0450 - PX Jobs fail due to performance issues | |
| Upcase function in parallel transformer convert Micro sign (hex B5) to hex 1A. | |
| The resource estimation tool causes the following error message for particular ds jobs : main_program: Fatal Error: Throwing exception: APT_BadAlloc: | |
| Salesforce encrypted passwords become corrupted when they are very long | |
| CFF STAGE REJECT MODE = FAIL DOES NOT WORK CORRECTLY. | |
| Score file deletion failure on Windows. | |
| information server 801, parallel jobs don't compile when Danish characters are contained in stage variables. | |
| When you exclude a value for comparison in the Change Capture stage it throws a warning in the log. | |
| PIVOT ENTERPRISE STAGE NOT IN ZLINUX BUILD | |
| UNABLE TO WRITE TO STATE FILE/DATASTAGE/DSP/WORK/SEQ_DW_MKT_VEHICLE_DIM.SKEY: INVALID ARGUM | |
| DS DIRECTOR FOR THE JOB MONITOR STOPS TRACKING WITH JOBS THAT HAVE MORE THAN 2,147,483,647 (MAGIC NUMBER FOR A 32 BIT INT) | |
| AFTER APPLYING FP1, SOME JOBS HAVE INTERMITTENTLY THE FOLLOWING FATAL ERRORS. | |
| ADD COMPILER WARNS TO ABS() FUNCTION | |
| EXTERNAL SOURCE STAGE FAILS IF THE COMMAND INCLUDES A COLON :" | |
| A PARTICULAR JOB ABORTS "RECEIVED SIGNAL SIGSEGV" WHEN THERE ARE MANY STRINGTODECIMAL() IN TRANSFORMER STAGE. | |
| JOB THROWS A WARNING WHEN UPCASE FUNCTION IS USED ON INPUT DATA THAT CONTAINS FF BYTES. THERE IS NO WARNING IN 7.5.2 | |
| UNABLE TO GENERATE A NODE MAP FROM FILESET OCCURS WHEN NO INPUT IS FOUND FOR SEQUENTIAL FILE STAGE | |
ASB Pack Fixes | |
Fix ID | Description |
| INFORMATION SERVER 8.1: THE XML PACK IN NON-NLS MODE SHOULD USE THE LOCAL CODE PAGE DEFINED IN THE LANG VARIABLE. | |
| XML STAGE CORRUPTS DATA AFTER APPLYING IS81 FP1 | |
| XML READER DOES NOT RESPECT THE LANG ENVIRONMENT VARIABLE IN NON NLS MODE | |
| EXISTING ASMX FILE IMPORTS FINE BEFORE FP1, BUT FAILS AFTER FP1. | |
Fast Track Fixes | |
Fix ID | Description |
| FAST TRACK JAVA.LANG.NULLPOINTER EXCEPTION GENERATING JOB. | |
| WHEN EXPORTING A MAPPING DEFINITION FROM THE FASTTRACK CLIENT TO CSV, THE ANNOTATIONS OF THE LOOKUP DEFS DO NOT GET EXPORTED. | |
| DELETION AND RE-IMPORTATION OF TABLE METADATA INVALIDATES FASTTRACK MAPPINGS | |
| FAST TRACK DOES NOT SEE THE PROJECT IF DATASTAGE PORT IS NOT DEFAULT VALUE | |
| GENERATING DATASTAGE JOBS FROM FASTTRACK FAILS WHEN NOT USING DEFAULT DATASTAGE PORT | |
| LOOKUP ANNOTATION NOT INCLUDED ON THE MAPPING SPECIFICATION REPORT | |
| TERADATA CONNECTOR USING FASTTRACK LEAVES SEVERAL ORPHAN SESSIONS ON TERADATA DATABASE. | |
| FASTTRACK ISSUE - ERROR WHEN MODIFYING PROJECT PROPERTIES. | |
Information Analyzer Fixes | |
Fix ID | Description |
| Missing DV index of FD table causes Column Analysis jobs with "Update Existing Table" as Yes, to take a long time. | |
| Policy text is limited to 255 characters | |
| Creation of Sequential Sample with size 0 does not throw up an error. UI screen is not refreshed after creating a sample in MCPK Analysis screen. | |
| In PK Analysis screen, Null & Duplicate percentages are rounded to 2 decimal places. | |
| Allow user to control how Null values are displayed in MCPK Analysis screen.. | |
| Very poor performance while opening the column analysis job run screen when lots of columns are selected.. | |
| DB2 Connection Handles not being freed for Drill down operations on non - UTF8 DB2 data source | |
| Rerun of MCPK Duplicate Check fails when field separator and null indicator are changed . | |
| Column Format violations report shows column names truncated to 10 characters. | |
| Improve the precision of percentage values and prevent false display of 0% and 100%. | |
| Fixed Filtering by Column name to work in the Column Analysis screen. | |
| In Column Frequency - Most Frequent Formats report, the Y scale in the chart has data truncated to 6 digits. Added support for 10 digits. | |
| User specified null indicator is truncated if the virtual column field definition is not wide enough. | |
| Order of columns in a Virtual column is lost in Multi-column Primary Key Analysis View. | |
| Fixed Drill down of Informix/Postgres/IDMS data source to not leak CAS connections. Over time, these leaks were causing an Out of Memory exception. | |
| CAS connection will not be leaked when "Agent not found" exception is encountered. | |
| In Report creation, when selecting the data source, the report parameters (Project name, Host name, Data store, Table name) should be listed in sorted order. | |
| Screen is not refreshed after Multi-column PK Duplicate Check or Sample creation, or Referential integrity complete. | |
| Multi-column Primary Key analysis produces duplicate/confusing results when the Field separator or Null indicator are changed. | |
JR37486 | Deleting one or more Data Sources at the Global level causes project name to be displayed in the Host list during Report creation. |
| In Open Column Analysis -> View Details -> Overview, the Description entered by the user is not displayed when the client is restarted. | |
| Null values are not included in Cross Domain Analysis violation counts. | |
| Information Analyzer GUI runs very slowly, some screens taking 5 minutes to update. | |
Information Services Director Fixes | |
Fix ID | Description |
| EXT REPORT FORMAT OPTION 'CSV' DOES NOT PRODUCE A CSV FORMATFILE | |
| DATASTAGE CLIENTS FAIL IF DNS LOOKUP COMES BACK WITH MULTIPLE HOST NAMES | |
| WISD APPLICATION SUBMITS QUERY TO ORACLE DB WITH SLOW RESPONSE: SAME QUERY OUTSIDE OF APP RUNS FAST. | |
| List of users report does not reports by role does not work when role type is Project | |
| Reports after migration in Target Box are not displayed under the respective project | |
| Number of lines in the log files not easy to read; format needs to be changed | |
| For LDAP external user registry IS 8.1.2 FIX PACK3, with user having ID length greather than 64 characters, column analysis fails. | |
| The logging agent uses significant CPU/network resources if the repository database is not accessible. | |
| OPENSOCKET RETURNED 39" LOGGED IN A WISD JOB LOG | |
| DEPLOYING SERVICE WITH TEXT OVER JMS BINDING FAILS WITH"INPUT DESTINATION COULD NOT BE LOCATED." | |
| "IGNORE ERRORS" FIELD IS NOT WORKING IN OUTPUT DESTINATION FOR TEXT OVER JMS. | |
| CANNOT DEPLOY AN ISD JOB WITH AN ENCRYPTED JOB PARAMETER | |
| THE INFORMATION SERVER ASB NODE AGENT CRASHES WITH AN OUT OF MEMORY ERROR. | |
| PROVIDER WITHOUT INPUTS AND OUTPUTS CAN NOT BE SELECTED. | |
| DISABLING A SERVICE PROVIDER VIA THE INFORMATION SERVER CONSOLE CAUSES THREAD HANGS IN WEBSPHERE | |
ISF Reporting | |
Fix ID | Description |
| ISF REPORTING PRODUCT / 3RD PARTY SW FIX TO BE PACKAGED FOR IIS | |
| ISF REPORTING FIX TO RETRIEVE REPORT RESULT EVEN IF IT DOES NOT EXIST ON FILE SYSTEM | |
Information Server Suite Installer Fixes | |
Fix ID | Description |
| REQUIREMENT FOR CONSOLE MODE TO NOT DISPLAY PASSWORDS WHEN USING THE UPDATER (PATCH INSTALLER). | |
Operational Metadata Fixes | |
Fix ID | Description |
| ADD ADDITIONAL RESULTS TO THE DATASTAGE JOB RUN REPORTS | |
| IMPORTER AND PURGE FOR OMD ARE TOO SLOW FOR INTENSIVE USE | |
QualityStage Fixes | |
Fix ID | Description |
| CORRECT INCONSISTENCIES BETWEEN MATCH RESULTS (WEIGHTS) AND POST MATCH WEIGHT COMPARISONS. | |
| UNDUP INDEPENDENT NEEDS TO BE MADE END OF WAVE FOR REALTIME APPS | |
| ISSUES USING MD ERROR RETURNED FROM WEIGHT LIBRARY: INPUT COLUMNXXX COULD NOT BE FOUND IN THE DATA DICTIONARY | |
| MATCH UNDUP CAUSING OVER FLOWS MATCHES. | |
| RULES SET LOCKED IF USERS DOESN'T BACK OUT. | |
| Add environment variable for distribute-component call to prevent problem in grid, cluster, or MPP environments when file systems are shared by all compute nodes and conductor. | |
MetaData Repository (XMETA) Fixes | |
Fix ID | Description |
| XMQL JOIN backport | |
JR34944 | Unnecessary JOINs were found in the generated SQL statements. Duplicate of JR34533. |
| JDBC CONNECTION POOL IS EXHAUSTED | |
| Avoid NullPointerException in AssetImportMerge. | |
| If QueryCompileOptions is set with ForUpdate.ALL, and query join optimization (JR34533) is applied, same query might be executed multiple times, | |
| Diagnostic Utility - Several of the queries executed by the dangling references probe were optimized. | |
Salesforce Pack | |
Fix ID | Description |
| Salesforce Pack updates. | |
Related Information
[{"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZJPD","label":"InfoSphere Business Glossary"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSX3EG","label":"InfoSphere FastTrack"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSZJMP","label":"InfoSphere Information Services Director"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSVSBF","label":"InfoSphere QualityStage"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SS3GFL","label":"InfoSphere Metadata Workbench"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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.1.0.2;8.1.0.1;8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21451369