Daily Digest is not being sent

Versions / Builds Affected

20120214

Status

Resolved

Problem Summary

The Daily Digest is not being generated at the specified time

TT / JIRAID

ESM-60

How to Identify

digester_*.csv - One of the following 2 errors will be present 1. 2012-03-08, 10:01:12, 921, 9, ac74, b3dc, info, digester.dll, .ctor, Last digest time: Monday, January 01, 0001 12:00:00 AM 2012-03-08, 10:01:28, 115, 9, ac74, b3dc, info, digester.dll, CheckDigest, Found user to notify EventsManagerAdministrator, id dec82eb1-2579-4268-8f68-a49b39c63632 2012-03-08, 10:01:28, 115, 9, ac74, b3dc, info, digester.dll, CheckDigest, Found user to notify Jamesi, id 2b640a61-1c2b-41c8-97c2-70fbce820ee9 2012-03-08, 10:01:28, 115, 9, ac74, b3dc, info, digester.dll, CheckDigest, Preparing digest. Last digest time was Monday, January 01, 0001 2012-03-08, 10:01:29, 176, 9, ac74, b3dc, info, digester.dll, FormattedSqlString, formatted string value is SELECT sourceArg,extraArg,totals from ( SELECT sourceArg=rule_name, extraArg=upper(computer_name), totals = COUNT(0) FROM cache_critical_events WITH (nolock) WHERE ((EVENT_DATE = cast( 40973.5000000000 as datetime ) AND DATEPART(hour,event_time)>=10) OR (EVENT_DATE = cast( 40974.5000000000 as datetime ) AND DATEPART(hour,event_time)<=10)) GROUP BY rule_name,upper(computer_name) ) TOPall order by extraArg 2012-03-08, 10:01:29, 192, 0, ac74, b3dc, error, digester.dll, LoadSourceTable, Unexpected exception: Invalid object name 'cache_critical_events'. 2012-03-08, 10:01:29, 192, 0, ac74, b3dc, error, digester.dll, LoadSourceTable, Stack trace is: at GFILog.LogException(Exception ex) at digester.DevXChart.LoadSourceTable() at digester.DevXChart..ctor() at digester.DigestEngine.CheckDigest() at SelmProcessor.SelmProc.DoWork() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2. 2012-03-02, 13:30:50, 977, 9, bc4, b08, info, digester.dll, .ctor, Last digest time: Monday, January 01, 0001 12:00:00 AM 2012-03-02, 13:31:07, 992, 9, bc4, b08, info, digester.dll, CheckDigest, Found user to notify Nick, id 35fc1dcd-85d9-4eac-aee7-dda3b02c7b6d 2012-03-02, 13:31:07, 992, 9, bc4, b08, info, digester.dll, CheckDigest, Preparing digest. Last digest time was Monday, January 01, 0001 2012-03-02, 13:31:08, 945, 9, bc4, b08, info, digester.dll, FormattedSqlString, formatted string value is SELECT sourceArg,extraArg,totals from ( SELECT sourceArg=rule_name, extraArg=upper(computer_name), totals = COUNT(0) FROM cache_critical_events WITH (nolock) WHERE ((EVENT_DATE = cast( 40967.5000000000 as datetime ) AND DATEPART(hour,event_time)>=13) OR (EVENT_DATE = cast( 40968.5000000000 as datetime ) AND DATEPART(hour,event_time)<=13)) GROUP BY rule_name,upper(computer_name) ) TOPall order by extraArg 2012-03-02, 13:31:24, 086, 0, bc4, b08, error, digester.dll, LoadSourceTable, Unexpected exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 2012-03-02, 13:31:24, 086, 0, bc4, b08, error, digester.dll, LoadSourceTable, Stack trace is: at GFILog.LogException(Exception ex) at digester.DevXChart.LoadSourceTable() at digester.DevXChart..ctor() at digester.DigestEngine.CheckDigest() at SelmProcessor.SelmProc.DoWork() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

Workaround / Fix Details

ftp://ftp.gfiusa.com/EventsManager/version2012/20120503_ESM2012SR1_PATCH_01.zip

Required Actions

Apply patch specified