Forum Discussion

Mahesh272's avatar
Mahesh272
Copper Contributor
Oct 07, 2023

Issue - Extracting Data from SAP using CDC connector

Hi,

I'm encountering an issue with the fullandIncremental load. While the initial loads are processing successfully, the delta loads aren't. Although I can observe the delta records in the staging area, they aren't being merged into the Azure SQL database. Can you assist?

 

Below is the error

 

Operation on target CDS View Extraction failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'SQLDB': Incorrect syntax near '393088964'.","Details":"shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '393088964'.\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."}

No RepliesBe the first to reply

Resources