Secure storage is locked

[Former Member]

Hi,

In my cloud SAP HANA Studio...in Navigator window,suddanly its showing the following error message.

'Secure Storage is locked;

and there is UNLOCK button beside this meaasge,but when i click on this button,nothing is happening.

Please help me out how t oresolve this issue.

Thanks,
Suren.

[jyoti_senapati · Accepted solution]

Hi Surendranath,

Please follow below steps.

Open HANA Studio->Windows -> Preferences -> General -> Security -> Secure Storage -> Content

Then click the push button. It will restart your application and you can see your system.

Regards,

Jyoti

[Former Member]

Another solution that worked in my case.

Go to: Windows - Preferences - General - Secure Storage.- Password [tab] - [Click button] Recover Password ... - [Answer the security questions].

A new master password is created. [Confirm]

Now click the Unlock button and you should be able to see your systems.

Please note, if you don't remember the answers to password recovery, you may have to delete the secure storage settings (from the contents tab), restart Eclipse and when it prompts for security questions, perform the Password Recovery setup seriously! This is as good as creating a new password which you want to use to recover as mentioned above.

[jevay_liu]

Hi Surendranath,

Please follow below steps.

Open HANA Studio->Windows -> Preferences -> General -> Security -> Secure Storage -> Content, then select the content items, and delete it, it will ask you whether allow to delete all passwords, click 'Yes' to confirm that. then it will restart the studio. when it opens again, the system will be back to work, thanks.

Regards,

Jevay

[Former Member]

Hello,

I'm also facing this issue with HANA DB 102, and can resolve with above steps.

But I'm curious, what's causing this issue happen ? and how to prevent it ?

Regards,

Hendra

[christian_haller2]

Hello Everybody,

I want to use secure_storage with 2 Machines (not at the same time):

1. SAP Desktop (WTS)
2. SAP Notebook (Windows 7 x64)

What I did on SAP Desktop (WTS)

1. Check Windows Explorer for existing Home Share N:\ ( https://sat.wdf.global.corp.sap > Home Share) and create subfolder: "N:\SAP HANA Studio"
2. When starting SAP HANA Studio Rev102 define the follwing folder in "Workspace Launcher": "N:\SAP HANA Studio"
3. Window > Preferences > type secure > Secure Storage > Tab Contents > The path is "N:\SAP HANA Studio\.eclipse\org.eclipse.equinox.security\secure_storage"
4. Exit SAP HANA Studio

What I did on SAP Notebook:

1. Check Windows Explorer for existing Home Share N:\ ( https://sat.wdf.global.corp.sap > Home Share) and create subfolder: "N:\SAP HANA Studio"
2. Install SAP HANA Studio via Software Center (SCClient) or Software Corner (Browser) but don't start it
3. Start > Search for cmd or command > right click on cmd.exe > Run as administrator
4. cd to your home: C:\Users\<D/C/I>\
5. mkdir .eclipse && cd .eclipse
6. mklink /D org.eclipse.equinox.security "N:\SAP HANA Studio\.eclipse\org.eclipse.equinox.security" symbolic link created for org.eclipse.equinox.security <<===>> N:\SAP HANA Studio\.eclipse\org.eclipse.equinox.security
7. Start SAP HANA Studio
8. Instead of the System list "Landscape" the message "Secure storage is locked" [Unlock] appears
9. When I click on [Unlock] nothing happens
10. Window > Preferences > type secure > Secure Storage > Tab Contents > The path is "C:\Users\<D/C/I>\.eclipse\org.eclipse.equinox.security\secure_storage"

Any Idea?

Thank you and best regards

Christian

[Former Member]

Hi All,

It's just the Eclipse thing.

the permanent solution would be, just open your users, hana studio and you can find .eclipse folder. rename it as old.eclipse instead of deleting it.

I prefer renaming it than deleting. Ensure you close the hana studio before renaming it.

Then open the hana studio again, you can see a window stating a new master password has been created.

Kind Regards,

Mahesh

[former_member204796]

Hi Team,

Any suggestions for the above issue ? appreciate your response in this regard, as I need to resolve this, as its impacting Project work.

Thanks in Advance,

Suma

[Former Member]

I just resolved the issue as below

A - 1. Go HANA Studio->Windows -> Preferences -> General -> Security -> Secure Storage ->Password

  2. Click on the Recover Password button.You should get questions you set up when you created the secure storage. With the correct answers, the secure storage will be unlocked.

  3. Open the orignal Workspace which was shown in the content tab - Storage Location - while reopening HANA Studio, else have to go with Option B

B - Open HANA Studio->Windows -> Preferences -> General -> Security -> Secure Storage -> Content

  Then click the Delete button. It will restart your application and you can see your system.

C - As per note 2118551 (If above doesn't work)

Solution - Please delete .eclipse folder under your HANA STUDIO workspace and try again.

Studio workspace is where you select in beginning

Go to C drive -- > Users -- > Your User name --> .eclipse

Regards,

Rupali S

[former_member204796]

Hi Team,

This issue of "Secure storage is locked " is not resolved for me after doing all the steps suggested in the above posts.

Can you suggest what could be the issue here and how to resolve the same ?

I am using SPS08 and HANA studio version Rev 80 and HANA modeller perspective, tried the same with Rev 83 and / or using HANA admin perspective , but does not help.

Steps I have tried already:

1. go to Windows -> Open New Window. This created a second instance of HANA studio that didn't have the Locked issue. So, I could add the system, but the added system was not shown here

2. After this I tried this as well :

go to Window->Preferences->General->Security->Secure Storage

switch to  <Contents> tab, and delete the default secure storage. and restart the HANA Studio.

This again shows "Secure Storage is Locked" issue

3. I have tried the last option to "Recover Password" , but this option is not enabled for me.

4. Use of "Unlock " button does not help.

If I ignore this  message and add a HANA System(with proper host details as provided by Basis team )  under "Systems" tray in HANA studio, it connects to the system using my user id credentials (can see the same at the progress bar in bottom right corner) but does not show that the system is added in the Systems tray and the Content , Catalog folders below it.

Can you suggest what could be the issue here and how to resolve the same ?

I am using SPS08 and HANA studio version Rev 80 and HANA modeller perspective, tried the same with Rev 83 and / or using HANA admin perspective , but does not help.

Appreciate urgent help in this regard.

Regards,

Suma

[former_member254965]

Here's another solution that lets you keep your files.

1. Go HANA Studio->Windows -> Preferences -> General -> Security -> Secure Storage ->Password

2. Click on the Recover Password button. You should get questions you set up when you created the secure storage. With the correct answers, the secure storage will be unlocked.

Regards,

Raimi

[business]

This might work for a small number of people. For backup and restore purposes my company PC is configured so that my personal stuff is saved to a network drive as well as c:\users\myName.... Hana Studio was trying to write directly to the network drive, which was not available.

It was quickly seen when I checked the log from Hana Studio.

Regards

Richard

[khampariamukesh]

Here is very easy and permanent solution :

Close HANA studio.

Go to C drive -- > Users -- > Your User name

Delete folder 'hdbstudio' and start SAP HANA Studio again.

Now click on "Open Administration Console"

Thanks and Regards,

Mukesh Khamparia

[Former Member]

Would i loose all the systems I have defined already? We have lots of HANA systems and it is a nightmare if every time I need to recreate them.

[christian_haller2]

1. File > Export > SAP HANA > Landscape
2. File > Import > SAP HANA > Landscape

[Former Member]

also did it for me, thanks !

[former_member196681]

Ok, I just started using HANA studio with the openSAP course and I got the same thing. I think something happened to my default workspace and I couldn't seem to "Unlock" it or go to the properties page to change the database options (because nothing was configured yet).

What I did find that works (and this may be a poor work-around, but it seemed to do the trick for me) is to go Windows -> Open New Window. This created a second instance of HANA studio that didn't have the Locked issue.

Now when I look at the original window it looks like this:

Not sure if that is the correct way to do it or a long term solution. Maybe someone has a better solution. Seem to get this every time I open SAP HANA studio. Did I install it incorrectly?

Thanks,

w.

[terry_huang]

First, I do the steps as  Wayne Pau.  and delete the exist system.

Then,go to Window->Preferences->General->Security->Secure Storage

switch to  <Contents> tab, and delete the default secure storage. and restart the HANA Studio.

This is worked for me.

[WMuellner]

I changed the windows user's password (on OS level) and after re-logon with the new password the HANA studio showed an empty space on the systems connections tab and this error message 'secure storage is locked' with a grey 'unlock' button - which does nothing.

In this case, there is no way to go to the file menu and change the properties of the 'connection' because there is NONE. And you are also NOT able to create a new one.

There was sort of a work-around mentioned somewhere, by just opening a new windows and then entering a new connection from there. This does work, but only for the actual HANA studio session, after closing the studio and re-open it everything has one again and studio is again locked.

So my question is:

what are the exact steps to be able to use HANA studio after having changed the Windows user's password??

br, Walter

[former_member196681]

Walter,

I got the following answer before when I asked in a different forum. I ran the steps and it worked well for me.

Wayne,

please follow the steps as described on http://scn.sap.com/community/developer-center/hana/blog/2012/09/27/the-not-quite-secure-storage-hana... should solve your problem.

-Bernd

Just to note, using the steps in the link worked for me. I had to create a new Master Password. The only thing is that in the link step #3 said click "yes" for me it was "no" to ahead and create the new password. However after that my HANA studio is working without the locked issue.

Good luck.

w.

[WMuellner]

Wayne,

thx for your response. Unfortunately you did not read my message very carefully: THERE IS NO DB-Connection available in my case, all HANA connections are gone. So this link does not help me at all - it tells me to change the database properties and re-cerate a new master password for the HANA connection...

I cannot change the connection/master password, because there is no interaction possible at this point.

Btw I already read all the messages here and could not find a proper solution.

Any more ideas?

Walter

[former_member196681]

You can do what Terry just said. That will get to you to same screen.

For me with no working connections I had to use my initial work-around to get a New Window and then create a new system. I put in localhost as the Hostname and "00" as the instance and clicked <next>. This put me on the screen that has the secure storage link.

However looking back at it, I think Terry's way is faster.

Really this seems to be an Eclipse thing. If you've read the link in the blog here:

http://help.eclipse.org/helios/index.jsp?topic=%2Forg.eclipse.platform.doc.user%2Freference%2Fref-se...

it talks about all that. As it says:

• If all else fails

    If you have a problem with secure storage that you can not find a workaround for, the secure storage can be deleted using the Delete button on the Secure Storage preference page. This, of course, will delete all the contents of the secure storage. It is highly recommended that you restart the application after secure storage has been deleted.

w.

[former_member198121]

Thanks Mate

It worked for me too

[Former Member]

Thank you Terry Huang

It worked for me too

Thanks and Regards,

Mythili

[stuart_smith3]

Tried this approach without success.

An error message said
the hdbstudio is currently used by another Eclips application. Found the
location of .eclipse and renamed it to old_.eclipse. Started Hana studio
without problem.

[Former Member]

That worked for me .. Thanks

[RodrigoCaparroz]

Thank you Terry. It's working for me now.

[holger_brasch]

Thanks - worked for me ...

[former_member210253]

Hi Terry,

Thanks..It worked for me..

Regards,

Babu.

[former_member251865]

it works for me too.. Thanks Terry..

Regards,

Yunianto

[former_member301444]

Thanks Terry, Its worked for me too.

[Former Member]

Thanx Terry.

[mayp_chen]

Terry,

Thanks for sharing.  It works.

[yanyan_wu]

Great. It works now.

[Former Member]

Hi Terry,

     Thanks a lot. It works.

[Former Member]

Worked for me as well!

Thank you!

[former_member184158]

Thank you
this had helped me , it works fine

[Former Member]

Hi Surendra,

Please try changing the secure store password or deleting and recreating the secure store as mentioned in this blog.

There was a similar issue raised  in another message.

Thanks,

Sharan