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.
SAP Knowledge Base Article - Preview