How To Fix OC790 - Database error encountered when accessing site control parameters

SAP Error Message - Details

• Message type: E = Error

• Message class: OC - IS-Oil: BDRP Bulk Distribution Requirement Planning messages

• Message number: 790

• Message text: Database error encountered when accessing site control parameters

What causes this issue?

A database access error was encountered when the system tried to load
site control parameters for this customer.

System Response

Processing continues without accessing the site control parameters.

How to fix this error?

Contact your system administrator.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message OC790 - Database error encountered when accessing site control parameters ?

  The SAP error message OC790, which indicates a "Database error encountered when accessing site control parameters," typically arises when there are issues related to database connectivity or integrity when the system is trying to access specific site control parameters in the SAP system.
  Causes:
  
  Database Connectivity Issues: There may be a problem with the connection between the SAP application server and the database server.
  Database Corruption: The database tables that store site control parameters may be corrupted or have integrity issues.
  Missing or Inaccessible Data: The required data for site control parameters may be missing or not accessible due to permission issues.
  Configuration Issues: Incorrect configuration settings in the SAP system or database settings can lead to this error.
  Locking Issues: If the database is locked or if there are long-running transactions, it may prevent access to the required data.
  
  Solutions:
  
  
  Check Database Connectivity:
  
  Ensure that the database server is up and running.
  Verify the connection settings in the SAP system to ensure they are correct.
  
  
  
  Database Integrity Check:
  
  Run database consistency checks to identify and fix any corruption in the database tables.
  Use database tools or transaction codes (like DB02) to check for inconsistencies.
  
  
  
  Review Authorization:
  
  Ensure that the user has the necessary permissions to access the site control parameters.
  Check the roles and authorizations assigned to the user.
  
  
  
  Check for Locks:
  
  Use transaction codes like SM12 to check for any locks on the database tables that might be causing the issue.
  If locks are found, determine if they can be released safely.
  
  
  
  Review Configuration Settings:
  
  Check the configuration settings in the SAP system related to the database and site control parameters.
  Ensure that all necessary parameters are correctly set.
  
  
  
  Consult SAP Notes:
  
  Search for relevant SAP Notes in the SAP Support Portal that may address this specific error message. There may be patches or updates available that resolve the issue.
  
  
  
  Contact SAP Support:
  
  If the issue persists after trying the above solutions, consider reaching out to SAP Support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with transaction codes like DB02 (Database Performance), SM12 (Lock Entries), and ST22 (Dump Analysis) for troubleshooting.
  SAP Notes: Regularly check for updates and patches related to your SAP version that may address known issues.
  System Logs: Review system logs (SM21) for any additional error messages or warnings that may provide more context about the issue.
  
  By following these steps, you should be able to diagnose and resolve the OC790 error in your SAP system.