Database crawler not creating index entries

We’ve been using OpenSearch Server v1.4 for file crawling for a number of years.

We’ve recently attempted to use it for database crawling for the first time. We’ve setup a schema, created a crawler, mapped the columns from the database query to the schema. It looks like it’s all setup and should work. When we click crawl we can see the queries being generated in Microsoft SQL Server Profiler, to get the data we were hoping to index and also the queries to mark the rows in the database as indexed. There’s no errors in the logs (we’ve able to find). It’s definitely getting a hundred of rows of data, however the index ends up with nothing in it.

Does anyone know if database crawling in OSS v1.4 works?

We’re running Apache 8.5

java -version
java version “1.8.0_311”
Java™ SE Runtime Environment (build 1.8.0_311-b11)
Java HotSpot™ 64-Bit Server VM (build 25.311-b11, mixed mode)

On Windows Server 2019