Data flow : "DFExecutorUserError","Message":"Job failed due to reason: at Sink 'SQLDB': Incorrect syntax near

Question

Hi, I build a pipeline to extract data from SAP CDS views to Azure SQL DB using SAP CDC connector. Pipeline is working fine for full loads and initial loads, but when it comes to delta the pipeline is failing with below error.

Operation on target CDS View Extraction failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'SQLDB': Incorrect syntax near '36849'.","Details":"shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '36849'.\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242)\n\tat shaded.msda"}

Answer 1

There's a SQL syntax error near the value '36849'. This could be due to a variety of reasons including missing quotes around strings, wrong placement of commas or other punctuations, and so on.

If possible, log or capture the actual SQL statement being generated and sent to Azure SQL DB. This will allow you to inspect and identify what might be wrong around the value '36849'.

Please check and get back to us !