question

MAY-4261 avatar image
1 Vote"
MAY-4261 asked lehus commented

Email settings in SSRS SharePoint 2016 - SharePoint mode

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()

office-sharepoint-server-administrationsql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @MAY-4261 , have you found the answer or any clues? I have exactly the same trouble, timer job cannot complete only on application server, only on one of the farms.. What CUs have you installed? Maybe this bug related to some certain updates..

0 Votes 0 ·
MAY-4261 avatar image
0 Votes"
MAY-4261 answered MichaelHan-MSFT commented

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?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MAY-4261

Per my test, I could not reproduce your issue on my end. Looks like there is something wrong with the SSRS timer job. You could try to restart the ssrs service and the app pool.

0 Votes 0 ·
MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT answered

Hi @MAY-4261

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.




image.png (35.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MAY-4261 avatar image
0 Votes"
MAY-4261 answered

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



image.png (59.5 KiB)
image.png (29.3 KiB)
image.png (12.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT answered

Hi @MAY-4261

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://docs.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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.