Problem Note 62519: A DATASETS procedure that requests a large number of Oracle tables from SAS® Federation Server takes a long time to complete
 |  |  |  |  |
When you submit code that is similar to the following example, the processing time for the procedure is slower than expected:
options metaserver="address" metaport=number metauser="user-id" metapass="password";
libname libref fedsvr dsn=oradsn server="federation-server-address" port=number;
proc datasets lib=libref;
quit;
libname libref fedsvr dsn=oradsn server="federation-server-address" port=number;
proc datasets lib=libref;
quit;
Note: Quotation marks in the syntax are optional; use them when the values contain special characters, such as an at sign (@).
This issue occurs when you request Oracle tables via SAS Federation Server.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| HP-UX IPF | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
A fix for this issue for SAS Threaded Kernel Extension for Oracle 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C8W.html#62519A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#62519
When you use PROC DATASETS to retrieve data from the FEDSVR library, the processing time is slower than expected.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-08-14 13:41:19 |
| Date Created: | 2018-06-25 13:59:19 |