.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

visio services - can't get rid of data refresh error

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :SharePoint

keep getting this error message on trying to refresh data

"Viso services was unable to refresh external data connections in this web drawing because of changes in teh structure od an underlying data source. one or more columns in this data source have been deleted after this web drawing was last saved."

The underlying data source has not been changed and I have tried re-creating the visio web drawing from scratch - always this error!

any ideas on how to progress?



View Complete Post

More Related Resource Links

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

2010 Visio Services Data Auto Refresh Issue


I have published vdw diagram in Sharepoint 2010 Shared Documents. The diagram data is linked to SQL database.

When I view the diagram in the browser, unless I click dedicated "Refresh" button on the top left at the sharepoint page, data is not updating.

I have changed all the SP 2010 Global settings to minimal value = 0 (as per previous post called 2010 Visio Services Data Refresh Issue).

Still you need to click dedicated "Refresh" button on the top left at the sharepoint page in order to see updated data.

In the article called "Visio Services for SharePoint 2010" is stated that new Visio service supports AUTOMATIC REFRESH.

Am I missing something? Is it possible to have a visio diagram with AUTOMATIC REFRESH published in SharePoint 2010?

I can do some workarounds like publishing in web parts page that has auto pooling, but my understanding was that the Visio diagram refresh is event based on data change only - means if data do not change 10 minutes there will be no calls?



Visio Services on Sharepoint error

Hello I have seen other posts regarding this problem but no real solution other than using an RTM version of Visio. When I publish Visio drawings (.vdw) to our Sharepoint 2010 server, I get the following error Visio Services was unable to load this diagram because it was published with an older version of Visio. To resolve this issue, republish this diagram with an updated version of Visio. However my version is 14.0.476.1000 (32bit) which is newer than those mentioned in the other posts. The document makes it to the server just fine and can be opened in Visio from the server but when trying to view on Sharepoint, the error above is returned. Can someone please help? Thanks Thanks

workbooks inside of sharePoint site has data refresh error


We have workbooks inside of our SharePoint site, using NTLM authentication and Excel Services connectors. They correctly display graphs when the page is first opened, but all of them throw an error when users try to trigger an update. The error message sayss "Excel. An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: [name of any data cube in use]. Learn more about data refresh." We are not using Power Pivot (which may make it easier, but is not authorised for use by our server administrators yet).

Visio service data refresh help


I have created Visio 2010 diagram hwich gets the data from SQL 2008 server. vsd diagram works fine on the client, data is refreshed when I click Refresh from Visio 2010.

I have published it as vwd using "Share" option of Visio 2010 on SharePoint 2010 server in Shared Documents site library. It opens fine in browser, you see the diagram, but data is not refreshing, although I force it with dedicated SharePoint Refresh button on the top of the page. No errors, just the data is not updating.

SQL 2008 server is actually on the same Windows 2008 server where the SharePoint 2010 server is. The question is how it connects and works fine from the client PC but cant refresh the data on the server. I am admin on all boxes.

Do I need to publish ODC file on the SharePoint 2010 server too ?

Any help is appreciated.



Excel Services data refresh from SSAS: How to?


Hello everybody,

I know there's been several threads already on this topic, but I haven't been able to distill a solution to my particular situation. The problem is largely because of my ignorance on the SharePoint part, I'm afraid.

Anyway, here's the situation:

  • SharePoint 2010 Ent in Stand-Alone mode
  • Windows Server 2008
  • Analysis Services 2008 R2 on the same box
  • No windows domain, all people using the system are outside the company
  • All users are created as local windows users
  • We're using the msmdpump to allow access to Analysis Services
  • Excel 2010 is the client for SSAS
  • The user id and password are both stored in the ODC file
  • The user in the ODC is member of a role that allows read-access to the cube
  • The ODC is in a trusted location
  • Since I want Excel Services to use the connection string, the Authentication setting is set to None in the ODC

Now, if I publish an Excel Pivot table to SharePoint and the try to open it in the browser, the initially cached data is displayed. As soon as I try to refresh the data, I get a Data Refresh Failed error. I've been reading for two days straight, and I think I understand that I need to configure the unattended service account using the Secure Store Service.

This is where I'm getting confused. i

Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)



In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Integration services(data flow error)



when executing my data flow package that contains only one source and one destination

OLE db source -> SQL server destination

the following errors occurs in my output

Error: 0xC0202009 at Data Flow Task(infraction action), SQL Server Destination [3600]: An OLE DB error has occurred. Error code: 0x80040E14.

Error: 0xC0202071 at Data Flow Task(infraction action), SQL Server Destination [3600]: Unable to prepare the SSIS bulk insert for data insertion.

Error: 0xC004701A at Data Flow Task(infraction action), DTS.Pipeline: component "SQL Server Destination" (3600) failed the pre-execute phase and returned error code 0xC0202071.

i've checked the structure of my source and destination table but nothing seems to be wrong

if someone have ever faced these errors help me :D

datarow data insertion error


this is the code which i am using and what i want means when i==0 first record should bind to datatable and when i==1 2nd record should bind to datatable. that means when i==1 1st and 2nd record should be present in datatable  Please see the code below


when i am binding 2nd record to datatable 1st record is getting deleted and recently inserted value is getting inserted please tell me how to resolvie this


datatable dt11=new datatable();
DataRow row11=null;

if (i == 0)
row11 = dt11.NewRow();

row11["qid"] = qnumber;

row11["question"] = question;
row11["useranswer"] = correctans;
row11["flag"] = answerstatus;


if (i == 1)

qnumber =ds5.Tables[0].Rows[i][0].ToString();
question =ds5.Tables[0].Rows[i][1].ToString();

row11 = dt11.NewRow();

OData and AtomPub: Building an AtomPub Server Using WCF Data Services


Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010

Data Points: LINQ Projection Queries and Alternatives in WCF Services


LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It's great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.

Julie Lerman

MSDN Magazine May 2010

VS 2010: Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010


Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.

Elisa Flasko

MSDN Magazine April 2010

Cutting Edge: ASP.NET Ajax Library and WCF Data Services


This month Dino takes a look at the JavaScript components coming in the ASP.NET Ajax Library and explains how they can be used for effective client-side data access.

Dino Esposito

MSDN Magazine March 2010

Cloud Security: Crypto Services and Data Security in Windows Azure


Many early adopters cloud platforms have questions about security. We review some of the cryptography services and providers in Windows Azure along with some security implications for applications in the cloud.

Jonathan Wiggs

MSDN Magazine January 2010

SQL Data Services: The Relational Database of the Azure Services Platform


This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.

David Robinson

MSDN Magazine August 2009

.NET RIA Services: Building A Data-Driven Expense App with Silverlight 3


.NET RIA Services provides a set of server components and ASP.NET extensions such as authentication, roles, and profile management. We'll show you how they work.

Jonathan Carter

MSDN Magazine May 2009

Data Services: Access Your Data On Premise Or In The Cloud With ADO.NET Data Services


In this article the author looks at two versions of the same application--one consuming an on-premise Data Service, and one consuming an Azure Table Data Service to illustrate data access in the cloud.

Elisa Flasko

MSDN Magazine May 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend