Install Advanced Analytics Fails with "Remote R package install script failed" — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Install Advanced Analytics Fails with "Remote R package install script failed"

Received Response
101
Views
7
Comments

Summary

Install Advanced Analytics Fails with "Remote R package install script failed"

Content

Hi,

I've got Data Vis Desktop installed and I'm trying to install the Advanced Analytics but it keeps failing with the following error message in the command prompt:

BI DV Desktop Advanced Analytics Installer 12.2.3.0.0
Logging to file C:\Users\!05016~1\AppData\Local\Temp\DVDesktopRInstall\logs\rinstall.log

Registry R Distribution installation location: C:\Program Files\R\R-3.1.1

[1] "repo.url=http://cran.us.r-project.org"
[1] "user.lib=C:/Program Files/R/R-3.1.1/library"
[1] "options.timeout=30"
[1] "https_proxy="
[1] "http_proxy=http://REDACTED_HOSTNAME:80
Proxy authentication failed:
        please re-enter the credentials or hit Cancel

  There is a binary version available (and will be installed) but the source version is later:
         binary source
forecast    7.1    8.1

also installing the dependencies 'zoo', 'timeDate', 'tseries', 'fracdiff', 'Rcpp', 'colorspace', 'ggplot2', 'RcppArmadillo'

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/zoo_1.7-13.zip'
Content type 'text/html' length unknown
opened URL
downloaded 1049 bytes

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/timeDate_3012.10.zip'
Content type 'application/zip' length 807624 bytes (788 Kb)
opened URL
downloaded 788 Kb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/tseries_0.10-34.zip'
Content type 'application/zip' length 320841 bytes (313 Kb)
opened URL
downloaded 313 Kb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/fracdiff_1.4-2.zip'
Content type 'application/zip' length 106800 bytes (104 Kb)
opened URL
downloaded 104 Kb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/Rcpp_0.12.4.zip'
Content type 'application/zip' length 3236565 bytes (3.1 Mb)
opened URL
downloaded 3.1 Mb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/colorspace_1.2-6.zip'
Content type 'application/zip' length 389026 bytes (379 Kb)
opened URL
downloaded 379 Kb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/ggplot2_2.1.0.zip'
Content type 'application/zip' length 1989346 bytes (1.9 Mb)
opened URL
downloaded 1.9 Mb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/RcppArmadillo_0.6.700.3.0.zip'
Content type 'application/zip' length 1697255 bytes (1.6 Mb)
opened URL
downloaded 1.6 Mb

trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/forecast_7.1.zip'
Content type 'application/zip' length 1364370 bytes (1.3 Mb)
opened URL
downloaded 1.3 Mb

Error in read.dcf(file.path(pkgname, "DESCRIPTION"), c("Package", "Type")) :
  cannot open the connection
Calls: install.packages -> .install.winbinary -> unpackPkgZip -> read.dcf
In addition: Warning messages:
1: In unzip(zipname, exdir = dest) : error 1 in extracting from zip file
2: In read.dcf(file.path(pkgname, "DESCRIPTION"), c("Package", "Type")) :
  cannot open compressed file 'zoo/DESCRIPTION', probable reason 'No such file or directory'
Execution halted
Runtime exception caught mainNoExit java.lang.RuntimeException: Remote R package
install script failed, exited with 1
Advanced Analytics installation failed due to:
Remote R package install script failed, exited with 1

Here is the full rinstall.log:

Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.RInstall mainNoExitWindows
INFO: Using time dilation 1
Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.RInstall mainNoExitWindows
INFO: Timeouts: execute = 1200 secs, read = 10 secs, connect = 30 secs.
Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.Distribution installR
INFO: Using existing R installation.
Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.Distribution remotePackages
INFO: Installing remote R packages using http://cran.us.r-project.org
Jul 14, 2017 2:48:05 PM oracle.bi.exec.ExecScript executeScript
INFO: Executing: [C:\Program Files\Oracle Data Visualization Desktop\OracleBI1\modules\oracle.bi.configutils\internetproxylookup.exe, http://cran.us.r-project.org]
Jul 14, 2017 2:48:05 PM oracle.bi.exec.ExecScript executeScript
INFO: Logging script stderr to C:\Users\!05016~1\AppData\Local\Temp\DVDesktopRInstall\logs\proxyProvider.log
Jul 14, 2017 2:48:05 PM oracle.bi.install.environment.WindowsProxyProvider getProxy
INFO: Proxy lookup result for URL http://cran.us.r-project.org
REDACTED_HOSTNAME:80

Auto proxy lookup

Jul 14, 2017 2:48:05 PM oracle.bi.install.environment.WindowsProxyProvider selectFromProxyList
INFO: Proxies: [*@REDACTED_HOSTNAME:80]
Jul 14, 2017 2:48:05 PM oracle.bi.install.validate.network.ConnectValidator validate
INFO: Attempting to connect to http://cran.us.r-project.org with timeout 30000MS, proxy HTTP @ REDACTED_HOSTNAME/REDACTED_IP:80
Jul 14, 2017 2:48:05 PM oracle.bi.install.validate.network.ConnectValidator validate
INFO: Connected to http://cran.us.r-project.org
Jul 14, 2017 2:48:05 PM oracle.bi.exec.ExecScript executeScript
INFO: Executing: [C:\Program Files\Oracle Data Visualization Desktop\OracleBI1\modules\oracle.bi.configutils\internetproxylookup.exe, http://cran.us.r-project.org]
Jul 14, 2017 2:48:05 PM oracle.bi.exec.ExecScript executeScript
INFO: Logging script stderr to C:\Users\!05016~1\AppData\Local\Temp\DVDesktopRInstall\logs\proxyProvider.log
Jul 14, 2017 2:48:05 PM oracle.bi.install.environment.WindowsProxyProvider getProxy
INFO: Proxy lookup result for URL http://cran.us.r-project.org
REDACTED_HOSTNAME:80

Auto proxy lookup

Jul 14, 2017 2:48:05 PM oracle.bi.install.environment.WindowsProxyProvider selectFromProxyList
INFO: Proxies: [*@REDACTED_HOSTNAME:80]
Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.Distribution runScript
INFO: executing R script env:[{http_proxy=http://REDACTED_HOSTNAME:80}]
Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.Distribution runScript
INFO: executing R script cmd:[[C:\Program Files\R\R-3.1.1\bin\x64\Rscript.exe, C:\Program Files\Oracle Data Visualization Desktop\OracleBI1\modules\oracle.bi.configutils\R\script\remote-packages.R, http://cran.us.r-project.org, 30]]
Jul 14, 2017 2:48:05 PM oracle.bi.dvdesktop.birinstall.Distribution execTimedWait
INFO: Execute: command [[C:\Program Files\R\R-3.1.1\bin\x64\Rscript.exe, C:\Program Files\Oracle Data Visualization Desktop\OracleBI1\modules\oracle.bi.configutils\R\script\remote-packages.R, http://cran.us.r-project.org, 30]] environment {http_proxy=http://REDACTED_HOSTNAME:80@} timeout 1200 (timeout @1200 seconds)
Jul 14, 2017 2:49:26 PM oracle.bi.dvdesktop.birinstall.Distribution execTimedWait
INFO: Complete: command [[C:\Program Files\R\R-3.1.1\bin\x64\Rscript.exe, C:\Program Files\Oracle Data Visualization Desktop\OracleBI1\modules\oracle.bi.configutils\R\script\remote-packages.R, http://cran.us.r-project.org, 30]] environment {http_proxy=http://REDACTED_HOSTNAME:80} timeout 1200 exited with 1
Jul 14, 2017 2:49:26 PM oracle.bi.dvdesktop.birinstall.RInstall mainNoExitWindows
SEVERE: R install failed: Remote R package install script failed, exited with 1
java.lang.RuntimeException: Remote R package install script failed, exited with 1
at oracle.bi.dvdesktop.birinstall.Distribution.remotePackages(Distribution.java:155)
at oracle.bi.dvdesktop.birinstall.Distribution.installR(Distribution.java:400)
at oracle.bi.dvdesktop.birinstall.RInstall.mainNoExitWindows(RInstall.java:152)
at oracle.bi.dvdesktop.birinstall.RInstall.mainExit(RInstall.java:66)
at oracle.bi.dvdesktop.birinstall.RInstall.main(RInstall.java:48)

Any ideas? The above output is from running C:\Program Files\Oracle Data Visualization Desktop\install_advanced_analytics.cmd" _payload_ "C:\Program Files\Oracle Data Visualization Desktop\" at an elevated command prompt.

Thanks in advance

Answers

  • Seems to be your internet proxy settings.  Check the settings.  If necessary, specify the internet proxy directly in the internet proxy settings rather than using a script to configure the proxy.

    Does your proxy require authentication?  Some proxies such as Squid can be configured this way.

    Your internet proxy config is telling the Advanced Analytics install script to use an internet proxy of http://REDACTED_HOSTNAME:80 when accessing the internet.  This is obviously not a correct proxy.

  • Did R install?

  • gavin_aus
    gavin_aus Rank 3 - Community Apprentice

    Hi Adam,

    I get prompted to authenticate with the proxy (which is just after "Proxy authentication failed" in the command prompt) and it seems to work because the zip files are downloading.

    Please note that I redacted the proxy hostname in the logs manually myself.

  • gavin_aus
    gavin_aus Rank 3 - Community Apprentice

    Yes, R installed correctly with no error messages.

  • gavin_aus
    gavin_aus Rank 3 - Community Apprentice

    In case anyone else has with the same issue - I resolved this by opening R (which was installed by Advanced Analytics batch file) and then manually installing each of the dependency zip files from within R.

  • Currently not supported.

  • 422933481
    422933481 Rank 1 - Community Starter

    Hi,Adam

    How does Oracle Data Visualization Desktop install advanced analysis without connecting to the external network?