Reporting webapi report never stops loading

2 posts, 0 answers
  1. Daniel
    Daniel avatar
    1 posts
    Member since:
    Dec 2015

    Posted 30 Jan Link to this post

    When I run a report via the webapi against a particular webserver, it just gets to where it's loading /api/Reports/clients/123/instances/documents/123/info indefinitely. It returns a status code of 202 Accepted, content has documentReady: false. No error or anything, it just does this indefinitely forever.

     

    I'm using the reporting services webapi to run reports with the mvc framework. To do that I have a class which implements IReportResolver, which instantiates a InstanceReportSource and returns that in the Resolve method. I create these InstanceReportSource instances programmatically else where in the same code base, and they work fine in those instances (without the webapi).

    I have a nearly identical code base with the exact same reporting implementation on another web server (Windows Server 2012, IIS 7), and there it works fine. It also works fine when I run it in Visual Studio. The environment where it does not work fine is Windows Server 2008 R2, IIS version 6.1. I am curious if upgrading the OS/IIS would fix it, but I can't do that at customer sites where this will be deployed to necessarily.

     

    I did find originally when I ran it, it'd crash the application pool. Seemed to be a permission thing because i'm using the TEMP environment variable for file storage, but switching which account the application pool was under fixed it so it wouldn't crash, but this action happens instead.

     

    Both webservers are setup nearly identical as far as I can tell, considering they are different versions. Unsure of where to look, if there's some underlying error or something else to be looking at. Any help is appreciated.

  2. Todor
    Admin
    Todor avatar
    270 posts

    Posted 04 Feb Link to this post

    Hello Daniel,

    We have previously observed a similar issue with Windows Server 2008 R2. We have related it to the worker threads on IIS.
    In general, the requests to the REST Service initiating the report rendering and the actual report rendering are performed in different threads. On older IIS versions this may actually lead to the reporting thread being executed under the windows account running the IIS Worker Process instead of the account configured in the site App Pool. My guess is that the account running the IIS Worker Process does not have adequate permissions for the cache storage.
    From the description, I infer that you use File storage. Could you test with another storage type?

    The endless Get Document Info request may indicate that the reporting engine has stopped, for example, due to an unhandled Internal Server Error. I suggest attaching a Trace Listener to the Telerik Reporting REST Service project. It may give further insights into the problem.
    You may consider opening a support ticket and attaching the generated log for local investigation.

    Regards,
    Todor
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top