SAP Knowledge Base Article - Preview

3446387 - Task fails asking for a row delimiter in lookup function

Symptom

  • A task in Cloud Integration for Data Services fails with the following error message:

    A column delimiter was seen after column number <X> for row number <Y> in file <FILE_PATH>. 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.

  • The debug package error logs show the following error message:

    Syntax error at line <X>: <CREATE TABLE <TABLE_NAME>.""."<FILENAME>";>: near <;> found <SUBVARIABLE> expecting <'('>.
                                                         1 error(s), 0 warning(s).
                                                         Check and fix the syntax and retry the operation.

  • The ATL generated by the Debug Package is missing the following line that contains the table's metadate:

    CREATE FILE DATASTORE <TABLE_NAME> (
    <TABLE_CONTENTS>
    )


Read more...

Environment

  • SAP Cloud Integration for data services
  • Recent CI-DS agent update

Product

SAP Cloud Integration for data services all versions

Keywords

CI-DS, Task, lookup, row delimiter, columns, CREATE TABLE , KBA , LOD-HCI-DS-CLD , Cloud Server, UI, Task Promotion, Web Services , LOD-HCI-DS-AGNT , On-Premise Agent, Connectivity, Task Run errors , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem

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.