Allow Users to Run Simultaneous Reports and Searches - configure per user Hot

by Steve Dieckbrader on September 16, 2015

SBM System Administrator, Options, Settings, Display tab allows you to enable/disable this global setting. Need this to be configurable on a user-by-user basis. Here is the use case: we have client apps that run using a single service account that can invoke reports via sbmappservices (SOAP). These can be run asynchronously, and/or initiated by more than one human coincidentally. Therefore, we want this user account to be able run simultaneous reports. Yet, we have "impatient users" who when not receiving their report results in a few seconds, click the Preview or execution link again, and again, and again in possible frustration; consuming all threads (DOS 'attack', effectively). We need to give our properly-functioning web services and well-behaved users this ability, while disallowing it for the untrained user.

  • At first glance, this would be a schema change and enhancement to the AE, requiring one or two release cycles. I will post a question on the forum to see if another user is facing this issue, and might have solved it with a bit of JavaScript custom inserted into SBM templates. There are several real-world examples where once a submit button is clicked, the button is disabled to prevent the user from submitting the same request a second time.

    Ideas

    Status
  • Please login to view any attachments.

  • This idea has not received many votes in 24 months since its submission. It has been closed (declined) due to insufficient support.
    David J. Easter Commented by David J. Easter June 04, 2018
    #1 Reviewer  -  

    This idea has not received many votes in 24 months since its submission. It has been closed (declined) due to insufficient support.

    Jeff, have you submitted an enhancement or idea for running reports in a different AppPool? That is a great idea.
    Ryan Spradlin Commented by Ryan Spradlin September 18, 2015
    Top 50 Reviewer  -  

    Jeff, have you submitted an enhancement or idea for running reports in a different AppPool? That is a great idea.

    In my mind the best way to solve this would be to enhance the reporting engine to issue a "Cancel' (stop the SQL execution and free up the thread) when a user cancels or navigates-away from a report which is in the process of executing. This could be triggered on the client-side in JS so as to not impact multiple simultaneous searches via web-service. Then the whole purpose of the "Allow simultaneous...' option would be negated and the setting could be removed.

    Also pair this with an enhancement to allow reports to be run from a separately-configured AppPool, either on the same server or a totally separate machine. In this way for example you could configure separation of reporting so that it doesn't take down the AE when there is a report issue, or even run reports from a separate read-only instance running against a mirrored (DR?) environments.
    Jeff Malin Commented by Jeff Malin September 17, 2015
    Top 50 Reviewer  -  

    In my mind the best way to solve this would be to enhance the reporting engine to issue a "Cancel' (stop the SQL execution and free up the thread) when a user cancels or navigates-away from a report which is in the process of executing. This could be triggered on the client-side in JS so as to not impact multiple simultaneous searches via web-service. Then the whole purpose of the "Allow simultaneous...' option would be negated and the setting could be removed.

    Also pair this with an enhancement to allow reports to be run from a separately-configured AppPool, either on the same server or a totally separate machine. In this way for example you could configure separation of reporting so that it doesn't take down the AE when there is a report issue, or even run reports from a separate read-only instance running against a mirrored (DR?) environments.

    Jeff Malin Commented by Jeff Malin September 17, 2015
    Top 50 Reviewer  -  
    I should clarify that Preview does proceed to a page with the wait spinner and a Back button. I think my users are clicking Back before the report finishes and then they click Preview again. In any case, I want to disallow the same report being executed in rapid succession by the same user, but allow different reports to still execute in tandem.
    Steve Dieckbrader Commented by Steve Dieckbrader September 16, 2015
    Top 50 Reviewer  -  

    I should clarify that Preview does proceed to a page with the wait spinner and a Back button. I think my users are clicking Back before the report finishes and then they click Preview again. In any case, I want to disallow the same report being executed in rapid succession by the same user, but allow different reports to still execute in tandem.

     

PrintEmail

Recent Tweets