Share via

Email settings in SSRS SharePoint 2016 - SharePoint mode

M. A. Y 6 Reputation points
2020-10-19T19:06:40.917+00:00

Hello,

I am unable to edit e-mails settings for Reporting services service application. Every time I try to modify something under email settings it runs out with below error. I checked the ULS logs but couldn't figure out the issue. ULS logs are also attached. Appreciate your help on this.

Error Msg:

Sorry, something went wrong
The timer job completed, but failed on one or more machines in the farm.
Technical Details

Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: bf46859f-3840-40a0-ea96-213a0c6a5aa8
Date and Time: 10/19/2020 3:04:15 PM

Go back to site

ULS LOGS:

Job 'SQL Server Reporting Services Service Application' failed while running on server SERVERNAME. Error: Some or all identity references could not be translated.. (Correlation=6144859f-387d-40a0-ea96-26edf700a45b)

SPTimerJobAsyncResult '490bc4f9-8aab-4fb5-8428-02ef2925b727': An error occurred while waiting for completion: Microsoft.SharePoint.SPException: The timer job completed, but failed on one or more machines in the farm.
at Microsoft.SharePoint.Administration.SPJobDefinition.WaitForCompletion(TimeSpan timeout)
at Microsoft.SharePoint.Administration.SPTimerJobAsyncResult.WaitForCompletion(Object state)

Error occurred while provisioning instances for ReportingWebServiceApplication with Id '83530131-6e90-4e26-8e26-d115cc2e3a2e': Microsoft.SharePoint.SPException: The timer job completed, but failed on one or more machines in the farm.
at Microsoft.SharePoint.Administration.SPTimerJobAsyncResult.End()
at Microsoft.SharePoint.Administration.SPServiceApplication.ProvisionInstances()
at Microsoft.ReportingServices.SharePoint.SharedService.Service.ReportingWebServiceApplication.ProvisionInstances()

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,900 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. MichaelHan-MSFT 18,026 Reputation points
    2020-10-20T09:01:18.847+00:00

    Hi @M. A. Y ，

    This article would be helpful to you: Configure E-mail for a Reporting Services Service Application

    Please make sure that the account of the user specified in From address must be a managed account that you specified when you configured the application pool for the Reporting Services service application.

    Besides. here are some articles to Install Reporting Service in sharepoint 2016:

    https://social.technet.microsoft.com/wiki/contents/articles/36240.sharepoint-2016-install-reporting-service-in-farm.aspx

    https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/install-the-first-report-server-in-sharepoint-mode?view=sql-server-2016

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. M. A. Y 6 Reputation points
    2020-10-20T13:59:35.157+00:00

    Hi @MichaelHan-MSFT ,

    I have made sure that the same account is registered under App pool and managed account. The From address is also associated to the same account and is a valid mailbox too. Do you think this is due to farm admin account?

    33630-image.png

    33647-image.png

    33731-image.png

    0 comments
  3. MichaelHan-MSFT 18,026 Reputation points
    2020-10-21T08:18:52.957+00:00

    Hi @M. A. Y ，

    Your email settings in SSRS is fine. You can use farm admin account for ssrs application.

    For the error "The timer job completed, but failed on one or more machines in the farm", it may due to the The SharePoint Timer service not started.

    Please make sure that the timer service is started in services.msc and the account of the service is a member of the Administrators group on the local computer.

    33983-image.png

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. M. A. Y 6 Reputation points
    2020-10-21T19:42:36.793+00:00

    Thanks @MichaelHan-MSFT ,

    The timer service was already started. I restarted it but still didn't work.

    I then performed an iisreset and email delivery extension now works but every time I change some "E-mail Settings", it runs out with same error - "The timer job completed, but failed on one or more machines in the farm" and I have to do iisreset to make it work. Any clue why this happening?