Symptom
SAP Data Services jobs fails with the following error message during bulk loading
System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
Call stack:
0x000000005F31BE06, SQLGetData()+55142 byte(s)
0x000000005F35DE14, bcp_initW()+0164 byte(s)
0x00000000E43C804C, MsDB::bulk_copy_init()+0140 byte(s)
0x00000000E4787C7A, MsSQLBulkBCPLoader::bulk_copy()+1338 byte(s)
0x00000000E478AC7F, MsSQLBulkBCPLoader::execute()+0095 byte(s)
0x00000000E498B81E, XTran_desc::execute()+0350 byte(s)
0x00000000E479F934, Rww_thread::main()+0148 byte(s)
0x00000000F4CF538F, RWThreadFunctionImp::run()+0127 byte(s)
0x00000000F4CE679E, RWRunnableImp::exec()+0270 byte(s)
0x00000000F4CF6B63, RWThreadImp::exec()+0051 byte(s)
0x00000000F4CF5649, RWThreadImp::~RWThreadImp()+0249 byte(s)
0x00000000F596CD70, o__realloc_base()+0096 byte(s)
0x00000000773259CD, BaseThreadInitThunk()+0013 byte(s)
0x000000007748383D, RtlUserThreadStart()+0029 byte(s)
Registers:
RAX=0000000000000001 RBX=0000000000000000 RCX=0000000000000000 RDX=00000000078D9BB0 RSI=0000000000000000
RDI=0000000007B51C60 RBP=0000000000000000 RSP=000000000895CD70 RIP=000000005F31BE06 FLG=0000000000010206
R8=0000000000000000 R9=0000000000000000 R10=000000000895CDF8 R11=000000000895CD90 R12=0000000000000000
R13=00000000FFFFFFFF R14=00000000078D9BB0 R15=0000000000000000
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 000000005F31BE06 01:000000000016AE06 C:\Windows\system32\sqlncli11.dll
Error 2
DBS-070402: |Data flow <>|Loader <>ODBC data source <> warning message for operation <bcp_init>: <[Microsoft][ODBC SQL Server Driver]Connection is not enabled for BCP>, SQLState <HY000>.
Read more...
Environment
- Microsoft SQL Server
- All Supported platforms
- SAP Data Services 4.3
Product
Keywords
SAP Data Services, ACCESS_VIOLATION, SQLGetData, bcp_initW, MsDB::bulk_copy_init(), MsSQLBulkBCPLoader::bulk_copy(), MsSQLBulkBCPLoader::execute(), XTran_desc::execute(), Rww_thread::main(), RWThreadFunctionImp::run(), sqlncli11.dll , DBS-070402, bcp_init , KBA , EIM-DS-EXE , Job Execution , EIM-DS-CON , Connectivity , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview