Running 10.3.1 seeing the following meessage in the OrionWeb.log. Looks like an issue to me with the H.DisplayName not existing in the vim_hosts table. Not sure which resource is generating the SQL. Thanks
2012-11-23 11:25:45,484 [75] WARN SolarWinds.InformationService.Contract2.InfoServiceProxy - Support! -- LONG RUNNING QUERY: 66534.5338 ms: SELECT H.NodeID AS NodeID, H.DisplayName AS DisplayName, 'H' AS NodeType
FROM Orion.VIM.VirtualMachines VM
LEFT JOIN Orion.VIM.Hosts H ON H.HostID = VM.HostID
WHERE VM.NodeID = 12491
UNION
(
SELECT MA.NodeID AS NodeID, '' AS DisplayName, 'VM' AS NodeType
FROM Orion.NodeMACAddresses MA
LEFT JOIN Orion.VIM.Hosts H ON H.NodeID = MA.NodeID
WHERE
(
MA.MAC LIKE '0003FF%' OR
MA.MAC LIKE '000C29%' OR
MA.MAC LIKE '005056%' OR
MA.MAC LIKE '000569%' OR
MA.MAC LIKE '001C14%'
) AND MA.NodeID = 12491 AND H.HostID IS NULL
)
ORDER BY NodeType ASC RETURN XML RAW
2012-11-23 11:25:45,484 [75] ERROR SolarWinds.Orion.Web.InformationService.InformationServiceProxy - main exception: System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
Server stack trace:
at System.ServiceModel.Channels.CommunicationObject.ThrowIfFaulted()
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at SolarWinds.InformationService.Contract2.IInformationService.Query(QueryXmlRequest query)
at SolarWinds.InformationService.Contract2.InfoServiceProxy.Query(QueryXmlRequest query)
at SolarWinds.Orion.Core.Common.OrionInfoServiceProxy.SolarWinds.InformationService.Contract2.IInformationService.Query(QueryXmlRequest query)
at SolarWinds.InformationService.InformationServiceClient.InformationServiceCommand.ExecuteReader(CommandBehavior behavior)
at SolarWinds.InformationService.InformationServiceClient.InformationServiceCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at SolarWinds.Orion.Web.InformationService.InformationServiceProxy.Query(String query, IDictionary`2 parameters, Boolean useSeparateExecutionContext)
