SAP Knowledge Base Article - Preview

3101409 - "Import ATL" error occurs while executing task/process - SAP Cloud Platform Integration for Data Services

Symptom

  • CI-DS task created from IBP tenplate fails with the error below:

    IMP-100 Import ATL
    Syntax error at line <389>: <WHERE (where clause)>: near <WHERE> found <WHERE> expecting
    <'(', &ERROR, __AL_LOOKUPEX_TRAN, __AL_SEARCH_REPLACE_TRAN, __RFC_FUNCTION, __AL_SCRIPT_FUNCTION, __AL_STORED_PROCEDURE,
    __AL_EXTRACT_FROM_XML, __AL_EXTRACT_FROM_JSON, __AL_TRAN_FUNCTION, +, AL_NEST, AL_UNNEST, AL_UNSPECIFIED_PARAM, CONVERT, DISTINCT, a float, FROM, identifier, an integer, *, a null, PUSHDOWN_SQL, a quoted identifier, ;, a string, a decimal, VARCHAR, VARIABLE, +, NOT>. C:\ProgramData\SAP\DataServicesAgent\log\ZbaCpvcki_isUEGbsB0L1z20210920_101629305_198.atl - 1 error(s), 0 warning(s).

  • No mappings seen in the transforms, mappings for output fields are blank.
  • The ATL is corrupt.


Read more...

Environment

SAP Cloud Integration for Data Services 1.0.11.xxxx

Product

SAP Cloud Integration for data services all versions

Keywords

LOD-HCI-DS, CPI-DS, CI-DS, IBP, syntax, error, ATL, import , KBA , 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.