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?

[nidhisingh14]

Hi david_engelhart 

In note 3451882, it is mentioned how you could create missing SDRQ table so please create table with help of this and check issue again after this.

Thank You.

Kind Regards
Nidhi

[david_engelhart]

Thank you Nidhi, though the table is not missing, it exists in SBOCOMMON. Only this one database causes that error, other databases on the server work fine.

[nidhisingh14]

Hi david_engelhart 

Please check KBA 3451882 - “Failed to Get Database Information from System Landscape Directory” error while logging into SAP Business One.

Thank You.

Kind Regards
Nidhi Singh
SAP Business One Support

[david_engelhart]

Thank you, although it seems that I did restore the database properly (in SSMS the "WITH REPLACE" option was not selected). At any rate I have suceeded to manually add the SDRQ table (had to make a few adjustments to the provided query for compatibility with SSMS) but I'm still getting the same message.

Also does this table need to contain any specific values? It's unclear what the process is from here.

Additionally, I see that other databases that I am able to log into do not have that table at all.

[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.