Recently I have found that the Top 40 Most Vulnerable Machines widget in the Orion web browser shows an information box that says no data to display.
Anyone seen this before or have any pointers? Everything else seems to be displayed correctly and syncing with the patch manager server.
Solved! Go to Solution.
There could be a timeout occurring due to the widget being based on 40 nodes, I'd recommend raising a Tech Support ticket so they can analyze debug logs and determine the root cause. As a first port of call, you could edit the widget and change the 'max number of items to display' to 10 and see if that results in the same error:
Good shout but unfortunately the same error as before.
OrionWeb log is showing the following:
2019-08-27 09:47:36,139  (263) ERROR SolarWinds.Orion.Web.InformationService.InformationServiceProxy - (null) Invalid column name 'C15'.
System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: RunQuery failed, check fault information.
Invalid column name 'C15'. (Fault Detail is equal to InfoServiceFaultContract [ System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'C15'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmd...).
Anyone have any ideas?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.