Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Last events failing

Hi.

After upgrade to 9.5 SP3 I get an error on all Last events components,

The Error is :

The "Last 25 Events " resource threw an exception..
.(

System.ArgumentException: The column NetObjectID2 does not belong to the table .   ved System.Data.DataRow.GetDataColumn(String columnName)   ved System.Data.DataRow.get_Item(String columnName)   ved Orion_Controls_EventsReportControl.LoadData(Int32 netObjectID, String netObjectType, String deviceType, Int32 eventType, DateTime periodBegin, DateTime periodEnd, Boolean showClearedEvents, Int32 maxRecords)   ved Orion_NetPerfMon_Resources_Events_LastXEvents.Page_Load(Object sender, EventArgs e)   ved System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)   ved System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)   ved System.Web.UI.Control.OnLoad(EventArgs e)   ved SolarWinds.Orion.Web.UI.BaseResourceControl.OnLoad(EventArgs e).

Find more posts tagged with

Accepted answers

efosshaug

Hi.

Just changed the source and removed the {2} and all works fine. This will do until the next upgrade :-)

All comments

bshopp

I have not seen this one before, best bet is to open a support ticket

efosshaug

Hi.

Will open an support ticket. I see that the EventsReportControl.ascx.cs has been changed. I have created a resource that filters the events - and this is still working.

What fails is this:

         DataTable eventsTable = EventsWebDAL.GetEventsTable(netObjectID, netObjectType,deviceType, eventType, periodBegin, periodEnd, showClearedEvents, maxRecords);

        // adds new column to the table for URL resolving
        eventsTable.Columns.Add("URL");

        foreach (DataRow r in eventsTable.Rows)
        {
            if ((r["NetObjectType"] is DBNull) || (r["NetObjectID"] is DBNull) || (r["NetObjectType"].ToString().Trim() == String.Empty) || ((int)r["NetObjectID"] == 0))
            {
                r["URL"] = String.Empty;
            }
            else
            {
    string objectType = (r["NetObjectType"].ToString().Trim().Equals("Y", StringComparison.OrdinalIgnoreCase)) ? "AM" : (r["NetObjectType"].ToString().Trim().Equals("Z", StringComparison.OrdinalIgnoreCase)) ? "AA" : r["NetObjectType"].ToString().Trim().ToUpper();

    r["URL"] = String.Format("/Orion/View.aspx?NetObject={0}:{1}{2}", objectType, r["NetObjectID"], (r["NetObjectID2"] is DBNull) ? string.Empty : ":" + r["NetObjectID2"]);
            }

            int color = (int)r["BackColor"];
            r["BackColor"] = ((color & 0xFF0000) >> 16) + (color & 0x00FF00) + ((color & 0x0000FF) << 16);

        }

Clearly datarow r does not contain a column named NetObjectID2 so I really can't see how this can work for anyone else either....

I changed the url-line to not contain NetObjectID2 and the resource is working again.

efosshaug

Hi.

Just changed the source and removed the {2} and all works fine. This will do until the next upgrade :-)