sys.fn_cdc_increment_lsn fails with Common Language Runtime(CLR) is not enabled on this instance

Question

I "think" sys.fn_cdc_increment_lsn is the culprit in the stack below but not 100%.

I'm trying to use the debezium engine from an IoT Edge Module send changes from a SQL Edge database with CDC enabled and it is failing.

Any ideas?

com.microsoft.sqlserver.jdbc.SQLServerException: Common Language Runtime(CLR) is not enabled on this instance.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:444)
at io.debezium.jdbc.JdbcConnection.prepareQueryAndMap(JdbcConnection.java:657)
at io.debezium.connector.sqlserver.SqlServerConnection.incrementLsn(SqlServerConnection.java:184)
at io.debezium.connector.sqlserver.SqlServerStreamingChangeEventSource.execute(SqlServerStreamingChangeEventSource.java:144)
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:101)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

highlighted line above is at:

https://github.com/debezium/debezium/blob/aa360a78bd12d58e7d0c5aa39375961b6991d069/debezium-connector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerConnection.java#L184

Answer 1

@Nathan Enright

Thanks for your patience. Our Team has conveyed the following:

"The function is dependent on CLR, which is not supported for SQL Edge. We mention this in the docs, that all CLR dependent T-SQL Functions are not supported.
CLR-dependent T-SQL functions, such as ASSEMBLYPROPERTY, FORMAT, PARSE, and TRY_PARSE.
Additionally they have added the note in the document conveying the same."

Please get back to us if any further questions.

Thanks
Navtej S