hello,
I applied the script for the following http://www.symantec.com/docs/TECH211381
and now I have this error:
Exception:Statement(s) could not be prepared. Invalid column name 'DELETED'. OLE DB provider "SQLNCLI10" for linked server "ITANALYTICS_SEP_SYMANTEC_CMDB_FOS-3SI-SECT\SEP_SEP" returned message "Deferred prepare could not be completed.".
LOG:
Exception updating SEP dependencies
System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): Statement(s) could not be prepared.
Invalid column name 'DELETED'.
OLE DB provider "SQLNCLI10" for linked server "ITANALYTICS_SEP_SYMANTEC_CMDB_FOS-3SI-SECT\SEP_SEP" returned message "Deferred prepare could not be completed.".
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.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.ITAnalyticsSEP.Tasks.SEPUpdateDependenciesTask.ProcessTasks()
SQL Exception details: code=8180, line=1
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.ITAnalyticsSEP.Tasks.SEPUpdateDependenciesTask.ProcessTasks()
at Altiris.ITAnalyticsSEP.Tasks.SEPUpdateDependenciesTask.OnExecuteTask(Hashtable taskArgs)
at Altiris.NS.StandardItems.Tasks.BaseItemTask.ExecuteTask(Hashtable taskArgs, ItemTaskState state)
at Altiris.NS.ItemTaskManagement.ItemTaskThread.LaunchTask()
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()
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.5.1670.0&language=fr&module=z2XPUchvpC1e9I1cd8HnExxxtpAho3mX72jxyI/RcJD5JgqUSufWTbNwB6J9FtUPFOKS3xTK5e2pyQXqVMclDQ==&error=-1021371503&build=**CEDUrlEnd**