Page Comparison

View file

name	ScanningApplicationJobList_se_2_14_129_patched.sql
height	250

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.

...

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.

Code Block

language	sql

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

Versions Compared

Old Version 4

New Version Current

Key

Related articles