Solved

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

Posted on 2014-03-05
2
429 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 10

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

749 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