SAP Knowledge Base Article - Preview

2070087 - Sybase IQ 16.0 SP8 error STRIP OFF WITH CHECKPOINT OFF BLOCK SIZE 500000 ROW DELIMITED BY '\n' - SAP Data Services 4.2 SP3

Symptom

  • Bulkload to Sybase IQ 16.0 SP8 Target fails with ACCESS VIOLATION error if "Binary Format" is selected
  • Bulkload to Sybase IQ 16.0 SP8 Target fails with error below  if "Binary Format" is not selected
    • Starting Bulk Copy. SQL Submitted is: LOAD TABLE "DBA"."<TableName>" ("DI_ROW_ID" )
      USING FILE 'D:/bulkloader/d30ed0eacec82712958657155fdc8ddd_0.dat'
      QUOTES OFF ESCAPES OFF FORMAT ASCII DELIMITED BY '\x7F' STRIP OFF WITH CHECKPOINT OFF BLOCK SIZE 500000 ROW DELIMITED BY '\n'
      MESSAGE LOG 'D:/bulkloader/d30ed0eacec82712958657155fdc8ddd.msg'
      ROW LOG 'D:/bulkloader/d30ed0eacec82712958657155fdc8ddd.row'
      LOG DELIMITED BY '\x7F'

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • Sybase IQ 16.0 SP8
  • Data Services 4.2 SP3

Product

SAP Data Services 4.2

Keywords

KBA , EIM-DS-EXE , Job Execution , Bug Filed

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.