Error: F_JD024D: DBMS Error [SQL Compilation Error: Syntax Error Line <Line> at Position <Position>]

Issue

Integrate is unable to process a merge SQL statement. The following error appears:

F_JD024D: DBMS error [SQL compilation error: syntax error line <line> at position <position>]

Environment

• DSS version 6.1.0/30 or below
• Target: Snowflake or BigQuery

Resolution

To resolve this issue, upgrade both the DSS Hub and DSS Agent to version 6.10/31 or higher.

If you're unable to upgrade, you can temporarily resolve the issue by disabling the burst single merge option. Add the following Environment action for the target location:

• Name: DSS_BURST_MERGE_DISABLE
• Value: 1