• Have you ever run into errors when attempting to run Spotfire’s built in TERR_PairsPlot data function?
  • Are you seeing a TERR error that references to RinR?

This week, I was helping some folks generate a pairs plot using the TERR_PairsPlot data function that comes built in with the software when you purchase the Spotfire Server product.  We ran into errors when trying to execute the data function, and I wanted to share this because…

  1. I’ve seen this error before but couldn’t remember the solution, so this is my way of codifying the solution in my brain.
  2. When users start diving into more advanced functions and R functions, this is often where they start, so this error is very common.

Here is what it looks like in the Spotfire library after install.

Here is the full error message that was received when trying to run TERR_PairsPlot.

 


TIBCO Enterprise Runtime for R returned an error: ‘Error in REvaluator.(expr, substitute = FALSE, verbose = verbose, dat : The R interpreter, ‘Cannot find R executable’, did not make an output file, the program probably could not be found (set options(RinR_R_FULL_PATH) or options(RinR_TERR_FULL_PATH) and call configureREvaluator)

Text output from call to interpreter is ‘”Cannot find R executable”‘ is not recognized as an internal or external command, operable program or batch file.’.

at Spotfire.Dxp.Data.DataFunctions.Executors.LocalFunctionClient.OnExecuting(FunctionClient funcClient)

at Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.<RunFunction>d__0.MoveNext()

at Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.<ExecuteFunction>d__0.MoveNext()

at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.<ExecuteFunction>d__6.MoveNext()


Now, TIBCO Enterprise Runtime for R (TERR) comes with an optional built-in “RinR” package, which makes it possible to send data and expressions (R commands) out to an open-source R instance that has been installed on the same machine.  The TERR_PairsPlot uses RinR.

The source of the error was that the user did not have open source R installed on his machine.  As soon as open source R was installed, the error resolved itself. Even though the data function is a TERR data function, you still need to have open source R installed.

Before downloading R, make sure to check which version of open source R was testing with the TERR version you are currently running.

 

Written by Julie Schellberg of Big Mountain Analytics, LLC
Residing in Whitefish, MT, an analytics partner with Ruths.ai. Specializing in Spotfire analytics, dabbling in Power BI and R.