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 120at 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()
This problem is caused by a corruption in the AgentPushData table.
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