​Database explorer does not show my queries

[#1]

Today I have accessed the Database Explorer and there is no trace of my queries in the SQL consoles. It is the first time this happens to me, I have logged in from the same browser and with the same user account. I have not deleted cookies, nor cache, nor anything else, but there is no trace of them.

Any idea how to recover my queries and scripts?

Is there another way to work safely? I think it is not possible to save the SQL consoles in Git or other site in a persistent way.

Thanks

[adam_hurst2]

Hi Xavier,

It is hard to say how the auto-loaded sql consoles were lost... Did you notice losing anything else at the same time (ie. databases in your tree or other preferences?)

Going forward, to securely store scripts and statements you can use the statement library (https://help.sap.com/viewer/a2cea64fa3ac4f90a52405d07600047b/cloud/en-US/f7e1e69e05cb4314b134ce69e5289697.html).

Thanks,
Adam

[XaviPolo]

No, everything else looks the same.

The last thing I did was to access from a new BTP Trial, which added the connection to the HANA Cloud, but at that point the SQL consoles loaded fine.

Yes, some scripts that I use frequently I saved in the library and they are still there, but the data analysis with a lot of SQLs are not ...

What I see different is the login screen, now it asks me to choose the provider, and using the default I get the Universal ID login, but I understand that this should not be the problem because I see the connections to the DBs correctly.

Thanks.

[ghoshsayantan3]

Hi Xavier,

If the queries were being used frequently ,you can try accessing the HOST_SQL_PLAN_CACHE it should have last few days executed queries in the statement_string column.This can help in getting back few of your queries which were executed.

Regards,

Sayantan

[XaviPolo]

thanks for the advice, although it is not my case, it is a good option to look at.