1 Reply Latest reply on Dec 15, 2009 3:39 PM by mharvey

    Orion Website Error

      I was attempting to create a new Custom Property called APALOCATION.

      Unfortunately it didn't work out and now when I log into the website it comes back with the following error:

      System.Data.SqlClient.SqlException: An expression of non-boolean type specified in a context where a condition is expected, near 'APALOCATION'.
         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.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)

       

      If anyone has any ideas how to fix this I would really appreciate it. 

        • Re: Orion Website Error
          mharvey

          If this was being used in a resource filter, you need to remove that filter.  The easiest way to do it would be to change the URL to http:\\server\Orion\Admin go to Manage Views, edit the home page and then removed and re-add the resource, most likely the node list.  If this doesn't work, please don't hesitate to open a case online and reference this thread.