| View file | ||||
|---|---|---|---|---|
|
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 | ||
|---|---|---|
| ||
-- 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
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...