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

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message SUSR_DBMS001 - Configuration error; connection missing in customizing ?

  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 for database connections (usually TDBCON).
  Verify that the required database connection is listed and correctly configured.
  
  
  
  Check Customizing Settings:
  
  Use transaction code SPRO to access the SAP Reference IMG.
  Navigate to the relevant section for user management or database settings and ensure that the connection is properly configured.
  
  
  
  Review Transport Requests:
  
  If the issue arose after a transport, check the transport logs to ensure that all necessary objects were transported correctly.
  Re-transport the relevant configuration if needed.
  
  
  
  Authorization Check:
  
  Ensure that the user has the necessary authorizations to access the database connection settings.
  Check the roles and profiles assigned to the user.
  
  
  
  Restart Services:
  
  Sometimes, restarting the SAP services or the application server can help resolve transient issues.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes related to SUSR_DBMS001 for any specific patches or updates that may address this issue.
  Documentation: Review the SAP documentation for user management and database connectivity for additional insights.
  Support: If the issue persists, consider reaching out to SAP Support for further assistance.
  
  By following these steps, you should be able to identify and resolve the configuration error related to the database connection in your SAP system.