PMImport Fails with alog Errors: Failed to generate catalog file and Failed to update assessment files
search cancel

PMImport Fails with alog Errors: Failed to generate catalog file and Failed to update assessment files

book

Article ID: 161662

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Issue/Introduction

The Import Patch Data For Windows task (PMImport) fails no matter what the configuration.

The following errors appear in the alogs:

Severity: 1
Date: 1/28/2015 1:08:15 AM
Tick Count: 136293393
Host Name: XDC01006
Process: AtrsHost (7524)
Thread: 4066
Module: AtrsHost.exe
Source: Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateAssessmentCatalog
Description: Failed to generate catalog file: C:\Program Files\Altiris\Patch Management\packages\windowsvulnerabilityscan\catalog.xml
System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   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()
   at Altiris.NS.DataAccessLayer.Implementation.Altiris_PatchManagement_DataAccessLayerPatchManagementWindowsImport.spPMWin_ServicePackReleases(Guid ServicePackGuid)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.<>c__DisplayClass11.<GenerateServicePacksOfAssessmentCatalog>b__e()
   at Altiris.PatchManagementCore.DataAccessLayer.PMDal.<>c__DisplayClass2`1.<PerformWithDlr>b__0(IDatabaseContext ac)
   at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, IsolationLevel isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Action`1 action, Action`1 retry)
   at Altiris.NS.ContextManagement.DatabaseContext.PerformWithDeadlockRetry(Int32 retries, Action`1 action, Action`1 retry)
   at Altiris.PatchManagementCore.DataAccessLayer.PMDal.PerformWithDlr[TResult](Func`1 func)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateServicePacksOfAssessmentCatalog(XmlWriter writer)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateAssessmentCatalog(String sRootPath)

SQL Exception details: code=64

Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
   at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateAssessmentCatalog(String sRootPath)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.UpdateAssesmentPackage(IEnumerable`1 listOfFiles)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.RunImport(String cabUrl)
   at Altiris.PatchManagementCore.Tasks.Server.PMResourceImportTask.ExecuteTask(IServerTaskExecutionInstance instance)
   at Altiris.PatchManagementCore.Tasks.Server.PMResourceImportTask.OnExecuteSingleton(IServerTaskExecutionInstance i)
   at Altiris.PatchManagementCore.Tasks.Server.SerializingBaseSingletonServerTask`2.OnExecute(IServerTaskExecutionInstance i)
   at Altiris.TaskManagement.ServerTasks.BaseServerTask.OnExecute(ITaskExecutionEngine engine, IServerTaskExecutionInstance instance, TaskInstanceRequest request)
   at Altiris.TaskManagement.ServerTasks.BaseServerTask.Execute(ITaskExecutionEngine engine, IBaseTaskExecutionInstance instance, TaskInstanceRequest request)
   at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.ExecuteTaskHandler()
   at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionThread.ExecuteTaskHandler()
   at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.OnExecute(Object eventComplete)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart(Object obj)

**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.5.1670.0&language=en&module=zow7fEjcoxoyx+7hI5rpZuIqnH48lgyyLOeNEL0kHRDIv5AfUlIQR/WepoTsFk0KoB3wziG7BEuV3hzwM5Q6ow==&error=-1603647839&build=**CEDUrlEnd**

 

 

 

 

 

Severity: 1
Date: 1/28/2015 1:08:15 AM
Tick Count: 136293393
Host Name: XDC01006
Process: AtrsHost (7524)
Thread: 4066
Module: AtrsHost.exe
Source: Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateAssessmentCatalog
Description: Failed to generate catalog file: C:\Program Files\Altiris\Patch Management\packages\windowsvulnerabilityscan\catalog.xml
System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   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()
   at Altiris.NS.DataAccessLayer.Implementation.Altiris_PatchManagement_DataAccessLayerPatchManagementWindowsImport.spPMWin_ServicePackReleases(Guid ServicePackGuid)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.<>c__DisplayClass11.<GenerateServicePacksOfAssessmentCatalog>b__e()
   at Altiris.PatchManagementCore.DataAccessLayer.PMDal.<>c__DisplayClass2`1.<PerformWithDlr>b__0(IDatabaseContext ac)
   at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, IsolationLevel isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Action`1 action, Action`1 retry)
   at Altiris.NS.ContextManagement.DatabaseContext.PerformWithDeadlockRetry(Int32 retries, Action`1 action, Action`1 retry)
   at Altiris.PatchManagementCore.DataAccessLayer.PMDal.PerformWithDlr[TResult](Func`1 func)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateServicePacksOfAssessmentCatalog(XmlWriter writer)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateAssessmentCatalog(String sRootPath)

SQL Exception details: code=64

Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
   at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.GenerateAssessmentCatalog(String sRootPath)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.UpdateAssesmentPackage(IEnumerable`1 listOfFiles)
   at Altiris.PatchManagement.Tasks.WindowsImportTask.RunImport(String cabUrl)
   at Altiris.PatchManagementCore.Tasks.Server.PMResourceImportTask.ExecuteTask(IServerTaskExecutionInstance instance)
   at Altiris.PatchManagementCore.Tasks.Server.PMResourceImportTask.OnExecuteSingleton(IServerTaskExecutionInstance i)
   at Altiris.PatchManagementCore.Tasks.Server.SerializingBaseSingletonServerTask`2.OnExecute(IServerTaskExecutionInstance i)
   at Altiris.TaskManagement.ServerTasks.BaseServerTask.OnExecute(ITaskExecutionEngine engine, IServerTaskExecutionInstance instance, TaskInstanceRequest request)
   at Altiris.TaskManagement.ServerTasks.BaseServerTask.Execute(ITaskExecutionEngine engine, IBaseTaskExecutionInstance instance, TaskInstanceRequest request)
   at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.ExecuteTaskHandler()
   at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionThread.ExecuteTaskHandler()
   at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.OnExecute(Object eventComplete)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart(Object obj)

**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.5.1670.0&language=en&module=zow7fEjcoxoyx+7hI5rpZuIqnH48lgyyLOeNEL0kHRDIv5AfUlIQR/WepoTsFk0KoB3wziG7BEuV3hzwM5Q6ow==&error=-1603647839&build=**CEDUrlEnd**

Cause

Unknown

Resolution

Repair Patch Management according to HOWTO47868. Then run the PMImport again to see if it succeeds. Otherwise follow TECH166778.

 

Applies To

 

Observed in Patch Management 7.5 HF3

Powered by Wolken Software