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

• 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>
  )

SAP Cloud Integration for data services

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