Posts

Posts

  • 1-8 of 8
  • Saumyadip Sarkar
    Keep a variable in Linear Regression Model
    Topic posted October 29, 2019 by Saumyadip Sarkar, tagged Machine Learning, Natural Language, Prepare & Model Data in Oracle Analytics public
    Title:
    Keep a variable in Linear Regression Model
    Summary:
    Oracle Analytics Desktop ommiting a variable in Linear Regression Model
    Content:

    I am trying to create a linear regression model using the following 2 predictors House_size and Year to predict Price. However while trying to create the model using OLS, the final model shows only the Year but not the House_Size. I assume , House_Size and Price are highly correlated. In this scenario, how I do I keep both the variables i.e House_Size and Year in my model. Using only Year makes no sense. I am using Oracle Analytics Desktop to create the model. Attaching the data for reference. 

    Any help on this would highly be appreciated.

    Version:
    Oracle Analytics Desktop 12c
  • Tod Goulds
    oracle data visualization desktop advanced analytics -...1
    Topic posted September 24, 2019 by Tod Goulds, tagged Analysis, Machine Learning, Reporting in Oracle Analytics public
    Title:
    oracle data visualization desktop advanced analytics - install error
    Summary:
    advanced analytics not installing
    Content:

    Hi there,

    I am trying to install the oracle data visualization desktop advanced analytics, and after some playing about, as the base install didn't work... i get further, but now fail with the following error:

    -------------------------------------------

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

    package 'NLP' successfully unpacked and MD5 sums checked
    package 'slam' successfully unpacked and MD5 sums checked
    package 'tm' successfully unpacked and MD5 sums checked

    The downloaded binary packages are in
            C:\Users\TG\AppData\Local\Temp\Rtmpy81tE8\downloaded_packages

    [1] "pkg.directory=C:\\PROGRA~1\\OracleDV\\OracleBI1\\modules\\oracle.bi.dvdesktop.installer\\R\\pkg"
    [1] "user.lib=C:/Program Files/R/R-3.1.1/library"
    Error in contrib.url(repos, type) :
      trying to use CRAN without setting a mirror
    Calls: install.packages -> grep -> contrib.url
    Execution halted
    Runtime exception caught mainNoExit java.lang.RuntimeException: Local R package install script failed, exited with 1
    Advanced Analytics installation failed due to:
    Local R package install script failed, exited with 1

    Press any key to continue . . .

    ----------------------------------------------------------

    I have attached the full cmd wind dump and also the log file... 

    any advice/ideas would be gratefully received... 

    thank you

    tod

     

    Document:
    Document:
  • Zunaira Butt
    Error In Oracle Data Visualization Desktop5
    Topic posted September 25, 2019 by Zunaira Butt, tagged Access & Manage Data, Analysis, Developers, Documentation, Machine Learning, Packaging & Licensing, Prepare & Model Data, Reporting, Tip in Oracle Analytics public
    Title:
    Error In Oracle Data Visualization Desktop
    Summary:
    Error in training the dataset
    Content:

    Hello sir/Madam, I have recently download the Oracle Data Visualization Desktop. I need this for my thesis project on Big Data analysis. I want to train my dataset using machine learning but when I train my dataset the following error show.

    Step |j| Execution failed. Status: FAILED. Message: [nQSError: 46105] Error executing process: "C:\Program Files\dvmlruntime\Python-3.5.2\amd64\python.exe" C:\Users\Zuni\AppData\Local\Temp\DVDesktop\servers\obis1\tmp\nQS_PAF_9636_3_16932481.TMPThe system cannot find the file specified.[nQSError: 43224] The Dataflow "example" failed during the execution.[nQSError: 43204] Asynchronous Job Manager failed to execute the asynchronous job.

    Please tell me how can I resolve this error. I also try to find the solution from Oracle Website but I don't get it. I hope you will help me to resolve this issue. Thank you.

    Version:
    12c (12.2.5.3.0)
    Image:
  • Senthilrajan Vaithianathan
    Data Visualization - Oracle Analytics - Training35.0
    Topic last edited September 11, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged Analysis, Machine Learning, Packaging & Licensing, Prepare & Model Data, Tip in Oracle Analytics public
    Title:
    Data Visualization - Oracle Analytics - Training
    Summary:
    Session on Data Visualization - Oracle Analytics
    Content:

    https://www.udemy.com/augmented-analytics

    Hope this is published by Oracle team and it is free. It has details for setting up the environment and practice sessions (with sample data)

     

  • Roberto Espinosa
    MacOS DVD Configure Python3
    Topic last edited September 11, 2019 by Roberto Espinosa, tagged Analysis, Machine Learning in Oracle Analytics public
    Title:
    MacOS DVD Configure Python
    Summary:
    Error when executing DVD Configure Python on Mac
    Content:

    Hi Team,

     

    I'm getting this error after installing DVD latest version (12.2.5.3.0) on my Mac:

     

    echo Downloading Installer for Python Framework;
        /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/jdk/jre/bin/java -Doracle.bi.rinstall.timedilation=1 -Doracle.bi.product.dir=/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1 -Doracle.bi.proxy.log.dir=$TMPDIR -jar /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.dvdesktop.installer/rinstall.jar -download=true -url=https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg -filePath=$TMPDIR/BiPython_Framework.pkg;open -W $TMPDIR/BiPython_Framework.pkg; /usr/bin/osascript -l JavaScript '/Applications/Oracle Data Visualization Desktop Configure Python.app/Contents/Resources/Scripts/DVDesktop_JSON_Writer.scpt';rm $TMPDIR/BiPython_Framework.pkg
    McBkPr-RES:~ robertoespinosa$ echo Downloading Installer for Python Framework;
    Downloading Installer for Python Framework
    McBkPr-RES:~ robertoespinosa$ /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/jdk/jre/bin/java -Doracle.bi.rinstall.timedilation=1 -Doracle.bi.product.dir=/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1 -Doracle.bi.proxy.log.dir=$TMPDIR -jar /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.dvdesktop.installer/rinstall.jar -download=true -url=https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg -filePath=$TMPDIR/BiPython_Framework.pkg;open -W $TMPDIR/BiPython_Framework.pkg; /usr/bin/osascript -l JavaScript '/Applications/Oracle Data Visualization Desktop Configure Python.app/Contents/Resources/Scripts/DVDesktop_JSON_Writer.scpt';rm $TMPDIR/BiPython_Framework.pkg
    Jun 11, 2019 5:00:06 PM oracle.bi.exec.ExecScript executeScript
    INFO: Executing: [/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.configutils/internetproxylookup.exe, https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg]
    Jun 11, 2019 5:00:06 PM oracle.bi.exec.ExecScript executeScript
    INFO: Logging script stderr to /var/folders/qk/7dknhwdx52vbv9ypnf2pt8q00000gn/T/proxyProvider.log

    Jun 11, 2019 5:00:06 PM oracle.bi.dvdesktop.birinstall.RInstall mainNoExitDownload
    SEVERE: Download failed: Unable to get proxy for https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg
    java.lang.RuntimeException: Unable to get proxy for https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg
        at oracle.bi.dvdesktop.birinstall.Download.copyURLtoFileWithProxy(Download.java:46)
        at oracle.bi.dvdesktop.birinstall.RInstall.mainNoExitDownload(RInstall.java:121)
        at oracle.bi.dvdesktop.birinstall.RInstall.mainExitDownload(RInstall.java:81)
        at oracle.bi.dvdesktop.birinstall.RInstall.main(RInstall.java:59)
    Caused by: oracle.bi.install.environment.ProxyException: Execution of proxy lookup command failed
        at oracle.bi.install.environment.MacProxyProvider.getProxy(MacProxyProvider.java:84)
        at oracle.bi.dvdesktop.birinstall.Download.copyURLtoFileWithProxy(Download.java:42)
        ... 3 more
    Caused by: oracle.bi.exec.ExecutionStatusException: Execution of [/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.configutils/internetproxylookup.exe, https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg] failed with exit value 139
        at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106)
        at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
        at oracle.bi.exec.ExecScript.executeQueryScript(ExecScript.java:106)
        at oracle.bi.install.environment.MacProxyProvider.getProxy(MacProxyProvider.java:82)
        ... 4 more

    Runtime exception caught mainNoExitDownload java.lang.RuntimeException: Unable to get proxy for https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg
    The file /var/folders/qk/7dknhwdx52vbv9ypnf2pt8q00000gn/T//BiPython_Framework.pkg does not exist.
    rm: /var/folders/qk/7dknhwdx52vbv9ypnf2pt8q00000gn/T//BiPython_Framework.pkg: No such file or directory

    It seems it is trying to execute a ".exe" file!

    Any ideas how to get Advanced Analytics running on Mac?

     

    Thanks

    Roberto

     

    Version:
    12.2.5.3.0
  • Keerthimanu Gattu
    Custom Script in Data Visualization Desktop4
    Topic last edited September 11, 2019 by Keerthimanu GattuGreen Ribbon: 100+ Points, tagged Machine Learning, Prepare & Model Data in Oracle Analytics public
    Title:
    Custom Script in Data Visualization Desktop
    Summary:
    I am actually learning to use custom python scripts in the tool. Seems like it has to be formatted into an XML. Any tool / easy way to do wrap the python script I have into XML?
  • Ravi Vallabhaneni
    Install Error for Data Visualization Machine Learning...4
    Topic last edited September 11, 2019 by Ravi Vallabhaneni, tagged Analysis, Machine Learning in Oracle Analytics public
    Title:
    Install Error for Data Visualization Machine Learning (DVML)
    Summary:
    Unable to reach https://oss.oracle.com/DVML/DVML-1.0.0-win.zip
    Content:

    'Install DVML' is unable to reach the  https://oss.oracle.com/DVML/DVML-1.0.0-win.zip but when I do it in browser it works fine.

    I even downloaded the file but its not opening. Any other way to install DVML

    Thanks,

     

    Image:
  • Lenin Valencia
    Multiple ERROR DVDAnswered2
    Topic last edited September 11, 2019 by Lenin ValenciaRed Ribbon: 250+ Points, tagged Analysis, Machine Learning in Oracle Analytics public
    Title:
    Multiple ERROR DVD
    Summary:
    Error Running Data Flow nQSError: 46105
    Content:
    I get this error when running a data flow
    Does anyone know how to correct it?
    [nQSError: 46105] Error al ejecutar el proceso: "C:\Program Files\dvmlruntime\Python-3.5.2\amd64\python.exe" C:\Users\lenin\AppData\Local\Temp\DVDesktop\servers\obis1\tmp\nQS_PAF_11996_3_4618808.TMP
    El sistema no puede encontrar el archivo especificado.
    [nQSError: 43224] The Dataflow "Bike Renting Training - Linear Regressión" failed during the execution.
    [nQSError: 43204] El gestor de trabajos asíncronos no ha podido ejecutar el trabajo asíncrono.