ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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