Failed to generate delta history for DataClass is triggered for different data classes after the NS.Daily task execution

Article:TECH201049  |  Created: 2012-12-20  |  Updated: 2012-12-20  |  Article URL http://www.symantec.com/docs/TECH201049
Article Type
Technical Solution


Issue



After upgrade from ITMS 7.1 SP2 to ITMS 7.1 SP2 MP1, logs are full of error messages like Failed to generate delta history for DataClass (data class guid) after the NS. Daily task execution (default execution time: At 2:10 AM every day).


Error



Failed to generate delta history for DataClass (Guid:3cf98cb3-07b7-4ea8-aa4c-175205d921d5 Name:Comment).
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8400.0&language=en&module=LT8pMTK1+mVI8bVP8a0G5usq3C5lKGgPJAxdPuUcPQg9AbIc2V/PLHZ4zvMHPf+m&error=1728578002&build=**CEDUrlEnd**


( Exception Details: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
   at System.Data.SqlClient.SqlBuffer.get_Int32()
   at Altiris.Connector.ResourceHistory.ResourceDeltaHistory.GenerateDeltas(Guid dataClassGuid)
   at Altiris.Connector.ResourceHistory.ResourceDeltaHistory.GenerateDeltas() )
( 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.Connector.ResourceHistory.ResourceDeltaHistory.GenerateDeltas()
   at Altiris.NS.Scheduling.Schedule.OnSchedule(String 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(IServerChannelSinkStack sinkStack, IMessage msg, IMessage& replyMsg)
   at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at System.Runtime.Remoting.Channels.SoapServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at System.Runtime.Remoting.MetadataServices.SdlChannelSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at System.Runtime.Remoting.Channels.Tcp.TcpServerTransportSink.ServiceRequest(Object state)
   at System.Runtime.Remoting.Channels.SocketHandler.ProcessRequestNow()
   at System.Runtime.Remoting.Channels.SocketHandler.BeginReadMessageCallback(IAsyncResult 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.SqlTypes.SqlNullValueException Src=System.Data )
-----------------------------------------------------------------------------------------------------
Date: 12/6/2012 3:10:08 AM, Tick Count: 827456041, Host Name: CLCNS2, Size: 3.96 KB
Process: AeXSvc (1268), Thread ID: 523, Module: AeXSVC.exe
Priority: 1, Source: Altiris.Connector.ResourceHistory.ResourceDeltaHistory.GenerateDeltas


Environment



Upgrade from ITMS 7.1 SP2 to ITMS 7.1 SP2 MP1


Cause



The error message is triggered by Connector solution functionality based on the assembly path: Altiris.Connector.ResourceHistory.ResourceDeltaHistory.GenerateDeltas. It appears that stored procedure spDCN_RH_GetHistorySnapshotData or spDCN_RH_GetHistorySnapshotDataBatch hasn't been created during the upgrade.
 


Solution



1. Please check from the MS SQL Management Studio -> Symantec_CMDB -> Programmability -> Stored Procedure if you have following Stored Procedues existing:

spDCN_RH_GetHistorySnapshotData
spDCN_RH_GetHistorySnapshotDataBatch

2. In case if at least one stored procedure is missing in your 7.1 SP2 MP1 installation:

* please check if the product is installed in C:\Program Files\Altiris, otherwise please change the path for the commands below.

- please open CMD
-CD C:\Program Files\Altiris\Notification Server\Bin
- AexConfig.exe /configure "C:\Program Files\Altiris\DataConnector\Config\DataConnector.config"

* The repair will run in background, please do not close the CMD during the command execution.  


Supplemental Materials

Value2650743



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


Terms of use for this information are found in Legal Notices