Anybody else attempt to run the PowerShell command...
# citrix-vad
d
Anybody else attempt to run the PowerShell command: Get-MonitorConfiguration on a 2402 site and get an error message: "Get-MonitorConfiguration : A database operation failed and could not be recovered : Reason ?" I opened a ticket with Citrix already. Found this for 7.11: https://support.citrix.com/article/CTX218011/error-getmonitorconfiguration-a-database-operation-failed-and-could-not-be-recovered I assume the issue is going to be similar.
s
works on a net new build (2402) for me....don't currently have an upgraded one to test.
👍 1
d
Happens on both of my upgraded sites.
s
Probably fixed another spelling error in the database, but don't change it during an upgrade.
d
That's my expectation as well, I couldn't find anything obvious in the one table I looked at. Just for giggles, I took an export of the column from the DB with the spelling error previously and ran it through ChatGPT to look for spelling errors. It didn't find anything obvious.
Would anybody mind comparing or sending me to do the comparison their list of names from the Site DB Monitor.Configuration table from a 2402 site that can run Get-MonitorConfiguration, please? SELECT * FROM [Monitor].[Configuration] Name DataCollectionEnabled GroomSessionsRetentionDays GroomFailuresRetentionDays GroomLoadIndexesRetentionDays GroomDeletedRetentionDays GroomSummariesRetentionDays GroomMachineHotfixLogRetentionDays GroomApplicationInstanceRetentionDays GroomResourceUsageRawDataRetentionDays GroomResourceUsageMinuteDataRetentionDays GroomResourceUsageHourDataRetentionDays GroomResourceUsageDayDataRetentionDays GroomProcessUsageRawDataRetentionDays GroomProcessUsageMinuteDataRetentionDays GroomProcessUsageHourDataRetentionDays GroomProcessUsageDayDataRetentionDays GroomSessionMetricsDataRetentionDays FullPollStartHour ResolutionPollTimeHours SyncPollTimeHours PermissionsCacheExpiration SinkErrorsBeforeFail FullPollRetryPeriodMinutes ResolutionPollRetryPeriodMinutes SyncPollRetryPeriodMinutes DatabaseWorkerRetryCount MaxItemsPerBrokerPoll MinSecsBetweenBrokerPolls MaximumDataPointsToReturn ReapSessionFrequencyHours ReapCatalogFrequencyHours ReapHypervisorFrequencyHours ReapDesktopGroupFrequencyHours ReapMachineFrequencyHours ReapApplicationFrequencyHours ReapSessionStartupDelayMinutes ReapCatalogStartupDelayMinutes ReapHypervisorStartupDelayMinutes ReapDesktopGroupStartupDelayMinutes ReapMachineStartupDelayMinutes ReapApplicationStartupDelayMinutes ReapRetryHours ConsolidateSessionActivityFrequencyMinutes ConsolidateMachineSessionCountFrequencyMinutes ConsolidateFailureLogsFrequencyMinutes ConsolidateLoadIndexesFrequencyHours ConsolidateSessionStartupDelayMinutes ConsolidateMachineSessionCountStartupDelayMinutes ConsolidateFailureLogsStartupDelayMinutes ConsolidateLoadIndexesStartupDelayMinutes ConsolidationRetryMinutes ConsolidateApplicationActivityFrequencyMinutes ConsolidateApplicationStartupDelayMinutes ConsolidateDesktopUsageActivityFrequencyMinutes ConsolidateDesktopUsageStartupDelayMinutes ConsolidateResourceUsageActivityFrequencyMinutes ConsolidateResourceUsageStartupDelayMinutes ConsolidateMachineMetricFrequencyDays ConsolidateMachineMetricStartupDelayMinutes ConsolidateProcessUsageActivityFrequencyMinutes ConsolidateProcessUsageStartupDelayMinutes GroomSessionsFrequencyDays GroomFailuresFrequencyDays GroomLoadIndexesFrequencyDays GroomDeletedFrequencyDays GroomSummariesFrequencyDays GroomMachineHotfixLogFrequencyDays GroomApplicationInstanceFrequencyDays GroomRetryMinutes DetailedSqlOutputEnabled MonitorQueryTimeoutSeconds GroomMinuteRetentionDays GroomHourlyRetentionDays GroomStartHour GroomTaskLogRetentionDays GroomTaskLogFrequencyDays CollectHotfixDataEnabled HotfixRetryCount HotfixRetrySpanMinutes GroomNotificationLogRetentionDays GroomNotificationLogFrequencyDays GroomResourceUsageFrequencyDays GroomResourceUsageSummaryFrequencyDays GroomProcessUsageFrequencyHours GroomProcessUsageMinuteFrequencyHours GroomProcessUsageHourFrequencyHours GroomProcessUsageDayFrequencyDays GroomSessionMetricsFrequencyHours EnableMinLevelGranularityProcessUtilization EnableHourLevelGranularityProcessUtilization EnableDayLevelGranularityProcessUtilization ForceHostNameResolution NameResolutionPollPeriodMinutes NameResolutionRetryPeriodMinutes GroomMachineMetricFrequencyDays GroomMachineMetricDaySummaryFrequencyDays GroomMachineMetricDataRetentionDays GroomMachineMetricDaySummaryDataRetentionDays GroomApplicationProbeLogsFrequencyDays GroomApplicationProbeLogsRetentionDays ReapProbeEndpointStartupDelayMinutes ReapProbeEndpointFrequencyHours ReapProbeEndpointRetentionDays ConsolidateMachinesFrequencyHours SyncMonitorDataToCasEventHubFrequencyInMinutes SyncMonitorDataToCasEventHubRetryMinutes SyncMonitorDataToCasEventHubStartupDelayMinutes GroomSessionAutoReconnectsRetentionDays GroomSessionAutoReconnectsFrequencyDays DismissHypervisorAlertsRetentionDays DismissHypervisorAlertsFrequencyDays SendVdaAnalyticsConfigToVdaFrequencyInMinutes SendVdaAnalyticsConfigToVdaRetryMinutes SendVdaAnalyticsConfigToVdaStartupDelayMinutes SendProcessDataToCASAndDatabase SendProcessDataToCASAndSkipDatabase DisableGoogleAnalytics DisableHypervisorMonitoring GroomStartMinuteOffsetEarliest GroomStartMinuteOffsetLatest DisablePendoTrackEvents SessionRecordingDataProcessing EnableProcessDataLimitedMachines GroomProcessDataLimitedMachinesRetentionDays ProcessDataLimitedMachinesCount GroomProcessDataLimitedMachinesFrequencyDays EnableVdaDataCollection
s
yeah, one sec
you want all the values, or just the names?
DataCollectionEnabled GroomSessionsRetentionDays GroomFailuresRetentionDays GroomLoadIndexesRetentionDays GroomDeletedRetentionDays GroomMachineHotfixLogRetentionDays GroomApplicationInstanceRetentionDays GroomResourceUsageRawDataRetentionDays GroomResourceUsageMinuteDataRetentionDays GroomResourceUsageHourDataRetentionDays GroomProcessUsageRawDataRetentionDays GroomProcessUsageMinuteDataRetentionDays GroomProcessUsageHourDataRetentionDays GroomProcessUsageDayDataRetentionDays GroomSessionMetricsDataRetentionDays FullPollStartHour ResolutionPollTimeHours SyncPollTimeHours DisableHypervisorMonitoring DisablePendoTrackEvents EnableProcessDataLimitedMachines SessionRecordingDataProcessing GroomProcessDataLimitedMachinesRetentionDays ProcessDataLimitedMachinesCount GroomLhcReportRetentionDays EnableVdaDataCollection PermissionsCacheExpiration SinkErrorsBeforeFail FullPollRetryPeriodMinutes ResolutionPollRetryPeriodMinutes SyncPollRetryPeriodMinutes DatabaseWorkerRetryCount MaxItemsPerBrokerPoll MinSecsBetweenBrokerPolls MaximumDataPointsToReturn ReapSessionFrequencyHours ReapCatalogFrequencyHours ReapHypervisorFrequencyHours ReapDesktopGroupFrequencyHours ReapMachineFrequencyHours ReapApplicationFrequencyHours ReapSessionStartupDelayMinutes ReapCatalogStartupDelayMinutes ReapHypervisorStartupDelayMinutes ReapDesktopGroupStartupDelayMinutes ReapMachineStartupDelayMinutes ReapApplicationStartupDelayMinutes ReapRetryHours ConsolidateSessionActivityFrequencyMinutes ConsolidateMachineSessionCountFrequencyMinutes ConsolidateFailureLogsFrequencyMinutes ConsolidateLoadIndexesFrequencyHours ConsolidateSessionStartupDelayMinutes ConsolidateMachineSessionCountStartupDelayMinutes ConsolidateFailureLogsStartupDelayMinutes ConsolidateLoadIndexesStartupDelayMinutes ConsolidationRetryMinutes ConsolidateApplicationActivityFrequencyMinutes ConsolidateApplicationStartupDelayMinutes ConsolidateDesktopUsageActivityFrequencyMinutes ConsolidateDesktopUsageStartupDelayMinutes ConsolidateResourceUsageActivityFrequencyMinutes ConsolidateResourceUsageStartupDelayMinutes ConsolidateMachineMetricFrequencyDays ConsolidateMachineMetricStartupDelayMinutes ConsolidateProcessUsageActivityFrequencyMinutes ConsolidateProcessUsageStartupDelayMinutes GroomSessionsFrequencyDays GroomFailuresFrequencyDays GroomLoadIndexesFrequencyDays GroomDeletedFrequencyDays GroomSummariesFrequencyDays GroomMachineHotfixLogFrequencyDays GroomApplicationInstanceFrequencyDays GroomRetryMinutes DetailedSqlOutputEnabled MonitorQueryTimeoutSeconds GroomMinuteRetentionDays GroomHourlyRetentionDays GroomStartHour SendVdaAnalyticsConfigToVdaFrequencyInMinutes SendVdaAnalyticsConfigToVdaRetryMinutes SendVdaAnalyticsConfigToVdaStartupDelayMinutes GroomTaskLogRetentionDays GroomTaskLogFrequencyDays CollectHotfixDataEnabled HotfixRetryCount HotfixRetrySpanMinutes GroomNotificationLogRetentionDays GroomNotificationLogFrequencyDays GroomResourceUsageFrequencyDays GroomResourceUsageSummaryFrequencyDays GroomProcessUsageFrequencyHours GroomProcessUsageMinuteFrequencyHours GroomProcessUsageHourFrequencyHours GroomProcessUsageDayFrequencyDays GroomSessionMetricsFrequencyHours EnableMinLevelGranularityProcessUtilization EnableHourLevelGranularityProcessUtilization EnableDayLevelGranularityProcessUtilization GroomProcessDataLimitedMachinesFrequencyDays GroomLhcReportFrequencyDays ForceHostNameResolution NameResolutionPollPeriodMinutes NameResolutionRetryPeriodMinutes GroomMachineMetricFrequencyDays GroomMachineMetricDaySummaryFrequencyDays GroomMachineMetricDataRetentionDays GroomApplicationProbeLogsFrequencyDays GroomApplicationProbeLogsRetentionDays ReapProbeEndpointStartupDelayMinutes ReapProbeEndpointFrequencyHours ReapProbeEndpointRetentionDays ConsolidateMachinesFrequencyHours SyncMonitorDataToCasEventHubFrequencyInMinutes SyncMonitorDataToCasEventHubRetryMinutes SyncMonitorDataToCasEventHubStartupDelayMinutes GroomSessionAutoReconnectsRetentionDays GroomSessionAutoReconnectsFrequencyDays DismissHypervisorAlertsRetentionDays DismissHypervisorAlertsFrequencyDays SendProcessDataToCASAndDatabase SendProcessDataToCASAndSkipDatabase GroomSummariesRetentionDays GroomResourceUsageDayDataRetentionDays GroomMachineMetricDaySummaryDataRetentionDays GroomApplicationFaultsFrequencyDays GroomApplicationErrorsFrequencyDays SyncDataToCasRetryMinutes SyncDataToCasStartupDelayMinutes SyncDataToCasFrequencyInMinutes SyncProbeDataToPendoStartupDelayMinutes SyncProbeDataToPendoFrequencyInMinutes ProbeDesktopWorkerDefaultTimeSpanHours ProbeDesktopWorkerStartupDelayMinutes ProbeDesktopWorkerRetryHours VdaDataWorkerRetryCount SettingsLoadedFromDB GroomApplicationFaultsRetentionDays GroomApplicationErrorsRetentionDays GroomStartMinuteOffsetEarliest GroomStartMinuteOffsetLatest SyncDataToCasStartHour
d
Much Appreciated! Looking through now.
With the data provided by @Steve Noel I was able to fix one test DB by adding the 17 missing values and deleting the extra value. Now to fix the other test DB and prepare to apply to production. Citrix support is still trying to have me test various DB connection strings and since I mentioned it, reverting to CU2 and upgrading to CU3 to see if things get better. I'm not in a position to rollback production 3 weeks to CU2, so that's really a non-starter. Glad for the community here to get great assistance!
s
nice!! hopefully the prod ones go as smoothly!
👍 1