Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories System Administration
Created by Guest
Created on May 25, 2017

RELATED IDEAS

Cancel on-demand data loading when user closes analyses

I've always argued that this is a bug, but have been told to submit as an enhancement request :(

 

If a user starts a large on-demand data load from an analysis loaded within Web Player, that load will continue even if the user closes the analysis or their browser. We have seen instances where poorly designed analysis files have allowed users to kick off queries that return 500GB or more of data - users close their browsers because things look unresponsive, but Web Player continues to pull the data into memory, eventually filling all available memory and temporary disk space. Put simply, we believe that at the point where a user closes the analysis all activity associated with that analysis should stop - ongoing queries should be canceled at the database level, Server should stop pulling data and Web Player should stop pulling data.

  • Attach files
  • Guest
    Reply
    |     Feb 25, 2020

    Also needed in Analyst, not only in web player: when you close an analysis, queries will continue running on the DB server as 'Zombies' - they will never return data to any client.
    Same is true, when closing a chart within a dashboard or even when changing settings in a chart - only the latest query needs to finish then.

  • Guest
    Reply
    |     Jul 3, 2017

    I certainly agree this is needed but I think it needs a complete overhaul of the Data handling on the Spotfire Server as it has not been designed to support canceling data requests. In fact for this to work properly query cancellation needs to be supported in the database (not all support this) and on the driver that you are using to connect to the database. On the data connectors side there has been some improvements where you can now specify a max number of rows to load which I suspect will work regardless of the user closing the browser:

    https://community.tibco.com/wiki/whats-new-tibco-spotfire#toc-81

  • Guest
    Reply
    |     May 25, 2017

    To add - I just found this information that I sent to support last year:

     

    I performed some tests on 7.7 and have the following observations:

    • Attempts to close an analysis using the X button in the top right corner of Web Player are ignored while it is loading on-demand. (BAD)
    • Closing the browser tab while loading on-demand leaves the analysis loading in the background – I can see it on the diagnostics page in the console, plus I can see actionlog events for get_data for the on-demand data. (BAD)
    • The now orphaned analysis continues to load and ignores idle timeouts. I tested by setting an idle timeout of 1 minute but my test analysis continued to run until all data had loaded. This matches the behaviour in 7.0 that we reported. (BAD)
    • Forcing a close of the analysis from the diagnostics page in console causes the on-demand loading for the orphaned analysis to stop when the next get_data event completes – I can see entries in the web player log showing that it’s detected a cancelation. (GOOD)
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us