I have several Web Reports that are scheduled to have results sent by email, but 2 reports are being sent, even though they are scheduled to be sent one time in a 12 hour (or 24 hours) time frame. The attached file (if an attached file is sent) has the same file name (ex. 15.csv) for the 2 emails, and the scheduled activity shows that the report is scheduled to run once in that period of time.
This is happening in an environment that has 1 BigFix Web Reports Application Server, and another that has 2 Application servers (the database is housed on a separate server).
Are You sure that each Web Reports service connect to a separated database? ( I mean BESReporting, not the datasource ) …
In addition have You checked that, if You temporarly disable such Scheduling Activity, the corresponding mail is not received at all, meaning there is not another Scheduling activity sending the same email at the same time?
Another … is it possible the problematic Scheduling activity have some mail addresses repeated multiple times?
Somehow, I missed your reply and just noticed it now.
For the environment with 1 Web Reports Database server and 2 Web Reports application servers:
We have one server that houses the Web Reports database
We have two servers that are the application servers (both running the BESWebReportsServer service), using that one database server for the Web Reports database.
If the scheduled activity is stopped, the duplicate email is not sent at all. Also, the scheduled report does not have a duplication of an email address in it.
I believe the issue arises from running two parallel instances of Web Reports connected to the same database. This setup can cause conflicts, such as duplicate emails for scheduled activities.
To achieve high availability in your BigFix Web Reports environment, the recommended approach involves configuring one server as the primary instance and another as a standby instance