Failed to get database information from system landscape directory for newly restored DB

[david_engelhart]

I saw a few questions for the same error but not exactly my situation.

I just restored an external database (using MS SSMS), and upgraded it successfully using the SAP setup wizard.

When I try to login using the SBO app, I get this message. 

I noticed that when I entered incorrect credentials, I received the appropriate error message. When the credentials were correct, I was stopped because of the "failed to get database information" message.

How can I fix this?

[seanarchernz]

Log in to the System Landscape Directory (SLD), select the restored Company Database in question and click the Refresh Database User button.

[seanarchernz]

Hi David,

Did you get this resolved?  The SAP Note requires the SDRQ table be created in the SBO-COMMON database rather than the Company Databases.

The following is the contents of the table from one of our environments...looks like it has some SQL and HANA versions of query joins...not sure what they are used for.

I've never encountered this issue before but I wonder if restoring SBO-COMMON from a backup before the issue occurred would work if you have a copy.

Cheers,

Sean

[david_engelhart]

Thanks for your comment. I have not resolved it. I see that I do have that table in the SBOCOMMON DB and it is quite populated. Again, all other databases seem to work fine, it is just this new one that I restored. Could it be a problem with that specific database?

[david_engelhart]

Regarding the comment "Log in to the System Landscape Directory (SLD), select the restored Company Database in question and click the Refresh Database User button."

Thank you so much for your response. I actually tried that, and when I click refresh, I get "Refresh Tech DataBase Users Unsuccessful".

Any insights on that? Thanks in advance.