Problem Note 59983: Retrieving more than a million records using SAS/ACCESS® Interface to the PI System under UNIX returns a segmentation violation error
 |  |  |  |  |
When you run SAS/ACCESS Interface to the PI System on Linux or UNIX operating systems, you might get a segmentation violation error similar to the one shown below:
Please contact technical support and provide them with the following traceback
information:
The SAS task name is [DATASTEP]
Segmentation Violation
You see this error when you are trying to retrieve more than a million PI Point (tag) records using the PISYSTEM engine.
Note: The number of records you try to retrieve before you encounter this problem varies depending on your available system memory.
The problem occurs because SAS/ACCESS Interface to the PI System calls PI Web API to retrieve data from a PI server when it runs on Linux or UNIX. The problem is caused by a memory leak in the PI Web API, which is fixed in SAS® 9.4 TS1M5. You do not encounter this problem when you run SAS/ACCESS Interface to the PI System under Windows, because it calls PI SDK API instead of PI Web API.
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/ACCESS Interface to the PI System | 64-bit Enabled AIX | 9.43 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.43 | 9.4 TS1M5 | ||||
| HP-UX IPF | 9.43 | 9.4 TS1M5 | ||||
| Linux for x64 | 9.43 | 9.4 TS1M5 | ||||
| Solaris for x64 | 9.43 | 9.4 TS1M5 | ||||