SAP Data Services occurred - Process dump option is off

[former_member562470]

Hi all,

We are facing Access Violation error in one of our jobs. Everytime it is coming up in same job and in same dataflow. However after re-running the job for 2 or 3 times it is completing successfully. Below are the log:

System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
Call stack:
0x00000000A0842FF6, SQLDisconnect()+300438 byte(s)
0x00000000A0838D14, SQLDisconnect()+258740 byte(s)
0x00000000A083760E, SQLDisconnect()+252846 byte(s)
0x00000000A08742E3, SQLExecute()+0467 byte(s)
0x00000000B603676E, SQLExecute()+0894 byte(s)
0x0000000080195094, ConnODBC::SQLExecute()+0132 byte(s),


d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\conn\connodbc.cpp, line 2411+0009 byte(s)
0x000000008038F77C, OdbcDB::pureExecSql()+0892 byte(s),
d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\dbspec\odbcdb.cpp, line 3933+0040 byte(s)
0x00000000806C6C50, LoadDB::execute_param_load()+0320 byte(s),
d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\loader\loaddb.cpp, line 2640
0x00000000806C9924, LoadDB::execute_for_real()+0276 byte(s),
d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\loader\loaddb.cpp, line 2567
0x00000000806CD610, LoadDB::execute()+2000 byte(s),
d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\loader\loaddb.cpp, line 2231
0x00000000801C8200, XTran_desc::execute()+0448 byte(s),
d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0812
0x000000008117E729, Rww_thread::main()+0249 byte(s),
d:\im_ds_4.2_sp07_patch_rel\src\dataservices\dataintegrator\codeline\code\src\rww\rww.cpp, line 0452


0x0000000000A7438E, RWThreadFunctionImp::run()+0126 byte(s)
0x0000000000A5C184, RWRunnableImp::exec()+0372 byte(s)
0x0000000000A74643, RWThreadImp::exec()+0051 byte(s)
0x0000000000A75F59, RWThreadImp::_setTimeSliceQuantum()+0169 byte(s)
0x00000000666837D7, endthreadex()+0071 byte(s)
0x0000000066683894, endthreadex()+0260 byte(s)
0x00000000C29713D2, BaseThreadInitThunk()+0034 byte(s)
0x00000000C4F154F4, RtlUserThreadStart()+0052 byte(s)


Registers:
RAX=0000000000000000  RBX=000000000BDBD4B8  RCX=000000000BDBD4B8  RDX=000000000B3C40A0  RSI=0000000000000000
RDI=000000000B3E91E0  RBP=000000000BDBD4E0  RSP=000000000BDBD410  RIP=00000000A0842FF6  FLG=0000000000010256
R8=00000000000008DE   R9=0000000000000035  R10=000000000CFA80B0  R11=0000000000000000  R12=0000000000000000
R13=000000000040B6B0  R14=0000000000000005  R15=000000000040CEF8


Exception code: C0000005 ACCESS_VIOLATION
Fault address:  00007FFFA0842FF6 01:00000000000B1FF6 E:\App\Teradata\Client\15.10\bin\tdata32.dll

[former_member198401]

schimmerd

Check the data flow which has Teradata table as the Source/Target.

Something is not correct in the data flow.

Regards

Arun Sasi