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:

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:

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

A fix for this issue for SAS Size Optimization 3.41 is available at:

A fix for this issue for SAS Revenue Optimization 5.4 is available at:

A fix for this issue for SAS Size Optimization 3.4 is available at: