Hot Fix Downloads for ALERT issues on HPUX

Hot Fix Download Quick Links:
Service Pack	BASE SAS	SAS INTEGRATION TECHNOLOGIES	SAS/ACCESS INTERFACE TO ODBC
SAS/ACCESS INTERFACE TO R/3	SAS/ACCESS INTERFACE TO SYBASE	SAS/IML	SAS/STAT
Other Hot Fix Links:
Hot Fixes for Additional SAS Products and Solutions
National Language Support Hot Fixes

Service Pack

SAS 9.1.3 Service Pack 4 for HPUX

Released: Mar 2006

SAS 9.1.3 Service Pack 4 contains previously available Hot Fixes and other SAS 9.1.3 updates. You must install SAS 9.1.3 Service Pack 4 before installing any currently available hot fixes. If you have installed any additional SAS products or solutions, please review the list of SAS Solutions NOT supported on Service Pack 4 before applying Service Pack 4 to your system.

SAS 9.1.3 Service Pack 4 Fix List

Service Pack FAQ

Install Instructions: Service Pack 4 for HPUX

Download: Service Pack 4 for HPUX   (File Size: 648.9M)

Top ^

BASE SAS

E9BA02 for HPUX
Released: Apr 2006
This Hot Fix is included in Hot Fix Bundle E9BX05.
Issue(s) Addressed:		Introduced:
SN-017049	ALERT - Deleted observations can get added to new data set when migrating	E9BA02
Install Instructions: E9BA02h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BA02. Download: E9BA02 for HPUX   (File Size: 51K)

Top ^

BASE SAS

E9BC12 for HPUX
Released: Dec 2008
This Hot Fix is included in Hot Fix Bundle E9BX05.
Issue(s) Addressed:		Introduced:
SN-021021	ALERT - Some national characters in variable names might be converted to other characters when the options VALIDVARNAME=ANY and GETNAMES=YES	E9BB71
SN-034254	How to allow a numeric value enclosed in quotation marks to be read in as numeric variable with PROC IMPORT or the IMPORT WIZARD	E9BC12
Install Instructions: E9BC12h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BC12. Download: E9BC12 for HPUX   (File Size: 205K)

Top ^

E9BC20 for HPUX
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: E9BC20h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BC20. Download: E9BC20 for HPUX   (File Size: 113K)

Top ^

E9BC59 for HPUX
Released: Dec 2008
This Hot Fix is included in Hot Fix Bundle E9BX05.
Issue(s) Addressed:		Introduced:
SN-017767	Export and Import Wizards require Metadata Server fixes	E9BA20
SN-017743	Login to SAS® web application fails when using an email address as the userid with LDAP authentication	E9BA20
SN-017761	ALERT - Jobs that are duplicated within a Project repository may lose their connection to Target objects	E9BA20
SN-017860	ALERT - BI Manager "Import" might cause metadata to be destroyed for all stored processes that contain parameters in SAS 9.1.3 Service Pack 4	E9BA20
SN-017852	ALERT - External table objects may get inadvertently deleted from metadata when importing or exporting metadata multiple times	E9BA20
SN-017855	ALERT - Server code does not support exporting and importing from a metadata Project repository	E9BA20
SN-017857	Exception may occur while exporting a block of objects from the Data Integration Studio custom tree	E9BA20
SN-017854	ALERT - Incorrect behavior might occur when all items are not selected within a package when performing a metadata import	E9BA20
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: E9BC59h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BC59. Download: E9BC59 for HPUX   (File Size: 2.0M)

Top ^

E9BC81 for HPUX
Released: Apr 2009
This Hot Fix is included in Hot Fix Bundle E9BX05.
Issue(s) Addressed:		Introduced:
SN-019773	Abend U1314 or traceback notes and messages attempting to read a migrated view from SAS® 8	E9BB11
SN-035112	ALERT - Invalid binary data when tranferring SAS data sets with PROC COPY or CPORT/CIMPORT.	E9BC81
Install Instructions: E9BC81h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BC81. Download: E9BC81 for HPUX   (File Size: 236K)

Top ^

BASE SAS

E9BD34 for HPUX
Released: Jul 2010
Issue(s) Addressed:		Introduced:
SN-018463	Access Violation or 0C4 abend in module SASSFM01 when using procedures that use multi-label formats	E9BA61
SN-020189	Statistic labels in PROC TABULATE not displayed in uppercase in table output	E9BB28
SN-020444	Error in PROC TABULATE NLS versions after applying hot fix E9BB28	E9BB42
SN-020359	Variable labels that contain multi-byte character set strings do not split correctly	E9BB53
SN-030679	Page dimension "and" in PROC TABULATE not displayed in uppercase in table output	E9BB81
SN-039321	ALERT - PROC MEANS, SUMMARY, or TABULATE might report incorrect _FREQ_ values when the THREADS and NOTRAP options are specified	E9BD27
SN-040136	PROC TABULATE might give incorrect frequency statistics when only the N statistic is requested and memory is constrained	E9BD34
Install Instructions: E9BD34h6.txt ( This Asian Language Support (DBCS) hot fix has post-installation requirements. Please review SN-038930 for more information. )
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD34. Download: E9BD34 for HPUX   (File Size: 870K)

Top ^

E9BD38 for HPUX
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: E9BD38h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD38. Download: E9BD38 for HPUX   (File Size: 2.7M)
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 ^

E9BD42 for HPUX
Released: Nov 2010
Issue(s) Addressed:		Introduced:
SN-017745	WHERE clause processing against an SQL view can cause Read Access or Segmentation Violations	E9BA28
SN-031607	Using the BY statement with the formatted ODS destinations can generate incorrect output	E9BA36
SN-017962	The first blank space in the name literal table names gets removed when you set the SYSLAST macro variable or _LAST_ system option	E9BA36
SN-017876	Creating index may cause SAS® to loop	E9BA36
SN-017981	ALERT - Incorrect output with WHERE and BY statements	E9BA36
SN-015813	Read Access Violation in Task (CONNECT) caused by long comments	E9BA50
SN-018156	Invoking an autocall macro which is stored as a SOURCE entry within a catalog may cause errors	E9BA50
SN-018305	Garbage characters in SAS log when localized DBCS SAS is used with products related to the Workspace server	E9BA50
SN-018396	Queries or WHERE clauses run against large data sets can cause SAS/SHARE® server to hang	E9BA50
SN-019372	Performance is poor in the SQL procedure when you use the COUNT(Distinct xxxx) function	E9BB02
SN-019601	The option VALIDVARNAME=UPCASE is not working as expected	E9BB02
SN-019978	Specifying LOGPARM system option may generate INSUFFICIENT AUTHORIZATION messages	E9BB13
SN-019984	Output in the listing is truncated using the DBCS version of SAS	E9BB13
SN-019344	SAS® may ignore indexes during query on 64-Bit UNIX systems	E9BB13
SN-019578	Update Flags from PROC SQL views are propagated by SAS® procedures with OUT= option	E9BB13
SN-020208	The ACCESS=READONLY option in the CATNAME statement is not working correctly	E9BB35
SN-020562	PROC APPEND step may damage BASE data set	E9BB52
SN-021003	Using the %v or #v LOGPARM path directive might cause the workspace server to fail to start and processes to stop responding	E9BB63
SN-030428	Aliased constant values become missing in outer joins and unions	E9BB72
SN-030390	Improvements are now available in relational database optimization via the SQL procedure	E9BB72
SN-019655	Filter behavior inconsistent between SAS® Web Report Studio 3.1 and SAS® Information Map Studio	E9BB72
SN-031300	Poor performance occurs when you use views that consist of inner joins from DBMS tables	E9BB98
SN-032375	Errors might occur reading XML files using the XML engine with very long strings	E9BC16
SN-033744	An incorrect buffer break occurs when calling a macro from an EXECUTE statement that specifies a parameter with an "at" sign (@) in the parameter name	E9BC51
SN-036281	PROC REPORT output generated by the CALL EXECUTE routine does not include text or variables generated by a COMPUTE block	E9BC61
SN-034018	MPRINT output generated twice when CALL EXECUTE is used within a macro	E9BC61
SN-035492	Could not find value or Record ID (RID) to do delete on index	E9BC85
SN-035117	ANYDTDTE informat incorrectly interprets invalid date value as a SAS date	E9BC86
SN-035895	An error occurred Executing the Workspace Job The server is disconnected message might occur if you run a job in SAS® Enterprise Guide®	E9BC89
SN-035991	A generic IOM error occurs when executing a stored process that produces graphics output	E9BC89
SN-034012	Column aliases are not passed correctly to GROUP BY or ORDER BY clauses in the SAS® Scalable Performance Data Server®	E9BC93
SN-036280	ALERT - The SQL procedure generates incorrect results when you copy a SAS® data set from one platform to another platform	E9BC93
SN-033084	An SQLPLAN internal error might occur when reference a variable from an in-line view that created the variable from a constant	E9BC93
SN-040951	Arithemetic performed on DATA and TIME data types is not passed to the underlying DBMS in SAS/ACCESS® 9.1.3 software	E9BC93
SN-034678	An SQLPLAN error occurs when you submit a query with a CALCULATED column reference in a CASE expression that contains a GROUP BY clause	E9BC93
SN-036177	Incorrect results might occur when you run a PROC SQL join with an additional WHERE clause against Teradata tables	E9BC93
SN-036202	SQLPLAN internal errors might occur when you reference calculated columns in an SQL procedure	E9BC93
SN-036070	Extraneous code might be added if CALL EXECUTE is used to generate many ODS HTML statements	E9BD01
SN-036592	ALERT - DELETE statement sometimes does not remove qualifying observations	E9BD10
SN-034234	Incorrect results might occur if you use the LIBNAME statement option IP=YES with an SQL procedure that contains data calculations in a WHERE clause	E9BD15
SN-038698	SAS® Enterprise Guide® becomes unresponsive and the SAS® Workspace Server log grows extremely large	E9BD22
SN-040558	Invoking nested autocall macros using des= option causes error	E9BD42
Install Instructions: E9BD42h6.txt ( This Asian Language Support (DBCS) hot fix has post-installation requirements. Please review SN-038930 for more information. )
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD42. Download: E9BD42 for HPUX   (File Size: 4.5M)
ATTENTION (1): To complete the installation of this hot fix, you must also download and install SAS Base hot fixes E9BD61 and E9BD48. Download E9BD61 Download E9BD61 for SAS with Asian Language Support (DBCS) Download E9BD48 Download E9BD48 for SAS with Asian Language Support (DBCS) This hot fix will NOT be fully functional without E9BD61 and E9BD48 applied. ATTENTION (2): For additional configuration instructions for improving relational database optimization, see Problem Note SN-030390 above.

Top ^

E9BD48 for HPUX
Released: Feb 2011
Issue(s) Addressed:		Introduced:
SN-016428	DBSLICEPARM creates incorrect syntax when DB2DECPT=,	E9BA58
SN-030942	The WHERE clause strips trailing blanks from string literals that are concatenated with DBMS columns of type VARCHAR	E9BB80
SN-031862	A U1314 abend might occur when a job sorts an SQL procedure view that references a DB2 table	E9BC14
SN-016338	Using PROC APPEND to insert rows into an Oracle table may report an error as a note	E9BC57
SN-033648	ALERT - The implicit pass-through facility does not correctly switch argument order for the DB2 LOCATE() function when you pass the INDEX() function to DB2	E9BC63
SN-035895	An error occurred Executing the Workspace Job The server is disconnected message might occur if you run a job in SAS® Enterprise Guide®	E9BC90
SN-035991	A generic IOM error occurs when executing a stored process that produces graphics output	E9BC90
SN-036748	The MULTI_DATASRC_OPT= option is ignored when multiple WHERE clause predicates are used in an SQL join operation	E9BD09
SN-035879	ALERT - Data imported from a DB2 library may be corrupt	E9BD14
SN-039997	A database error can occur when you submit an SQL query with a LIBNAME statement that uses the MULTI_DATASRC_OPT=IN_CLAUSE option	E9BD33
SN-041748	Using the LIBNAME option MULTI_DATASRC_OPT=IN_CLAUSE can result in an error	E9BD46
SN-042030	Oracle PREPARE error issued when SAS table is empty and no keys are in the WHERE clause	E9BD48
Install Instructions: E9BD48h6.txt ( This Asian Language Support (DBCS) hot fix has post-installation requirements. Please review SN-038930 for more information. )
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD48. Download: E9BD48 for HPUX   (File Size: 573K)
ATTENTION (1): To complete the installation of this hot fix, you must also download and install SAS Base hot fixes E9BD42 and E9BD61. Download E9BD42 Download E9BD42 for SAS with Asian Language Support (DBCS) Download E9BD61 Download E9BD61 for SAS with Asian Language Support (DBCS) This hot fix will NOT be fully functional without E9BD42 and E9BD61 applied. ATTENTION (2): Oracle customers running on Solaris for X64 must download and install SAS Oracle hot fix E9OC11 and SAS Base hot fix E9BB64. Download E9OC11 Download E9OC11 for SAS with Asian Language Support (DBCS) Download E9BB64 Download E9BB64 for SAS with Asian Language Support (DBCS) ATTENTION (3): Oracle customers running on all other platforms must also download and install SAS Oracle hot fix E9OC15. Download E9OC15 Download E9OC15 for SAS with Asian Language Support (DBCS) ATTENTION (4): OpenVMS Alpha customers should install SAS BASE hot fix E9BD33. Download E9BD33

Top ^

E9BD55 for HPUX
Released: Apr 2011
Issue(s) Addressed:		Introduced:
SN-017704	ALERT - An update to ensure proper authentication logging on to an Integration Technology Server	E9BA16
SN-032805	Trusted Peer Connections between a SAS® process in a Windows environment and a Metadata Server in a z/OS environment run as public user connections	E9BB40
SN-020384	If your z/OS user ID begins with special characters, you cannot see pre-assigned libraries from SAS® Enterprise Guide® 4.1	E9BB40
SN-020418	"ACCESS DENIED" authentication error is not displayed as expected when the Metadata server using a Japanese version of Windows	E9BB40
SN-031165	IOM messages are truncated in the SAS® Metadata Server log	E9BB96
SN-034913	The SAS® Metadata Server stops responding if a long user ID or password is submitted for authentication	E9BC69
SN-034915	Submitting a blank user ID when logging in to the SAS® Metadata Server causes the server memory usage to increase suddenly	E9BC69
SN-040494	ALERT - A SAS/SHARE® server fails or does not respond when it is run as a Microsoft Windows service	E9BD37
SN-042456	You cannot access files on a SAS/SHARE® server	E9BD51
Install Instructions: E9BD55h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD55. Download: E9BD55 for HPUX   (File Size: 666K)
ATTENTION(1): To fully implement the fix for SN-041220, you must also download and install SAS Base hot fix E9BD54. The fix for the problem documented in this SAS Note will not be fully functional unless both E9BD54 and E9BD55 are applied. ATTENTION(2): OpenVMS Alpha customers should install SAS BASE hot fix E9BD62.

Top ^

E9BD56 for HPUX
Released: Jun 2011
Issue(s) Addressed:		Introduced:
SN-017667	ALERT - Segmentation Violation in task [ DATASETS ] using DELETE statement	E9BA13
SN-017072	Metadata server service might show starting state but never start	E9BA19
SN-020233	Increasing timeout value on UNIX may improve performance	E9BB32
SN-020274	Grid sign-on fails to honor the TCPPORTFIRST and the TCPPORTLAST options	E9BB36
SN-020438	Unix cleanwork utility does not remove UTILLOC directories	E9BB45
SN-019386	SAS/CONNECT may issue "Segmentation Violation In Task [ Program ]"	E9BB58
SN-020817	Using the JOBNAME= option to specify a job name in the GRDSVC_ENABLE call routine	E9BB58
SN-021112	A SAS/CONNECT® software session might result in orphaned processes on a remote UNIX server	E9BB75
SN-031719	Some components from version 6 of SAS/AF® software might cause a read-access violation with repeated use	E9BC09
SN-031795	Dragging the cursor to an unselected item within the Radio Box control can unexpectedly update the internal value for the unselected item	E9BC09
SN-031400	Resetting system time backwards causes negative "real time" value in STIMER output	E9BC09
SN-019028	Truncation errors might occur when using Unicode SAS with UTF-8 encoding to process 8-bit characters	E9BC18
SN-032113	The $EBCDIC format/informat generates incorrect results if ENCODING=UTF8 is set	E9BC18
SN-019330	Problems might occur when you invoke SAS® macros using Microsoft Object Linking and Embedding (OLE) automation submit method	E9BC18
SN-032096	ERROR "SAS Error Event: Error sending status, 1, to SCM. Error 6: The handle is invalid." occurs when stopping the SAS® Metadata Server	E9BC18
SN-032521	ALERT - A Multi-Processing (MP) CONNECT session might not respond in UNIX environments	E9BC18
SN-032547	Data sets written to tape in SAS® 8.2 are not readable in SAS® 9.1.3	E9BC18
SN-032945	On HP Integrity systems, SAS® 9.1.3 SP4 installation process hangs if memory page size has been set higher than 8Kb	E9BC30
SN-033403	Segmentation violation and bridge stub errors on AIX	E9BC60
SN-036130	Running large SQL queries in the AIX operating environment can generate results with missing values	E9BC60
SN-034651	Using a Japanese or DBCS character in a pathname may cause truncation of file name	E9BC67
SN-034955	The SAS® Metadata Server stops accepting new client connections and returns an error when too many files are open	E9BD12
SN-040822	Specifying the SAS® system option OPLIST may cause a segmentation violation error in the UNIX environment	E9BD41
SN-041361	Modification datetime stamp is changed on existing version of a SAS® data set when you create a new data set with same name	E9BD44
Install Instructions: E9BD56h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD56. Download: E9BD56 for HPUX   (File Size: 3.5M)
ATTENTION (1): To obtain the complete fix for SN-020817 and SN-019386 you must also download and install SAS/CONNECT hot fix E9CT05. The issues described in SN-020817 and SN-019386 will not be fully fixed until both E9BD56 and E9CT05 are applied. ATTENTION (2): To obtain the complete fix for SN-021112 you must also download and install SAS/ACCESS Interface to DB2 hot fix E9D216. The issue described in SN-021112 will not be fully fixed until both E9BD56 and E9D216 are applied. This is not applicable to z/OS sites. Customers running on VMS should download E9BD44. Customers running on Windows should download E9BD59.

Top ^

E9BD61 for HPUX
Released: Oct 2011
Issue(s) Addressed:		Introduced:
SN-017873	ALERT - Extra WHERE clause may get added to query passed to databases	E9BA31
SN-017888	Segmentation Violation error issued when using PROC SQL and SAS/ACCESS® with a LENGTH= option larger than 32	E9BA31
SN-018108	Segmentation violation when executing multiple queries against a PROC SQL view containing a LIBNAME statement	E9BA44
SN-018176	ALERT - Import of table through Information Map Library Engine deletes physical table	E9BA48
SN-020479	Batch jobs might end with a return code of 4 with no warning in the SAS® log	E9BA53
SN-018487	Compress() function returns incorrect results when used on PROC SQL INSERT statement after applying SAS® 9.1.3 Service Pack 4	E9BA53
SN-016074	"WARNING: At least one nonessential grouping column reference has been removed from a GROUP BY's reference list"	E9BA53
SN-019170	Errors issued when integer references for column is used in a PROC SQL GROUP BY statement	E9BA83
SN-019372	Performance is poor in the SQL procedure when you use the COUNT(Distinct xxxx) function	E9BB04
SN-019527	Specifying the NOIPASSTHRU option in PROC SQL does not disable implicit passthru	E9BB04
SN-016547	Correlated subqueries using column aliases may not be passed to your dbms when using SAS/ACCESS LIBNAME statement	E9BB10
SN-019930	Using more than 36 tables in a UNION operation within an SQL procedure generates an error message	E9BB26
SN-020130	Aliases columns or aliased tables in the SQL procedure blocks Implicit Pass-Through	E9BB29
SN-030428	Aliased constant values become missing in outer joins and unions	E9BB29
SN-020162	Using functions without parameters in WHERE clauses can block Implicit Pass-Through	E9BB29
SN-020126	SAS/ACCESS® software now provides full support of the INNER JOIN syntax	E9BB29
SN-020116	SAS/ACCESS® software fails to use table aliases correctly when you use in-line SELECT statements	E9BB29
SN-020123	Incorrect SQL text is generated when inner and left joins are used	E9BB29
SN-020125	Using implicit pass-through might cause an incorrect table reference assignment	E9BB29
SN-020129	An incorrect Implicit Pass-Through query is generated when you use a combination of inner and outer Joins	E9BB29
SN-020122	Performance issues occur because SQL code is not passed to the database	E9BB29
SN-030390	Improvements are now available in relational database optimization via the SQL procedure	E9BB70
SN-019655	Filter behavior inconsistent between SAS® Web Report Studio 3.1 and SAS® Information Map Studio	E9BB70
SN-020635	Incorrect textualization of SQL Implicit Pass-Through queries occurs when you combine multiple inner joins with one or more outer joins	E9BB70
SN-032085	Incorrect SQL optimization may produce incorrect results	E9BB76
SN-030942	The WHERE clause strips trailing blanks from string literals that are concatenated with DBMS columns of type VARCHAR	E9BB76
SN-030923	Aliased summary functions in Base SAS® software are not passed to databases	E9BB76
SN-030893	Using an ORDER BY clause in the SQL procedure causes performance problems	E9BB76
SN-031102	A segmentation-violation error might occur after you apply Hot Fix E9BA83 and you access Oracle	E9BB76
SN-031191	Support is now available for the PROC SQL CREATE TABLE statement for the SAS® Scalable Performance Data Server®	E9BB93
SN-031122	SQLPLAN internal errors might occur when you select columns from an SQL view	E9BB93
SN-031121	Implicit Pass-Through errors occur when accessing Oracle tables	E9BB93
SN-031291	Errors occur in SAS® Scalable Performance Data Server® for numeric columns that are defined with the MISSING statement when it is used in WHERE processing	E9BB99
SN-031211	Errors occur in the SQL procedure's Implicit Pass-Through facility after you apply hot fixes E9BB72, E9BB76, and E9BB80	E9BB99
SN-031249	SQLPLAN errors occur when you reference a calculated column on an SQL WHERE clause	E9BB99
SN-031905	Enhancements to the Implicit SQL Pass-Through facility enable more of a query to be passed to a database	E9BC11
SN-031863	ALERT - Using the EQT operator in the SQL procedure incorrectly classifies rows with missing values as a match	E9BC11
SN-031564	Performance problems occur when you use the CASE expression with DBMS tables	E9BC11
SN-031825	After applying hot fixes E9BB98 and E9BB99, column aliases are passed to the SQL GROUP BY clause in place of the corresponding real column names	E9BC11
SN-033763	Using the CALCULATED keyword in a WHERE clause in a PROC SQL inner join generates a cartesian product	E9BC25
SN-033649	Calculations that involve DBMS datetime values can return incorrect results	E9BC25
SN-033073	Using the CALCULATED keyword in a WHERE clause generates a Carteisan product	E9BC25
SN-032636	A Read-access violation might be generated after you apply hot fixes E9BB80, E9BB98, and E9BB99	E9BC25
SN-032537	ALERT - Incorrect query results might be generated after you apply hot fixes E9BB80, E9BB98, and E9BB99 or you run SAS® 9.2	E9BC25
SN-032925	An error occurs when you use the IDXNAME= and the WHERE= data set options in an SQL procedure query	E9BC32
SN-032472	Concatenating libraries can result in Read-access violations in the SQL procedure	E9BC32
SN-032545	An SQLPLAN error might occur after you apply hot fixes E9BB98 and E9BB99	E9BC32
SN-032406	Outer joins that contain a WHERE clause with the STRIP() and PUT() functions cause abnormal endings	E9BC32
SN-035779	The LENGTH= column modifier is handled incorrectly when you use PROC SQL to create character columns in SAS® Scalable Performance Data Server® tables	E9BC32
SN-034012	Column aliases are not passed correctly to GROUP BY or ORDER BY clauses in the SAS® Scalable Performance Data Server®	E9BC32
SN-032542	An error message incorrectly appears when you use the IDXNAME= and the WHERE= option data set options together in an SQL procedure	E9BC32
SN-011210	Incorrect results occur when you use a WHERE= option with indexed tables in the SQL procedure	E9BC46
SN-034564	The COUNT() or N() functions return incorrect results when used in a query containing a WHERE clause or a WHERE= data set option	E9BC46
SN-035011	A Read-access violation occurs in the SQL procedure when the WHERE= data set option is placed in an ORDER BY clause	E9BC46
SN-033094	ALERT - Incorrect results might be generated when you use the LIBNAME statement to join multiple Oracle tables	E9BC46
SN-033648	ALERT - The implicit pass-through facility does not correctly switch argument order for the DB2 LOCATE() function when you pass the INDEX() function to DB2	E9BC62
SN-034993	An error occurs when you run an SQL query with the ORACLE LIBNAME engine	E9BC62
SN-034975	Segmentation violations might occur after you apply Hot Fix E9BC46 in queries that reference DBMS tables	E9BC62
SN-034391	An SQLPLAN error might occur when you use a calculated field to subset a table	E9BC62
SN-036280	ALERT - The SQL procedure generates incorrect results when you copy a SAS® data set from one platform to another platform	E9BC94
SN-033084	An SQLPLAN internal error might occur when reference a variable from an in-line view that created the variable from a constant	E9BC94
SN-034678	An SQLPLAN error occurs when you submit a query with a CALCULATED column reference in a CASE expression that contains a GROUP BY clause	E9BC94
SN-036177	Incorrect results might occur when you run a PROC SQL join with an additional WHERE clause against Teradata tables	E9BC94
SN-036202	SQLPLAN internal errors might occur when you reference calculated columns in an SQL procedure	E9BC94
SN-036748	The MULTI_DATASRC_OPT= option is ignored when multiple WHERE clause predicates are used in an SQL join operation	E9BD08
SN-034153	Option DBIDIRECTEXEC prevents SAS® Enterprise Guide from opening tables created by PROC SQL	E9BD13
SN-034234	Incorrect results might occur if you use the LIBNAME statement option IP=YES with an SQL procedure that contains data calculations in a WHERE clause	E9BD13
SN-040951	Arithemetic performed on DATA and TIME data types is not passed to the underlying DBMS in SAS/ACCESS® 9.1.3 software	E9BD20
SN-038458	SQLPLAN internal errors might occur when you reference a view in a query that has variables that are defined with the the LENGTH= column modifier	E9BD20
SN-040492	Incorrect textualization of SQL Implicit Pass-Through queries occurs when you combine multiple inner joins with the UNION operator	E9BD20
SN-038519	Specifying both the DBSLICPARM= and the MULTI_DATASRC_OPT= options might generate incorrect results	E9BD26
SN-039304	SQL views of DBMS tables may not return aliased column names	E9BD26
SN-039129	Formatting a newly created, missing numeric variable might result in a "Format not found" error	E9BD32
SN-039125	An SQLPLAN error might occur when you use a new column variable in a correlated subquery	E9BD32
SN-039271	ALERT - Outer join condition may not appear on WHERE clause when performing query against Oracle	E9BD32
SN-039984	An SQL procedure view does not return any rows when it is used in DATA step or a PRINT procedure	E9BD43
SN-041785	Read Access Violation errors occur when creating a long macro variable with the PROC SQL / INTO: macro interface	E9BD43
SN-042030	Oracle PREPARE error issued when SAS table is empty and no keys are in the WHERE clause	E9BD47
SN-044069	Performance might be affected if your query joins multiple tables or views in which variables are being renamed	E9BD61
Install Instructions: E9BD61h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9BD61. Download: E9BD61 for HPUX   (File Size: 1.2M)
ATTENTION (1): E9BD61 for Windows is also available for the following languages: German, Spanish, French, Italian, Japanese, Polish, Simplified Chinese ATTENTION (2): Customers running SAS Base SQL must also download and install SAS Base hot fixes E9BD42 and E9BD48. Download E9BD42 Download E9BD42 for SAS with Asian Language Support (DBCS) Download E9BD48 Download E9BD48 for SAS with Asian Language Support (DBCS) ATTENTION (3): OpenVMS Alpha customers should install SAS BASE hot fix E9BD32. Download E9BD32

Top ^

SAS INTEGRATION TECHNOLOGIES

E9IH01 for HPUX
Released: Jul 2006
Issue(s) Addressed:		Introduced:
SN-017764	ALERT - Processing halted and Error dialog box displayed when reading IBM WebSphere MQ queue	E9IH01
Install Instructions: E9IH01h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9IH01. Download: E9IH01 for HPUX   (File Size: 102K)

Top ^

SAS/ACCESS INTERFACE TO ODBC

E9OD08 for HPUX
Released: May 2010
Issue(s) Addressed:		Introduced:
SN-037514	Support is now available for reading the MySQL LONGTEXT data type in SAS/ACCESS® Interface to ODBC	E9OD01
SN-018348	"Data truncated" warning issued using SAS/ACCESS® Interface to ODBC to access Informix data	E9OD01
SN-017463	Incorrect length assigned to character variables using SAS/ACCESS® Interface to ODBC and SAS 9.1.3 SP4	E9OD01
SN-018476	READBUFF setting not honored with certain SQL queries against a SAS/ACCESS® Interface to ODBC libref	E9OD02
SN-018538	"Error: DIAG[42000] [HP ODBC driver] ERROR [4118] The cursor query expression is not updatable. (-4118) when using HP ODBC driver SQL"	E9OD02
SN-018988	Netezza support for remote external tables interface for SAS/ACCESS® Interface to ODBC	E9OD03
SN-018990	Incorrect data inserted into DB2 column defined as "CHAR() FOR BIT DATA"	E9OD03
SN-018991	ALERT - Bulkloading into Microsoft SQL Server can lead to loss of precision	E9OD03
SN-019988	PROC DBLOAD fails to insert the correct number of rows when you use SAS/ACCESS® Interface to ODBC	E9OD04
SN-019994	SAS/ACCESS® Interface to ODBC has been enhanced to use the new DB2 API interface for bulk loading and importing data to DB2	E9OD04
SN-019990	A floating-point exception error can occur when you use SAS® Data Integration Studio 3.4 to update table metadata in the SAS/ACCESS® Interface to ODBC	E9OD04
SN-019995	Accessing SYBASE IQ tables with SAS/ACCESS® Interface to ODBC appears to freeze or is extremely slow	E9OD04
SN-019970	SAS/ACCESS® Interface to ODBC does not properly set the SYSDBRC and SYSDBMSG automatic macro variables when a Netezza load fails	E9OD04
SN-032370	DBLOAD procedure does not write non-English characters to Microsoft SQL Server Unicode Field	E9OD05
SN-016094	Invalid characters might display when use SAS/ACCESS® Interface to ODBC to connect a SAS Unicode server to a Unicode database	E9OD05
SN-033733	The LIBNAME statement’s QUALIFIER= option is not honored in subsequent PROC SQL SELECT statements that include the DISTINCT option and that are run against the same libref	E9OD06
SN-035182	The QUALIFIER= option is ignored when you use DISTINCT in a PROC SQL SELECT statement with a libref in SAS/ACCESS® Interface to DB2	E9OD06
SN-033148	An error message occurs when you connect to the HP Neoview database with the SAS/ACCESS® Interface to ODBC engine	E9OD06
SN-035971	An error occurs when you use SAS/ACCESS® Interface to ODBC to append data to a nonexistent DATAllegro table	E9OD07
SN-037477	An incorrect value might be inserted into an Oracle SMALLINT data type when you use SAS/ACCESS® Interface to ODBC on a Linux platform	E9OD08
Install Instructions: E9OD08h6.txt ( This Asian Language Support (DBCS) hot fix has post-installation requirements. Please review SN-038930 for more information. )
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9OD08. Download: E9OD08 for HPUX   (File Size: 1.6M)

Top ^

SAS/ACCESS INTERFACE TO R/3

D9R302 for HPUX
Released: Oct 2005
Issue(s) Addressed:		Introduced:
SN-015516	ALERT - The incorrect Xerces library for the SAS RFC server is installed on all UNIX hosts in SAS 9.1.3	D9R302
SN-016007	SAS/ACCESS 4.1 Interface to R/3 produces 'ERROR: Unexpected end of file'	D9R302
SN-016008	ERROR: Unexpected end of file generated when running SAS/ACCESS 4.1 Interface to R/3 batch extractions in parallel	D9R302
Install Instructions: D9R302h6.txt
Download: D9R302 for HPUX   (File Size: 48.8M)
ATTENTION (1): This hot fix should be applied to SAS/Access to R/3 4.1 only. It should not be applied to any other release of this product. ATTENTION (2): This hot fix can be applied to systems running either SAS 9.1.3 Service Pack 3 or SAS 9.1.3 Service Pack 4.

Top ^

SAS/ACCESS INTERFACE TO SYBASE

E9SB09 for HPUX
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: E9SB09h6.txt ( This Asian Language Support (DBCS) hot fix has post-installation requirements. Please review SN-038930 for more information. )
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9SB09. Download: E9SB09 for HPUX   (File Size: 881K)

Top ^

SAS/IML

E9ML03 for HPUX
Released: Sep 2009
Issue(s) Addressed:		Introduced:
SN-034587	ALERT - CALL EIGEN in the IML Procedure might modify the input matrix	E9ML03
Install Instructions: E9ML03h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9ML03. Download: E9ML03 for HPUX   (File Size: 102K)

Top ^

SAS/STAT

E9ST02 for HPUX
Released: May 2006
Issue(s) Addressed:		Introduced:
SN-013179	ALERT - Incorrect standard errors may occur when using the OFFSET option with the COVS option	E9ST02
SN-017530	ALERT - Incorrect sandwich estimate standard errors occur in PROC PHREG with the counting process (start, stop) syntax when using the COVS, OFFSET and MULTIPASS options	E9ST02
SN-017587	COVS option in PROC PHREG may cause missing standard errors, chisquare statistics, pvalues and hazard ratios	E9ST02
Install Instructions: E9ST02h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9ST02. Download: E9ST02 for HPUX   (File Size: 410K)

Top ^

E9ST08 for HPUX
Released: Mar 2007
Issue(s) Addressed:		Introduced:
SN-017255	ALERT - PROC MIXED can produce incorrect results for CONTRAST or ESTIMATE statement involving levels of random effects	E9ST05
SN-017503	ALERT - Incorrect results with RANDOM statement and TYPE=SP() when random effect involves a continuous effect	E9ST05
SN-017511	ALERT - Incorrect output when REPEATED statement uses TYPE=ANTE(1) and data not sorted by repeated effect within each subject	E9ST05
SN-019432	ALERT - Incorrect output possible with the GROUP= option on RANDOM statement	E9ST08
Install Instructions: E9ST08h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9ST08. Download: E9ST08 for HPUX   (File Size: 901K)

Top ^

E9ST09 for HPUX
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: E9ST09h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9ST09. Download: E9ST09 for HPUX   (File Size: 328K)

Top ^

E9ST10 for HPUX
Released: Apr 2009
Issue(s) Addressed:		Introduced:
SN-013510	Invalid reference value error if REF='level' used for two or more variables	E9ST03
SN-017517	SCALE= option may be ignored when PARAM=REF or PARAM=EFFECT is specified	E9ST03
SN-019162	Excessive time or memory required with many levels of CLASS variable	E9ST07
SN-016848	ALERT - Incorrect output statistics with DIST=MULT and full-rank CLASS coding	E9ST10
Install Instructions: E9ST10h6.txt
IMPORTANT! You must have SAS 9.1.3 Service Pack 4 installed on your system before installing E9ST10. Download: E9ST10 for HPUX   (File Size: 758K)

Top ^