When you run code on the SAS^® Stored Process Server or on the SAS/IntrNet^® application server, a segmentation violation (or access violation) might occur. The problem happens when the code accesses a database and tracing is turned on (via the SASTRACE= option).

In particular, the problem happens when a SAS Stored Process uses SQL procedure code to access an Oracle, Netezza, DB2, Microsoft SQL Server, or Teradata database. (It is possible, too, that other databases might experience this problem.)

In some cases, the server also might stop functioning after the problem occurs. When the server stops, the SAS Stored Process log file might contain a message similar to the following before the segmentation violation occurs:

ORACLE_25: Prepared: on connection 0
SELECT * FROM SOMELIB.SOME_TABLE_HERE

You can either work around this problem or you can download a hot fix.

Click the Hot Fix tab in this note to access the hot fix for this issue.

If you prefer to use the workaround, you need to locate and remove the following OPTIONS statement from your code:

Note: If you are not sure whether tracing is turned on (because, for example, you either do not have access to the code or you have a very large amount of code to search), the following technique can be helpful. Add the following statements to the code that is experiencing the segmentation violation:

These statements generate output that indicates whether tracing is on. When tracing is on, the SASTRACE= option appears in the output with a non-blank character value (for example, ",,,d"). In that case, you (or whoever maintains the affected code) should locate and remove the appropriate OPTIONS statement.

If you experience the problem described in this note but the workaround shows that tracing is not turned on, contact SAS Technical Support for further help.

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M3 is available at:

A fix for this issue for Base SAS 9.3 is available at:

A fix for this issue for Base SAS 9.3_M1 is available at: