Client Management Suite

 View Only
  • 1.  Agent Install Page - Data could not be loaded

    Posted Nov 23, 2010 10:04 AM

    I am unable to push the Agent out to clients.  Upon adding a mahine to the list of machines to which I want to push the agent, I get a popup message that reads "Data could not be loaded."  I've included a screen shot and the corresponding text from the Altiris log viewer below.

    Thanks!

     

    Altiris Event Log Details:

    ----------------------------------------------------------------------------------------------------

    <event date="Nov 23 14:48:03 +00:00" severity="1" hostName="CH-INF-ALT-T01" source="Altiris.NS.Discovery.DiscoveredMachinePushItem.SyncPushDataWithDB" module="w3wp.exe" process="w3wp" pid="4088" thread="4" tickCount="57903359"><![CDATA[Failed to load data!
    **CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=Unknown&language=en&module=vvL+KqsGL5HXhUkbNNLn9DdUVAcO6IjkZsUguRJ+5lMTA4uaZoR53fpN2fMuAWL6&error=-177810722&build=**CEDUrlEnd**


    ( Exception Details: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_AgentPushData'. Cannot insert duplicate key in object 'dbo.AgentPushData'.
    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.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.SqlBulkCopy.WriteToServerInternal()
       at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
       at Altiris.NS.Discovery.DiscoveredMachinePushItem.SyncPushDataWithDB(Boolean bBackupData) )
    ( Exception logged from:
       at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
       at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
       at Altiris.NS.Discovery.DiscoveredMachinePushItem.SyncPushDataWithDB(Boolean bBackupData)
       at Altiris.NS.Discovery.DiscoveredMachinePushItem.OnToXml(XmlTextWriter xmlBuilder)
       at Altiris.NS.ItemManagement.Item.Save()
       at Altiris.NS.UI.InstallClientTab.ImportFromFile(String importMachines)
       at Altiris.NS.UI.InstallClientTab.computerGridControl_OnPreGridCallback(Object sender, CallBackEventArgs args)
       at Altiris.WebControls.GridControl.GridControl_GridCallback(Object sender, CallBackEventArgs e)
       at ComponentArt.Web.UI.CallBack.HandleCallback(String[] arParams)
       at ComponentArt.Web.UI.CallBack.ComponentArtRender(HtmlTextWriter output)
       at ComponentArt.Web.UI.WebControl.Render(HtmlTextWriter output)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at ComponentArt.Web.UI.CallBack.ComponentArtRender(HtmlTextWriter output)
       at ComponentArt.Web.UI.WebControl.Render(HtmlTextWriter output)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
       at System.Web.UI.WebControls.CompositeControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
       at System.Web.UI.WebControls.CompositeControl.Render(HtmlTextWriter writer)
       at ASP.admin_clientmanagement_installclienttab_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at Altiris.NS.UI.InstallClientTab.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
       at System.Web.UI.WebControls.CompositeControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
       at ComponentArt.Web.UI.PageView.Render(HtmlTextWriter output)
       at ComponentArt.Web.UI.MultiPage.ComponentArtRender(HtmlTextWriter output)
       at ComponentArt.Web.UI.WebControl.Render(HtmlTextWriter output)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
       at System.Web.UI.WebControls.CompositeControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output)
       at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer)
       at ASP.admin_clientmanagement_installclient_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Page.Render(HtmlTextWriter writer)
       at Altiris.NS.UI.Controls.PageCachePage.Render(HtmlTextWriter writer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.admin_clientmanagement_installclient_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
       at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
       at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
       at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
       at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
       at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
     )
    ( Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient Data Provider )]]></event>

    ----------------------------------------------------------------------------------------------------



  • 2.  RE: Agent Install Page - Data could not be loaded
    Best Answer

    Posted Nov 23, 2010 10:41 AM

    If anyone else encounters this, I was able to resolve it by opening up the dbo.AgentPushData table and then deleting its entries.  In my case, all of the entries had GUIDs comprised of 0s and the [InputName] field contained machine names that were either blank or had spaces between each of the letters.

    After removing the invalid entries, I was able to add machines to the installation list without issue.

     

    Mike