Note: Before attempting to run the steps below, try to reclaim the scheduled reports from the
Administration >
Orphaned Content page. Content from a deleted user will appear on this page and can be reclaimed by an administrator, and then modified or deleted easily from the UI.
To resolve the issue, remove the scheduled report from the database.
vRealize Operations 8.0 - 8.6.4
- Log into the Primary node as root via SSH or console.
- Run the following command to log into the Cassandra database:
$VMWARE_PYTHON_BIN $ALIVE_BASE/cassandra/apache-cassandra-*/bin/cqlsh --ssl --cqlshrc $VCOPS_BASE/user/conf/cassandra/cqlshrc
- Use the select query to view all scheduled reports:
select * from globalpersistence.nce_content_report_schedule_reportschedule;
Note: Use strvalue of the output of the select statement to identify the scheduled report to be deleted.
Example: strvalue from a scheduled report that runs on the cluster level every Monday at 8 AM:
{"com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule":{"id":"########-####-####-####-########4a91","uniqueKey":"com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule.########-####-####-####-########4a91","Version":0,"locale":"en","ownerUserId":"########-####-####-####-########8fe3","reportDefinitionId":"########-####-####-####-########8505","resourceRef":{"resourceId":"########-####-####-####-########5b8a","resourceKindKey":{"AdapterKind":"VMWARE", "ResourceKind":"ClusterComputeResource"},"traversalSpecTypeName":"vSphere Hosts and Clusters-VMWARE-vSphere World"},"nextScheduledRuntime":"2016-04-11 15:00:00.0 UTC","recurrence":{"@class":"com.vmware.statsplatform.persistence.content.report.schedule.recurrence.WeeklyRecurrence","timeZoneId":"America/Phoenix",
"startHour":8,"startDate":"2016-04-07 00:00:00.0 UTC","recurrencePeriod":1,"occurDaysOfWeek":[{"com.vmware.statsplatform.persistence.content.report.schedule.recurrence. DayOfWeek":"MONDAY"}]},"lastModificationTimeStamp":
"2016-04-07 22:06:40.501 UTC","sendEmail":false,"emailRecipients":"","privacy":"private","uploadReport":false,"uploadFolder":"","uploadCsvReport":false,
"uploadPdfReport":false}}
- Note the uniqueKey value of the scheduled report to be deleted from step 3.
Example: com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule.########-####-####-####-########4a91
- Run the following command to delete the scheduled report:
delete from globalpersistence.nce_content_report_schedule_reportschedule where namespace='nce_content_report_schedule_reportschedule' and classtype='nce_content_report_schedule_reportschedule' and key= key_value;
Note: Replace key_value with the key value found in step 4.
Example: delete from globalpersistence.nce_content_report_schedule_reportschedule where namespace='nce_content_report_schedule_reportschedule' and classtype='nce_content_report_schedule_reportschedule' and key='com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule.
########-####-####-####-########4a91';
- Type exit to log out.
VMware Aria Operations 8.10 and later
- Log into the Primary node as root via SSH or console.
- Run the following command to switch to the postgres user:
su - postgres
- Run the following command to launch the psql utility in the repl DB:
/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433
- Use the select query to view all scheduled reports:
select * from kv_nce_content_report_schedule_reportschedule;
Note: Use strvalue of the output of the select statement to identify the scheduled report to be deleted.
Example: strvalue from a scheduled report that runs on the cluster level every Monday at 8 AM:
{"com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule":{"id":"########-####-####-####-########4a91","uniqueKey":"com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule.########-####-####-####-########4a91","Version":0,"locale":"en","ownerUserId":"########-####-####-####-########8fe3","reportDefinitionId":"########-####-####-####-########8505","resourceRef":{"resourceId":"########-####-####-####-########5b8a","resourceKindKey":{"AdapterKind":"VMWARE", "ResourceKind":"ClusterComputeResource"},"traversalSpecTypeName":"vSphere Hosts and Clusters-VMWARE-vSphere World"},"nextScheduledRuntime":"2016-04-11 15:00:00.0 UTC","recurrence":{"@class":"com.vmware.statsplatform.persistence.content.report.schedule.recurrence.WeeklyRecurrence","timeZoneId":"America/Phoenix",
"startHour":8,"startDate":"2016-04-07 00:00:00.0 UTC","recurrencePeriod":1,"occurDaysOfWeek":[{"com.vmware.statsplatform.persistence.content.report.schedule.recurrence. DayOfWeek":"MONDAY"}]},"lastModificationTimeStamp":
"2016-04-07 22:06:40.501 UTC","sendEmail":false,"emailRecipients":"","privacy":"private","uploadReport":false,"uploadFolder":"","uploadCsvReport":false,
"uploadPdfReport":false}}
- Note the uniqueKey value of the scheduled report to be deleted from step 3.
Example: com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule.########-####-####-####-########4a91
- Run the following command to delete the scheduled report:
delete from kv_nce_content_report_schedule_reportschedule where namespace='nce_content_report_schedule_reportschedule' and classtype='nce_content_report_schedule_reportschedule' and key= key_value;
Note: Replace key_value with the key value found in step 4.
Example: delete from kv_nce_content_report_schedule_reportschedule where namespace='nce_content_report_schedule_reportschedule' and classtype='nce_content_report_schedule_reportschedule' and key='com.vmware.statsplatform.persistence.content.report.schedule.ReportSchedule.
########-####-####-####-########4a91';
- Type \q to log out.