Symptom
You get a HANA alert 51, and a message similar with "There are diagnosis files of size greater than or equal to <'1911.79'> MB. This can indicate a problem with the database.".
If run the queries below in the SYSTEMDB of the affected HANA DB instance,
SELECT * FROM "SYS_DATABASES"."M_TRACEFILES" ORDER BY FILE_SIZE DESC;
SELECT * FROM "SYS"."M_DATABASE";
you can see the largest file is "uaa-audit.log", the size is 2014MB, mostly reached 1.97 GB.
DATABASE_NAME, HOST, FILE_NAME, FILE_SIZE, FILE_MTIME
SYSTEMDB, xxx, uaa-audit.log, 2112479768, 2023-02-03 11:13:08.000000000
SYSTEMDB, xxx, backint_20230202132436.gz, 59324301, 2023-02-02 13:24:44.000000000
SYSTEMDB, xxx, backint_version_delete.log, 59158149, 2023-02-03 10:01:24.000000000
...
Read more...
Environment
- SAP HANA Extended Application Services, Advanced Model version higher than 1.0.144
Product
Keywords
uaa-audit.log, HANA alert 51, there are diagnosis files of size greater than or equal to, this can indicate a problem with the database, AuditLog.File.MaxFiles, AuditLog.File.MaxSizeBytes, bytes, MB, xsuaaserver.ini , KBA , BC-XS-RT , XS Advanced Runtime / XS Controller , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.