KNOWN ISSUE: "Failed to refresh the Resource Update Summary table. Invalid column name '_id'" error appears in log

book

Article ID: 157682

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Customer reported that they have an error in the NS logs that seems to be causing issues with their AD Import (while trying to import Cost Center association mappings).

This is the error message found during AD Import failure:

"Failed to refresh the Resource Update Summary table.


( Exception Details: System.Data.SqlClient.SqlException: Invalid column name
'_id'.
   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.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.ExecuteScalar()
   at
Altiris.NS.StandardItems.Purge.RefreshResourceUpdateSummaryItem.RefreshResourceU
pdateSummary()
)
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity,
String strMessage, String category, Exception exception)
   at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String
strMessage, String category, Exception exception)
   at
Altiris.NS.StandardItems.Purge.RefreshResourceUpdateSummaryItem.RefreshResourceU
pdateSummary()
   at
Altiris.NS.StandardItems.Purge.RefreshResourceUpdateSummaryItem.OnSchedule(Strin
g identifier)
   at Altiris.NS.Scheduling.ScheduleService.ProcessSchedule(String scheduleId)
   at
System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr
md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
   at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
   at
System.Runtime.Remoting.Messaging.ServerObjectTerminatorSink.SyncProcessMessage(
IMessage
reqMsg)
   at System.Runtime.Remoting.Lifetime.LeaseSink.SyncProcessMessage(IMessage
msg)
   at
System.Runtime.Remoting.Messaging.ServerContextTerminatorSink.SyncProcessMessage
(IMessage
reqMsg)
   at
System.Runtime.Remoting.Channels.CrossContextChannel.SyncProcessMessageCallback(
Object[]
args)
   at
System.Runtime.Remoting.Channels.ChannelServices.DispatchMessage(IServerChannelS
inkStack
sinkStack, IMessage msg, IMessage& replyMsg)
   at
System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServe
rChannelSinkStack
sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream
requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders,
Stream& responseStream)
   at
System.Runtime.Remoting.Channels.SoapServerFormatterSink.ProcessMessage(IServerC
hannelSinkStack
sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream
requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders,
Stream& responseStream)
   at
System.Runtime.Remoting.MetadataServices.SdlChannelSink.ProcessMessage(IServerCh
annelSinkStack
sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream
requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders,
Stream& responseStream)
   at
System.Runtime.Remoting.Channels.Tcp.TcpServerTransportSink.ServiceRequest(Objec
t state)
   at System.Runtime.Remoting.Channels.SocketHandler.ProcessRequestNow()
   at
System.Runtime.Remoting.Channels.SocketHandler.BeginReadMessageCallback(IAsyncRe
sult
ar)
   at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
   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.Net.ContextAwareResult.Complete(IntPtr userToken)
   at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr
userToken)
   at System.Net.Sockets.BaseOverlappedAsyncResult.CompletionPortCallback(UInt32
errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
   at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32
errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
)
( Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient
Data Provider
)","Altiris.NS.StandardItems.Purge.RefreshResourceUpdateSummaryItem.RefreshResou
rceUpdateSummary","AeXSvc","1720"


Cause

Known Issue

Resolution

This issue has been reported to the Symantec Development team. A fix has been provided with ITMS 7.1 SP2 MP1 Rollup v3. See HOWTO81832


Applies To

Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1