We have Orion 8.5.1 w/ all current hot fixes installed. We have several users on the web interface with most more or less customized to that individual or group of individuals. Some groups need account limitations such as our server group who only need access to the server nodes. When I try to add a limitation to the user account through account manager it works fine if I select Limitation by 'Group of Nodes'. All nodes are properly filtered and everything works well. The problem is there are 50+ server nodes and thats a lot of check boxes if I have to build more accounts in the future, not to mention every time we add a server thats x number of accounts I have to remember to update. We use a hard fast naming convention (which we use for other grouping in Orion) and I have tried applying this to the account limitation using 'Node Name Pattern' instead of 'Group of Nodes' where I input 'SV-' into the filter (including the single quotes). This works on our main summary page to filter all node beginning with SV- (our naming convention for server) but when it is applied to an account as a limitation the account fails to login giving this.
Orion Website Error
An error has occurred with the Orion website.
Additional Information
System.Data.SqlClient.SqlException: Incorrect syntax near 'SV'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at SolarWinds.Orion.Common.SqlHelper.ExecuteReader(SqlCommand command)
at SolarWinds.Orion.Web.DAL.LimitationDAL.GetNetObjectIDs(Limitation limit)
at SolarWinds.Orion.Web.Limitation.b__3()
at SolarWinds.Orion.Web.RequestCache.Get[T](String key, Getter`1 getter)
at SolarWinds.Orion.Web.Limitation.GetNetObjectIDs()
at SolarWinds.Orion.NPM.Web.Node.PassesLimitation(Limitation myLimit)
at SolarWinds.Orion.Web.Limitation.Filter[T](IList`1 objects)
at SolarWinds.Orion.NPM.Web.Node.GetFilteredNodes(String whereClause)
at Orion_NetPerfMon_NodeTree.GetNodes()
at Orion_NetPerfMon_NodeTree.BuildNodeTree()
at Orion_NetPerfMon_NodeTree.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.AddedControl(Control control, Int32 index)
at System.Web.UI.ControlCollection.Add(Control child)
at Orion_ResourceContainer.ResourcePlaceHolder_DataBind(Object sender, EventArgs e)
at System.Web.UI.Control.OnDataBinding(EventArgs e)
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.Repeater.DataBind()
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at Orion_ResourceContainer.DataBind()
at Orion_SummaryView.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
My first clue is was the account limitation is the first line.
System.Data.SqlClient.SqlException: Incorrect syntax near 'SV'.
This also causes login problems with other accounts (luckily there has always been someone able to login or already logged in to remove the limitation). Is there a different syntax that I need to use or is that particular function not available at this time? Has anyone else encountered a similar issue w/ account limitations?
