OAC: R_EXECUTABLE_PATH Not Found While Trying to Use R Functions

(Doc ID 2371078.1)

Last updated on MARCH 08, 2018

Applies to:

Oracle Analytics Cloud Service - Version 18.1.3 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

While trying to use an advanced analytic function you get this error:

Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 47092. [nQSError: 47092] The value of R_EXECUTABLE_PATH is set to /usr/bin/R which is invalid. (HY000)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms