The connection to the controller API could not be established
Sometimes maybe you could have gotten this message when you tried to login to XSA services on SAP HANA Express, just like that:
When you got this message you can’t list XSA applications, because this command requires you have succesfully logged with the XSA_ADMIN user.
So, the way I found to fix the problem was looking for the error in the log/trace files. Specifically theses files are usefull:
hxeadm@me:/usr/sap/HXE/HDB90/<myhome>/trace> ll xsuaaserver* -rw-r--r-- 1 hxeadm sapsys 4611 Mar 16 23:28 xsuaaserver.out -rw-r--r-- 1 hxeadm sapsys 4871 Mar 16 22:37 xsuaaserver.out.20190316232651 -rw-r----- 1 hxeadm sapsys 78330 Mar 16 23:28 xsuaaserver_0.log -rw-r----- 1 hxeadm sapsys 0 Feb 8 18:22 xsuaaserver_0.log.lck
Note that I used the command “ll”. You can use “ls -l” as well.
When you check these files, you can see this message:
2019-03-16 22:37:23:132]-[Generic]-[error]: FAILED to check/wait for XSA database being up and running. com.sap.xs2rt.installation.util.InstallationException: Error during reloadDatabaseHostsFromHdbnsUtil The secure store is still locked: SSFS-1670: Update of the secure storage is locked by user "hxeadm" from host "<myhost>" since "2019-02-23 12:53:34 UTC" (lock management was under application control at the time of lock creation) (RC = 3). If you are sure that the locking process is already gone you can resolve that problem by executing: rm /usr/sap/HXE/SYS/global/xsa/security/ssfs/data/SSFS_HXE.LCK : at com.sap.xs2rt.installation.impl.util.InstallationParameterContainer.reloadDatabaseHostsFromHdbnsUtil(InstallationParameterContainer.java:557)
As you can see, SAP HANA Express gives you the answer in this message:
If you are sure that the locking process is already gone you can resolve that problem by executing: rm /usr/sap/HXE/SYS/global/xsa/security/ssfs/data/SSFS_HXE.LCK
In my case, the problem was I forgot to connect the battery to my laptop, so it shutdown suddendy and that was the reason the process stayed as locked.
When you remove the file, you only have to reebot you computer (or laptop maybe), and that is all. the problem was fixed!.
I hope this tip can help you.
I am stuck here. You were mentioning about checking the log. How do i see the log to find out what the error is?
Well, I'm not sure if the problem you have is the same I show in this post. That is because I can see a problem with your network address. But if you want to try the way I fixed I'll tell you.
Look for this path:
In this path, you can see some files that match with this expression:
So inside them you'll find out the message I showed you in my post.
But I insist the problem you show me is another. I don't know if you are using SAP HANA Express on a native Linux or in a Virtual Machine on Windows. I had a problem with the last and I fixed the network problem only setting a custom specific virtual network, and finally it works.
I hope this will help you.
Have a nice day/night.
Hi José this was very useful and helped me to fix an issue