Skip to Content

Visual Intelligence error connecting to HANA server instance

I am able to connect to the HANA server with HANA Studio fine. version 28

However, when I try to connect to that same HANA server (HANA server instance) from Visual Intelligence  I get an error “Unable to connect to the HANA server instance”. 

VI is version 1.0.0  Build 313

Other co-workers in our intranet are able to successfully log in with VI with their laptops using the same userid and password.  

Any ideas of what I might check on my laptop that could be causing VI to not connect successfully? 

3 Comments
You must be Logged on to comment or reply to a post.
  • Hi Jim,

    Build 313 should be correct at this point. Some questions which might help:

    Do your colleagues have SAP HANA Studio installed as well? Maybe there is a driver conflict.

    Have you checked the Java 64bit version is installed (not 32bit)? maybe update it?

    Just to be sure the driver ngdbc.jar is installed in: C:\Program Files\SAP Visual Intelligence\Desktop\plugins\com.sap.hilo.common.hana_1.0.0.r313_v20120510\lib

    Have you tried with a different Windows user (one of your colleagues logging into your laptop), maybe it is a file rights issue?

    Kind Regards,

    Denis

    • Hi Denis, 

      Thanks for your response. 

      I have both java’s installed on my laptop, 32 bit and 64
      bit.  After your email I uninstalled the 64 bit and downloaded the latest
      and installed java 7. 

      My connection still doesn’t work.  I didn’t reboot yet, but I will try to. 

      I checked the folder for ngdbc.jar and it is all there.   

      My colleagues have SAP HANA studio installed, the same version
      28 as mine. 

      I also installed the SAP HANA client (I guess it just and install
      for drivers).  I wonder if there is a driver conflict between SAP HANA
      Client and SAP HANA studio. 

      Let me know if you think this is possible.  I’m not sure
      how to “uninstall” the SAP HANA Client since it is just drivers, right? 

      How about registry entries?  Is there anything that I
      should check there? 

      Yes, I have had our HANA admin try to log into my machine (over
      a web session) and he also got an error on my machine.  He is able to
      connect to HANA fine with VI on his machine. 

      So it doesn’t seem to be a rights issue. 

      Thanks, Jim  Johnson

      • Hi Jim,

        Can you enable traces before connecting and add the traces to the post please?

        1. Enter the following command on the command line: java -jar <installation_path>\ngdbc.jar 
        2. Select Trace enabled and check the location you write to.

        For example: java -jar  "C:\Program Files\SAP Visual Intelligence\Desktop\plugins\com.sap.hilo.common.hana_1.0.0.r313_v20120510\lib\ngdbc.jar"

        Thanks

        Denis