2 Replies Latest reply on Nov 6, 2008 12:57 PM by Felix29

    Orion Website error (Orion 9.0)

      I was configuring custom properties via NPM and then deleted a column and created a new one.  Now I can't get to the website. Please look at the msg below and advise....Thanks.

      Orion Website Error
      An error has occurred with the Orion website.

      Additional Information
      System.Data.SqlClient.SqlException: Invalid column name 'Corporate_Routers_Switches'.
      Invalid column name 'Corporate_Routers_Switches'.
      Invalid column name 'Corporate_Routers_Switches'.
      Invalid column name 'Corporate_Routers_Switches'.
      ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
         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.GetPropertyValues(String property, String whereClause, Dictionary`2 parameters)
         at NodeTree.BuildTreeLevel(HtmlTextWriter writer, ResourceInfo resource, String rootId, Int32 treeLevel, Object[] keys, Int32 startIndex, String filter)
         at NodeTree.GetTreeSection(Int32 resourceId, String rootId, Object[] keys, Int32 startIndex)
         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)
        • Re: Orion Website error (Orion 9.0)
          tdanner

          Do you have a Corporate_Routers_Switches custom property for nodes? You have a node tree resource that is configured to group by this property, but it appears that it isn't in your database. I would try either creating a property with that name or edit the view and remove that node tree. You could then add a replacement node tree and configure it to group by whatever properties.

            • Re: Orion Website error (Orion 9.0)
              Yes.  I used custom property  to create "Corporate_Routers_Switches" for nodes, then deleted it. But as you pointed out, the webinterface was still referencing it.  I re-created the property and was able to get back into the website.  I then removed it with the "edit" nodes option.

              Thanks!