| D9T036 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64417 | In-database procedures require engine-specific definitions for SQL syntax requirements |
D9T036 |
NOTE: If you install this hot fix, you must also install hot fixes D9T029, D9T041, and D9T051 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y001.
If you install this hot fix and have SAS Threaded Kernel In-Database Supervisor 9.41_M4 installed, you must also install hot fix F6B001. |
|
|
| D9T041 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63630 | Performance issues or an ORA-01841 error might occur when you query a database management system (DBMS) table |
D9T008 |
| 64417 | In-database procedures require engine-specific definitions for SQL syntax requirements |
D9T035 |
| 64422 | A new environment variable, SAS_PRESERVE_EMPTY_STRING, provides options for the behavior when a blank or empty string is encountered |
D9T035 |
| 63320 | SAS® Federation Server does not translate the DATE format as documented for a view (DSN=BASE) created from database tables |
D9T041 |
NOTE: If you install this hot fix, you must also install hot fixes D9T029, D9T036, D9T051, and D9T042 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y001.
If you install this hot fix and have SAS Threaded Kernel In-Database Supervisor 9.41_M4 installed, you must also install hot fix F6B001. |
|
|
| D9T042 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63831 | Transcoded Oracle data is truncated incorrectly by the SAS® Federation Server LIBNAME (FEDSRV) engine |
D9T013 |
| 63320 | SAS® Federation Server does not translate the DATE format as documented for a view (DSN=BASE) created from database tables |
D9T042 |
| 64387 | The APPEND procedure generates the error "Cannot insert into readonly column column-ID" when you access data through SAS® Federation Server |
D9T042 |
| NOTE: If you install this hot fix, you must also install hot fix D9T041 for Base SAS 9.4_M6. |
|
|
| D9T044 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64130 | The error "Internal error. Failed to get disked NAMESTR from hptgetdiskvarno" occurs when you access an SPD Engine data set |
D9T044 |
NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, you must also install hot fix D9T051.
If you install this hot fix and have SAS Threaded Kernel Components for Scalable Performance Data 9.41_M6 installed, you must also install hot fix F8U001.
If you install this hot fix and have SAS Threaded Kernel Drivers for Scalable Performance Data 5.3_M3 installed, you must also install hot fix F8T001. |
|
|
| D9T049 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 60730 | Initialization of SAS® shows system abend 0C4 when there are more than 16 CPs |
D9T010 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
D9T022 |
| 64237 | "ERROR:The requested LPAR name...does not match the actual LPAR name" occurs when you run sub-capacity setinits and apply IBM security patches (APARs) |
D9T032 |
| 64580 | The SAS/SHARE® server might improperly validate user access to SAS® data sets |
D9T047 |
| 60629 | When you use the DFSORT configuration option, "ERROR: in dynamic allocation for DDname XXXX (rc=0 error=0000 reason=0000)" occurs |
D9T049 |
| NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, you must also install hot fix D9T051. |
|
|
| D9T051 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63688 | Using the ODS EXCEL and ODS POWERPOINT destinations with SAS/IntrNet® software in SAS® 9.4M6 (TS1M6) generates errors |
D9T017 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
D9T020 |
| 63295 | A SAS® session can stop working in a Microsoft Windows operating environment due to incorrect syntax for an %IF macro statement in open code |
D9T025 |
| 63508 | An application that is executed multiple times ends with an exception |
D9T025 |
| 64160 | Access methods that govern when Python can be executed from SAS® code |
D9T027 |
| 64417 | In-database procedures require engine-specific definitions for SQL syntax requirements |
D9T037 |
| 64422 | A new environment variable, SAS_PRESERVE_EMPTY_STRING, provides options for the behavior when a blank or empty string is encountered |
D9T037 |
| 64430 | The IMPORT procedure fails in SAS when you use the GUESSINGROWS=MAX option or a high value for the argument in the GUESSINGROWS= statement |
D9T040 |
| 64130 | The error "Internal error. Failed to get disked NAMESTR from hptgetdiskvarno" occurs when you access an SPD Engine data set |
D9T043 |
| 63624 | An unpaired quotation mark in a LIBNAME statement generates the message "Error: Buffer overrun occurred" |
D9T051 |
| 64651 | The error "The text expression length . . . exceeds maximum length" appears after using a %SUPERQ function and a text-string value greater than 32K |
D9T051 |
NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, for UNIX you must also install hot fix D9T056 and
for MVS you must also install hot fix D9T049.
If you install this hot fix, you must also install hot fixes D9T029, D9T041, and D9T036 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Message Passing Interface 2.82 installed, you must also install hot fix E8Y002.
If you install this hot fix, you must also install hot fix E2G005 for SAS Threaded Kernel 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y001.
If you install this hot fix and have SAS Threaded Kernel In-Database Supervisor 9.41_M4 installed, you must also install hot fix F6B001. If you install this hot fix and have SAS Threaded Kernel In-Database Supervisor 9.41_M4 installed, you must also install hot fix F6B001.
If you install this hot fix and have Base SAS 9.4_M6 installed, you must also install hot fix D9T044.
If you install this hot fix and have SAS Threaded Kernel Components for Scalable Performance Data 9.41_M6 installed, you must also install hot fix F8U001.
If you install this hot fix and have SAS Threaded Kernel Drivers for Scalable Performance Data 5.3_M3 installed, you must also install hot fix F8T001. |
|
|
| D9T054 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63923 | An enhancement to the SAS® system option SQLIPONEATTEMPT prevents further attempts to run a query if an error occurs while the query is running |
D9T007 |
| 63940 | Subsetting a view in SAS® 9.4M5 (TS1M5) with a comparison operator that contains an equal sign and colon (=:) returns different results than expected |
D9T007 |
| 64015 | A memory leak occurs after multiple CONNECT and DISCONNECT statements when you use the SQL procedure with explicit pass-through |
D9T007 |
| 64342 | Performance degradation might occur when you use a PROC SQL query to access SAS® Scalable Performance Data Server 5.4 |
D9T029 |
| 64343 | A PROC SQL query that joins multiple Hive tables results in "Execute error: Error while compiling statement: FAILED: SemanticException[Error 10017]" |
D9T029 |
| 64344 | A new SAS/ACCESS® Interface to Snowflake product is available as an add-on to SAS® 9.4M6 (TS1M6) in Rev. 940_19w34 or to SAS® Viya® 3.4 (19w34) |
D9T029 |
| 64345 | A new SAS/ACCESS® Interface to Google BigQuery product is available as an add-on to SAS® 9.4TS1M6 in Rev. 940_19w34 or to SAS® Viya® 3.4 (19w34) |
D9T029 |
| 64422 | A new environment variable, SAS_PRESERVE_EMPTY_STRING, provides options for the behavior when a blank or empty string is encountered |
D9T029 |
| 64528 | Aggregate functions are not passed down through an implicit pass-through query to Apache Hive |
D9T045 |
| 64592 | "ERROR: The SQL statement contains a UDF that is not being passed to the database" occurs with Hadoop queries that contain user-defined functions |
D9T045 |
| 65036 | SAS® Customer Intelligence queries to five or more joined DBMS tables take a long time to execute |
D9T045 |
| 64819 | A DATA step that executes a PROC SQL view with a WHERE clause does not select the index |
D9T054 |
| 64931 | An incorrect index is selected by the SQL procedure when the number of distinct values exceed 2147483647 (2 GiB - 1) |
D9T054 |
NOTE: If you install this hot fix, you must also install hot fixes D9T041, D9T036, and D9T051 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y001.
If you install this hot fix and have SAS Threaded Kernel In-Database Supervisor 9.41_M4 installed, you must also install hot fix F6B001. |
|
|
| D9T056 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63389 | Code that sets consecutive SYSTASK commands stops executing after about 6,481 consecutive attempts |
D9T003 |
| 63200 | Importing a CSV file with UTF-16LE encoding and TERMSTR=CRLF can result in data loss |
D9T005 |
| 63941 | The NOHPRUSERFILES option is available as a restricted option in SAS® High-Performance Risk 4.2 |
D9T016 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
D9T019 |
| 63143 | Windows Defender Credential Guard and SAS® Software |
D9T026 |
| 64207 | A segmentation violation occurs after you submit SYSTASK and WAITFOR statements repeatedly within a macro loop |
D9T028 |
| 64580 | The SAS/SHARE® server might improperly validate user access to SAS® data sets |
D9T046 |
| 64979 | ALERT - An uninstallation of SAS® 9.4 using SAS® Deployment Manager fails with the error "A problem was encountered while uninstalling..." |
D9T056 |
NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, you must also install hot fix D9T051.
If you install this hot fix and have SAS Threaded Kernel Message Passing Interface 2.82 installed, you must also install hot fix E8Y002.
If you are on MVS please install D9T022. |
|
|
| E3R003 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63524 | The PROC S3 PUT statement fails with a segmentation violation or write thread errors |
E3R001 |
| 64079 | The message "HTTP/1.1 400 Bad Request" occurs when you run PROC S3 on Amazon Elastic Compute Cloud (Amazon EC2) |
E3R002 |
| 64158 | PROC S3 PUT fails with the message "ERROR: tks3ConnectionUploadPart..." |
E3R002 |
| 64690 | The message "The SAS System stopped processing this step because of errors" occurs when you use IAM role security credentials with PROC S3 |
E3R003 |
|
|
| F1E005 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63389 | Code that sets consecutive SYSTASK commands stops executing after about 6,481 consecutive attempts |
F1E001 |
| 63200 | Importing a CSV file with UTF-16LE encoding and TERMSTR=CRLF can result in data loss |
F1E001 |
| 63941 | The NOHPRUSERFILES option is available as a restricted option in SAS® High-Performance Risk 4.2 |
F1E001 |
| 63846 | CALL MODULE routines fail with the message "ERROR: Module module-name is not in whitelist..." when you use Kerberos Constrained Delegation |
F1E001 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
F1E001 |
| 64207 | A segmentation violation occurs after you submit SYSTASK and WAITFOR statements repeatedly within a macro loop |
F1E002 |
| 63143 | Windows Defender Credential Guard and SAS® Software |
F1E003 |
| 64580 | The SAS/SHARE® server might improperly validate user access to SAS® data sets |
F1E004 |
| 64979 | ALERT - An uninstallation of SAS® 9.4 using SAS® Deployment Manager fails with the error "A problem was encountered while uninstalling..." |
F1E005 |
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
| G1J001 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64671 | The FCMP procedure in a DBCS-encoded session for SAS® 9.4M6 (TS1M6) truncates the return length value to 8 bytes |
G1J001 |
NOTE: This hot fix applies to SAS components SAS Compiler and Symbolic Differentiator 9.46 (cmp) and SAS Thread-safe Compiler and Symbolic Differentiator 9.47 (tkcmp). For instructions for how to determine the release of these components you have installed see SAS Note 35968.
|
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
Important changes to Hot Fixes!