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.