Has anybody had any issues with AppInsight for IIS since upgrading to 6.3? I had to open a support case (#1064264) this morning because I'm finding that it's not polling at all, or polling so slow that SAM thinks that IIS is "unknown".
I have multiple servers that I added since the upgrade that are stuck in "Initial poll in progress". I've done the usual of uninstalling the JobEngine, JobEngine.v2, and Collector, and reinstalling, but that didn't help. I've noticed as well that the counts in the MSMQ for "solarwinds/collector/processingqueue/apm.blackbox.iis.application.statistics.api" are slowly increasing, suggesting that the job fetching the data is working, but the job processing the results are not (or are processing substantially slower than they should be). I've got data in that queue that's over 4 hours old (this was about an hour after I did the last uninstall/reinstall/reboot combo).
I have also noticed in the Collector.Service.Log the following error messages:
2016-10-13 13:07:35,239 [66] 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)
The resolution from the Success Center for the top part of the error is to reinstall the services I've already done. The second part (ExecuteReader) suggests a database connection was closed before the data was read/processed throwing an exception.
Anybody seeing anything similar?
