MailInsight User Traffic report not generating in a reasonable amount of time in large environment

Versions / Builds Affected

20150218

Status

Open

TT / JIRAID

2998

How to Identify

Generating reports against large data sets can take a significant amount of time - this is normal. This "known issue" is based on a customer running GFI Archiver in an environment with 3500 users and a high mail flow. As an example, a User Traffic report against [Everyone] and a [1 day time range] took 20 hours, 27 minutes and 35 seconds to generate (keep an eye on the time stamps of the lines): 2015-07-01,09:14:13,936,1,"#00004A84","#0000001E","info ","MIScheduler",">>> Start GenerateReport(). Report: UserTraffic. User: 53fbccc96bb2634686786b86e2b686a4." 2015-07-01,09:14:13,936,1,"#00004A84","#0000001E","info ","MIScheduler","Get Report Plug-in for UserTraffic" 2015-07-01,09:14:13,954,1,"#00004A84","#0000001E","info ","MIUserTrafficRep","Setting up Font to: Arial for language en-US" 2015-07-01,09:14:13,955,1,"#00004A84","#0000001E","info ","MIUserTrafficRep","Collecting Report Info..." 2015-07-01,09:14:13,955,1,"#00004A84","#0000001E","info ","MIUserTrafficRep","Date between 7/1/2015-7/1/2015 for * " 2015-07-01,09:14:13,956,1,"#00004A84","#0000001E","info ","MIUserTrafficRep","Generating report Data >>" 2015-07-01,09:14:14,017,1,"#00004A84","#0000001E","info ","MIGenUserTraffic",">>Compute" 2015-07-01,09:14:14,032,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","DBs:1" 2015-07-01,09:14:14,032,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","CheckIndexState >>" 2015-07-01,09:14:14,040,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","Normal or Bulk - OK" 2015-07-01,09:14:14,040,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","<< CheckIndexState" 2015-07-01,09:14:28,262,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","Users: 3578" 2015-07-01,09:14:28,326,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","Searching..." 2015-07-01,09:14:30,230,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","Search[0] ... 3668" 2015-07-01,09:14:30,230,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","Searching..." ... 2015-07-01,09:15:14,823,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","Search[16] ... 1511" 2015-07-02,05:41:39,095,1,"#00004A84","#0000001E","info ","MIGenUserTraffic","<Workaround / Fix DetailsPATCH A patch which improves the User Traffic report generation time is available at PSG level. WORKAROUND Generate the report against: - less users (for example smaller groups) - a shorter time range

Required Actions

Consult with PSG