Solved

Unexpected Error when I click on Manage Data Refresh in Powerpivot gallery in sharepoint

Posted on 2014-03-05
2
411 Views
Last Modified: 2015-01-09
When I click on Manage Data Refresh in Powerpivot in sharepoint, I get Unexpected Error. When I see the sharepoint log files "System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host    at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) ". I see this error. There are other power pivot reports that were configured refresh and are working fine. Could anyone help me ?
 
Enviroment - sharepoint 2010, powerpivot 2010.

Below is the log file :
 
03/03/2014 09:16:26.41  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Monitoring                     nasq Medium   Entering monitored scope (Request (GET:https://test/rec/_layouts/PowerPivot/ViewDataRefreshHistory.aspx?list=%7b2A368E31-D35F-4575-A1E2-46E1AFB5F819%7d&ID=14&Source=https%3a%2f%2ftest.net%2frec%2fCloseout%2520Readiness%2520Gallery%2fForms%2fGallery.aspx))
 03/03/2014 09:16:26.41  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Request (GET:https://test/rec/_layouts/PowerPivot/ViewDataRefreshHistory.aspx?list=%7b2A368E31-D35F-4575-A1E2-46E1AFB5F819%7d&ID=14&Source=https%3a%2f%2ftest.net%2frec%2fCloseout%2520Readiness%2520Gallery%2fForms%2fGallery.aspx) 586d550a-867c-446f-a66b-00f3bf3b482b
 03/03/2014 09:16:26.43  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Site=/rec 586d550a-867c-446f-a66b-00f3bf3b482b
 03/03/2014 09:16:26.45  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (EnsureListItemsData). Execution Time=14.608560585214 586d550a-867c-446f-a66b-00f3bf3b482b
 03/03/2014 09:16:26.48  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Topology                       e5mc Medium   WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc' Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetItemDataRefreshHistory' MessageId: 'urn:uuid:ed8a5473-b7d3-484d-84ff-44ce348fe613' 586d550a-867c-446f-a66b-00f3bf3b482b
 03/03/2014 09:16:26.88  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Runtime                        tkau Unexpected System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host    at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) 586d550a-867c-446f-a66b-00f3bf3b482b
 03/03/2014 09:16:26.90  w3wp.exe (0x21F8)                        0x0AD0 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (ExecuteWcfOperation:http://tempuri.org/IGeminiServiceApplication/GetItemDataRefreshHistory). Execution Time=419.91349459219 586d550a-867c-446f-a66b-00f3bf3b482b
 03/03/2014 09:16:26.98  w3wp.exe (0x21F8)
0
Comment
Question by:asrithap
2 Comments
 
LVL 9

Accepted Solution

by:
Mohit Nair earned 500 total points
ID: 39908591
0
 

Author Comment

by:asrithap
ID: 39908872
Thank you for the link. But I did not see any solution for my issue as mentioned in log files.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now