We are no longer receiving executive reports

SonarQube Server / Community Build
1

Must-share information (formatted with Markdown):

  • SonarQube Server version v10.7 Enterprise.
  • Image in Openshift
  • Executive reports from Portfolios are no longer sent by email.
  • After upgradring to SonarQube Server 10.7 we do not receive any executive reports as per email any more.

I have been able to trigger the test-email and I receive it in my mailbox as expected. However, neither me nor any other employee no longer receive the executive reports for portfolios. I find no errors in the logs with regards to the email. I do, however, find log lines saying email being sent successfully.

2024.11.18 09:24:46 INFO  ce[5881a7ab-a615-4858-bcb8-20fcb3167396][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=1ms

I have confered with security and we have checked that there should be no rules to stop the emails in a spam-filter or similar. Again, we have successfully received the test-email from SonarQube.

Anyone have experienced the same or have some clues as to what to check next?

2

  • which versions are you using (SonarQube Server / Community Build, Scanner, Plugin, and any relevant extension)
    Sonarqube Enterprise Edition v10.7 (96327)

  • how is SonarQube deployed: zip, Docker, Helm
    .zip

  • what are you trying to achieve
    Send pdf report emails for portfolio evaluations.

  • what have you tried so far to achieve this
    Confirmed that the SMTP setup for our instance is working. I am able to send and receive a test email. Our SMTP relay service does not show any attempt to send an email at the time the report is supposed to trigger. Checked the web.log and found no entries related to the report or email.

Is there another log I should be checking, etc.? The issue seems to have started after migrating our instance to a new server. All other functionality appears unaffected by the move.

3

Hi,

I’ve combined your strikingly similar reports, and am flagging this for more expert eyes.

 
Ann

1 Like
5

Hi,
Could you please try to enable debug logs in the Compute Engine and check your logs again?

6

Hi,

I got this, which I don’t quite understand as the test email works fine.

2024.11.19 14:45:23 DEBUG ce[d89d6861-90b3-4ad2-a089-61e8c83e52ee][com.sonar.d.x.T.I.x] Email for portfolio 'Alle prosjekter' has not been sent because email settings are not configured.
2024.11.19 14:45:23 INFO  ce[d89d6861-90b3-4ad2-a089-61e8c83e52ee][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=0ms
2 Likes
7

I did a version upgrade at the same time as the server move. It’s probably the more relevant change made and the other user is on the same version.

Should have some logs available to post tomorrow.

1 Like
8

Checked the logs and only found INFO level logs relating to email at the time the PDF report is supposed to trigger. I also did a grep for “DEBUG” and found no logs relating to email for the entire day.

sudo grep “email” ce.2024-11-19.log

2024.11.19 20:30:27 INFO ce[89a7805c-3bfa-4089-82ff-9ce51f4a2bb8][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=3ms
2024.11.19 22:00:03 INFO ce[9de5c6ed-b47b-487a-9440-015638cac63e][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=3ms
2024.11.19 22:00:03 INFO ce[5c0ae284-10c4-4efd-9253-602a4eaacbec][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=3ms
2024.11.19 22:00:04 INFO ce[1a7810cd-e394-48c2-ba16-0481dda95f36][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=3ms
2024.11.19 22:00:06 INFO ce[e07cf471-0d24-4d95-ad5f-570da879a19c][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=16ms
2024.11.19 22:00:07 INFO ce[33403c3f-641d-4f1f-9546-dfc8e5836aca][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=3ms
2024.11.19 22:00:08 INFO ce[1fe55aa0-d436-4bc0-bb4c-1167013926a8][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=3ms
2024.11.19 22:00:21 INFO ce[89ff6127-8565-4cc4-ac33-96b9e631e7e0][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=4ms
2024.11.19 22:00:32 INFO ce[79020a38-ae74-4d36-ba21-cdceba065a85][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=4ms
2024.11.19 23:00:03 INFO ce[5aa81604-f415-4b1f-be3c-21fc97dda620][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=4ms
2024.11.19 23:00:18 INFO ce[25c31e4e-4e36-44fb-bac1-147630dd4b53][o.s.c.t.s.ComputationStepExecutor] Send report by email | status=SUCCESS | time=4ms

We see no records of the email send attempts on our SMTP relay service. Test emails from the email notification configuration page are still sending successfully, showing in SMTP relay logs, and being received by end users.

1 Like
11

Hello @jmaitla8,

We looked into this problem and there is indeed a bug :fearful: We tracked it into SONAR-23719.

So essentially the following emails are not being sent:

  • Project report (at the end of the analysis)
  • Portfolio report (when the portfolio is being recomputed)
  • Notification for token expiration

Other notifications are sent though (new issues, QG status changes, license expirations, etc.).

Unfortunately, there is no workaround at the moment; we are working on it now and will ship a fix in SonarQube 10.8.

Antoine

2 Likes