Team Calendars for Confluence Send Email Notifications to Users that Are Not Related to the Calendar

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Email notifications from Team Calendars for Confluence about a specific calendar are sent to all/some users when the calendar is updated or new events are added. The emails are sent even though these users do not subscribe to the calendar and they do not watch any pages that have this calendar embedded.

Diagnosis

  1. Find out the name of the calendar that has this issue
  2. Run the following SQL query to find the Calendar ID of this calendar:

    select "ID" from "AO_950DC3_TC_SUBCALS" WHERE "NAME" LIKE '%Insert the Name of Calendar Here%';
  3. Go to Confluence and search all pages that return given this Calendar ID:

    embeddedSubCalendarId:CALENDARID
  4. In the results, check for any page that does not embed the calendar in question. Check whether the watchers that are receiving erroneous notification emails are watching these pages.

Cause

This is caused by the way calendar ID lookups are implemented in the Lucene index, which is used by Team Calendars for Confluence. Full technical details can be found in this bug report:  TEAMCAL-2055 - Getting issue details... STATUS

Resolution

Upgrade to Team Calendars for Confluence 4.3 and above, which resolves this bug. After upgrading Team Calendars for Confluence the notifications will stop but Step 3 above will still return multiple calendars because the search functionality was not fixed as part of this bug.

Last modified on Aug 11, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.