Ask the Community
Groups
You See An Error In /Inc/SuspendUpdate.Inc, Line 46 On EmailNotify - Connect IT Community | Kaseya
<main> <article class="userContent"> <h3 data-id="problem">Problem</h3> <p>You have followed the instructions in KB - <a rel="nofollow" href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/hc/en-gb/articles/229034308-Agent-Offline-and-other-alerts-are-not-generated">https://helpdesk.kaseya.com/hc/en-gb/articles/229034308-Agent-Offline-and-other-alerts-are-not-generated</a></p> <p>The process fails with the error:</p> <p>[Microsoft][ODBC SQL Server Driver][SQL Server]The datediff function resulted in an overflow. The number of dateparts seperating two date/time instances is too large. Try to use datediff with a less precise datepart.</p> <p>/inc/suspendUpdate.inc</p> <p>/inc/suspendUpdate.inc, line 46</p> <h3 data-id="cause">Cause</h3> <p>The issue happens when an agent installed on Mac OSX has suspended alarms and the date time of the Mac endpoint reverted to a 1904 date, which can happen during some failure events.</p> <h3 data-id="solution">Solution</h3> <p>Resolve the date issue on the Mac endpoint and remove the alarm suspension from the agent. The, re-run the emailNotify.asp page and make sure you get a blank page and the error is gone. You can then re-apply the alarm suspension.</p> </article> </main>