Page Comparison

Problem: Unable to rescan vCenter application with version 2.14.205.

...

There is an issue with the DataTTL column when setting the recan rescan for vCenters. Even though the value is set to 1 (which is the value for daily rescan) there rescan is happening.

...

Confirm the vCenter is ApplicationTypeEnumID = 12

Resolution:

Set up a SQL Server Agent Job to run Daily,Weekly or Monthly

...

UPDATE ApplicationScanHistory SET AttemptCount = 1, NextScanDate = GETDATE()
WHERE ApplicationID IN
(SELECT ApplicationID FROM Application WHERE ApplicationTypeEnumID = 12)

Or Run the patch included

Line 44-55 has been added.

	-- Reset any Application that DataTTL has expired since the last scan attempt
	UPDATE dbo.[ApplicationScanHistory]
		SET [AttemptCount] = @MaxFailures-1
	WHERE [ApplicationScanHistoryID]IN
		(
			SELECT [ApplicationScanHistoryID]
			FROM [ApplicationScanHistory] ash WITH( NOLOCK )
			JOIN [Application] a WITH( NOLOCK ) ON a.[ApplicationID] =ash.[ApplicationID]
			WHERE ([ServiceTypeEnumID] = @ServiceTypeEnumID
				AND a.[DataTTL] is not null 
				AND DATEADD(DAY, a.[DataTTL], ash.[LastAttemptDate]) <= @CurrentDate)
				AND ash.[AttemptCount] >= @MaxFailures);	

Related articles