Solved

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

Posted on 2014-03-05
2
435 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

739 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