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

Article:TECH202761  |  Created: 2013-02-13  |  Updated: 2013-02-13  |  Article URL http://www.symantec.com/docs/TECH202761
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



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


Error



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"



Environment



Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1


Cause



Known Issue


Solution



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


Supplemental Materials

SourceETrack
Value2966660


Article URL http://www.symantec.com/docs/TECH202761


Terms of use for this information are found in Legal Notices