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..