The problem
So you're at home wanting to access your company's SAP HANA system, of from your office, trying to reach an SAP HANA system at your customer. You connect to your company's network using VPN client software.
Then you open the SAP HANA Studio and notice that there's an odd icon near your system's connection and when you hover your mouse over the connection, you get a popup saying:
<SYSID> <hostname> <instance> - System state cannot be determined
SAPControl request failed: Permission denied: connect
Database connection is not available. See error log for more details
Searching for a solution
So you go investigate a little deeper and try one or more of the following, any of which will leave you more confused because none of the options will point you towards a possible cause!
Confused? I was too, until I ran into http://www.java.net/node/703177 Quote: "In JDK 7 brings support for IPv6 on Windows. When you attempt to connect to an IPv4 address then under the covers it will use an IPv4-mapped IPv6 address.". So if your VPN client has no support for IPv6, then you're busted. My Cisco AnyConnect client apparently does not support IPv6.
One solution is reverting to JDK6 instead of JDK7, but that is not always an option.
The real solution
Close HANA Studio.
Edit the file %PROGRAMFILES%\sap\hdbstudio\hdbstudio.ini with your favorite editer (Hint: Open the editor as administrator!)
Add the line
-Djava.net.preferIPv4Stack=true
at the end of the file. This tells JDK not to map to IPv6 addresses. Another solution might be reverting back to JDK6 instead of JDK7.
Save, close your editor and start HANA Studio and you'll see that the problem is solved!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |