SAP Knowledge Base Article - Preview

3401688 - Tasks are failing "Syntax error at line <x>" in Error log, "Failed to direct import ATL for JobRunid" in DSOnPremiseAgent log

Symptom

  • Tasks are failing with error messages similar to the following:
    PAR-10102 Initialization Syntax error at line <3>: <CREATE TABLE Supply_Area_Mapping_File.""."SUPPLY_AREA_MAPPING_FILE.>: near <;> found <SUBVARIABLE> expecting <'('>.
                                                               1 error(s), 0 warning(s).
                                                             Check and fix the syntax and retry the operation.
  • Upon clearing the history and ATL cache the task may run or may give another error.
  • DSOnPremiseAgent log contains errors similar to:
    SEVERE: Failed to execute from JobServer jobrunID:20703 error:Failed to execute from JobServer jobRunID:20703
    and:
    INFO: /opt/sap/DataServiceAgent/log/6RmGJB8IjbmlhaAkbhjA0N_20704_20231115_165759212.cmd:Failed to direct import ATL for JobRunid:20704 via al_engine. ((E) (1568620:2485983168)PAR-010102: Initialization

                                                             Syntax error at line <98>: <https://hcids.us4.hana.ondemand.com/DSoD/session/logon#>: near </> found <DIVIDE> expecting <':'>.
                                                             Syntax error at line <102>: <SET>: near <SET> found <SET> expecting <&ERROR_STEP, __AL_IFDEF, BEGIN_SCRIPT, CALL, identifier,
                                                             IF, PARALLEL, REALTIME_PROCESSING, a quoted identifier, TRANSFORM_SCHEMA_MAPPING, VARCHAR, WHILE>.
                                                             /opt/sap/DataServiceAgent/log/6RmGJB8IjbmlhaAkbhjA0N20231115_165759207_20704.atl - 2 error(s), 0 warning(s).
                                                             Check and fix the syntax and retry the operation.


" in Error log, "Failed to direct import ATL for JobRunid" in DSOnPremiseAgent log"> Read more...

Environment

  • Cloud Integration for data services
  • Linux Agent Installation

Product

SAP Cloud Integration for data services 1.0

Keywords

BODS, SAPDS, resources , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , EIM-HCI , SAP HANA Cloud Integration (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.