How To Fix BA517 - Database-based archiving statistics are switched off

SAP Error Message - Details

• Message type: E = Error

• Message class: BA - Data Archiving

• Message number: 517

• Message text: Database-based archiving statistics are switched off

What causes this issue?

If the database-based archiving statistics are switched off, then the
calculation of the statistics is based on the related ABAP dictionary
object type. This means that the length defined in the ABAP dictionary
is used for the calculation. These values can differ from the memory
actually used in the database, especially in the following cases:
Tables that exist on the database in a compressed format (especially
when using SAP HANA).
Tables that contain table fields of variable length (for example, data
types LCHAR, LRAW, STRING, or XSTRING).

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?

Check whether it makes sense to switch on the database-based statistics.
To be able to determine the correct archiving statistics in this way,
the database statistics need to have been generated and they must be
up-to-date. The method for updating statistical information from the
database system depends on the specific database platform.

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 BA517 - Database-based archiving statistics are switched off ?

  The SAP error message BA517 indicates that database-based archiving statistics are switched off in your SAP system. This can prevent the system from collecting and displaying statistics related to archiving processes, which can be important for monitoring and optimizing data management.
  Cause:
  The error occurs when the database-based archiving statistics feature is not enabled in the SAP system. This can happen due to configuration settings or if the necessary parameters are not set correctly.
  Solution:
  To resolve the BA517 error, you need to enable database-based archiving statistics. Here are the steps to do this:
  
  
  Check Configuration Settings:
  
  Go to transaction code SPRO to access the SAP Reference IMG.
  Navigate to the following path: SAP NetWeaver -> Application Server -> Database -> Database-based Archiving.
  Ensure that the settings for archiving statistics are correctly configured.
  
  
  
  Enable Archiving Statistics:
  
  You may need to set the relevant parameters in the database configuration. This can typically be done in the RZ10 transaction (for profile parameters).
  Look for parameters related to archiving statistics, such as dbs/archiving/statistics or similar, and ensure they are set to "1" (enabled).
  
  
  
  Check User Authorizations:
  
  Ensure that the user executing the archiving process has the necessary authorizations to access and modify archiving settings.
  
  
  
  Restart the System:
  
  After making changes to the configuration, it may be necessary to restart the SAP system or the relevant application server for the changes to take effect.
  
  
  
  Test the Configuration:
  
  After enabling the statistics, perform a test archiving operation to verify that the statistics are now being collected and displayed correctly.
  
  
  
  Related Information:
  
  Documentation: Refer to the SAP Help Portal for detailed documentation on database-based archiving and statistics.
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or updates related to this error message.
  Monitoring Tools: Utilize SAP monitoring tools (like ST03N) to analyze performance and ensure that archiving processes are functioning as expected.
  
  If the issue persists after following these steps, consider reaching out to SAP support for further assistance.