Suddenly starting this past Thursday, monitors we had using the ODBC user experience to query a postgreSQL database stopped working. These have been working for some time. I've tried changing the advanced properties for the preferred method to agentless, and I've turned debugging on. I can see this error:
2019-05-28 15:30:10,474 [STP SmartThreadPool Thread #4] [C42858] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - Start SQL query execution
2019-05-28 15:30:10,486 [STP SmartThreadPool Thread #4] [C42858] ERROR SolarWinds.APM.Probes.OdbcQAProbe - DbException caught.
System.Data.Odbc.OdbcException (0x80131937)
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at SolarWinds.APM.Probes.SQL.DbClient.ExecuteQuery[T](String sqlQuery, String connectionString, Int32 queryTimeout, String providerInvariantName, T& statistics, String& message)
at SolarWinds.APM.Probes.OdbcQAProbe.QueryOdbc(OdbcQAProbeSettings settings, Stopwatch watch, DateTime probeDeadline, Double& statisticsData, String& message)
at SolarWinds.APM.Probes.OdbcQAProbe.ProbeInternal(ProbeInformation configuration, CounterMonitorResult result)
But from what I can tell, there has been no change to the monitors, or the polling server. I've checked the ODBC connectors, I've even used PGAdmin on the polling server to connect without issue with the same credentials and run the same queries.
The connection string that was working until now is: Driver={PostgreSQL Unicode(x64)};Server=${IP};DataBase=tcmadb;Uid=${USER};Pwd=${PASSWORD};
SAM version is 6.7. Any help would be appreciated.
