Unable to Display Visualization with Advanced Analytics Function After Upgrade from DVD 1.x to 2.0 (Doc ID 2211427.1)

Last updated on DECEMBER 11, 2016

Applies to:

Oracle Data Visualization Desktop - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Goal

After upgraded from Data Visualization Desktop (DVD) 12.2.1.x.0 (1.x) to 2.0, the visualization with advanced analytics function cannot be displayed.
The error details are like the below:

-----
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 C:\ProgramFiles\R\R-3.1.1\bin\x64\R.exe which is invalid. (HY000)
SQL Issued: ...
-----

The error indicates that the value of R_EXECUTABLE_PATH is incorrect.
How can I correct the value of R_EXECUTABLE_PATH?

 

Solution

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