You can translate the question and the replies:

Getting default logging levels for each log category

Does Denodo offer a quick way to confirm what were the default logging levels for each category? E.g. if I suspect someone changed a few of them temporarily and forgot to revert them. At the moment we keep a copy of every config file (especially Log4j) from the original installation but this is not very efficient and reliable when comparing many many configs from different files. The ideal would be, when calling GET_ACTIVE_LOGGER(), to have a 3rd column for "Default Value".

3 Answers

Hi, In general, the default log value is set to **ERROR**, and if a log file needs to be reverted to the default logger value, then we can revert it to **ERROR** level. In addition to this, please refer to [Log Categories](https://community.denodo.com/kb/en/view/document/Using%20logcontroller%20and%20useful%20log%20categories#h.jsvoixm25xlx) Knowledge Base article for more information on log levels. If I want to know the changed log levels for the log files, I would use [GET_ACTIVE_LOGGERS()](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_active_loggers) stored procedure which returns information about the log categories that have been set in the Virtual DataPort server. Please note that it is always recommended to revert the logger back to the default log level, i.e) ERROR after performing the tests to debug issues. For more information, please refer to [Configuring the Logging System](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/appendix/configuring_the_logging_engine/configuring_the_logging_engine) section of the Virtual DataPort Administration Guide. If you still need further assistance and if you are a valid support user, you can raise a [Support Case](https://support.denodo.com/cases/add), for further assistance from the Support Team. Hope it helps!
Denodo Team
01-11-2023 04:23:22 -0400
code
> In general, the default log value is set to ERROR Okay thank you. So "in general" means 99% of the time ? How can we know which loggers are not ERROR by default?
user
13-11-2023 15:35:20 -0500
Hi, I would like to clarify that the default log value for most of the loggers in the Virtual Data port are set to **ERROR**. Some of the log categories are set with the default log levels as **INFO** and **FATAL**. For instance, please find the log categories that are set to ``INFO`` and ``FATAL`` by default: ``` com.google.api.client.http.HttpTransport - FATAL com.denodo.tomcat - INFO org.enhydra.jdbc.xapool - FATAL server.start - INFO server.stop - INFO ``` If I need to find the loggers that has been changed, then I would use the [GET_ACTIVE_LOGGERS()](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_active_loggers) stored procedure, which returns information about the log categories that have been set in the Virtual DataPort server, to find the changed log levels and set it back to the default log level i.e) **ERROR**. Also, please note that the log levels ``TRACE`` and ``DEBUG`` would be enabled to log sensitive information like the data retrieved from the data sources etc. Hence, it is recommended to avoid setting the log category **“com.denodo”** to **“DEBUG”** or **“TRACE”** because it will reduce the performance of Virtual DataPort, due to the amount of messages that the logging system will have to store. For further information, please refer [Log Categories](https://community.denodo.com/kb/en/view/document/Using%20logcontroller%20and%20useful%20log%20categories#h.jsvoixm25xlx:~:text=%27%2C%20%27FATAL%27.-,Log%20categories,-The%20log%20categories ) Knowledge Base Article. If you still need further assistance and if you are a valid support user, you can raise a [Support Case](https://support.denodo.com/cases/add), for further assistance from the Support Team. Hope it helps!
Denodo Team
16-11-2023 03:52:59 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here