Monitoring LiveCache from Solman

[Sathya-08]

Issue:

Solman monitoring for LiveCache system not working and the configuration from solution manager shows below error.

com.sun.xml.internal.ws.fault.ServerSOAPFaultException: Client received SOAP Fault from server: 'EnumerateInstances' on 'SAP_ITSAMDatabaseMetric' fail:

Operation not supported: SAP_DB_ListDatabaseMetrics: The function is only executing with MaxDB Database user from type "SYSDBA". Please see the server log to find more detail regarding exact cause of the failure

Troubleshooting:

Solman utilize SAP HostAgent to collect data about LiveCache and MaxDB and sends the collected data back to Solution Manager.

For SAPHostAgent to connect with MaxDB, it needs userkey value maintained in xuser under sapadm user.

Login into sapadm user account and check the output  of below command

/sapdb/programs/bin/xuser list

It should has a entry with key <SID>SAPDBCTRL with user SUPERDBA to connect with SQL of MaxDB.

If you dont have this entry, add it using below command as root,

/usr/sap/hostctrl/exe/saphostctrl -host <hostname> -user sapadm <password> -dbname <SID> -dbtype ada -function SetDatabaseProperty DBCredentials=SET -dboption User=SUPERDBA -dboption Password=<password>

If you have special character in the password use masking eg- pass\@word\#  (\ for masking )

Once you have the entry check the connectivity status with below command,

/usr/sap/hostctrl/exe/saphostctrl -function GetCIMObject -enuminstances SAP_ITSAMDatabaseMetric -properties "Name=<SID>&Type=ada" -arguments "ID=TOTAL_DATA_AREA"
Error: 'EnumerateInstances' on 'SAP_ITSAMDatabaseMetric' fail: Operation not supported: MaxDB PowertoyTools Lib (MaxDB client 7.9.08.40) is not available.

Unfortunately it was not working and showing irrelevant error.

Solution:

SAPHostAgent executable need library to connect with MaxDB and that is located under Hostagent Executable Directory /usr/sap/hostctrl/exe

Update the below library to newer version or link to latest version of the same library available in your system.

lrwxrwxrwx 1 root system 36 Oct 05 23:50 libSQLDBC.so -> /sapdb/<SID>/db/lib/lib64/libSQLDBC.so

Output should show as below,

/usr/sap/hostctrl/exe/saphostctrl -function GetCIMObject -enuminstances SAP_ITSAMDatabaseMetric -properties "Name=<SID>&Type=ada" -arguments "ID=TOTAL_DATA_AREA"
*********************************************************
CreationClassName , String , SAP_DB_MetricTable
Timestamp , String , 2021/10/05 23:51:10
*********************************************************
CreationClassName , String , SAP_DB_MetricValue
Name , String , TOTAL_DATA_AREA
MetricID , String , TOTAL_DATA_AREA
Resource , String ,
SystemHost , String , <hostname>
SystemID , String , <SID>
SystemType , String , Database
Timestamp , String , 2021.10.05 23:51:10.982
Unit , String , MB
Value , String , 56000
Rating , int16 , 1

Once we get above output, then Solution Manager should be able to connect with MaxDB using SAPHostAgent without any issue.

Have Fun Solving issues.