Encountered Issue While Using My Visio

Asked By 0 points N/A Posted on -
qa-featured

Can someone explain this to me?

I recently encountered an interesting issue while using my Visio.

I was using Visio Services to publish and view my works when an error report popped up:

Visio Services error -unable to refresh external data connection in this web drawing

 

Visio Services was unable to refresh external data connections in this Web drawing because of changes in the structure of an underlying data source. One or more columns in this data source have changed the data type after this web drawing was last saved. To resolve this issue, restore the data types of the affected columns to their previous values or update the data connection information in this Web drawing using Visio.

I had a couple of resources taken from and were linked to an SQL server data when this happened so I looked into it. The thing is, I found a DATETIME2 datatype in my SQL so I tried deleting it and it worked. It was an iffy solution, that’s why I’m here asking for an alternative solution.

Thanks for entertaining my queries!

SHARE
Answered By 0 points N/A #101731

Encountered Issue While Using My Visio

qa-featured

The error reflects that a particular instance of the connection is being changed. This can be due to few reasons.

  1. The first reason is because of a bad internet connection that cause frequent disconnects leaving the data scattered and disrupted. First make sure that your internet connection is stable.
  2. Second, check all the connection variables that they are getting the proper amount of parameters that is needed for it.
  3. Third, make sure that the data is being used only once during the whole connection because you cannot edit or modify the data if there is someone else on the same connection using the data for its own purposes.

Related Questions