Failed to get database information from System Landscape Directory-HANA SAP B1

[nizam_babayev]

Dear all, i have issue with SAP B1

I make restore database, everything goes successfully, but from SAP B1 it doesn't enter to the database and gives the following error:

Failed to get database information from System Landscape Directory

below are my codes which is used to make restore:

IMPORT "TEST"."*"  FROM '/hana/shared/export' WITH REPLACE threads 10 RENAME SCHEMA TEST TO DEMO_DB3;

OR

IMPORT "TEST"."*" AS BINARY FROM '/hana/shared/export' WITH IGNORE EXISTING  threads 10 RENAME SCHEMA TEST TO DEMO_DB7;

Error from Log File

"SLDClient SLDClientOP::GetCompanyDBCredentials OData Exception code:807 message:Error while adding database logon credentials for ""{0}"": B1_44854D4F5F777237_RW

SAP B1 FP2308 ^ HANA V2

[hammachek]

Hello,

I have the same problem, please help me to resolve it by explaining the steps to follow

[nidhisingh14]

Hi nbacy

You need to create missing SDRQ table with help of another SBOCOMMON database where this table exists.

Or

Please create incident using component SBO-BC-SLD so that we could provide you script to create the missing SDRQ table.

Thank You.

Kind Regards
Nidhi Singh
SAP Business One Support

[nidhisingh14]

Hi nbacy

Please check in the SBOCOMMON schema if SDRQ table exists. If not, please let me know and I will send script how to recreate it which could solve this issue.

Also check if the Authentication Service is started and port 40020 is opened as described in the attached SAP Note

3297866 - Error - 'Failed to get access token, contact your administrator'

Kind Regards
Nidhi Singh
SAP Business One Support

[nizam_babayev]

Hi dear Nidhi, no SDRQ table is not exists. Thanks in advance.

[nizam_babayev]

i can successfully connect to the original database, but i when i try to copy and login - it shows that error.

[david_engelhart]

I would also like to learn how to solve this issue