Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > IIS Average Network Traffic resource error in SAM

IIS Average Network Traffic resource error in SAM

Updated October 3, 2017

Overview

After upgrading to a product that installs Orion Core Services 2017.3 (for example, SAM), the AppInsight for IIS resource Average Network Traffic resource (and only that resource) shows a SolarWinds Information Service (SWIS) error instead of rendering a chart.  

 

Within the OrionWeb.log, you can see the following error:

 

2017-09-11 17:36:45,599 [68] (34) ERROR SolarWinds.Orion.Web.InformationService.InformationServiceProxy - (null)  Column "T1.DateTime" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: RunQuery failed, check fault information.
Column "T1.DateTime" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause. (Fault Detail is equal to InfoServiceFaultContract [ System.Data.SqlClient.SqlException (0x80131904): Column "T1.DateTime" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
   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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at...).

 

Environment

  • SAM 6.4 
  • NPM 12.2/3 Orion Core Services 2017.3

 

Cause 

This issue was introduced in SolarWinds Information Service (SWIS) 2017.3.0.710; it is being tracked in 

SAM-6013.

 

Resolution

This issue should be resolved with Core MSP1.

 

 

Last modified

Tags

Classifications

Internal Use Only