Differences

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

--- resolution_area:watchdog_resolutions:res-w9215 [2021/06/25 10:09] – external edit 127.0.0.1
+++ resolution_area:watchdog_resolutions:res-w9215 [2021/07/06 12:32] (current) – 10.91.120.28
@@ Line 1: / Line 1: @@
 =====MonthlyNetIdentifierCountIsZero=====
-**Level:** Major
+**Level:** Major :!:
-**Purpose:**
+**Purpose:** This alert tells us that the network identifier count query returned 0 results. This is used for billing purposes
-**Scenario:**
+**Scenario:** This watchdog runs this query and alerts us if the result is 0 <WRAP center round box 60%>
+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(*)';
+</WRAP>
-**Resolution:**
-**Manual Action Steps:**
+**Resolution:** Check the cronjob to see if this executed at the right time <WRAP center round box 60%>
+0 1 * * /home/scotty/script/network_element_count_stats/populate_ne_count_stats.sh  > /home/scotty/script/network_element_count_stats/ne_populate_stats.out 2>&1
+</WRAP>
+This is supposed to run at 00:00 on the first of the month but sometimes it may run an hour before.
-**Auto Clear:**
+**Manual Action Steps:** If this happens check the crontab, there may not be a CRON_TZ variable set and cron may be using a different timezone than the server. If this is the case set this to be the same timezone and restart the cron service.
+**Auto Clear:** This will auto clear once the result is not 0

Internal Errigal Collaboration Wiki