Problem Note 63571: SOAP requests might have poor performance in SAS® Pack Optimization
 |  |  |  |  |
In SAS Pack Optimization, the processing of SOAP requests might perform poorly. This issue is likely to occur when there are a large number of old request records in the PROCESS_STATUS table.
You can identify the number quantity of old request records in the table by running the following query in a SAS session where the MI libraries are allocated. For example, if you want to determine the number of records older than January 01, 2019, then run a query similar to the following:
SELECT COUNT (*) FROM DI_DM2.PROCESS_STATUS
WHERE START_DTTM < '01JAN2019:00:00:00'dt;
QUIT;
It is recommended that you clean up this table on a regular basis.
In addition to cleaning up the PROCESS_STATUS table, you can also add the following alternate indexes by running the SQL below directly in ORACLE in your DI_DM instance:
CREATE INDEX PROC_STATUS_IX3 on DI_DM.PROCESS_STATUS (CONTEXT_SK);
The addition of these indexes prevents full table scans on the PROCESS_STATUS table when processing SOAP requests.
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 Pack Optimization | Microsoft® Windows® for x64 | 3.41 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise 32-bit | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Enterprise x64 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Pro 32-bit | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Pro x64 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Pro x64 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows 10 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 R2 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 for x64 | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 Datacenter | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 R2 Std | 3.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 Std | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Enterprise 32 bit | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Enterprise x64 | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Home Premium 32 bit | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Home Premium x64 | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Professional 32 bit | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Professional x64 | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Ultimate 32 bit | 3.41 | 9.4 TS1M4 | ||||
| Windows 7 Ultimate x64 | 3.41 | 9.4 TS1M4 | ||||
| Linux for x64 | 3.41 | 9.4 TS1M4 | ||||