SAP Knowledge Base Article - Preview

2762924 - Not all rows are read from flat file source - Data Services and CPI-DS

Symptom

  • ERROR: A column delimiter was seen after column number <X> for row number <nnn> in file <<path>\filename.txt>. The total number of columns defined is <X>, so a row delimiter should be seen after column number <X>. Check the file for bad data, or redefine the input schema for the file by editing the file format in the UI.
  • Rows read is less than the total number of rows minus the rows reported with delimiter errors
  • All records in the input file are not being read
  • Some rows are not read even though no errors are reported for those rows
  • Monitor log shows less rows than what the source file contains
  • Delimited source file

Read more...

Environment

  • SAP Data Services
  • SAP Cloud Platform Integration for data services

Product

SAP Cloud Platform Integration for data services all versions ; SAP Data Services all versions

Keywords

HCI, HCI-DS, CPI, CPI-DS, BODS, DSOD , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , EIM-DS-EXE , Data Services Job Execution , 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.