Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Cannot create the powerviwe report based on the workbook in SP2013

Answered Cannot create the powerviwe report based on the workbook in SP2013

  • Friday, December 14, 2012 5:12 AM
     
     
    Sign In to Vote
    0

    Hey there,

     I just uploaded a excel workbook with powerpivot model into the "powerpivot gallery". Based on that workbook, I attempted to create a powerview report by hitting the right-upper button.

    It reports error as below. Anyone knows why?

    -----------------------------------------------------------------------------------

    Sorry, something went wrong

    An unexpected error has occurred.

    Correlation ID: 279fea9b-f7fa-8097-fd4d-114539f37195

    Date and Time: 12/13/2012 10:56:51 PM

    -----------------------------------------------------------------------------

    Derek

     

All Replies

  • Friday, December 14, 2012 5:14 AM
     
     
    Sign In to Vote
    0

    And something more about this,

    I created a local excel2013 workbook with powerpivot and powerview then uploaded this one to sharepoint 2013.

    In the gallery, I attempted to open this workbook, it also shows me this error.

    Do I miss something in setup?

    Derek

     
  • Monday, December 17, 2012 6:25 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Derek,

    Based on your error message, it is difficult to determine the issue what happended. Please help to collect ULS log for further investigation.
    SharePoint ULS Log Viewer: http://ulsviewer.codeplex.com/

    Power View is a component of SSRS 2012. Specifically, it's part of SSRS installed in SharePoint integrated mode. In addition, you may need to check whether all the SharePoint Services and Apps are running fine. For more information about the installation, please see:
    Installing and configuring SQL Reporting services on SharePoint 2013: http://blogs.msdn.com/b/biblog/archive/2012/12/04/installing-and-configuring-sql-reporting-services-on-sharepoint-2013.aspx
    How to install SharePoint 2013 preview with SQL Server 2012 SP1 CTP3 SSRS, SSAS, PowerPivot and Power View:
    http://blog.cloudshare.com/2012/09/05/how-to-install-sharepoint-server-2013-preview-with-sql-server-2012-sp1-ctp3-ssrs-ssas-and-powerpivot-and-powerview/
    Configure PowerPivot and Deploy Solutions (SQL Server 2012 SP1): http://msdn.microsoft.com/en-us/library/jj682085.aspx

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Monday, December 17, 2012 4:29 PM
     
     
    Sign In to Vote
    0

    Hello Elvis,

    Thanks for your help. I think probably we have some issues in installing reporting service. Let me fix that first and see what is going on.

    Also, this time, I captured the error msg from event viewer as below.

    WebHost failed to process a request.
     Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/35320229
     Exception: System.ServiceModel.ServiceActivationException: The service '/5ff16e352d194afa98d84de3ef01ecf8/ReportingWebService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.. ---> System.InsufficientMemoryException: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
       at System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes)
       at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity)
       at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
       --- End of inner exception stack trace ---
       at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
       at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
     Process Name: w3wp
     Process ID: 7648

    Derek

     
  • Monday, December 17, 2012 4:29 PM
     
     
    Sign In to Vote
    0

    Hello Elvis,

    Thanks for your help. I think probably we have some issues in installing reporting service. Let me fix that first and see what is going on.

    Also, this time, I captured the error msg from event viewer as below.

    WebHost failed to process a request.
     Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/35320229
     Exception: System.ServiceModel.ServiceActivationException: The service '/5ff16e352d194afa98d84de3ef01ecf8/ReportingWebService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.. ---> System.InsufficientMemoryException: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
       at System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes)
       at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity)
       at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
       --- End of inner exception stack trace ---
       at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
       at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
     Process Name: w3wp
     Process ID: 7648

    Derek

     
  • Monday, December 17, 2012 4:29 PM
     
      Has Code
    Sign In to Vote
    0

    Hello Elvis,

    Thanks for your help. I think probably we have some issues in installing reporting service. Let me fix that first and see what is going on.

    Also, this time, I captured the error msg from event viewer as below.

    WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/35320229
 Exception: System.ServiceModel.ServiceActivationException: The service '/5ff16e352d194afa98d84de3ef01ecf8/ReportingWebService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.. ---> System.InsufficientMemoryException: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
   at System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
 Process Name: w3wp
 Process ID: 7648


    Derek

     
  • Tuesday, December 18, 2012 1:34 AM
    Moderator
     
     Answered Has Code
    Sign In to Vote
    0

    Hello Elvis,

    Thanks for your help. I think probably we have some issues in installing reporting service. Let me fix that first and see what is going on.

    Also, this time, I captured the error msg from event viewer as below.

    WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/35320229
 Exception: System.ServiceModel.ServiceActivationException: The service '/5ff16e352d194afa98d84de3ef01ecf8/ReportingWebService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.. ---> System.InsufficientMemoryException: Memory gates checking failed because the free memory (404168704 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
   at System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
 Process Name: w3wp
 Process ID: 7648

    Hi,

    In your case, could you please post more information about your SharePoint Server? Such as OS, memory and so on. Based on the error message, you can try to restart the process “SharePoint Search Host Controller" to free some memory. For detail information, please see:
    http://www.information-worker.nl/2012/07/27/sp2013-memory-usage-noderunner-process/

    For the installation that configure SQL 2012 SP1 with SharePoint 2013 Preview, I recommand you refer to the documents I posted above.

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Wednesday, December 26, 2012 1:23 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Derek,

    Have you solved this issue? Please let us know how things go.

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Tuesday, April 23, 2013 12:14 PM
     
     
    Sign In to Vote
    0
    Thanks !! it worked for me :-)