DBMAuthorizationProblemTroubleshooting

Database authorization problems from dbmcli

Problem description

You have problems connecting to your database MYDB from dbmcli using sql_connect or util_connect. Typical error messages are

•     sapdb@dws10:~> dbmcli -d MYDB -u DBA,******** -uSQL -c quit
      ERR
      -24988,ERR_SQL: sql error
      -4008,Unknown user name/password combination
      sapdb@dws10:~>
    

Troubleshooting

Probably there is something wrong with one of the files <indepdatapth>/config/MYDB.upc, <indepdatapth>/config/MYDB, <RUNDIRECTORY>/dbm.cfg.

Here's how to check what is going wrong:

• Check the name of the "firstDBM" with

  • dbmcli -d MYDB -u DBA,******** param_getvalue CONTROLUSERID

  And check the user data record of your "first DBM":

  • dbmcli -d MYDB -u DBA,******** user_get <firstdbmname>

  The last line of the return should be "USERTYPE=DBM".

  Check the configuration key which contains the name of the "first DBM" too:

  • dbmcli -d MYDB -u DBA,******** dbm_configget SAPDB12

Usually, the the second or third command will return incorrect information. In this case update the SAPDB12 key to the correct value with

• dbmcli -d MYDB -u DBA,******** dbm_configset SAPDB12 <firstdbmname>