The Delta Resource Membership update schedule fails to run: Error retrieving Collection Last Run Date or it has an invalid format
search cancel

The Delta Resource Membership update schedule fails to run: Error retrieving Collection Last Run Date or it has an invalid format

book

Article ID: 158174

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

When the Delta Resource Membership update schedule is run it quickly fails and aborts. An error similar to the following (excerpt) is found in the NS logs.

 

Module: w3wp.exe

Source: Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule
Description: Error occurred during delta collection updating: Altiris.NS.Exceptions.AeXException: Error retrieving Collection Last Run Date or it has an invalid format. Value '1434-08-14 09:59:19.000', Format 'yyyy'-'MM'-'dd HH':'mm':'ss' ---> System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style)
   at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.get_LastRunDate()
   --- End of inner exception stack trace ---
   at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.get_LastRunDate()
   at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.OnSchedule_Impl()
 

 

Environment

ITMS 7.x, 8.x

Cause

When the process is initiated the stored procedure “spDeltaCollectionUpdate” is run and passed the date and time that the last update had been run via the paramter @LastRunDate. In this case the stored procedure was passed in a data that it could not use:
 
EXECUTE spDeltaCollectionUpdate @LastRunDate='1434-08-14 09:59:19.000', @DependantDataClassHint=N'dependant_dataclass'
 
As a result the process aborts. The value passed into the @LastRunDate parameter is found in C:\ProgramData\Symantec\SMP\Settings\CoreSettings.config
 
DeltaCollectionUpdateLastRunDate

 
In this case the value set was as follows:

<customSetting key="DeltaCollectionUpdateLastRunDate" type="local" value="1434-08-14 09:59:19.000" />

 

Resolution

Change the bogus date to a valid date and time then save the file:
 
<customSetting key="DeltaCollectionUpdateLastRunDate" type="local" value="2013-07-04 10:54:17" />  
 
Also verify that the setting PolicyChangeCollectionUpdateLastRunDate has a valid date as well, or the error may still occur.