Issue in Importing Sharepoint List Data feed in to PowerPivot RRS feed

  • Question

  • HI All,

    I installed and activated PowerPivot integration features on my site collection which shows "Export as Data Feed" button on the ribbon in sharepoint list. When i try to open the exported .atomsvc file on the excel which has PowerPivot add-in enabled, tested the connection which works perfectly fine. Proceeding further shows an error message:

    "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method."

    I googled the error and made sure the hotfix (Windows6.1-KB976127-v6-x64) suggested in one of the blog needs to be installed and inspite of installing the fix i still see the error message getting displayed when i try to import the data feed. When i see the event viewer on the Web-FrontEnd server, I see the below error message.

    WebHost failed to process a request.

    Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/44624228

    Exception: System.ServiceModel.ServiceActivationException: The service '/_vti_bin/ListData.svc' cannot be activated due to an exception during compilation. The exception message is: Exception has been thrown by the target of an invocation.. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.

    at Microsoft.SharePoint.Linq.ListDataService..ctor()

    --- End of inner exception stack trace ---

    at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)

    at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

    at System.ServiceModel.Description.ServiceDescription.CreateImplementation(Type serviceType)

    at System.ServiceModel.ServiceHost.CreateDescription(IDictionary`2& implementedContracts)

    at System.ServiceModel.ServiceHostBase.InitializeDescription(UriSchemeKeyedCollection baseAddresses)

    at System.ServiceModel.ServiceHost..ctor(Type serviceType, Uri[] baseAddresses)

    at System.ServiceModel.Web.WebServiceHost..ctor(Type serviceType, Uri[] baseAddresses)

    at System.Data.Services.DataServiceHost..ctor(Type serviceType, Uri[] baseAddresses)

    at Microsoft.SharePoint.Client.Services.MultipleBaseAddressDataServiceHost..ctor(Type serviceType, Uri[] baseAddresses)

    at Microsoft.SharePoint.Client.Services.MultipleBaseAddressDataServiceHostFactory.CreateServiceHost(Type serviceType, Uri[] baseAddresses)

    at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)

    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)

    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)

    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)

    --- End of inner exception stack trace ---

    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)

    at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)

    Process Name: w3wp

    Process ID: 2828

    Request you to suggest me a concrete solution for the issue.


    Sathish. R




    Sathish Kumar
    Tuesday, March 15, 2011 4:02 PM


All replies