Running index-checker with MS-SQLServer

[CesarCapillas]

Hi Angel:

I tried to run index checker with MS-SQL Database (I used this database with Alfresco 7.2.0 EE and ASS 2.0.2)
I added MS-SQLDriver dependency in pom.xml, then I packaged but when running checker with --validation-nodes=true I obtain the following ERROR.

$ /usr/lib/jvm/jre-11-openjdk/bin/java -jar index-checker-0.0.1-SNAPSHOT.jar

16:29:37.172 o.a.i.NodesValidator - Count SOLR documents = 251790
16:29:37.610 o.s.b.a.l.ConditionEvaluationReportLoggingListener - 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
16:29:37.614 o.s.b.SpringApplication - Application run failed
java.lang.IllegalStateException: Failed to execute CommandLineRunner
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:322)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
	at org.alfresco.indexchecker.App.main(App.java:60)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:107)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT COUNT(1) FROM alf_node, alf_node_properties, alf_qname, alf_namespace WHERE alf_node_properties.node_id = alf_node.id   AND alf_node.store_id = 7   AND alf_node_properties.qname_id = alf_qname.id   AND alf_qname.ns_id = alf_namespace.id   AND NOT alf_node_properties.boolean_value   AND alf_qname.local_name = 'isIndexed'   AND alf_namespace.uri = 'http://www.alfresco.org/model/content/1.0']; SQL state [S0001]; error code [4145]; Se especificó una expresión no booleana en un contexto donde se esperaba una condición, cerca de 'AND'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Se especificó una expresión no booleana en un contexto donde se esperaba una condición, cerca de 'AND'.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:462)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:473)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:480)
	at org.alfresco.indexchecker.db.DbClient.getNodeCount(DbClient.java:62)
	at org.alfresco.indexchecker.NodesValidator.validate(NodesValidator.java:51)
	at org.alfresco.indexchecker.App.run(App.java:44)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795)
	... 13 common frames omitted
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Se especificó una expresión no booleana en un contexto donde se esperaba una condición, cerca de 'AND'.
	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.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:868)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
	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.SQLServerStatement.executeQuery(SQLServerStatement.java:693)
	at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
	at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
	... 21 common frames omitted

Regards.
--C.