Error while trusting data functions in bulk using the trust script from find-analysis-scripts in Spotfire

Error while trusting data functions in bulk using the trust script from find-analysis-scripts in Spotfire

book

Article ID: KB0070518

calendar_today

Updated On:

Products Versions
Spotfire Server 10.3.x and higher

Description

In below community article, refer section "Trusting data functions in bulk, using the trust script from find-analysis-scripts"

https://community.spotfire.com/articles/spotfire/guidelines-how-introduce-improved-trust-mechanism-spotfire-103-or-higher-when-upgrading/

As per this section, when the find-analysis-scripts command is executed, one of its outputs should have been a script file named trust_[date].script (e.g.  trust_2020-04-24.script). This file is by default located in the [TIBCO Spotfire Server installation directory]\tomcat\spotfire-bin\find-analysis-scripts directory. The script file contains the trust commands to trust each individual untrusted data function (but also untrusted scripts, and custom queries) that was found when running the find-analysis-scripts command. If you now choose to apply trust in bulk, you can execute the entire script using a server command like this:
----------
config run trust_2020-04-24.script
-----------

While running this command, you may come across below errors:

For example:

------------
C:\tibco\tss\10.9.0\tomcat\spotfire-bin>config run trust_2020-04-24.script
Error executing command script trust_2020-04-24.script: illegal set expression on line 6
-------------
OR
-------------
C:\tibco\tss\10.9.0\tomcat\spotfire-bin>config run trust_2020-04-24.script
Error executing command script trust_2020-04-24.script: illegal set expression on line 7
-------------

Environment

All

Resolution

Before running above command, you need to update below two parameters in the generated script file (for example: trust_2020-04-24.script) on line no.6 and 7.

set BOOTSTRAP_PATH = ""
set CONFIG_TOOL_PASSWORD = ""


From:
-------------- 
# This script can be used for trusting all untrusted scripts, data functions and custom queries that were found when running the 'find-analysis-scripts' command
# Run this script from the command-line using the following command:
# config run trust_2020-04-24.script

# Before using this script you may need to set the variables below:
set BOOTSTRAP_PATH = ""
set CONFIG_TOOL_PASSWORD = ""
---------------- 

TO:
-------------- 
# This script can be used for trusting all untrusted scripts, data functions and custom queries that were found when running the 'find-analysis-scripts' command
# Run this script from the command-line using the following command:
# config run trust_2020-04-24.script

# Before using this script you may need to set the variables below:
set BOOTSTRAP_PATH = "set_path_of_your_Bootstrap_file"
set CONFIG_TOOL_PASSWORD = "Your_config_tool_password"
----------------

Issue/Introduction

Error while trusting data functions in bulk using the trust script from find-analysis-scripts in Spotfire

Additional Information