Symantec Management Platform (Notification Server)

 View Only

  • 1.  pmimport fails after database reconfigure

    Posted Jun 03, 2010 12:59 AM
    This is when we decided to reconfigure the database after a month of troubleshooting on the Symantec Installation Manager of Patch Management on SP2 error (Not properly configure)

    When the database is reconfigure, the Patch Management on SP2 was back to normal but then the pmimport failed to update.





  • 2.  RE: pmimport fails after database reconfigure

    Posted Jun 03, 2010 08:06 AM

    check the Altiris logs on the server. Looks for errors (red color, severity 1), and warnings (blue, severity 2).


  • 3.  RE: pmimport fails after database reconfigure

    Posted Jun 08, 2010 08:08 AM
    Below is the error log after I run the pmimport.


    Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a.log
    Priority: 1
    Date: 6/8/2010 12:51:23 AM
    Tick Count: 1274525718
    Host Name: BBH-NS-01
    Process: AeXSvc (12564)
    Thread ID: 129
    Module: AeXSVC.exe
    Source: Altiris.NS.LegacyInterop.
    ItemMessageDispatcherService.Dispatch
    Description: ItemMessageDispatcherService::Dispatch

    ( Exception Details: Altiris.NS.Exceptions.AeXItemNotFoundException: Unable to load the target item for the client message. (Guid: "Deleted: office2003-KB981432-FullFile-ENU.exe for April212010-KB-973687, KB-979306, MS10-018, MS10-019, MS10-020, MS10-021, MS10-022, MS10-023, MS10-024, MS10-025, MS10-026, MS10-028, MS1... (e007a2d6-2d61-4e82-8add-e1e9b67bd71f)")
      at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message, Boolean useFilename) )
    ( Exception logged from:
      at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
      at Altiris.Diagnostics.Logging.EventLog.ReportException(String strMessage, String category, Exception exception)
      at Altiris.NS.Logging.EventLog.ReportException(String strMessage, Exception exception)
      at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message, Boolean useFilename)
      at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message)
      at Altiris.NS.ClientMessaging.FileDispatcher.ProcessFileCallback(Object state)
      at Altiris.Common.Threading.LocalThreadPool.ExecuteUserWorkItem(UserWorkItem workItem)
      at Altiris.NS.Threading.NSThreadPool.ExecuteUserWorkItem(UserWorkItem workItem)
      at Altiris.Common.Threading.LocalThreadPool.ExecuteUserWorkItemInContext(UserWorkItem workItem)
      at Altiris.Common.Threading.LocalThreadPool.ThreadPoolProc(Object threadStartParameter)
      at System.Threading.ThreadHelper.ThreadStart(Object obj)
     )
    ( Extra Details:  Type=Altiris.NS.Exceptions.AeXItemNotFoundException Src=Altiris.NS.LegacyInterop )


  • 4.  RE: pmimport fails after database reconfigure

    Posted Jun 11, 2010 07:39 AM

    Good Evening Guys,

    I found another log that implies the failure of pmimport.

    Please lend me some time for me to understand how this scenario be answered.

    Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a11.log
    Priority: 1
    Date: 6/11/2010 1:32:25 AM
    Tick Count: 1536035000
    Host Name: BBH-NS-01
    Process: AtrsHost (1736)
    Thread ID: 94
    Module: AtrsHost.exe
    Source: Altiris.PatchManagementCore.
    Tasks.Server.PMResourceImportTask.ExecuteTask
    Description: Patch Management Import Resources task exception

    ( Exception Details: System.Data.SqlClient.SqlException: Procedure
    spPMCore_DataDeletionForItemStatusAfterPMImportTable has no parameters
    and arguments were supplied.
      at System.Data.SqlClient.SqlConnection.OnError(SqlException
    exception, Boolean breakConnection)
      at System.Data.SqlClient.SqlInternalConnection.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.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.InternalExecuteNonQuery(DbAsyncResult
    result, String methodName, Boolean sendToPipe)
      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
      at Altiris.NS.DataAccessLayer.Implementation.Altiris_PatchManagementCore_DataAccessLayerPatchManagementCorePoliciesDAL.spPMCore_DataDeletionForItemStatusAfterPMImportTable(Guid
    VendorGuid)
      at Altiris.PatchManagementCore.Tasks.Server.PMResourceImportTask.ExecuteTask()
    )
    ( Exception logged from:
      at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32
    severity, String strMessage, String category, Exception exception)
      at Altiris.Diagnostics.Logging.EventLog.ReportException(String
    strMessage, String category, Exception exception)
      at Altiris.NS.Logging.EventLog.ReportException(String strMessage,
    Exception exception)
      at Altiris.PatchManagementCore.Tasks.Server.PMResourceImportTask.ExecuteTask()
      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.ThreadHelper.ThreadStart_Context(Object state)
      at System.Threading.ExecutionContext.runTryCode(Object userData)
      at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode
    code, CleanupCode backoutCode, Object userData)
      at System.Threading.ExecutionContext.RunInternal(ExecutionContext
    executionContext, ContextCallback callback, Object state)
      at System.Threading.ExecutionContext.Run(ExecutionContext
    executionContext, ContextCallback callback, Object state)
      at System.Threading.ThreadHelper.ThreadStart(Object obj)
     )
    ( Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net
    SqlClient Data Provider )


    Thank you..



  • 5.  RE: pmimport fails after database reconfigure

    Posted Jun 15, 2010 03:51 AM

    Hi Guys,

    I have been thru with this procedure using the vbs for SMP 7

    https://kb.altiris.com/display/1n/articleDirect/index.asp?aid=3861&r=0.5499842

    I ended up twice failure.

    I also undergone query on the Notification Server base on this link

    http://www.ledegen.be/html/NSindex.htm (KB 26246) hoping that I could find the guid ive looking for but i didnt.

    Im new to sql query. I would like to ask form anybody how to restore the pmimport failure out from itemnotfound log value.

    See below.



    Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a.log
    Priority: 1
    Date: 6/14/2010 9:05:55 PM
    Tick Count: 326183250
    Host Name: BBH-NS-01
    Process: AeXSvc (1616)
    Thread ID: 51
    Module: AeXSVC.exe
    Source: Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch
    Description: ItemMessageDispatcherService::Dispatch

    ( Exception Details: Altiris.NS.Exceptions.

    AeXItemNotFoundException: Unable to load the target item for the client message. (Guid: "Deleted: office2003-KB981432-FullFile-ENU.exe for April212010-KB-973687, KB-979306, MS10-018, MS10-019, MS10-020, MS10-021, MS10-022, MS10-023, MS10-024, MS10-025, MS10-026, MS10-028, MS1... (e007a2d6-2d61-4e82-8add-e1e9b67bd71f)")
       at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message, Boolean useFilename) )
    ( Exception logged from:
       at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
       at Altiris.Diagnostics.Logging.EventLog.ReportException(String strMessage, String category, Exception exception)
       at Altiris.NS.Logging.EventLog.ReportException(String strMessage, Exception exception)
       at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message, Boolean useFilename)
       at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message)
       at Altiris.NS.ClientMessaging.FileDispatcher.ProcessFileCallback(Object state)
       at Altiris.Common.Threading.LocalThreadPool.ExecuteUserWorkItem(UserWorkItem workItem)
       at Altiris.NS.Threading.NSThreadPool.ExecuteUserWorkItem(UserWorkItem workItem)
       at Altiris.Common.Threading.LocalThreadPool.ExecuteUserWorkItemInContext(UserWorkItem workItem)
       at Altiris.Common.Threading.LocalThreadPool.ThreadPoolProc(Object threadStartParameter)
       at System.Threading.ThreadHelper.ThreadStart(Object obj)
     )
    ( Extra Details:  Type=Altiris.NS.Exceptions.AeXItemNotFoundException Src=Altiris.NS.LegacyInterop )
     



    Im hoping for any kind of  answer that ill be followng with the next step in this troubleshooting process.. Thank You.


  • 6.  RE: pmimport fails after database reconfigure

    Posted Jun 15, 2010 09:13 AM
    so, I'm not following your troubleshooting steps. The first error log indicates packages that were staged for patch management are no longer found, and should be easily resolved by restaging, once you get the pmimport done.

    The second log is more descriptive, and indicates you are having issues with a core patch management stored procedure that is either corrupted or missing a key requirement.

    Perhaps you can shed some light on how your performed your database 'reconfigure'. Were you logged on locally to the server? Is the SQL Server on box or off? Were you logged on with the Altiris service account?


  • 7.  RE: pmimport fails after database reconfigure

    Posted Jun 15, 2010 09:56 AM

    Thanks for the Reply Sir Jharings,

    Well, just now, i didnt find an error on itemnotfound when i add the package from where it was looked.

    And the remaining one is the the one you have ask of.


    To answer you Sir,

    I did the 'reconfigure' when I logged in locally to the NS server which has its own SQL EXPRESS. Now as I remember, it was not the Altiris service account I logged in and to the 'reconfigure' .



  • 8.  RE: pmimport fails after database reconfigure
    Best Answer

    Posted Jun 16, 2010 12:15 AM

    Guys Id like to dissiminate this information that I finally able to resolve this issue using the Altiris KB 52130.

    https://kb.altiris.com/display/1n/index.asp?c=&cpc=&cid=&cat=&catURL=&r=3.988284E-02


    Thank You.