Hot Fixes for SAS Data Integration Studio 4.21

Providing software solutions since 1976

Go to Product List

SAS Data Integration Studio 4.21_M2

Hot Fix Downloads

Important changes to Hot Fixes!

B51001 was replaced by B51005

B51002 was replaced by B51005

B51003 was replaced by B51005

B51004 was replaced by B51005

B51005

SAS Data Integration Studio 4.21_M2

Issue(s) Addressed: Introduced:

40005 An error occurs in the SASŽ Data Integratio Studio job log due to invalid truncate syntax for a SASŽ Scalable Performance Date ServerŽ table B51001

40008 "This job has changed since it was last opened" message displays when opening a SASŽ Data Integration Studio 4.21 job B51001

40010 "Error reading metadata: No transformation type found" displays when opening a SASŽ Data Integration Studio job B51001

40011 The Data Validation transformation generates invalid code if the name of a lookup table contains special characters B51001

40013 Unpredictable behavior occurs if SAS Data Integration Studio Server Data is not installed on the machine with the metadata server B51001

40014 Errors occur when executing a job if there are unmatched single quotation marks in parameter values B51001

40015 Values for the TPT_TRACE_LEVEL_INF data set option in the Teradata Loader properties are incorrect B51001

40016 Using the SET= Teradata table option to enable duplicates results in behavior that is opposite of what is expected B51001

40017 Partitioned primary indexes are incorrectly omitted when searching for primary indexes on Teradata tables B51001

40019 Changes to a SASŽ Data Integration Studio Job are not saved B51001

40028 A SASŽ Data Integration Studio client session becomes unresponsive when working in the Process Editor window B51001

40036 Saving a job in SASŽ Data Integration Studio might fail with the error "Error writing metadata" B51001

40072 After migration or partial promotion, options in the second or subsequent instances of a user-generated transformation are blank B51001

40452 "ERROR:CLI execute error...Invalid object name..." occurs in the SCD Type 2 Loader transformation when loading data to a Microsoft SQL Server database B51002

40532 An exception occurs when migrating or importing a SASŽ Data Integration Studio job B51002

40556 Using the Generate Indexes on the Target Tables transformation option can cause unexpected results B51002

40570 Descending sort order asscociated with columns in the Extract or SQL Join transformation is lost after a migration or import to SASŽ 9.2 B51002

40571 "An invalid format is specified" error occurs in the Mining Results transformation B51002

40572 Large SASŽ Data Integration Studio jobs open slowly B51002

40632 A new SASŽ Data Integration Studio 4.2 option on the Table Loader transformation Load Technique tab affects _LOADTM column updates in the target table B51002

40633 "Table WORK.Wnnnnnnn.DATA does not exist" error occurs in SASŽ Data Integration Studio jobs that use the Loop transformation B51002

40769 An incorrect configuration warning occurs when logging in to a project repository B51002

40775 SQL Join transformations might be lost when importing or migrating jobs B51002

41026 Jobs that contain SQL Join transformations might appear with changes after migrating from SASŽ 9.1.3 to SASŽ 9.2 B51002

41027 The SCD Type 2 Loader transformation fails or experiences performance problems B51002

41028 ALERT - Processing can terminate prematurely if exceptions occur during ETL metadata migration B51002

41035 All input and output ports are incorrectly activated for generated transformations after job migration B51002

41037 Extra table objects appear in job definitions after migrating from SASŽ 9.1.3 to SASŽ 9.2 B51002

41039 Problems occur with alias definitions in SQL Join transformations after migrating from SASŽ 9.1.3 to SASŽ 9.2 B51002

41040 The MetadataUpdated field remains unchanged after the source code is altered for generated transformations B51002

41042 Incorrect output data is generated in the Comparison Results window B51002

41044 The table options are not surfaced in transformation properties or in generated code after applying Hot Fix B51001 B51002

41053 Metadata problems occur as a result of using the SQL Join transformation B51002

40348 Netezza tables accessed using SAS/ACCESSŽ Interface OLE DB cannot be registered in SASŽ Management Console B51003

42066 Update a time field in an existing data set can result in incorrect time B51003

42077 CDISC-SDTM to CRT-DDS transformation loses an output connector B51003

42989 You are unable to map the second instance of a column when you join a table with itself via aliases in SASŽ Data Integration Studio B51003

42990 Unable to register table metadata with the OLE DB designer template for Netezza in SASŽ Management Console and SASŽ Data Integration Studio B51003

42992 The Metadata Importer comparison mode in SASŽ Data Integration Studio fails to import extended attributes B51003

42994 Mapping multiple tables to a single table when you import a SASŽ metadata package file results in corruption B51003

42995 A "Table not found" error occurs in SASŽ Data Integration Studio when loading data B51003

43034 Database management system library options are omitted from explicit SQL pass-through code in SASŽ Data Integration Studio B51003

43036 The SQL Join transformation is incorrectly marked as incomplete if the WHERE expression begins with the NOT operator B51003

43115 The Build Expression button is missing from the Filter tab in SASŽ Data Integration Studio B51003

43158 An error occurs when you use an SCD Type 2 loader to update a database management system table using explicit pass-through processing B51003

43165 The error "No SAS Connect server found" appears when you select the Code tab or try to run a job within SASŽ Data Integration Studio B51003

43174 You might receive errors when you attempt to generate code or run jobs after they have been promoted using the Export and Import SAS Package wizards B51003

43214 A table-not-found error occurs when you run a SASŽ Data Integration Studio job using the SQL Join transformation B51003

43215 The SAS Import Package wizard might fail when you attempt to import jobs that are created in earlier releases of SASŽ Data Integration Studio B51003

43229 The SAS server that you specified is no longer available in SASŽ Data Integration Studio B51003

43236 Subquery objects are lost from SASŽ Data Integration Studio SQL Join transformations that contain WHERE, HAVING, or SELECT clauses B51003

43254 The Teradata Table Loader transformation does not retain load technique settings B51003

43256 SASŽ Data Integration Studio uses the wrong SQL procedure statement when you clear the contents of a Netezza table B51003

43268 Applying Hot Fix B51002 can cause SASŽ Data Surveyor for Clickstream Data 2.2 jobs to fail B51003

43290 After you apply hot fix B51002 an error can occur when jobs are automatically deployed by Adapter Setup Wizard B51003

18957 ALERT - The Loader transformation's "Update/Insert" technique in SASŽ Data Integration Studio 3.4 might load nonmapped target-table columns with incorrect data B51004

43211 A Splitter transformation in SASŽ Data Integration Studio generates the error "Data set was not specified on the DATA statement" B51004

44668 After installing hot fix B51003 for SASŽ Data Integration Studio, jobs fail to generate complete code B51004

44893 ALERT - New rows containing incorrect data are loaded into the target table B51004

44908 "Mapped source columns do not match columns used in expression" might occur after you install hot fix B51003 B51004

36333 Automatic mapping does not occur for columns referenced in expressions B51005

45307 The traditional Chinese version of SASŽ Data Integration Studio displays simplified Chinese in the menu B51005

45769 Text written to the Log and the Output tabs in SASŽ Data Integration Studio always wraps at 100 characters B51005

45831 The Model Universal Unique Identifier value is not shown in the Mining Results transformation properties in SASŽ Data Integration Studio B51005

45920 The SCD Type 2 Loader transformation provides no option to suppress index creation on the permanent cross reference table or on the target table B51005

45996 The SPD Server Table Loader transformation ignores the "Alternative library for temporary tables" option for target tables B51005

NOTE: If you install this hot fix, you must also install hot fix C63004 for Data Integration Studio Server Data 9.2-M2 on your metadata server machine.
NOTE: To implement the fix for the issue described in SN-45307 please contact SAS Technical Support.

Windows Released: March 22, 2012 Documentation: B51005wn.html ^D Download: B51005wn.exe

Windows for x64 Released: March 22, 2012 Documentation: B51005x6.html ^D Download: B51005x6.exe

^D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.

Top ^

C63001 was replaced by C63004

C63002 was replaced by C63004

C63003 was replaced by C63004

C63004

SAS Data Integration Studio Server Data 9.2_M2 hot fix for SAS Data Integration Studio 4.21_M2

Issue(s) Addressed: Introduced:

40452 "ERROR:CLI execute error...Invalid object name..." occurs in the SCD Type 2 Loader transformation when loading data to a Microsoft SQL Server database C63001

40532 An exception occurs when migrating or importing a SASŽ Data Integration Studio job C63001

40556 Using the Generate Indexes on the Target Tables transformation option can cause unexpected results C63001

40570 Descending sort order asscociated with columns in the Extract or SQL Join transformation is lost after a migration or import to SASŽ 9.2 C63001

40571 "An invalid format is specified" error occurs in the Mining Results transformation C63001

40572 Large SASŽ Data Integration Studio jobs open slowly C63001

40632 A new SASŽ Data Integration Studio 4.2 option on the Table Loader transformation Load Technique tab affects _LOADTM column updates in the target table C63001

40633 "Table WORK.Wnnnnnnn.DATA does not exist" error occurs in SASŽ Data Integration Studio jobs that use the Loop transformation C63001

40769 An incorrect configuration warning occurs when logging in to a project repository C63001

40775 SQL Join transformations might be lost when importing or migrating jobs C63001

41026 Jobs that contain SQL Join transformations might appear with changes after migrating from SASŽ 9.1.3 to SASŽ 9.2 C63001

41027 The SCD Type 2 Loader transformation fails or experiences performance problems C63001

41028 ALERT - Processing can terminate prematurely if exceptions occur during ETL metadata migration C63001

41035 All input and output ports are incorrectly activated for generated transformations after job migration C63001

41037 Extra table objects appear in job definitions after migrating from SASŽ 9.1.3 to SASŽ 9.2 C63001

41039 Problems occur with alias definitions in SQL Join transformations after migrating from SASŽ 9.1.3 to SASŽ 9.2 C63001

41040 The MetadataUpdated field remains unchanged after the source code is altered for generated transformations C63001

41042 Incorrect output data is generated in the Comparison Results window C63001

41044 The table options are not surfaced in transformation properties or in generated code after applying Hot Fix B51001 C63001

41053 Metadata problems occur as a result of using the SQL Join transformation C63001

40348 Netezza tables accessed using SAS/ACCESSŽ Interface OLE DB cannot be registered in SASŽ Management Console C63002

42066 Update a time field in an existing data set can result in incorrect time C63002

42077 CDISC-SDTM to CRT-DDS transformation loses an output connector C63002

42989 You are unable to map the second instance of a column when you join a table with itself via aliases in SASŽ Data Integration Studio C63002

42990 Unable to register table metadata with the OLE DB designer template for Netezza in SASŽ Management Console and SASŽ Data Integration Studio C63002

42994 Mapping multiple tables to a single table when you import a SASŽ metadata package file results in corruption C63002

42995 A "Table not found" error occurs in SASŽ Data Integration Studio when loading data C63002

43034 Database management system library options are omitted from explicit SQL pass-through code in SASŽ Data Integration Studio C63002

43174 You might receive errors when you attempt to generate code or run jobs after they have been promoted using the Export and Import SAS Package wizards C63002

43214 A table-not-found error occurs when you run a SASŽ Data Integration Studio job using the SQL Join transformation C63002

43215 The SAS Import Package wizard might fail when you attempt to import jobs that are created in earlier releases of SASŽ Data Integration Studio C63002

43236 Subquery objects are lost from SASŽ Data Integration Studio SQL Join transformations that contain WHERE, HAVING, or SELECT clauses C63002

43254 The Teradata Table Loader transformation does not retain load technique settings C63002

43256 SASŽ Data Integration Studio uses the wrong SQL procedure statement when you clear the contents of a Netezza table C63002

43268 Applying Hot Fix B51002 can cause SASŽ Data Surveyor for Clickstream Data 2.2 jobs to fail C63002

43290 After you apply hot fix B51002 an error can occur when jobs are automatically deployed by Adapter Setup Wizard C63002

18957 ALERT - The Loader transformation's "Update/Insert" technique in SASŽ Data Integration Studio 3.4 might load nonmapped target-table columns with incorrect data C63003

43211 A Splitter transformation in SASŽ Data Integration Studio generates the error "Data set was not specified on the DATA statement" C63003

44668 After installing hot fix B51003 for SASŽ Data Integration Studio, jobs fail to generate complete code C63003

44893 ALERT - New rows containing incorrect data are loaded into the target table C63003

44908 "Mapped source columns do not match columns used in expression" might occur after you install hot fix B51003 C63003

45796 Installing hot fix B51002 for SASŽ Data Integration Studio triggers "ERROR: LIBNAME ETLSTMP is not assigned" in an SCD Type 2 Loader transformation C63003

45881 SASŽ Data Integration Studio 4.2 jobs might become corrupted if a CASE expression is used on the right side of a WHERE expression in a SQL Join C63003

45896 After installing hot fix B51003 for SASŽ Data Integration Studio 4.2, invalid SQL Pass-Through code for RDBMS Teradata is generated. C63003

43115 The Build Expression button is missing from the Filter tab in SASŽ Data Integration Studio C63004

45307 The traditional Chinese version of SASŽ Data Integration Studio displays simplified Chinese in the menu C63004

45769 Text written to the Log and the Output tabs in SASŽ Data Integration Studio always wraps at 100 characters C63004

45831 The Model Universal Unique Identifier value is not shown in the Mining Results transformation properties in SASŽ Data Integration Studio C63004

45996 The SPD Server Table Loader transformation ignores the "Alternative library for temporary tables" option for target tables C63004

NOTE: If you install this hot fix, you must also install hot fix B51005 for Data Integration Studio 4.21 - M2 on your client machine.
NOTE: To implement the fix for the issue described in SN-45307 please contact SAS Technical Support.

z/OS Released: March 22, 2012 Documentation: C63004os.html ^D Download: C63004os.bin

Windows Released: March 22, 2012 Documentation: C63004wn.html ^D Download: C63004wn.exe

Windows for IPF Released: March 22, 2012 Documentation: C63004w6.html ^D Download: C63004w6.exe

Windows for x64 Released: March 22, 2012 Documentation: C63004x6.html ^D Download: C63004x6.exe

64-bit Enabled HP-UX Released: March 22, 2012 Documentation: C63004h6.html ^D Download: C63004h6.bin

64-bit Enabled Solaris Released: March 22, 2012 Documentation: C63004s6.html ^D Download: C63004s6.bin

64-bit Enabled AIX Released: March 22, 2012 Documentation: C63004r6.html ^D Download: C63004r6.bin

Linux Released: March 22, 2012 Documentation: C63004lx.html ^D Download: C63004lx.bin

HP-UX IPF Released: March 22, 2012 Documentation: C63004hx.html ^D Download: C63004hx.bin

Linux for x64 Released: March 22, 2012 Documentation: C63004la.html ^D Download: C63004la.bin

Solaris for x64 Released: March 22, 2012 Documentation: C63004sx.html ^D Download: C63004sx.bin

^D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.

Top ^

PLEASE CAREFULLY READ THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT ("AGREEMENT") BEFORE DOWNLOADING MATERIALS FROM THIS SITE. BY DOWNLOADING ANY MATERIALS FROM THIS SITE, YOU ARE AGREEING TO THESE TERMS.

You are downloading software code ("Code") which will become part of a product ("Software") you currently have licensed from SAS Institute Inc. or one of its subsidiaries ("the Institute"). this Code is designed to either correct an error in the Software or to add functionality to the Software. The code is governed by the same agreement which governs the Software. If you do not have an existing agreement with the Institute governing the Software, you may not download the Code.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ^® indicates USA registration. Other brand and product names are registered trademarks or trademarks of their respective companies.