SAS ALERT Hot Fixes for 9.1.3 (9.1 TS1M3) -SBCS- on SAX

Return to 9.1.3 Hot Fix Home

SAS 9.1.3 (9.1 TS1M3)

Hot Fix Downloads for ALERT issues on Solaris for x64

Hot Fix Download Quick Links:

SAS/ACCESS INTERFACE TO SYBASE SAS/IML SAS/OR SAS/STAT

Other Hot Fix Links:

Hot Fixes for Additional SAS Products and Solutions

National Language Support Hot Fixes

BASE SAS

E9BC20 for Solaris for x64

Released: Jun 2008

This Hot Fix is included in Hot Fix Bundle E9BX05.

Issue(s) Addressed: Introduced:

SN-017906 The I/O subsystem has returned error message 'WHERE clause is not allowed with preset index.' E9BA26
SN-017800 ALERT - WHERE clause is not allowed with preset index E9BA26
SN-032112 Performance degradation might occur with the SAS� Metadata Server E9BC20

Install Instructions: E9BC20sx.txt

Download: E9BC20 for Solaris for x64 (File Size: 106K)

Top ^

E9BC59 for Solaris for x64

Released: Dec 2008

This Hot Fix is included in Hot Fix Bundle E9BX05.

Issue(s) Addressed: Introduced:

SN-018452 ALERT - Unauthorized access to metadata server content E9BA54
SN-030465 ALERT - Adding new records to a metadata repository after performing a metadata restore adds multiple metadata objects with the same internal ID value E9BB74
SN-031345 Metadata objects stored in a custom repository are not returned by client applications or metadata query results when they should be E9BC03
SN-033984 Poor performance occurs in client applications when the metadata environment contains a large number of repositories E9BC59
SN-034096 Content is added to a parent repository, even when you do not have Check In Metadata permissions E9BC59

Install Instructions: E9BC59sx.txt

Download: E9BC59 for Solaris for x64 (File Size: 2.0M)

Top ^

BASE SAS

E9BD38 for Solaris for x64

Released: Aug 2010

Issue(s) Addressed: Introduced:

SN-017410 SAS� OLAP Server process may crash if slicer contains infinite loop E9BA01
SN-017408 Permission condition memory is not released when OLAP session closed E9BA01
SN-017409 SAS� OLAP Server performance enhancements available in SAS 9.1.3 Service Pack 4 E9BA01
SN-018037 PROC OLAP DEFINE statement can allow duplicate calculated members to be created E9BA34
SN-017931 NUNIQUE values may be incorrect depending on the setting for "Maximum number of region execution threads" E9BA34
SN-017445 Listing active queries on SAS� OLAP Server can cause server crash E9BA34
SN-017523 Selecting an OLAP Session in the OLAP Server monitor may cause SAS� Management Console to hang E9BA34
SN-018020 ALERT - SAS� OLAP Server may error when empty data is passed to certain SAS� functions E9BA34
SN-017871 ALERT - Drilldown may cause calculated member values to return from the SAS� OLAP Server as missing in Service Pack 4 E9BA34
SN-018018 Complex MDX query within a WITH expression might generate an access violation E9BA34
SN-018030 SAS� OLAP Server might abend with an OLS_NAMESPACEDELETE traceback E9BA34
SN-017907 ALERT - OLAP cubes with deep hierarchies may return incorrect result sets E9BA34
SN-018089 Detailed SAS� OLAP Server logging now outputs SAS OLAP Server option settings E9BA34
SN-018012 Threadpool options for the SAS® OLAP Server are being overwritten E9BA34
SN-018198 TKASSERT error might be received when querying a SAS� OLAP cube on z/OS E9BA34
SN-017449 NON EMPTY CROSSJOIN optimization in SAS� OLAP Server E9BA47
SN-018254 MDX WHERE clause might return incorrect number of rows resulting in a performance loss E9BA56
SN-018701 ALERT - Session and Global calculated members might be dropped when using NonEmpty Optimization E9BA56
SN-018580 Disabling NonEmpty Crossjoin optimization does not have any effect E9BA56
SN-018794 ALERT - DrillDownMemberTop function might cause crashes in the SAS� OLAP Server E9BA56
SN-018702 ALERT - Global calculated members might cause crash in SAS OLAP Server with Optimization of Non Empty Crossjoins E9BA56
SN-018795 ALERT - OLAP queries might return empty results if requesting missing values E9BA56
SN-018796 ALERT - MDX iif functions that return null values might incorrectly return empty result sets E9BA56
SN-019048 ALERT - Calculated measures might be dropped from the OLAP result set when using Non Empty Crossjoin Optimization E9BA56
SN-019164 Memory degradation or access violation could occur when querying a SAS® OLAP cube with member-level security applied E9BA84
SN-018253 DBCS drillthrough labels might not be rendered correctly E9BA89
SN-019226 ALERT - Sorted OLAP queries might return incorrect results E9BA89
SN-019314 Use of global MDX String functions could halt the SAS� OLAP Server E9BA93
SN-019418 AGGREGATE MDX function might cause slow query performance when member-level security is defined to the OLAP cube E9BA99
SN-019725 AGGREGATE functions using calculated members containing NUNIQUE measures might cause SAS� OLAP Server to crash E9BB07
SN-019820 ALERT - NONEMPTYCROSSJOIN function might cause data loss in an OLAP Query E9BB19
SN-020202 Incorrect totals calculated when aggregate has members in same dimension of the NUNIQUE measure being used E9BB33
SN-020292 SAS� OLAP Server performance might be worse after applying hotfix E9BA34 or later E9BB38
SN-020291 ALERT - SAS� OLAP Server AGGREGATE function might return incorrect results on certain calculated members E9BB38
SN-030537 SAS MDX isEmpty function will not evaluate cells containing character data E9BB68
SN-020146 ALERT - Total calculations might be incorrect when an NUNIQUE measure is used E9BB68
SN-013365 Drill-through and ROLAP aggregation tables can fail if the MDX query contains a numeric member E9BC15
SN-020028 Empty drillthrough result when format width for a column is too small E9BC15
SN-020652 NON EMPTY CROSSJOIN optimization might drop members from result set E9BC73
SN-035621 SAS� OLAP Server appears to hang and must be frequently restarted E9BC88
SN-033970 NON EMPTY CROSSJOIN optimization might cause slower performance with secured data E9BC92
SN-036393 ERROR: "An OLAP server thread has failed" occurs when a drill-through query returns no records E9BD03
SN-038401 MDX queries using totals in SAS� Web reports are not optimized by the SAS� OLAP Server E9BD21
SN-038374 An error related to AVL trees might be returned by OLAP queries E9BD23
SN-038652 Performance problems might occur on SAS� OLAP Servers that are running multiple requests E9BD24
SN-038708 "Internal server exception: access violation" and _pthread_body errors received during an OLAP query E9BD24
SN-040398 The SAS� OLAP Server might fail on Microsoft Windows Server installations E9BD38

Install Instructions: E9BD38sx.txt

Download: E9BD38 for Solaris for x64 (File Size: 2.8M)

ATTENTION: If you are running SAS Management Console 9.1.3 Service Pack 4, with Implementation-Version=9.1.20050622.20001, you must also download and install SAS Management Console hot fix 913SMC02 to address the issue described in SN-017449. The fix for the problem documented in this SAS Note will not be fully functional unless both E9BD38 and 913SMC02 are applied.
You do not need to install 913SMC02 if you have any other Implementation-Version of SAS Management Console.

ATTENTION: To fully implement the fix for SN-018254, you must also download and install SAS Base hot fix E9BC49. The fix for the problem documented in this SAS Note will not be fully functional unless both E9BD38 and E9BC49 are applied.

Top ^

E9BD52 for Solaris for x64

Released: Mar 2011

Issue(s) Addressed: Introduced:

SN-042334 ALERT - Extra rows are returned in resulting data sets when you use the syntax SELECT * rather than SELECT A, B, C in SAS� Warranty Analysis E9BD52

Install Instructions: E9BD52sx.txt

Download: E9BD52 for Solaris for x64 (File Size: 172K)

Top ^

SAS/ACCESS INTERFACE TO SYBASE

E9SB09 for Solaris for x64

Released: Sep 2009

Issue(s) Addressed: Introduced:

SN-017567 Connection to Sybase not released when using PROC DBLOAD with the SAS/ACCESS� Interface to Sybase E9SB01
SN-018210 Incorrect amount of data may be returned when using SAS/ACCESS� Interface to Sybase with threads E9SB02
SN-017889 Notes, Warnings, or Errors not being issued when attempting to insert into a SYBASE table with triggers E9SB02
SN-018400 Different column Format is given when using ORDER BY and a date literal within a SELECT statement using the Sybase engine E9SB03
SN-018792 Text strings greater than 32767 are stored as a blank field when read into SAS� with the DBMAX_TEXT option set E9SB04
SN-019240 Selecting a column that contains null values for autopartitioning when DBSLICEPARM=ALL might generate incorrect data E9SB04
SN-019099 SAS/ACCESS� Interface to Sybase with the bulkcopy feature may return a warning when an actual error was issued E9SB04
SN-019748 Incorrect results can occur when you use the DBSLICEPARM= option with SAS/ACCESS� Interface to Sybase E9SB05
SN-033901 An error occurs in releases of Sybase that support the data types Date and Time E9SB06
SN-033896 Performance degradation occurs when you run programs in SAS/ACCESS� Interface to Sybase after you have migrated from SAS� 8.2 to SAS� 9.1.3 E9SB06
SN-035927 ALERT - An error occurs when you append a SAS� data set to Sybase table that has a VARCHAR column with a length greater than 255 E9SB08
SN-036626 ALERT - Incorrect dates are appended to the Sybase table when you use the APPEND procedure with the SASDATEFMT= and the BULKCOPY= options E9SB09

Install Instructions: E9SB09sx.txt

Download: E9SB09 for Solaris for x64 (File Size: 559K)

Top ^

SAS/IML

E9ML01 for Solaris for x64

Released: Sep 2006

Issue(s) Addressed: Introduced:

SN-018573 ALERT - PROC IML will not load on Intel hardware E9ML01

Install Instructions: E9ML01sx.txt

Download: E9ML01 for Solaris for x64 (File Size: 275K)

Top ^

E9ML03 for Solaris for x64

Released: Sep 2009

Issue(s) Addressed: Introduced:

SN-034587 ALERT - CALL EIGEN in the IML Procedure might modify the input matrix E9ML03

Install Instructions: E9ML03sx.txt

Download: E9ML03 for Solaris for x64 (File Size: 106K)

Top ^

SAS/OR

E9OR01 for Solaris for x64

Released: Sep 2006

Issue(s) Addressed: Introduced:

SN-018424 ALERT - Certain SAS/OR� procedures will not load on Intel hardware E9OR01

Install Instructions: E9OR01sx.txt

Download: E9OR01 for Solaris for x64 (File Size: 3.4M)

Top ^

SAS/STAT

E9ST09 for Solaris for x64

Released: Jan 2008

Issue(s) Addressed: Introduced:

SN-021142 ALERT - Missing or incorrect results for stratified tests via the GROUP= option of the STRATA statement in PROC LIFETEST may occur when a BY statement is used E9ST09

Install Instructions: E9ST09sx.txt

Download: E9ST09 for Solaris for x64 (File Size: 342K)

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.


Hot Fix Download Quick Links:
SAS/ACCESS INTERFACE TO SYBASE	SAS/IML	SAS/OR	SAS/STAT
Other Hot Fix Links:
Hot Fixes for Additional SAS Products and Solutions
National Language Support Hot Fixes

E9BC20 for Solaris for x64
Released: Jun 2008
This Hot Fix is included in Hot Fix Bundle E9BX05.
Issue(s) Addressed:		Introduced:
SN-017906	The I/O subsystem has returned error message 'WHERE clause is not allowed with preset index.'	E9BA26
SN-017800	ALERT - WHERE clause is not allowed with preset index	E9BA26
SN-032112	Performance degradation might occur with the SAS� Metadata Server	E9BC20
Install Instructions: E9BC20sx.txt
Download: E9BC20 for Solaris for x64 (File Size: 106K)

E9BC59 for Solaris for x64
Released: Dec 2008
This Hot Fix is included in Hot Fix Bundle E9BX05.
Issue(s) Addressed:		Introduced:
SN-018452	ALERT - Unauthorized access to metadata server content	E9BA54
SN-030465	ALERT - Adding new records to a metadata repository after performing a metadata restore adds multiple metadata objects with the same internal ID value	E9BB74
SN-031345	Metadata objects stored in a custom repository are not returned by client applications or metadata query results when they should be	E9BC03
SN-033984	Poor performance occurs in client applications when the metadata environment contains a large number of repositories	E9BC59
SN-034096	Content is added to a parent repository, even when you do not have Check In Metadata permissions	E9BC59
Install Instructions: E9BC59sx.txt
Download: E9BC59 for Solaris for x64 (File Size: 2.0M)

E9BD38 for Solaris for x64
Released: Aug 2010
Issue(s) Addressed:		Introduced:
SN-017410	SAS� OLAP Server process may crash if slicer contains infinite loop	E9BA01
SN-017408	Permission condition memory is not released when OLAP session closed	E9BA01
SN-017409	SAS� OLAP Server performance enhancements available in SAS 9.1.3 Service Pack 4	E9BA01
SN-018037	PROC OLAP DEFINE statement can allow duplicate calculated members to be created	E9BA34
SN-017931	NUNIQUE values may be incorrect depending on the setting for "Maximum number of region execution threads"	E9BA34
SN-017445	Listing active queries on SAS� OLAP Server can cause server crash	E9BA34
SN-017523	Selecting an OLAP Session in the OLAP Server monitor may cause SAS� Management Console to hang	E9BA34
SN-018020	ALERT - SAS� OLAP Server may error when empty data is passed to certain SAS� functions	E9BA34
SN-017871	ALERT - Drilldown may cause calculated member values to return from the SAS� OLAP Server as missing in Service Pack 4	E9BA34
SN-018018	Complex MDX query within a WITH expression might generate an access violation	E9BA34
SN-018030	SAS� OLAP Server might abend with an OLS_NAMESPACEDELETE traceback	E9BA34
SN-017907	ALERT - OLAP cubes with deep hierarchies may return incorrect result sets	E9BA34
SN-018089	Detailed SAS� OLAP Server logging now outputs SAS OLAP Server option settings	E9BA34
SN-018012	Threadpool options for the SAS® OLAP Server are being overwritten	E9BA34
SN-018198	TKASSERT error might be received when querying a SAS� OLAP cube on z/OS	E9BA34
SN-017449	NON EMPTY CROSSJOIN optimization in SAS� OLAP Server	E9BA47
SN-018254	MDX WHERE clause might return incorrect number of rows resulting in a performance loss	E9BA56
SN-018701	ALERT - Session and Global calculated members might be dropped when using NonEmpty Optimization	E9BA56
SN-018580	Disabling NonEmpty Crossjoin optimization does not have any effect	E9BA56
SN-018794	ALERT - DrillDownMemberTop function might cause crashes in the SAS� OLAP Server	E9BA56
SN-018702	ALERT - Global calculated members might cause crash in SAS OLAP Server with Optimization of Non Empty Crossjoins	E9BA56
SN-018795	ALERT - OLAP queries might return empty results if requesting missing values	E9BA56
SN-018796	ALERT - MDX iif functions that return null values might incorrectly return empty result sets	E9BA56
SN-019048	ALERT - Calculated measures might be dropped from the OLAP result set when using Non Empty Crossjoin Optimization	E9BA56
SN-019164	Memory degradation or access violation could occur when querying a SAS® OLAP cube with member-level security applied	E9BA84
SN-018253	DBCS drillthrough labels might not be rendered correctly	E9BA89
SN-019226	ALERT - Sorted OLAP queries might return incorrect results	E9BA89
SN-019314	Use of global MDX String functions could halt the SAS� OLAP Server	E9BA93
SN-019418	AGGREGATE MDX function might cause slow query performance when member-level security is defined to the OLAP cube	E9BA99
SN-019725	AGGREGATE functions using calculated members containing NUNIQUE measures might cause SAS� OLAP Server to crash	E9BB07
SN-019820	ALERT - NONEMPTYCROSSJOIN function might cause data loss in an OLAP Query	E9BB19
SN-020202	Incorrect totals calculated when aggregate has members in same dimension of the NUNIQUE measure being used	E9BB33
SN-020292	SAS� OLAP Server performance might be worse after applying hotfix E9BA34 or later	E9BB38
SN-020291	ALERT - SAS� OLAP Server AGGREGATE function might return incorrect results on certain calculated members	E9BB38
SN-030537	SAS MDX isEmpty function will not evaluate cells containing character data	E9BB68
SN-020146	ALERT - Total calculations might be incorrect when an NUNIQUE measure is used	E9BB68
SN-013365	Drill-through and ROLAP aggregation tables can fail if the MDX query contains a numeric member	E9BC15
SN-020028	Empty drillthrough result when format width for a column is too small	E9BC15
SN-020652	NON EMPTY CROSSJOIN optimization might drop members from result set	E9BC73
SN-035621	SAS� OLAP Server appears to hang and must be frequently restarted	E9BC88
SN-033970	NON EMPTY CROSSJOIN optimization might cause slower performance with secured data	E9BC92
SN-036393	ERROR: "An OLAP server thread has failed" occurs when a drill-through query returns no records	E9BD03
SN-038401	MDX queries using totals in SAS� Web reports are not optimized by the SAS� OLAP Server	E9BD21
SN-038374	An error related to AVL trees might be returned by OLAP queries	E9BD23
SN-038652	Performance problems might occur on SAS� OLAP Servers that are running multiple requests	E9BD24
SN-038708	"Internal server exception: access violation" and _pthread_body errors received during an OLAP query	E9BD24
SN-040398	The SAS� OLAP Server might fail on Microsoft Windows Server installations	E9BD38
Install Instructions: E9BD38sx.txt
Download: E9BD38 for Solaris for x64 (File Size: 2.8M)
ATTENTION: If you are running SAS Management Console 9.1.3 Service Pack 4, with Implementation-Version=9.1.20050622.20001, you must also download and install SAS Management Console hot fix 913SMC02 to address the issue described in SN-017449. The fix for the problem documented in this SAS Note will not be fully functional unless both E9BD38 and 913SMC02 are applied. You do not need to install 913SMC02 if you have any other Implementation-Version of SAS Management Console. ATTENTION: To fully implement the fix for SN-018254, you must also download and install SAS Base hot fix E9BC49. The fix for the problem documented in this SAS Note will not be fully functional unless both E9BD38 and E9BC49 are applied.

E9BD52 for Solaris for x64
Released: Mar 2011
Issue(s) Addressed:		Introduced:
SN-042334	ALERT - Extra rows are returned in resulting data sets when you use the syntax SELECT * rather than SELECT A, B, C in SAS� Warranty Analysis	E9BD52
Install Instructions: E9BD52sx.txt
Download: E9BD52 for Solaris for x64 (File Size: 172K)

E9SB09 for Solaris for x64
Released: Sep 2009
Issue(s) Addressed:		Introduced:
SN-017567	Connection to Sybase not released when using PROC DBLOAD with the SAS/ACCESS� Interface to Sybase	E9SB01
SN-018210	Incorrect amount of data may be returned when using SAS/ACCESS� Interface to Sybase with threads	E9SB02
SN-017889	Notes, Warnings, or Errors not being issued when attempting to insert into a SYBASE table with triggers	E9SB02
SN-018400	Different column Format is given when using ORDER BY and a date literal within a SELECT statement using the Sybase engine	E9SB03
SN-018792	Text strings greater than 32767 are stored as a blank field when read into SAS� with the DBMAX_TEXT option set	E9SB04
SN-019240	Selecting a column that contains null values for autopartitioning when DBSLICEPARM=ALL might generate incorrect data	E9SB04
SN-019099	SAS/ACCESS� Interface to Sybase with the bulkcopy feature may return a warning when an actual error was issued	E9SB04
SN-019748	Incorrect results can occur when you use the DBSLICEPARM= option with SAS/ACCESS� Interface to Sybase	E9SB05
SN-033901	An error occurs in releases of Sybase that support the data types Date and Time	E9SB06
SN-033896	Performance degradation occurs when you run programs in SAS/ACCESS� Interface to Sybase after you have migrated from SAS� 8.2 to SAS� 9.1.3	E9SB06
SN-035927	ALERT - An error occurs when you append a SAS� data set to Sybase table that has a VARCHAR column with a length greater than 255	E9SB08
SN-036626	ALERT - Incorrect dates are appended to the Sybase table when you use the APPEND procedure with the SASDATEFMT= and the BULKCOPY= options	E9SB09
Install Instructions: E9SB09sx.txt
Download: E9SB09 for Solaris for x64 (File Size: 559K)

E9ML01 for Solaris for x64
Released: Sep 2006
Issue(s) Addressed:		Introduced:
SN-018573	ALERT - PROC IML will not load on Intel hardware	E9ML01
Install Instructions: E9ML01sx.txt
Download: E9ML01 for Solaris for x64 (File Size: 275K)

E9ML03 for Solaris for x64
Released: Sep 2009
Issue(s) Addressed:		Introduced:
SN-034587	ALERT - CALL EIGEN in the IML Procedure might modify the input matrix	E9ML03
Install Instructions: E9ML03sx.txt
Download: E9ML03 for Solaris for x64 (File Size: 106K)

E9OR01 for Solaris for x64
Released: Sep 2006
Issue(s) Addressed:		Introduced:
SN-018424	ALERT - Certain SAS/OR� procedures will not load on Intel hardware	E9OR01
Install Instructions: E9OR01sx.txt
Download: E9OR01 for Solaris for x64 (File Size: 3.4M)

E9ST09 for Solaris for x64
Released: Jan 2008
Issue(s) Addressed:		Introduced:
SN-021142	ALERT - Missing or incorrect results for stratified tests via the GROUP= option of the STRATA statement in PROC LIFETEST may occur when a BY statement is used	E9ST09
Install Instructions: E9ST09sx.txt
Download: E9ST09 for Solaris for x64 (File Size: 342K)