Drop and Recreate Tables in Clotho for DEX May releaseIssue Description Drop and recreate the tables in Clotho to reflect the retention period change from 3 to 7 days for the following tables. 'dex_active_device_count', 'dex_active_user_count', 'dex_app_available_percentage', 'dex_battery_charge_percentage', 'dex_cpu_usage', 'dex_cpu_usage_all_agents_avg', 'dex_crashes', 'dex_crashes_all_agents_sum', 'dex_disk_usage', 'dex_dns_lookup_time', 'dex_dns_lookup_time_all_agents_avg', 'dex_energy_consumption', 'dex_failed_web_requests', 'dex_failed_web_requests_all_agents_sum', 'dex_io_usage_read', 'dex_io_usage_read_all_agents_avg', 'dex_io_usage_write', 'dex_io_usage_write_all_agents_avg', 'dex_is_running', 'dex_memory_usage', 'dex_memory_usage_all_agents_avg', 'dex_pageload_time', 'dex_pageload_time_all_agents_avg', 'dex_response_time', 'dex_response_time_all_agents_avg', 'dex_session_count', 'dex_session_length', 'dex_session_length_all_agents_avg', 'dex_successful_web_requests', 'dex_successful_web_requests_all_agents_sum', 'dex_uptime', 'dex_usage', 'dex_usage_all_agents_sum', 'dex_is_running' Workaround steps 1. After an instance is upgraded to DEX May release, run the below script in the following path System Definition -> Scripts - Background and select sn_dex scope to drop the tables in Clotho. Make sure the script runs without any errors. var kafkaProducer = new sn_dex.DEXKafkaProducer(), dropStatements = [], tables = ['dex_active_device_count', 'dex_active_user_count', 'dex_app_available_percentage', 'dex_battery_charge_percentage', 'dex_cpu_usage', 'dex_cpu_usage_all_agents_avg', 'dex_crashes', 'dex_crashes_all_agents_sum', 'dex_disk_usage', 'dex_dns_lookup_time', 'dex_dns_lookup_time_all_agents_avg', 'dex_energy_consumption', 'dex_failed_web_requests', 'dex_failed_web_requests_all_agents_sum', 'dex_io_usage_read', 'dex_io_usage_read_all_agents_avg', 'dex_io_usage_write', 'dex_io_usage_write_all_agents_avg', 'dex_is_running', 'dex_memory_usage', 'dex_memory_usage_all_agents_avg', 'dex_pageload_time', 'dex_pageload_time_all_agents_avg', 'dex_response_time', 'dex_response_time_all_agents_avg', 'dex_session_count', 'dex_session_length', 'dex_session_length_all_agents_avg', 'dex_successful_web_requests', 'dex_successful_web_requests_all_agents_sum', 'dex_uptime', 'dex_usage', 'dex_usage_all_agents_sum', 'dex_is_running']; tables.forEach(function(table) { dropStatements.push('DROP TABLE ' + table); }); var message = [{ key: DEXConstants.TABLE.DEX_MATERIALIZED_VIEW_CONFIG, action: 'command', message: dropStatements }]; kafkaProducer.send(DEXConstants.TABLE.DEX_MATERIALIZED_VIEW_CONFIG, message); 2. Follow the below steps to restart the Clotho server Connect to the Clotho server, using LDAP credentials (execute the command in the terminal. Ex: bssh db160021.dva401 - this can be fetched from URL mentioned in <clotho.connection.endpoint> tag in the <instance name>/xmlstats.do?include=clotho url) Note: If ‘bssh’ is not available on your system, please install using this KB article: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0821276 After connecting to clotho server execute ‘pbrun su’ Note: if you get error “Rejected - no privilege found in your groups” Use below kb article to get access https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0657239 LDAP Group Name: ops Or please check this below request RITM392382 | Requested Item | ServiceNow Create a user on the clotho server using the command "snow add-appuser <clotho port> -- --username=<user_name> --password=<password>" if you don't have credentials already.Restart the Clotho server using the command "snow service <clotho port> restart"Run the below script in the following path System Definition -> Scripts - Background and select sn_dex scope to refresh the Clotho. Make sure the script runs without any errors. sn_clotho.ClothoConfigService.refresh(true); 3. Repeat the Step 1. 4. Run the below script in the following path System Definition -> Scripts - Background and select sn_dex scope to recreate the tables in Clotho. Make sure the script runs without any errors. DEXMetricDefinition.createTablesIfNotExist(); Verification steps 1. Get the Clotho endpoint URL from the following link <instance name>/xmlstats.do?include=clotho Ex: <clotho.connection.endpoint><URL>http://db160021.dva401.service-now.com:3409/</URL> 2. Connect to the above Clotho endpoint URL -> Verify that all records in the glide table dex_metric_definition should exist in the URL <clotho_endpoint_url>/testTaggedTable