Problem Note 32364: Segmenation violation occurs when creating Access tables from sas datasets with date values using the ACCESSCS engine
A segmentation violation occurs in a task DATA step when you use the SAS PC Files Server ACCESSCS engin to create Microsoft Access (MBD) tables. The problem occurs when both of the following conditions exist:
- You have variables that are formatted as dates.
- The value for the INSERTBUFF= option is 1.
The following sample code that replicates the problem:
libname test pcfiles path='c:\sastest\baseball.mdb'
server='server-name' port=8621 insertbuff=2;
data temp1;
input mydates date9.;
format mydates date9.;
datalines;
25jun2006
27aug2007
;
data test.mytable2;
set temp1;
run;
quit;
libname test clear;
The violation occurs because of a problem with the INSERTBUFF= option. To circumvent the problem, set the INSERTBUFF parameter to 1. However, be aware that performance will decrease.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Linux | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
A segmenation violation in task datastep will occur when using the ACCESSCS engine to create MDB tables in an access database when INSERTBUFF is set greater than 1.
| Type: | Problem Note |
| Priority: | |
| Date Modified: | 2009-10-21 12:43:36 |
| Date Created: | 2008-06-04 12:18:47 |
