Tuesday, 7 November 2017

SharePoint Visio-Bug: The server failed to process the request

A Developer reported that they are not able to open Visio file in SharePoint site level, they are getting error like “The server failed to process the request”.
Here are the steps that we need to follow to fix this issue:
This solution will work SharePoint 2010,2013 and 2016 as well.
  • Login to the server and verify the Visio service Application is created.
  • To check the same, go to CA>Click on Mange Service Applications
  • Now navigate the page down and verify Visio Graphics Service Application is created and started
  • Also check from Central Administration>System Settings>Mange services on server and checked if the Visio Services were running:

  • Now, we will open SharePoint Management Shell with Admin rights and execute below given command.

Get-SPServiceApplication -DisplayName "{Visio Graphics Service Application}"

  • Now execute below command to find the Service account used for Visio service Application.

Get-SPServiceApplicationPool -Name "Visio Graphics Service Application"

  • Now we have Service name and service account name, now we need to get Content Db name for Site and assign the SPdataAccess
  • To get site collection Content DB there is two ways to get the same result, one is from PowerShell command and other one using GUI mode, Executing the command will be easiest way to get Content DB name and SQL server instance name.

Get-SPContentDatabase -site http://contoso.com/sites/test
Result would be like below screen shot:
  • Now login to the SQL server with above server instance name and verify the above given service account is added under SQL security group or not, if it’s not added; add this user
  • Right click on Added user and click on User Mapping option, there will be many db name available identify the Content DB which you got from site collection URL.  
  • Now select that db and assign SPDataAccess permission to the same and click on ok.

  • Now go back to the site and open the Visio File and you will get the vision opened on the Page.

No comments:

Post a Comment