Skip to Content
0
Aug 19 at 12:48 PM

R3trans error: Get database information failed on connection 0 : rc=100

77 Views

Hello guys,

I'm currently installing a SAP NW 7.5 from scratch on a Linux x86_64 with SAP HANA database as a distributed system.

SCS and DB are already installed. Now, during the installation of the primary application server (PAS), SWPM stops with the following error message:

Process call '/usr/sap/SID/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/SID/SYS/profile/SID_D01_sidpas -install_first_temp O0124582368 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic

I checked saplikey.log and found that the system is not able to connect to the DB. So I checked R3trans -d and noticed that it shows the same error and RC 0012:

*** ERROR => Get database information failed on connection 0 : rc=100
SQLCODE    : 100
SQLERRTEXT : Row not found
SQL COMMAND: SELECT TOP 1 D.DATABASE_NAME || '/' || H.VALUE, L.HOST, CURRENT_USER, CURRENT_SCHEMA, CURRENT_CONNECTION FROM M_DATABASE D, SYS.M_HOST_INFORMATION H, SYS.M_LANDSCAPE_HOST_CONFIGURATION L WHERE H.KEY ='sapsystem' AND L.INDEXSERVER_ACTUAL_ROLE = 'MASTER' ;
-> SetSdbDbslCA(errcode=100)
-> SetSdbDbslCA(errcode=100)
-> disconnect(con_hdl=0)

The interesting thing is: when I execute this statement with user SYSTEM in HANA Studio or HANA Cockpit, it's executable and giving a result with correct Database name, host, user, ...

If I exeute it as SAPABAP1 it's executable but the result set is empty. During further investigation I found out that SAPABAP1 is getting no data because view SYS.M_LANDSCAPE_HOST_CONFIGURATION is empty. The reason for this is that SAPABAP1 is not authorized to select from SYS.M_LANDSCAPE_HOST_CONFIGURATION_ (Please take attention to the _ in the object name at the end)

The other two views are filled with correct data.

So the root cause of the issue above is the missing authorization for SAPABAP1 to read data of SYS.M_LANDSCAPE_HOST_CONFIGURATION_.

Which brings me to the question: do anybody have an idea how to grant this missing authorization?

I tried to execute the following statement with SYSTEM.

grant select on SYS.M_LANDSCAPE_HOST_CONFIGURATION_ to SAPABAP1

But unfortunately I got the message about unsufficient privileges.

Thanks for any comments, ideas or questions.

Kind regards.