System Exception <ACCESS_VIOLATION> occurred in batch ETL job.

[Former Member]

I get this error occasionally across a few of my ETL jobs. After I get the error I typically re-run the job and it processes successfully. Any one else come across this and know who to fix it?

System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\ProgramData\SAP BusinessObjects\Data

Services\log\BODI_MINI20150706003618_16160.DMP> and <C:\ProgramData\SAP BusinessObjects\Data

Services\log\BODI_FULL20150706003618_16160.DMP>

Process dump is written to <C:\ProgramData\SAP BusinessObjects\Data Services\log\BODI_MINI20150706003618_16160.DMP> and

<C:\ProgramData\SAP BusinessObjects\Data Services\log\BODI_FULL20150706003618_16160.DMP>

Call stack:

0x00000000804D0723, XRow_data::unserializeRowData()+0483 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\eval\row.cpp, line 3999+0009 byte(s)

0x00000000804D10FA, XRow_data::unserializeBinary()+0346 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\eval\row.cpp, line 4464+0039 byte(s)

0x00000000804DF5EE, DIFileCacheCursor::get_next()+0142 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\eval\difilecache.cpp, line 1024

0x00000000810655F6, XTran_sort_file_rdr::get_next()+0150 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0187+0012 byte(s)

0x000000008106564F, XTran_sort_file_rdr::get_next_extended()+0015 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0217

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x00000000810657B8, XTran_sort_merge_rdr::get_next_extended()+0040 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0378+0021 byte(s)

0x0000000081068F00, XTran_sort_runtime::initPageableRdr()+2992 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 1663+0010 byte(s)

0x0000000081069540, XTran_sort_runtime::getnext()+0160 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 1749

0x000000008106A2BA, XTran_sort::getnext()+0762 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0686+0008 byte(s)

0x0000000081066155, XTran_sort::execute()+0037 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\xform\tsort.cpp, line 0817+0022 byte(s)

0x000000008018CFBA, XTran_desc::execute()+0442 byte(s),

d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0678

0x0000000080EFF6F9, Rww_thread::main()+0249 byte(s), d:\ds_sprel\src\dataservices\dataintegrator\codeline\code\src\rww\rww.cpp,

line 0451

0x0000000000B5438E, RWThreadFunctionImp::run()+0126 byte(s)

0x0000000000B3C184, RWRunnableImp::exec()+0372 byte(s)

0x0000000000B54643, RWThreadImp::exec()+0051 byte(s)

0x0000000000B55F59, RWThreadImp::_setTimeSliceQuantum()+0169 byte(s)

0x00000000757F37D7, endthreadex()+0071 byte(s)

0x00000000757F3894, endthreadex()+0260 byte(s)

0x0000000077B1652D, BaseThreadInitThunk()+0013 byte(s)

0x0000000077C4C541, RtlUserThreadStart()+0033 byte(s)

Registers:

RAX=0000000000000000  RBX=0000000000000001  RCX=0000000015473EE0  RDX=0000000013644DE3  RSI=00000000000100F0

RDI=0000000000003020  RBP=0000000013634CF3  RSP=00000000108CEAA0  RIP=00000000804D0723  FLG=0000000000010202

R8=0000000000000008   R9=0000000013654D00  R10=0000000080000000  R11=0000000015473ED8  R12=0000000013654D00

R13=0000000015473380  R14=0000000000000B60  R15=000000000FFF5EF0

Exception code: C0000005 ACCESS_VIOLATION

Fault address:  00000001804D0723 01:00000000004CF723 C:\Program Files (x86)\SAP BusinessObjects\Data Services\bin\acta.dll

==========================================================

Collect the following and send to Customer Support:

1. Log files(error_*, monitor_*, trace_*) associated with this failed job.

2. Exported ATL file of this failed job.

3. DDL statements of tables referenced in this failed job.

4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when

the job failed.

5. Core dump, if any, generated from this failed job.

==========================================================

[former_member198401]

Hi James,

Can you give more information about the job which is failing with core dump error?

Which transforms are used in the data flow

Are you extracting data from SAP ECC tables?

Regards

Arun Sasi

[Former Member]

The job is pulling data from and AS400 DB2 database using the iSeries ODBC driver and inserting into a local SQL Server database.

[former_member198401]

Are using any Sorting in any of the transform? Also let us know more about the job (e.g if there is a distinct when you are selecting the rows from DB2 database tables)

Regards

Arun Sasi

[Former Member]

There is an order by on two columns then its goes into a table compare before the target.