Hi,
We are working with an EOC environment, recently upgraded: Orion Platform HF5, NPM HF3: 2020.2.6
So fat we only have one site under the EOC deployment to test this behavior and when we create a filter on the widget like this: Ecosystem like '%value%'. Solarwinds complains about these columns that don't exist but we are 100% sure that those columns exist on the site:
Here's the error on EOC logs:
2022-12-02 11:25:11,675 [320] (56) ERROR SolarWinds.Orion.Web.UI.BaseResourceControl - (null) Possible invalid filter: Support_L1 ='NOC' AND Status=2 AND (Ecosystem='Presentation' OR Ecosystem='NGCN' OR Ecosystem='Critical Infrastructure') AND System<>'Telephony'
System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: RunQuery failed, check fault information.
Invalid column name 'Ecosystem'.
Invalid column name 'Ecosystem'.
Invalid column name 'Ecosystem'.
Invalid column name 'Support_L1'.
Invalid column name 'System'. (Fault Detail is equal to InfoServiceFaultContract [ System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Ecosystem'.
Invalid column name 'Ecosystem'.
Invalid column name 'Ecosystem'.
Invalid column name 'Support_L1'.
Invalid column name 'System'.
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 forDescrib...).
Note that certain custom fields DO work but these custom fields above won't work at all.
Do you have any suggestion?
