How To Fix SMMSS_ALERTS064 - This alert shows the ms/access

SAP Error Message - Details

• Message type: E = Error

• Message class: SMMSS_ALERTS - Message class for MSSQL rz20 messages

• Message number: 064

• Message text: This alert shows the ms/access

What causes this issue?

This alert shows the millisecs per access for each file which makes up
the database. The time is calculated by querrying the system function
::fn_virtualfilestats and dividing the column IoStallMS by the the
total number of reads and writes.

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?

If alerts are displayed for access times more the 10ms / access, then
consider reengineering the i/o system being measured. More disk i/o
could be added, or the file layout changed to achieve better
performance.

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 SMMSS_ALERTS064 - This alert shows the ms/access ?

  The SAP error message SMMSS_ALERTS064 typically relates to issues with the Microsoft Access database or the Microsoft SQL Server database when using SAP systems. This alert indicates that there is a problem with the database connection or configuration that is affecting the SAP system's ability to access or interact with the database.
  Cause:
  
  Database Connection Issues: The SAP system may not be able to connect to the Microsoft Access or SQL Server database due to incorrect connection parameters, such as server name, database name, username, or password.
  Database Configuration: The database may not be configured correctly, or the necessary drivers may not be installed or properly configured.
  Network Issues: There may be network connectivity issues preventing the SAP system from reaching the database server.
  Permissions: The user account being used to connect to the database may not have the necessary permissions to access the database or perform the required operations.
  Database Corruption: The database itself may be corrupted or experiencing issues that prevent it from functioning correctly.
  
  Solution:
  
  Check Connection Parameters: Verify that the connection parameters (server name, database name, username, password) are correct in the SAP configuration.
  Database Configuration: Ensure that the database is properly configured and that the necessary drivers (e.g., ODBC drivers for Access or SQL Server) are installed and configured correctly.
  Test Network Connectivity: Check the network connection between the SAP system and the database server. Use tools like ping or telnet to test connectivity.
  Review User Permissions: Ensure that the user account being used to connect to the database has the necessary permissions to access the database and perform the required operations.
  Check Database Health: If you suspect database corruption, run database repair tools or restore from a backup if necessary.
  Consult Logs: Review the SAP application logs and database logs for any additional error messages or information that can help diagnose the issue.
  
  Related Information:
  
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error message or provide additional troubleshooting steps.
  Documentation: Refer to the official SAP documentation for guidance on configuring database connections and troubleshooting database-related issues.
  Community Forums: Consider reaching out to SAP community forums or support channels for assistance from other users who may have encountered similar issues.
  
  If the problem persists after following these steps, it may be necessary to engage SAP support or a database administrator for further assistance.