Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,842
Community Members
 
Community Events
168
Community Groups

Collective e-mail notifications do not work

Hello together,

we have a problem with our Jira Core 8.5.2 instance. The collective email notification do not work. Has anyone a idea what the problem might it be or how to proceed with such a problems?

Our normal e-mail notification works without problems, when we set the collective email notification we won't get any more e-mails.

In the atlassian-jira_batch_notify_errors.log I have this error-codes. Can the problem be caused by the server working behind a reverse proxy (192.168.1.3 - SophosUTM)? Or is it a database problem?

2020-01-16 15:46:03,087+0100 JIRA-INFORM-Thread-4 ERROR anonymous 516x12931x1 19d79v 192.168.1.245,192.168.1.3 /secure/CreateWorklog.jspa [c.a.j.p.m.service.provider.MobileNotificationRecipientProvider] Can not get mobile recipients
com.querydsl.core.QueryException: Caught SQLServerException for select "AO_0A5972_NOTIFICATION_SETTING"."ID", "AO_0A5972_NOTIFICATION_SETTING"."TYPE", "AO_0A5972_NOTIFICATION_SETTING"."USER_KEY", "AO_0A5972_NOTIFICATION_SETTING"."KEY", "AO_0A5972_NOTIFICATION_SETTING"."VALUE" from "null"."AO_0A5972_NOTIFICATION_SETTING" "AO_0A5972_NOTIFICATION_SETTING" where ("AO_0A5972_NOTIFICATION_SETTING"."USER_KEY" in (?, ?)) and "AO_0A5972_NOTIFICATION_SETTING"."KEY" = ? and "AO_0A5972_NOTIFICATION_SETTING"."TYPE" = ?

2020-01-16 15:46:03,087+0100 JIRA-INFORM-Thread-4 ERROR anonymous 516x12931x1 19d79v 192.168.1.245,192.168.1.3 /secure/CreateWorklog.jspa [c.a.j.p.inform.performance.MeasurementWorkerFactory] Exception occured
com.querydsl.core.QueryException: Caught SQLServerException for insert into "null"."AO_733371_EVENT" ("CREATED", "EVENT_TYPE", "USER_KEY", "ACTION", "ACTION_ID", "EVENT_BUNDLE_ID") values (?, ?, ?, ?, ?, ?)
  

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events