Faulting Application SQLLDR.EXE, Faulting Module MSVCR80.DLL

(Doc ID 1907532.1)

Last updated on JULY 16, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Generic Windows

Symptoms

o  Sql*Loader is executed at least 70000 times per day using DIRECT=TRUE and PARALLEL=TRUE to load CSV files and 16 billion records per day.  Each sqlldr execution uses only one CSV file from a shared LUN on an external SAN. One time every 2-3 days, a Windows message appears with the error:

"Faulting application sqlldr.exe, version 0.0.0.0, faulting module
msvcr80.dll, version 8.0.50727.4053, fault address 0x000000000002a696.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."


o  In this case, the Sql*Loader doesn't return the result and the log is empty. A FATAL ERROR code is returned.

o  Creating a User-Mode Dump for the sqlldr failure using Process Explorer which invoke automatically Microsoft Windows Debugging Tool, the following stack is generated:

 > kb
 RetAddr           : Args to Child                                            
               : Call Site
 00000000`77dc0614 : 00000000`00000000 00000000`00000001 00000000`00103440
 00000000`0000957c : ntdll!NtWaitForMultipleObjects+0xa
 00000000`7813b145 : 00000000`00000010 00000000`00000000 00000000`00000000
 00000000`00000000 : kernel32!UnhandledExceptionFilter+0xa34
 00000000`7815a696 : 00000000`00000000 00000000`00000000 00000000`00000000
 00000000`00103f30 : msvcr80!_invalid_parameter+0xc5
 [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\invarg.c  88]
 00000001`80186192 : 00000000`00000003 0000494f`e9734c01 00000000`0437f124
 00000000`0437f298 : msvcr80!_close+0x96
 [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\close.c  48]
 00000001`4000ce40 : 00000000`0437f298 00000000`000001f4 00000000`0437f124
 00000000`0000000e : oracommon11!sllfcf+0x50
 00000001`4000d82c : 00000000`00000000 00000000`04e47f70 00000000`00001001
 00000000`0000001e : sqlldr!ulerr+0x796
 00000001`400424d7 : 00000000`00000061 00000000`042c0080 00000000`00000000
 00000000`0000000e : sqlldr!ulerrsllf+0x12e
 00000001`40056cb2 : 00000000`00000000 00000000`043808e0 00000000`0436cec8
 00000000`00000000 : sqlldr!ulfndf+0x3fd
 00000001`40037d57 : 00000000`ffffffff 00000000`04e55ac0 00000000`04e558d0
 00000000`04e58e00 : sqlldr!ulndwr+0xac
 00000001`400060ca : 39333133`3332392d 32323938`34353335 00006c74`632e3035
 00000000`00428863 : sqlldr!uldlm+0xbc1
 00000001`40004283 : 00000000`04349fe0 00000001`40083ba8 00000001`40083ec0
 00000000`04307fa8 : sqlldr!ulmain+0x5088
 00000001`4000102c : 00000000`00000000 00000000`78131b3f 00000000`00000000
 00000000`00369e99 : sqlldr!ulmain+0x3241
 00000001`40082180 : 00000000`00130000 00000dea`e6f5788e 00000000`00000000
 00000000`00000000 : sqlldr!main+0x1e
 00000000`77d5964c : 00000000`00000000 00000000`00000000 00000000`00000000
 00000000`0012ffa8 : sqlldr!__tmainCRTStartup+0x120
 [f:\sp\vctools\crt_bld\self_64_amd64\crt\src\crtexe.c  597]
 00000000`00000000 : 00000001`40082300 00000000`00000000 00000000`00000000
 00000000`00000000 : kernel32!BaseProcessStart+0x29

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms