Hot Fix Downloads

General Information about Hot Fixes

B51001 was replaced by B51006

B51002 was replaced by B51006

B51003 was replaced by B51006

B51004 was replaced by B51006

B51005 was replaced by B51006

B51006
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" occurs 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
40037	An error occurs in SAS� Data Integration Studio 4.21 if the action Send Job Status is used to direct records to a table with data set options	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	SAS� Clinical Data Integration version 2.2 - 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
48511	The Column reference property setting for Group By columns in the Extract transformation is set to the default value Name when migrated or promoted	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
47908	"ERROR: Expected open parenthesis after macro function name not found" occurs when using an SCD Type 2 Loader transformation	B51005
48472	The message "Error in the LIBNAME statement" appears in SAS� Data Integration Studio jobs that use the SCD Type 2 Loader transformation	B51005
48510	Business keys in the SCD Type 2 Loader transformation are missing after you migrate or promote jobs from SAS� Data Integration Studio 3.4	B51005
47906	The target table might not update correctly when using the SCD Type 2 Loader transformation	B51006
48456	"ERROR: A link must be established by executing the SIGNON command ..." occurs in SAS� Data Integration Studio jobs that use the Loop transformation	B51006
48458	SAS� Data Integration Studio jobs with Loop transformations incorrectly complete with nonzero return codes	B51006
48484	Values for Additional Data Table Options in the SPD Server Loader transformation are missing after a migration or promotion	B51006
48485	SAS� Data Integration Studio shows only one Foreign Key Column if multiple foreign keys reference the same primary key table	B51006
48531	The COMPRESS=BINARY option is not included in the selection list for table options in SAS� Data Integration Studio 4.21	B51006
48532	Data does not import correctly when using the External File Wizard or the Table Properties window in SAS� Data Integration Studio	B51006
NOTE: If you install this hot fix, you must also install hot fix C63005 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 04, 2013       Documentation: B51006wn.html D         Download: B51006wn.exe   Windows for x64 Released: March 04, 2013       Documentation: B51006x6.html D         Download: B51006x6.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 C63005

C63002 was replaced by C63005

C63003 was replaced by C63005

C63004 was replaced by C63005

C63005
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	SAS� Clinical Data Integration version 2.2 - 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	Applying Hot Fix B51002 for SAS� Data Integration Studio triggers "ERROR: LIBNAME ETLSTMP is not assigned" in an SCD Type 2 Loader transformation	C63003
45881	Importing a SAS� Data Integration Studio 3.4 job into SAS� Data Integration Studio 4.2 might fail with errors	C63003
45896	Invalid SQL pass-through code is generated after applying Hot Fix B51003 for SAS� Data Integration Studio 4.2	C63003
48511	The Column reference property setting for Group By columns in the Extract transformation is set to the default value Name when migrated or promoted	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
45846	A "Maximum data source count will be exceeded (1)" error occurs when migrating jobs containing a Splitter transformation with two or more input tables	C63004
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	C63004
45939	The error "BY variables are not properly sorted on data set LIBREF.TARGETTABLE" occurs in an SCD Type 2 Loader transformation	C63004
45979	Cannot save a SAS� Data Integration Studio 4.2 job that contains a user-generated transformation	C63004
45996	The SPD Server Table Loader transformation ignores the "Alternative library for temporary tables" option for target tables	C63004
48472	The message "Error in the LIBNAME statement" appears in SAS� Data Integration Studio jobs that use the SCD Type 2 Loader transformation	C63004
48510	Business keys in the SCD Type 2 Loader transformation are missing after you migrate or promote jobs from SAS� Data Integration Studio 3.4	C63004
48571	Registering Teradata tables fails in SAS Data Integration Studio for libraries using the SAS/Access ODBC or OLE DB engines.	C63004
47906	The target table might not update correctly when using the SCD Type 2 Loader transformation	C63005
47908	"ERROR: Expected open parenthesis after macro function name not found" occurs when using an SCD Type 2 Loader transformation	C63005
48456	"ERROR: A link must be established by executing the SIGNON command ..." occurs in SAS� Data Integration Studio jobs that use the Loop transformation	C63005
48458	SAS� Data Integration Studio jobs with Loop transformations incorrectly complete with nonzero return codes	C63005
48484	Values for Additional Data Table Options in the SPD Server Loader transformation are missing after a migration or promotion	C63005
48485	SAS� Data Integration Studio shows only one Foreign Key Column if multiple foreign keys reference the same primary key table	C63005
48531	The COMPRESS=BINARY option is not included in the selection list for table options in SAS� Data Integration Studio 4.21	C63005
48532	Data does not import correctly when using the External File Wizard or the Table Properties window in SAS� Data Integration Studio	C63005
NOTE: If you install this hot fix, you must also install hot fix B51006 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 04, 2013       Documentation: C63005os.html D         Download: C63005os.bin   Windows Released: March 04, 2013       Documentation: C63005wn.html D         Download: C63005wn.exe   Windows for IPF Released: March 04, 2013       Documentation: C63005w6.html D         Download: C63005w6.exe   Windows for x64 Released: March 04, 2013       Documentation: C63005x6.html D         Download: C63005x6.exe   64-bit Enabled HP-UX Released: March 04, 2013       Documentation: C63005h6.html D         Download: C63005h6.bin   64-bit Enabled Solaris Released: March 04, 2013       Documentation: C63005s6.html D         Download: C63005s6.bin   64-bit Enabled AIX Released: March 04, 2013       Documentation: C63005r6.html D         Download: C63005r6.bin   Linux Released: March 04, 2013       Documentation: C63005lx.html D         Download: C63005lx.bin   HP-UX IPF Released: March 04, 2013       Documentation: C63005hx.html D         Download: C63005hx.bin   Linux for x64 Released: March 04, 2013       Documentation: C63005la.html D         Download: C63005la.bin   Solaris for x64 Released: March 04, 2013       Documentation: C63005sx.html D         Download: C63005sx.bin
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.

Top ^