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
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
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,