Object reference not set to an instance of an object—Altiris Agent Installation Page ('InstallClient.aspx')
search cancel

Object reference not set to an instance of an object—Altiris Agent Installation Page ('InstallClient.aspx')

book

Article ID: 151989

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

After clicking on the Altiris Agent Installation task within the Notification Server Console the following error message is shown on the right hand side of the console:

Altiris Notification Server Error
The following error occurred on the page 'InstallClient.aspx':

Object reference not set to an instance of an object.


You also see the following information in the a.log files

Date: Jan 27 12:15:29:000
Source: global.asax
Description: Unhandled exception.  Type=System.NullReferenceException Msg=Object reference not set to an instance of an object.
StackTrace=
   at Altiris.NS.UI.InstallClientTab.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at Altiris.Common.UI.Controls.TabHostCtrl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
  
at ASP.InstallClient_aspx.__RenderInstallClient(HtmlTextWriter __output, Control parameterContainer) in F:\Program Files\Altiris\Notification Server\Admin\ClientManagement\InstallClient.aspx:line 120

   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)

at ASP.InstallClient_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in F:\Program Files\Altiris\Notification Server\Admin\ClientManagement\InstallClient.aspx:line 90

 

Module: AltirisNativeHelper.dll
Source: Altiris.NS.UI.InstallClientTab.ReportError
Description: Failed to refresh the grid : Altiris.NS.Exceptions.AeXException: Failed to get machine data. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.#pushPageTableNameDomain' with unique index 'idxTemp'.
Warning! The maximum key length is 900 bytes. The index 'idxTemp' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
The statement has been terminated.
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Altiris.NS.Discovery.enteredMachineData.GetMachineData(Hashtable machines)
   at Altiris.NS.UI.InstallClientTab.GetCurrentMachinesData()
   --- End of inner exception stack trace ---
   at Altiris.NS.UI.InstallClientTab.GetCurrentMachinesData()
   at Altiris.NS.UI.InstallClientTab.RefreshData()

Cause

This problem is caused by a corruption in the AgentPushData table.

Resolution

Note: Using Enterprise Manager or another SQL management tool, open the AgentPushData table and look for obvious corruption (invalid characters and so on). This table contains information regarding the installation of Altiris Agents and the information is safe to delete.

Approach 1

Deleting the information contained in the AgentPushData is safe to do since it only contains what computers were added to the Push Altiris Agent Installation page. If you are not interested in the information contained in this table, open Query Analyzer and run the following query

truncate table AgentPushData

Then, go to the Altiris Agent Installation page and refresh it.

Approach 2

If you don't want to lose the information contained in this table for any reason, the following SQL can be run in Query Analyzer and will back up the AgentPushData table to AgentPushData_Backup and then will remove the data from AgentPushData:

select * into AgentPushData_Backup from AgentPushData
delete from AgentPushData

The following in SQL can be run from Query Analyzer, and it will delete (or truncate) the data in the AgentPushData table:

truncate table AgentPushData

Note: If there is already a AgentPushData_Backup table, the following can be run to preserve the data:

select * into AgentPushData_Backup2 from AgentPushData
delete from AgentPushData

and then run this:

select * into AgentPushData_Backup3 from AgentPushData_Backup
delete from AgentPushData_Backup


Applies To
Notification Server 6.0 SP2 Hotfix 19
Notification Server 6.0 SP3