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.
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.
)
INFO: Completed Import job jobRunID:20704 Returning to cloud server with (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

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.