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

[eddie86]

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.

[eddie86 · Accepted solution]

Die issue was resolved by dropping the database tenant of SAPABAP1 and doing another clean installation of the database instance.

Seems something went wrong during the original run.

[dvankempen]

Hi Florian,

SYS owns the view, not SYSTEM, hence SYSTEM cannot grant this to anyone (unless granted WITH ADMIN privileges).

Would granting the MONITOR role solve the issue?

[eddie86]

Hello Dennys,

thanks for you comment. Unfortunately it did not change anything to grant role MONITORING to SAPABAP1.

And yes, I know that SYS owns SYS.M_LANDSCAPE_HOST_CONFIGURATION_

But I'm not sure that this is a view at all as I cannot find it under section view of schema SYS (I only can find SYS.M_LANDSCAPE_HOST_CONFIGURATION which is calling SYS.M_LANDSCAPE_HOST_CONFIGURATION_).