SAS WTABORT (EXPORT) The SAS System has detected an abort condition

hhchenfx — Fri, 15 Apr 2022 02:23:24 GMT

Hi Everyone,

When I export 2 SAS datasets to Excel, the first one goes fine, then I received the following error when the 2nd file is being exported.

The log below I got from my SAS running in batch.

Recently, when I manually run the export, sometime SAS automatically shutdown. In these instance, I dont have a log file to see what is going on.

Now I have the log. Can you please review and see what can I do to fix?

Thanks,

HHC

proc export data=m44_UP
outfile="C:\Users\OneDrive\........\file1_UP_&today..xlsx"
replace;
run;

proc export data=m44_DOWN
outfile="C:\Users\OneDrive \.........\file1_DOWN_&today..xlsx"
replace;
run;

NOTE: File "C:\Users\OneDrive\.......\file1_UP_20220414.xlsx" will be created if the export process succeeds.
NOTE: "M44_UP" range/sheet was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.33 seconds
cpu time 0.20 seconds

NOTE: File "C:\Users\OneDrive\......\file2_DOWN_20220414.xlsx" will be created if the export process succeeds.

ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:

The SAS task name is [EXPORT]
ERROR: Read Access Violation EXPORT
Exception occurred at (0795C006)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
000000000795C006 00000000096CB910 sasjet:tkvercn1+0xAFC6
0000000007D5DFF8 00000000096CB918 sasiojet:tkvercn1+0xCFB8
0000000007DF3828 00000000096CB9B8 sasxdbi:tkvercn1+0x427E8
0000000007DC77A1 00000000096CBA90 sasxdbi:tkvercn1+0x16761
0000000004919F84 00000000096CBA98 sasyh:tkvercn1+0x18F44
0000000004BB83C9 00000000096CBC18 sasxshel:tkvercn1+0x27389
0000000004B9344E 00000000096CC0C0 sasxshel:tkvercn1+0x240E
0000000004B919F5 00000000096CC150 sasxshel:tkvercn1+0x9B5
0000000004BBC332 00000000096CC2D0 sasxshel:tkvercn1+0x2B2F2
0000000004BE81C2 00000000096CC630 sasxshel:tkvercn1+0x57182
0000000004BEBDC4 00000000096CC720 sasxshel:tkvercn1+0x5AD84
116 The SAS System 17:12 Thursday, April 14, 2022

0000000004BE5015 00000000096CC7C0 sasxshel:tkvercn1+0x53FD5
0000000007771877 00000000096CC7C8 sasimdts:tkvercn1+0x837
000000000774372A 00000000096CC8C8 sasimode:tkvercn1+0x26EA
0000000005584497 00000000096CE9C8 sasimctr:tkvercn1+0x3457
00000000055817FB 00000000096CF820 sasimctr:tkvercn1+0x7BB
00000000055612B0 00000000096CF828 sasexpor:tkvercn1+0x270
000000000349A066 00000000096CF9B8 sashost:Main+0x11BA6
00000000034A011D 00000000096CFD20 sashost:Main+0x17C5D
00007FF842F97034 00000000096CFD28 KERNEL32:BaseThreadInitThunk+0x14
00007FF844BA2651 00000000096CFD58 ntdll:RtlUserThreadStart+0x21

SAS WTABORT (EXPORT) The SAS System has detected an abort condition. An Exception occurred
during wthtrm().
Please Contact Technical Support.

Tasks

[MAIN ] [WAITING ] pri[ 5] reb[03366E40] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[03366E40]
[EVENTTSK] [WAITING ] pri[ 0] reb[03366E40] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[03366E40] WC[0] WN[1]
[SGIOREAD] [WAITING ] pri[ 3] reb[03366E40] WC[0] WN[1]
[SGIOWRIT] [WAITING ] pri[ 3] reb[03366E40] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[04C77FA0] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[04C78620] WC[0] WN[1]
[Program ] [WAITING ] pri[ 7] reb[04C79140] WC[0] WN[1]
[SASODR ] [WAITING ] pri[ 3] reb[0816F2C0] WC[0] WN[1]
[EXPORT ] [RUNNING ] pri[ 7] reb[0816DD40]
Traceback
SASTBTraceBackCtx has been called with a
string ("vacrash") instead of a CONTEXT pointer.
Address Frame (DBGHELP API Version 4.0 rev 5)
00007FF842354F69 00000000096C9760 KERNELBASE:RaiseException+0x69
0000000010055F3B 00000000096C9768 tkmk:tkBoot+0x541EB
0000000010055D09 00000000096C9CB0 tkmk:tkBoot+0x53FB9
000000001004A15A 00000000096C9D00 tkmk:tkBoot+0x4840A
00000000034912D9 00000000096C9D08 sashost:Main+0x8E19
00000000034821C4 00000000096C9DB0 sashost:rtmdoit+0x234
0000000003495F8F 00000000096C9F30 sashost:Main+0xDACF
0000000003499A10 00000000096CA0E0 sashost:Main+0x11550
000000000349FEAA 00000000096CA6B0 sashost:Main+0x179EA
000000000349F6B9 00000000096CA9D0 sashost:Main+0x171F9
00000000034A0140 00000000096CAA00 sashost:Main+0x17C80
000000000360351F 00000000096CAA70 sashost:tkStartSas+0xB67F
00007FF844BF20CF 00000000096CAA78 ntdll:_chkstk+0x11F
00007FF844BA1454 00000000096CB1B0 ntdll:RtlRaiseException+0x434
00007FF844BF0BFE 00000000096CB8D0 ntdll:KiUserExceptionDispatcher+0x2E
000000000795C006 00000000096CB8D8 sasjet:tkvercn1+0xAFC6
0000000007D5DFF8 00000000096CB918 sasiojet:tkvercn1+0xCFB8
0000000007DF3828 00000000096CB9B8 sasxdbi:tkvercn1+0x427E8
117 The SAS System 17:12 Thursday, April 14, 2022

0000000007DC77A1 00000000096CBA90 sasxdbi:tkvercn1+0x16761
0000000004919F84 00000000096CBA98 sasyh:tkvercn1+0x18F44
0000000004BB83C9 00000000096CBC18 sasxshel:tkvercn1+0x27389
0000000004B9344E 00000000096CC0C0 sasxshel:tkvercn1+0x240E
0000000004B919F5 00000000096CC150 sasxshel:tkvercn1+0x9B5
0000000004BBC332 00000000096CC2D0 sasxshel:tkvercn1+0x2B2F2
0000000004BE81C2 00000000096CC630 sasxshel:tkvercn1+0x57182
0000000004BEBDC4 00000000096CC720 sasxshel:tkvercn1+0x5AD84
0000000004BE5015 00000000096CC7C0 sasxshel:tkvercn1+0x53FD5
0000000007771877 00000000096CC7C8 sasimdts:tkvercn1+0x837
000000000774372A 00000000096CC8C8 sasimode:tkvercn1+0x26EA
0000000005584497 00000000096CE9C8 sasimctr:tkvercn1+0x3457
00000000055817FB 00000000096CF820 sasimctr:tkvercn1+0x7BB
00000000055612B0 00000000096CF828 sasexpor:tkvercn1+0x270
000000000349A066 00000000096CFCF0 sashost:Main+0x11BA6
00000000034A011D 00000000096CFD20 sashost:Main+0x17C5D
00007FF842F97034 00000000096CFD28 KERNEL32:BaseThreadInitThunk+0x14
00007FF844BA2651 00000000096CFDD0 ntdll:RtlUserThreadStart+0x21

ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.28 seconds
cpu time 0.28 seconds

ERROR: Errors printed on pages 115,116,117.

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 9:01.08
cpu time 8:25.23

Re: SAS WTABORT (EXPORT) The SAS System has detected an abort condition

japelin — Fri, 15 Apr 2022 02:43:32 GMT

Is the space after OneDrive in the code you provided Typo?

If you do not export m44_UP but only m44_DOWN, does the same situation occur?

Does this occur even if I delete the existing Excel files file1_UP_&today..xlsx and file1_DOWN_&today..xlsx before executing?

I would suggest contacting SAS Technical Support, though, since the address for Traceback is output.

Re: SAS WTABORT (EXPORT) The SAS System has detected an abort condition

hhchenfx — Fri, 15 Apr 2022 14:48:09 GMT

Thank you for your comment.

I re-run the code and it works correctly.

I will check with the tech support.

HHC

topic SAS WTABORT (EXPORT) The SAS System has detected an abort condition in SAS Programming

SAS WTABORT (EXPORT) The SAS System has detected an abort condition

Re: SAS WTABORT (EXPORT) The SAS System has detected an abort condition

Re: SAS WTABORT (EXPORT) The SAS System has detected an abort condition