Differences

This shows you the differences between two versions of the page.

--- resolution_area:watchdog_resolutions:res-w9216 [2021/06/29 17:02] – btobin
+++ resolution_area:watchdog_resolutions:res-w9216 [2021/12/23 16:51] (current) – 10.91.120.28
@@ Line 5: / Line 5: @@
 **Purpose:**
+The stats_network_identifier_node_count table that this watchdog checks is used by the "Availability - Carrier Availability Per Network and Month" report specific to EXT. It checks if the required data has been populated.
 **Scenario:**
+The last time this watchdog occurred was because the cronjob didn't run on the required time.
 **Resolution:**
+This watchdog will resolve itself once this query returns a non-zero value:
+<code>SELECT IF(DAY(NOW()) = 1, 1, (SELECT  COUNT(*) FROM stats_network_identifier_node_count WHERE MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()))) as 'count(*)';</code>
 **Manual Action Steps:**
+Ensure crontab is working correctly and run <code>/home/scotty/script/network_element_count_stats/populate_ne_count_stats.sh</code> script that exists on extdb1
 **Auto Clear:**
+No

Internal Errigal Collaboration Wiki