deleted deleted

deleted deleted   •   over 8 years ago

Connect to Biginsight from desktop RStudio


I triy to connect to Biginsight from desktop RStudio. I follow these instructions:

Unfortunatelly I can't do the 6. steps. In Biginsight the connection works but in Rstudio doesn't. My parameteres are:

bigr.connect(host="", 7052, "default", user="biblumix", password="xxmypasswordxx")
Error: BigR[bigr.connect]: Connection could not be established. Verify connection parameters.

What could be wrong?



  •   •   over 8 years ago

    Try stoping and restarting the BIg SQL scheduler on the big insights cluster tab. I had the same issue and this worked.

  •   •   over 8 years ago

    It takes several minutes for the service to get back up and running after stopping. Make sure it is running before trying to connect through R Studio.

  •   •   over 8 years ago

    Hi Melinda, I was able to connect to your cluster from local RStudio. Make sure you enter the correct biblumix password from your A4H service page.
    > library(bigr)
    Loading required package: rJava
    > bigr.connect(host="", 7052, "default", user="biblumix", password="ReplaceWithBiblumixPasswordOnA4HPage")
    > is.bigr.connected()
    [1] TRUE

  •   •   over 8 years ago

    Hi Melinda, Can you please try these steps :
    1. Make sure Oracle Java 7 is set in your JAVA_HOME and path. What Java version do you use ? Please try with Oracle Java 7. Also , ensure that its 64 bit or 32 bit Java pertaining to your environment. As the stackoverflow link states , you can set JAVA_HOME inside R in the following way
    Sys.setenv(JAVA_HOME="C:\\Program Files\\Java\\jre7\\")
    options(java.home="C:\\Program Files\\Java\\jre7\\")
    2. One more thing : please make sure the underlying R in your environment is either 32 bit or 64 bit and not both. If you have installed for both, uninstall R and then re-install only one.
    Hope this helps and let me know .

Comments are closed.