.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

workbooks inside of sharePoint site has data refresh error

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :SharePoint

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

View Complete Post

More Related Resource Links

Show custom error message inside SharePoint Business Data List web part?

I am using SharePoint 2007 Business Data List web part to show external information retrieved from my simple web service. Is there ability to show custom error message on Business Data List web part?

Accessing SharePoint 2010 data inside Windows Phone 7

Hi All, I have started building Windows Phone 7 Applications. So, I need to know how to access the Sharepoint 2010 data in my WP7 applciation. Is it possible to implement Client Object model in WP7?? If not then how do we access the Sharepoint 2010 data?? Can any1 pls help me out. Thank you.

SharePoint 2010 Site Actions Site Settings Error

I can not seem to go to Site Settings for a sub site in SharePoint 2010.  I installed SharePoint 2010 developer version on my laptop (Win 7 64bit) with Visual Studio 2010.  Try to create a sub site and go to Site Settings and bam!!! Error File Not Found.  This is frustrating.  Very frustrating.  I found so many problem with SharePoint 2010 and get no where with this version upgrade.  My life is completely ____ now.  Thanks Microsoft!  Why! Why! and Why do you not test your software and make people life much more convenience.  Why roll out this crapy software now on MSDN instead of making it clear that it is not ready??????????  WHY!!!!!! Yes, and I try to go to Site Settings from within SharePoint 2010 Designer.  It took me to the same error!!!!!  So what is going on?

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

Sharepoint 2010: Get error: You do not have permissions to have lists and pages within My Site.

I am using the administrator login for the sharepoint 2010 farm.  I'm able to access My Site.  However, when I click on My content, I'm getting You do not have permissions to have lists and pages within My Site.   Any ideas?   Thanks.

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

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

After Installing SharePoint Foundation 2010, trying to open site gives 404 error in browser


I had this as reply on a thread about migrating from WSS 3.0 to SFS 2010. But I have completed all the steps with the modified documentation, but the browser delivers an error 404 when I try to open the site I created.  Same thing happens if I go at it via https, but first I get a certificate warning error (using the IP instead of the FQDN) and then being prompted for credentials.

I am completely stumped at what else to look at.  Any help in gathering information to get help is also appreciated.

Environment:  SBS 2008, SFS 2010, SQL Express 2008.  Rest of the IIS sites continue to function normally and I can get to the management site ok.  Although after the install, I had to go into application pool and change the service account from the domain admin (it defaulted to that) to networkservice account, otherwise I got a 503.  Same thing happened on the site I created until I changed the service account.  Now just a 404.

Session State throws error in ASP.NET Site Pages for SharePoint 2010 portal using Visual Studio 2010


I'm developing Visual Studio 2010 solution for site pages. I’ve created Site Pages in SharePoint 2010 and I’m trying to access Session variables in code behind in ASP.NET but it throws the following error.

Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.

I set the page directive as enableSessionState=&quo

Trying to recreate Help Desk site in SharePoint 2010 fails with an error


The site template requires that the Feature {af6d9aec-7c38-4dda-997f-cc1ddbb87c92} be activated in the site collection.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 1c60c31d-cf82-47f0-a065-3673b4e16ca6

Date and Time: 8/27/2010 7:54:24 AM

I looked up the GUID using http://blogs.msdn.com/b/mcsnoiwb/archive/2010/01/07/features-and-their-guid-s-in-sp2010.aspx as my reference.  However, I cannot for the life of me figure out how to add this feature to the site collection.  When I go to the top-level site and go to add site collection features Web Analytics Customize Reports functionality is not there.

Clearly there is something I'm missing but since Microsoft is not redoing the Fabulous 40 site templates, any help in getting the old sites to work in a sharepoint database attach migration will be greatly appreciated.


Michael Caplan

Error while installing a feature on sharepoint site


Hi everyone,

  I am trying to install a feature that creates an custom menu item.

  When I run the stsadm command the following error comes :

Required tag 'http://schemas.microsoft.com/sharepoint/:Feature' is missing from XML file ...\12\Templates\Features\GoogleMenuItem\feature.xml'. found 'Feature' instead.

Kindly help me resolve this error...


Thank you

Getting error when creating SharePoint site



When i login as site collection administrator then i can able to create Share Point site. But when i login as contributor user then i am unable to create Share Point site.

I have also tried 'FormDigestSettings' but still issue is there.

When i turnoff security from CA site then i can able to create site as contributor user.Might be it is security issue. please suggest.


public SPWeb CreateSiteWithElevatedPrivileges(ProjectSiteEntity objProjectSiteEntity, SPUser objSiteOwner)
            SPWeb newSite = null;
                using (SPSite elevatedSite = SpSecurityHelper.GetCurrentSiteAsElevated())
                    using (newSite = elevatedSite.AllWebs.Add(objProjectSiteEntity.SiteName, objProjectSiteEntity.SiteName, objProjectSiteEntity.Description, 1033, objProjectSiteEntity.SiteTemplate, true,

SharePoint 'Open with Access' - > 'Link to data on the SharePoint site' does not display data wi


Here's the scenario:

- I have a custom list in SharePoint 2010 with approximately 30 columns and 450 rows

- When I got to 'List Tools' -> 'List' -> 'Open With Access', I have two options 1) Link to data on the SharePoint Site and 2) Export a copy of the data

- If I select either option, I am able to view the items in my list in 'DataSheet' view and in the bottom right of Access I see the 'Online with SharePoint' text

- If I select the PivotTable view and drag in a column to either the row or column option, I have not seeing my data if I choose option #1 above (Link to data on the SharePoint Site).  I am able to see my values if I select option #2 above and view in PivotTable view

- If I click the 'Refresh Pivot' button in the ribbon still no data. 

- If I got back to datasheet view, I see my data

Any ideas?

Any suggestions

SharePoint Server 2010 Site Suddenly Dissapeared - 404 Error


I created a site in a brand new SharePoint Server 2010 environment.  Now when I browse to the site, I get a 404 error.  The site has suddenly vanished. The link to the site still remains in SharePoint, but it's not there!  I tried running the SP Prod and Tech Config Wizard, rebooting, etc...

No one is even using this environment.

Any ideas?

Did anyone at Microsoft test SharePoint Server or Project Server before launch?  This 2010 release is so full of bugs.  Sorry to rant.

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


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?



Web Service error "401 Unauthorised " when published at Sharepoint site


Hi All,

I am working on infopath where i created dataconnection for web service published at Sharepoint - 80 site(the webservice has webreference to a webservice which access sharepoint form library)

Now when i click on the button i get dataconnection error.

So i checked sharepoint log i got error as mentioned below

Forms Services Runtime - Data C 82fy Warning  
The following query failed: GetItemsBySerialNoOrName (User: EICHERGROUP\ssharma2, Form Name: LeaveAR_RecordDeletion, IP: ,
 Request: http://sharepoint_test/_layouts/Postback.FormServer.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:LeaveAR-RecordDeletion:-myXSD-2005-10-21T21-12-27,
Type: DataAdapterException, Exception Message: The remote server returned an error: (401) Unauthorized. The remote server
 returned an error: (401) Unauthorized.) 09dfb4c4-26b2-425c-a8e0-8d29a4afbc6e 

Pls advise how to resolve this..



-- Regards Sandeep

Cannot access SharePoint 2007 site after moving data to another AD domain



We are setting up a staging farm on a test domain. For this we took a copy of the data from production and attached them to staging. In the test domain I created user with same user name as in production but they cannot login. I tried making the user site admin still he cannot access. I hope there is a problem when we move sharepoint data between domains.

I ran the stsadm migrateuser comman with ignoresidhistory and it ran successfully, but still user get access denied message. Is there someway this can be fixed?

For example, we have 2 domains, prod and test. I setup SharePoint farm (same patch level as prod) in domain test and copied all my content databases and attached in test domain sharepoint. The system account in test domain is “test\spadmin”. Now only he can access the new site in test domain.

There was a user “user1” in prod domain and I created a similar user in test domain - “test\user1”. Even after giving him full control on the sites, he gets Access Denied error. I tried creating a new user in test domain that does not exist in prod domain, even he cannot access the site because of Access Denied exception. Is it a limitation of SharePoint that we cannot move data between domains.

PS: We are running MOSS 2007 Ent 64 bit SP1 and SQL Server 2005 SP3. We use NTLM authentication.


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