How to keep Scheduled Updates from executing data functions against TIBCO Spotfire Statistics Services (TSSS).

How to keep Scheduled Updates from executing data functions against TIBCO Spotfire Statistics Services (TSSS).

book

Article ID: KB0079908

calendar_today

Updated On:

Products Versions
Spotfire Statistics Services All Versions
Spotfire Analyst All Versions

Description

When Scheduled Updates loads a report into cache, it will attempt to execute any data function present in the analysis. This might be undesirable if the results that would be cached would not be usable because the data functions must be executed again when end users open the report. In this case, the data function executions sent to TIBCO Spotfire Statistics Services (TSSS) are not required and only add an additional unnecessary load, especially if the executions are long. Because of this, it can be useful to completely disable the execution of data functions by Scheduled Updates. Note that this is not normally required and is only configured in special cases.

Issue/Introduction

How to keep Scheduled Updates from executing data functions against TIBCO Spotfire Statistics Services (TSSS).

Resolution

This can be accomplished by defining the preferences for the Scheduled Updates' user group with an invalid TSSS URL. This will cause the data function execution attempt to fail because the Web Player will not be able to communicate with the TSSS server.

If the TSSS URL is not defined on the "Everyone" group, nor on any other group the Scheduled Updates user belongs to directly:
  1. Open "Administration Manager" > "Preferences" tab > Select the "Scheduled Updates Users" group > "Preferences" tab > TIBCO Spotfire Statistics Services > StatisticsServices > Click the "Edit" button.
  2. In the required engine URL preferences, depending on the data function script types used, enter an invalid TSSS URL such as "http://InvalidTSSSURL".
  3. Click OK.
 

If the TSSS URL is defined on the "Everyone" group:

If the "Everyone" group has a valid TSSS URL defined, then setting the preference on the "Scheduled Updates Users" group will not be sufficient because the "Everyone" group preference will have precedence due to alphabetical ordering. The Scheduled Updates user would be explicitly in both the "Everyone" and the "Scheduled Updates Users" groups. See KB: 46190 "Preference and License inheritance and precedence" for details.

  1. Create a new group which will have the invalid TSSS URL defined in its preferences.
    • Open "Administration Manager" > "Groups and Licenses" tab > Click the "New Group" button.
    • Ensure that the new user group's name begins with "A" or a special character, so that this group name is first alphabetically. 
    • For example, "Alt - Scheduled Updates Users".
  2. Open "Administration Manager" > "Preferences" tab > Select your new group (for example "Alt - Scheduled Updates Users") > "Preferences" tab > TIBCO Spotfire Statistics Services > StatisticsServices. Click the "Edit" button.
  3. In the required engine URL preferences (depending on the data function script types used), enter an invalid TSSS URL, like "http://InvalidTSSSURL"
  4. Click OK.
Now when Scheduled Updates is initiated, the preference with the invalid TSSS URL will be used, preventing the execution of data functions on the TSSS server during the caching of reports by Scheduled Updates.

Additional Information

KB 000022058 "Preference and License inheritance and precedence" for details"