Troubleshooting Guide: What to capture when troubleshooting issues related to failed calls for imported packages with the error, "Could not execute function call. TIBCO Spotfire Statistics Services returned an error: 'package' or namespace load failed for

Troubleshooting Guide: What to capture when troubleshooting issues related to failed calls for imported packages with the error, "Could not execute function call. TIBCO Spotfire Statistics Services returned an error: 'package' or namespace load failed for 'packagename'".

Resolution: Here is a list of commands to query the TIBCO Spotfire Statistical Services (TSSS) server to ensure it is functional, validate if the searchPaths are set, and verify if all the required packages are loadable. The results are useful for diagnosing why the particular package cannot be loaded and can be sent to TIBCO Spotfire Support or investigation.

Diagnostic Test Commands:

• Command to verify TSSS version

Format: http:////api/v8/expression/eval?cmd=version

Example: http://myTSSS.COM/SplusServer/api/v8/expression/eval?cmd=version

• Command to verify TSSS is functional

Format: http:////api/v8/expression/eval?cmd=sqrt(64)

Example: http://myTSSS.COM/SplusServer/api/v8/expression/eval?cmd=sqrt(64)
• Command to get the absolute file path to each package in the search list for the current environment

Format: http:////api/v8/expression/eval?cmd=searchpaths()

Example: http://myTSSS.COM/SplusServer/api/v8/expression/eval?cmd=searchpaths()

• Command to list the names of the packages currently loaded or those that could be loaded.

Format: http:////api/v8/expression/eval?cmd=.packages(all.available=TRUE)

Example: http://myTSSS.COM/SplusServer/api/v8/expression/eval?cmd=.packages(all.available=TRUE)

• Command to verify if a package is loadable

Format: http:////api/v8/expression/eval?cmd=library()

Example: http://myTSSS.COM/SplusServer/api/v8/expression/eval?cmd=library(plyr)

• Command to get a character vector whose elements are the names of each package in the search list for the current environment.

Format: http:////api/v8/expression/eval?cmd=search()

Example: http://myTSSS.COM/SplusServer/api/v8/expression/eval?cmd=search()

To capture the execution and results of these queries, follow these steps.

1. Open a web browser.

2. For each of the test command URLs listed above, modify them to match your particular TSSS instance:

o Replace with the server name of the TSSS instance to where the Spotfire data function's script is being sent.

o Replace with the service name (as defined in the spserver.properties file) for the TSSS instance to where the Spotfire data function's script is being sent. This is case sensitive.

o Replace with the name of the particular package you are unable to execute per the error message.

3. Paste the modified URLs into a web browser and execute them in the same order by pressing the key.

4. Copy all of the results that are displayed in the web browser.

5. Paste the results into a text file.

6. Send the resulting text file to TIBCO Spotfire Support via the service request.

Keywords: Could not execute function call. TIBCO Spotfire Statistics Services returned an error: 'package or namespace load failed, TSSS troubleshooting, package load fails in TSSS