Our IPAM scans have been hung. I tried flushing the Collector and JobEngine by stopping services and copying in the blank for each. I have also cleared the SNMPCred table for IPAM. It still isn't working. I just found this in the Collector.Service.log. Does anyone know what this means?
2019-01-29 11:28:25,068 [26] ERROR SolarWinds.Collector.PollingController.PollingController - Resolve polling plan failed!! We will try to resolve it in next round
System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at SolarWinds.IPAM.Storage.DAL.DhcpServerDAL.Get(String SqlPostfix)
at SolarWinds.IPAM.Storage.DAL.DhcpScopeDAL.FindParentDhcpServer(Int32 NodeId)
at SolarWinds.IPAM.Collector.DhcpScopesPollingPlan.UpdatePolling(IUpdatePollingContext context)
at SolarWinds.Collector.PollingController.PollingController.ResolvePollingPlanReal(PendingItem pendingItem)
at SolarWinds.Collector.PollingController.PollingController.ResolvePendingItemsThread(Object state)
Its now showing:
019-01-29 11:44:22,339 [7] ERROR SolarWinds.Collector.PollingController.PollingController - Resolve polling plan failed!! We will try to resolve it in next round
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at SolarWinds.IPAM.Storage.DAL.DhcpServerDAL.Get(String SqlPostfix)
at SolarWinds.IPAM.Storage.DAL.DhcpScopeDAL.FindParentDhcpServer(Int32 NodeId)
at SolarWinds.IPAM.Collector.DhcpScopesPollingPlan.UpdatePolling(IUpdatePollingContext context)
at SolarWinds.Collector.PollingController.PollingController.ResolvePollingPlanReal(PendingItem pendingItem)
at SolarWinds.Collector.PollingController.PollingController.ResolvePendingItemsThread(Object state)