When you run a SAS Stored Process, the SAS^® Stored Process Server might stop functioning properly when you execute SQL procedure code. In some cases, when you execute PROC SQL code (especially when you access database tables), a segmentation violation or an access violation can occur.

When that happens, you should try clearing the LIBNAME statements (library assignments). To clear the statements, add the following statement to the end of your SAS Stored Process code:

This statement closes all libraries that are allocated in this SAS Stored Process request. It does not close pre-assigned libraries.

There are also other scenarios that might cause a segmentation violation or an access violation to occur when you run PROC SQL code. Two such scenarios are discussed in the following SAS Notes:

• SAS Note 44257: "A segmentation violation might occur and your server might not function when you run a SAS^® Stored Process that accesses a database"
• SAS Note 45689: The SAS^® Stored Process Server might stop functioning properly if you cancel a request that is running PROC SQL code"

You can also search SAS Notes for similar issues by submitting the following keywords: proc sql violation