Solved

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

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 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