Error while resubmitting the service from WmMonitor


I am using the WmMonitor to resubmit the failed services. ISCoreAudit log database is lying on SQL Server. I am able to submit the service successfully from the WmMonitor but I see error message in the server log. The error message says “Could not determine if service exists in db java.sql.SQLException: [wm-cjdbc31-0006][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword ‘COUNT’.”

Can anybody tell me what can be the cause of this error? I am not seeing any error message in the error log.


I was getting the same message. For me, the problem was that I had my databases defined on SQL Server 7. I moved everything to SQL Server 2000 and now all is well.