Visio Services Won’t Refresh in SharePoint 2010–How to Fix It

I recently ran across a problem where a user had connected a Visio 2010 diagram to data in a SharePoint list to create a dynamic graphical dashboard of the items in the list. He had a problem though that the data wouldn’t refresh. So, when values changed in the SharePoint list, the Visio diagram that had been published to SharePoint as a Web Drawing wouldn’t update automatically, nor would it update when the Refresh button was clicked.

It was an end user (or rather power user) who was experiencing the problem who was not the SharePoint Administrator. So all he knew was that it wasn’t working. He didn’t receive any errors or anything to indicate what the problem might be.

The solution turned out to be a configuration problem in Central Administration—which this user couldn’t access.

When I logged into Central Administration, I clicked on the SharePoint Health Analyzer and saw an issue that said, “The Unattended Service Account Application ID is not specified or has an invalid value.” This was our culprit, but there was nothing in that description to indicate it affected Visio Services at all.

The Unattended Service Account Application ID is not specified or has an invalid value.

When I clicked on the link, I saw the following details for the issue:

image

This told me everything I needed to know to resolve the problem. I clicked on Application Management > Manage service applications.

Application Management > Manage Service Applications

I then selected the Secure Store Service and clicked Manage.

Manage Secure Store Service

The Secure Store Service in SharePoint 2010 has replaced Single Sign-On that was in SharePoint 2007. The service securely stores credentials that are associated with a given application identification. On the next page, I could see that nothing had been configured here. In fact, I saw a notification stating “Before creating a new Secure Store Target Application, you must first generate a new key for this Secure Store Service Application from the ribbon.” To do this, I clicked on the Generate New Key icon.

Before creating a new Secure Store Target Application, you must first generate a new key for this Secure Store Service Application from the ribbon.

On the next page, I had to enter the Pass Phrase that was created when the farm was created. You did make a note of that somewhere didn’t you? Smile

Generate New Key - Pass Phrase

After clicking OK, the notification went away and more of the ribbon icons became active.

There are no Secure Store Target Applications in this Secure Store Service Application. You can create a new Target Application from the Mange Target Applications group inthe Edit ribbon group.

I entered in the Application settings shown below, which were appropriate for this environment. Essentially, your Target Application ID and Display Name can be whatever you want it to be. If you are just configuring this to make Visio Services refresh start working, you’ll probably be fine with all the other defaults too.

Target Application Settings

On the next page, I accepted the defaults there and clicked Next again.

Target Applicaton Fields - User Name and Password

On the next page, select any users you want to be able to manage the settings.
Target Application Administrators

This finished creating my Target Application.

Target Applications

Now that this was created, I just had to associate it with Visio Services. In Application Management > Manage Service Applications, I selected Visio Graphics Service and clicked Manage on the ribbon.

Manage Visio Grpahics Service

I clicked on Global Settings.
Visio Graphics Service > Global Settings

At the bottom of the Global Settings page for Visio Services, there is a section called External Data where you can enter the Application ID for an Unattended Service Account. Here I entered the Application ID I had just created and clicked OK.

Visio Graphics: External Data | Unattended Service Account | Application ID

After this, I returned to the Visio Web Graphic and the refresh was now working properly.

Hopefully this will help some of you. If you are the end user or power user that is experiencing this problem, be sure to forward this post to your SharePoint Administrator as this is probably the culprit.

3 Comments

  1. Tweets that mention SharePoint Help — Blog — Visio Services Won’t Refresh in SharePoint 2010–How to Fix It -- Topsy.com - October 1, 2010, 11:14 am

    [...] This post was mentioned on Twitter by Ricky Spears, Hire SharePoint Dev. Hire SharePoint Dev said: I just wrote a new blog post: Visio Services Won’t Refresh in SharePoint 2010–How to Fix It http://bit.ly/d3FdNb #sharepoint [...]

  2. SCOM 2012 Visio Diagramm in SharePoint 2010 – Errors | SCOMfaq.ch - June 20, 2012, 4:53 pm

    [...] Solution:Verify also that your shared credentials are set up correctly like described in this blog post. [...]

  3. SCOM 2012 SP1 – Publish Visio Dashboard in SharePoint 2010 Walkthrough | SCOMfaq.ch - July 10, 2013, 1:32 pm

    [...] Solution: The soulution can be found on sharepointsolutions.com [...]

Leave a Reply