SAP Knowledge Base Article - Preview

2314354 - Table comparison and long datatype fails with Access Violation - Data Services

Symptom

  • Job with Table Comparison Fails when comparing a long datatype.
  • Data in source and target table are of different lengths.
  • Data length is longer then database max length size for varchar.
  • Data is 80K-400K characters long.
  • Job fails with following Access Violation 
  • Error:
    "System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
    Call stack:
    0x000000008062B03B, acta_strcmp()+0315 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\genutil\strfunc.cpp, line 0302+0010 byte(s)
    0x00000000805AA9AC, Compare()+4108 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\eval\calc.cpp, line 0877+0026 byte(s)
    0x000000008058F947, XRow_data_ptr_with_schema::compareEQ_NullEQNull()+0759 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\eval\row.cpp, line 4997+0053 byte(s)
    0x0000000080E18C52, RdrDB::getnext()+1906 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrdb.cpp, line 2153+0026 byte(s)
    0x0000000080E0ED7F, RdrDB::execute()+0223 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrdb.cpp, line 2381
    0x00000000801C2E00, XTran_desc::execute()+0448 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0812
    0x0000000081147DC9, Rww_thread::main()+0249 byte(s),
    d:\im_ds_4.2_sp06_patch_rel\src\dataservices\dataintegrator\codeline\code\src\rww\rww.cpp, line 0452
    0x0000000000A3438E, RWThreadFunctionImp::run()+0126 byte(s)
    0x0000000000A1C184, RWRunnableImp::exec()+0372 byte(s)
    0x0000000000A34643, RWThreadImp::exec()+0051 byte(s)
    0x0000000000A35F59, RWThreadImp::_setTimeSliceQuantum()+0169 byte(s)
    0x00000000500137D7, endthreadex()+0071 byte(s)
    0x0000000050013894, endthreadex()+0260 byte(s)
    0x00000000C9E513D2, BaseThreadInitThunk()+0034 byte(s)
    0x00000000CC4B54E4, RtlUserThreadStart()+0052 byte(s)
    Registers:
    RAX=000000003FA09C80 RBX=00000000B1E8295C RCX=00000000F188C5DB RDX=00000000B1E8295C RSI=00000000C806CF2B
    RDI=00000000B1E8325C RBP=00000000B1E8295C RSP=000000000A9DD9A0 RIP=000000008062B03B FLG=0000000000010216
    R8=00000000161E9CD0 R9=000000003FA09C80 R10=0000000001B69F60 R11=000000000000000F R12=00000000161E9CD0
    R13=000000003FA09C80 R14=000000003FA09C80 R15=000000000566DF10
    Exception code: C0000005 ACCESS_VIOLATION
    Fault address: 000000018062B03B 01:000000000062A03B 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."

     


Read more...

Environment

SAP Data Services 4.x
Microsoft SQL Server

Product

SAP Data Services 4.2

Keywords

KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.