How To Fix SUSR_DBMS001 - Configuration error; connection missing in customizing

SUSR_DBMS001 - Overview

• Message type: E = Error

• Message class: SUSR_DBMS - message for data base user administration

• Message number: 001

• Message text: Configuration error; connection missing in customizing

What causes this issue?

In the current client of SAP NetWeaver Application Server (SAP NetWeaver
AS) ABAP, the database connection required for linking users of SAP
NetWeaver AS ABAP with the DBMS is missing.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Enter a database connection with the supported type and the current
client in maintenance view USR_DBMS_SYSTEM.
Ensure that the database connection is maintained in transaction DBCO
and the user for the database connection has appropriate authorizations
in the DBMS.
For more information, see SAP Note 1836006.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

SUSR_DBMS001 - Details

• The SAP error message SUSR_DBMS001 indicates a configuration issue related to the database connection in the SAP system. This error typically arises when the system is unable to find the necessary database connection settings in the customizing (configuration) settings.
  
  Cause:
  The error can occur due to several reasons, including:
  
  Missing Database Connection: The database connection required for the SAP system is not defined in the system's configuration.
  Incorrect Configuration: The existing database connection settings may be incorrect or incomplete.
  Transport Issues: If the configuration was recently transported from another system, it may not have been set up correctly.
  Authorization Issues: The user may not have the necessary authorizations to access the database connection settings.
  
  
  Solution:
  To resolve the SUSR_DBMS001 error, you can follow these steps:
  
  
  Check Database Connection Settings:
  
  Go to transaction code DBACOCKPIT or SICF to check the database connection settings.
  Ensure that the database connection is correctly defined and active.
  
  
  
  Maintain Database Connection:
  
  Use transaction code SM30 to access the table/view