Disk Performance Stats Not Working

by Feb 7, 2018

Greetings! I was recently giving access to Uptime for monitoring an on-premise SharePoint 2013 farm. Our company is running Uptime version 7.7.2. Being new to Uptime, I looked around all the features available, and I noticed that Disk Performance Stats doesn't work for any of the servers. An error message displays "Database is not responding …" Clicking on the error, and it expends error in detail:

com.uptimesoftware.uptime.database.RuntimeSQLException: java.sql.SQLException: Incorrect syntax near the keyword 'current'.
at com.uptimesoftware.uptime.database.QueryDatabaseConnector.executeWork(QueryDatabaseConnector.java:21)
at com.uptimesoftware.uptime.database.JdbcExecutor.execute(JdbcExecutor.java:45)
at com.uptimesoftware.uptime.dataservice.query.Query.getResultSet(Query.java:53)
at com.uptimesoftware.uptime.dataservice.QueryExecutor.getResultSet(QueryExecutor.java:14)
at com.uptimesoftware.uptime.dataservice.ResultSetCommandExecutor.execute(ResultSetCommandExecutor.java:13)
at com.uptimesoftware.uptime.dataservice.FrontEndCommandExecutor.execute(FrontEndCommandExecutor.java:11)
at com.uptimesoftware.uptime.dataservice.FrontEndCommandType.execute(FrontEndCommandType.java:34)
at com.uptimesoftware.uptime.dataservice.ProtocolHandler.run(ProtocolHandler.java:97)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'current'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:144)
at com.uptimesoftware.uptime.database.JdbcQuery.doWork(JdbcQuery.java:20)
at com.uptimesoftware.uptime.database.JdbcQuery.doWork(JdbcQuery.java:9)
at com.uptimesoftware.uptime.database.QueryDatabaseConnector.executeWork(QueryDatabaseConnector.java:43)
at com.uptimesoftware.uptime.database.QueryDatabaseConnector.executeWork(QueryDatabaseConnector.java:18)
… 8 more

I've since reached out to the company POC, but I haven't heard anything back yet. In the meantime, I've also searched the community forum and the web but didn't find any hits. Is there anything that I can do to troubleshoot the error? Thank you.