Skip to Content
Author's profile photo Former Member
Former Member
Posted on June 4, 2012 Less than a 1 minute read

Visual Intelligence error connecting to HANA server instance

Follow RSS feed
0 Likes 679 Views 3 Comments

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? 

Assigned tags

Related Blog Posts

    Related Questions

      3 Comments
      You must be Logged on to comment or reply to a post.
      • Author's profile photo Denis Sproten
        Denis Sproten

        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

        • Author's profile photo Former Member
          Former Member

          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

          • Author's profile photo Denis Sproten
            Denis Sproten

            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