{
"data": {
"message": "An error has occurred.",
"exceptionMessage": "RunQuery failed, check fault information.\nOperand data type NULL is invalid for count operator.",
"exceptionType": "System.ServiceModel.FaultException`1[[SolarWinds.InformationService.Contract2.InfoServiceFaultContract, SolarWinds.InformationService.Contract, Version=2024.4.0.0, Culture=neutral, PublicKeyToken=null]]",
"stackTrace": " at SolarWinds.InformationService.InformationServiceClient.InformationServiceCommand.CreateFaultException(Message message)\r\n at SolarWinds.InformationService.InformationServiceClient.InformationServiceCommand.HandleQueryResponse(Message message)\r\n at SolarWinds.InformationService.InformationServiceClient.InformationServiceCommand.ExecuteReader(CommandBehavior behavior)\r\n at SolarWinds.InformationService.InformationServiceClient.InformationServiceCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)\r\n at SolarWinds.Orion.Core.Common.InformationService.InformationServiceProxy.<>c__DisplayClass8_0.<Query>b__0(InfoServiceProxy n)\r\n at SolarWinds.Orion.Core.Common.ChannelProxy`1.CallMethodWithPool[TResult](Func`2 fnc, Boolean retryCall)\r\n at SolarWinds.Orion.Core.Common.ChannelProxy`1.Invoke[TResult](Func`2 fnc, ChannelProxyBehavior behavior, String methodName)\r\n at SolarWinds.Orion.Core.Common.ChannelProxy`1.Invoke[TResult](Func`2 fnc, ChannelProxyBehavior behavior)\r\n at SolarWinds.Orion.Core.Common.InformationService.InformationServiceProxy.Query(String query, IDictionary`2 parameters)\r\n at SolarWinds.Orion.Core.Common.InformationService.InformationServiceProxy.Query(String query)\r\n at SolarWinds.Orion.Core.Common.InformationService.InformationServiceProxyImpersonate.Query(String query)\r\n at SolarWinds.Orion.Core.Common.InformationService.InformationServiceProxyImpersonate.Query(String query, Boolean useSeparateExecutionContext)\r\n at SolarWinds.Orion.Widgets.WebApi.Controllers.TileController.PopulateTilesByStatusData(Tile tile, List`1 sitesFilter, List`1& swisErrors)\r\n at SolarWinds.Orion.Widgets.WebApi.Controllers.TileController.<>c__DisplayClass12_0.<GetTileResponse>b__0()\r\n at System.Threading.Tasks.Task.InnerInvoke()\r\n at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at SolarWinds.Orion.Widgets.WebApi.Controllers.TileController.<GetTileResponse>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at SolarWinds.Orion.Widgets.WebApi.Controllers.TileController.<GetTileResponse>d__10.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at SolarWinds.Orion.Widgets.WebApi.Controllers.TileController.<LoadTileInfo>d__8.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__18`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__18`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"
},
"status": 500,
"config": {
"method": "POST",
"transformRequest": [
null
],
"transformResponse": [
null
],
"jsonpCallbackParam": "callback",
"params": {
"lang": "en-us",
"viewId": 70,
"swAlertOnError": true,
"swLogOutOnAuthError": false,
"swLogOnError": [
401,
403,
500,
501,
502,
503,
504,
505,
506,
507,
508,
509,
510
],
"swToastOnError": [
401,
403,
500,
501,
502,
503,
504,
505,
506,
507,
508,
509,
510
]
},
"headers": {
"Accept": "application/json, text/plain, */*",
"Content-Type": "application/json;charset=utf-8",
"X-XSRF-TOKEN": "ZdnIGOUvWkfHoS6cbeaTRaSujNWIdTYOU57W1B1teSE="
},
"cache": false,
"url": "">win-831ouvoackp:8787/.../loadtileinfo",
"data": {
"siteIds": [],
"tile": {
"swql": "SELECT Status, InstanceSiteId FROM (\r\nSELECT Status, InstanceSiteId FROM Cortex.Orion.CiscoAci.ApplicationProfile (nolock=true) e \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.CiscoAci.EndpointGroup (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.CiscoAci.Fabric (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.CiscoAci.PhysicalEntity (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.CiscoAci.Tenant (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.APM.Exchange.Database (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.APM.Application (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.APM.ApplicationItem (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.NetMan.CloudMonitoring.CloudAccount (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.NetMan.CloudMonitoring.VirtualNetwork (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.NetMan.CloudMonitoring.VirtualNetworkConnection (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.CloudMonitoring.CloudVPNGateway (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.CloudMonitoring.CloudVPNConnection (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.APM.Component (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM System.ComputerSystem (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.StorageControllers (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.StorageControllerPorts (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.NPM.CustomPollerAssignment (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.FileShares (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.Container (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.HardwareHealth.HardwareCategoryStatusBase (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.HardwareHealth.BMC.Chassis (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.HardwareHealth.HardwareInfoBase (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.HardwareHealth.HardwareItemBase (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.NPM.Interfaces (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.LUNs (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.Volumes (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.Nodes (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.IpSla.Operations (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.Orchestrators.Info (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SEUM.Agents (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.PolicyEngine.Policy (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.Pools (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.UDT.Port (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.Providers (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.QBM.Queries (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SdWan.NodesInterfaces (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SdWan.Nodes (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SdWan.Tunnels (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SamAppOptics.ApmService.Service (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.StorageArrays (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SEUM.Transactions (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SEUM.TransactionSteps (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Cortex.Orion.PowerControlUnit (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.VIM.Clusters (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.VIM.DataCenters (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.VIM.Datastores (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.VIM.Hosts (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.Virtualization.Instance (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.SRM.VServers (nolock=true) e ) \r\nUNION ALL\r\n (SELECT Status, InstanceSiteId FROM Orion.WirelessHeatMap.AccessPoints (nolock=true) e ) \r\n)",
"otherIssuesSwql": "SELECT c.Name, CASE WHEN c.Severity = 4 THEN 0 WHEN c.Severity = 0 THEN 1 WHEN c.Severity = 1 THEN 2 WHEN c.Severity = 3 THEN 3 WHEN c.Severity = 2 THEN 4 END as Priority, a.InstanceSiteId, o.EntityUri\r\n FROM Orion.AlertActive (nolock=true) a \r\n INNER JOIN Orion.AlertObjects (nolock=true) AS o ON o.AlertObjectID = a.AlertObjectID AND o.InstanceSiteId = a.InstanceSiteId\r\n INNER JOIN Orion.AlertConfigurations (nolock=true) AS c ON o.AlertID = c.AlertID AND o.InstanceSiteId = c.InstanceSiteId\r\n WHERE o.EntityType IN('Cortex.Orion.CiscoAci.ApplicationProfile','Cortex.Orion.CiscoAci.EndpointGroup','Cortex.Orion.CiscoAci.Fabric','Cortex.Orion.CiscoAci.PhysicalEntity','Cortex.Orion.CiscoAci.Tenant','Orion.APM.Exchange.Database','Orion.APM.Application','Orion.APM.ApplicationItem','Cortex.Orion.NetMan.CloudMonitoring.CloudAccount','Cortex.Orion.NetMan.CloudMonitoring.VirtualNetwork','Cortex.Orion.NetMan.CloudMonitoring.VirtualNetworkConnection','Orion.CloudMonitoring.CloudVPNGateway','Orion.CloudMonitoring.CloudVPNConnection','Orion.APM.Component','System.ComputerSystem','Orion.SRM.StorageControllers','Orion.SRM.StorageControllerPorts','Orion.NPM.CustomPollerAssignment','Orion.SRM.FileShares','Orion.Container','Orion.HardwareHealth.HardwareCategoryStatusBase','Orion.HardwareHealth.BMC.Chassis','Orion.HardwareHealth.HardwareInfoBase','Orion.HardwareHealth.HardwareItemBase','Orion.NPM.Interfaces','Orion.SRM.LUNs','Orion.SRM.Volumes','Orion.Nodes','Orion.IpSla.Operations','Orion.Orchestrators.Info','Orion.SEUM.Agents','Orion.PolicyEngine.Policy','Orion.SRM.Pools','Orion.UDT.Port','Orion.SRM.Providers','Orion.QBM.Queries','Orion.SdWan.NodesInterfaces','Orion.SdWan.Nodes','Orion.SdWan.Tunnels','Orion.SamAppOptics.ApmService.Service','Orion.SRM.StorageArrays','Orion.SEUM.Transactions','Orion.SEUM.TransactionSteps','Cortex.Orion.PowerControlUnit','Orion.VIM.Clusters','Orion.VIM.DataCenters','Orion.VIM.Datastores','Orion.VIM.Hosts','Orion.Virtualization.Instance','Orion.SRM.VServers','Orion.WirelessHeatMap.AccessPoints')",
"hasListSwql": true,
"tileType": "CustomBasic"
}
}
},
"statusText": "Internal Server Error",
"xhrStatus": "complete"
}
