Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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. …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

860 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