7.2.2 Log4j2.xml Configuration

In the <OFSAAI Installed Directory>/database/db_tools/log4j2.xml files file, you can modify the default location to where you want to direct logging output for each utility. The entries that you make require a specific format; the file contains instructions and examples of correct formatting.

The following Sample Logging Information in the Log4j2.xml File provides a sample Log4j2.xml file.

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<Appenders>
<RollingFile name="CALENDAR_MANAGER" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/calendar_manager.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/calendar_manager.log</FileN
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [CALENDER_MANAGER] [%5p] - %
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="PURGE_UTIL" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/purge.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/purge.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [PURGE_UTIL] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="BATCH_CONTROL" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/batch_control.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/batch_control.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [BATCH_CONTROL] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="DATA_RETENTION_MANAGER" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/DRM_Utility.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/DRM_Utility.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [DATA_RETENTION_MANAGER]
[%5p] - %m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="TRUNCATE_MANAGER" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/truncate_manager.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/truncate_manager.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [TRUNCATE_MANAGER] [%5p] -
%m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="COMMON_UTILITIES" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/common_utilities.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/common_utilities.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [COMMON_UTILITIES] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
(Continued on next page)
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="EXTRACT" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/extract.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/extract.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [EXTRACT] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="LOAD" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/load.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/load.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [LOAD] [%5p] - %m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="REFRESH_TEMP_TABLE" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/refresh_temp_table.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/refresh_temp_table.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [REFRESH_TEMP_TABLE] [%5p]
-
%m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="RUN_STORED_PROCEDURE" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/run_stored_procedure.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/run_stored_procedure.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [RUN_STORED_PROCEDURE]
[%5p] - %m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="GET_DATASET_QUERY" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/get_dataset_query.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/get_dataset_query.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [GET_DATASET_QUERY] [%5p] -
%m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="DATA_ANALYSIS_TOOL" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/data_analysis_tool.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/data_analysis_tool.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [DATA_ANALYSIS_TOOL] [%5p] -
%m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="DB_BUILDER" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/db_builder.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/db_builder.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [DB_BUILDER] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="ARCHIVE_PDF" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/pdf_archive.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/pdf_archive.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [ARCHIVE_PDF] [%5p] -
%m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="HIGHLIGHT_GENERATOR" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/highlight_generator.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/highlight_generator.log</
FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [HIGHLIGHT_GENERATOR] [%5p]
-
%m%n</Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="HDC" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/hdc.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/hdc.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [HDC] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="REPORT" append="true"
filePattern="@ORION_DB_DBTOOLS_PATH@/logs/report.log">
<FileName>@ORION_DB_DBTOOLS_PATH@/logs/report.log</FileName>
<PatternLayout>
<Pattern>[%d{E dd/M/yyyy hh:mm:ss}] [REPORT] [%5p] - %m%n</
Pattern>
</PatternLayout>
<Policies>
<SizeBasedTriggeringPolicy size="10000kb"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<Console name="stdout" target="SYSTEM_OUT">
<PatternLayout>
<pattern>
[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %c{1} -
%msg%n
</pattern>>
</PatternLayout>
</Console>
</Appenders>
<Loggers>
<Logger name="CALENDAR_MANAGER" level="info"
additivity="false">
<AppenderRef ref="CALENDAR_MANAGER" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="PURGE_UTIL" level="info" additivity="false">
<AppenderRef ref="PURGE_UTIL" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="BATCH_CONTROL" level="info" additivity="false">
<AppenderRef ref="BATCH_CONTROL" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="HDC" level="info" additivity="false">
<AppenderRef ref="HDC" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="HIGHLIGHT_GENERATOR" level="info" additivity="false">
<AppenderRef ref="HIGHLIGHT_GENERATOR" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="DATA_RETENTION_MANAGER" level="info" additivity="false">
<AppenderRef ref="DATA_RETENTION_MANAGER" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="DB_BUILDER" level="info" additivity="false">
<AppenderRef ref="DB_BUILDER" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="DB_BUILDER_SQL" level="info" additivity="false">
<AppenderRef ref="DB_BUILDER" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="EXTRACT" level="info" additivity="false">
<AppenderRef ref="EXTRACT" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="CORRRULEMIGRATIONUTIL_EXTRACT" level="info"
additivity="false">
<AppenderRef ref="EXTRACT" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="CONFIGURATIONMIGRATIONUTIL_EXTRACT" level="info"
additivity="false">
<AppenderRef ref="EXTRACT" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="LOAD" level="info" additivity="false">
<AppenderRef ref="LOAD" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="CORRRULEMIGRATIONUTIL_LOAD" level="info"
additivity="false">
<AppenderRef ref="LOAD" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="CONFIGURATIONMIGRATIONUTIL_LOAD" level="info"
additivity="false">
<AppenderRef ref="LOAD" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="REFRESH_TEMP_TABLE" level="info" additivity="false">
<AppenderRef ref="REFRESH_TEMP_TABLE" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="RUN_STORED_PROCEDURE" level="info"
additivity="false">
<AppenderRef ref="RUN_STORED_PROCEDURE" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="GET_DATASET_QUERY" level="info" additivity="false">
<AppenderRef ref="GET_DATASET_QUERY" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="REPORT" level="info" additivity="false">
<AppenderRef ref="REPORT" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Logger name="DATA_ANALYSIS_TOOL" level="info" additivity="false">
<AppenderRef ref="DATA_ANALYSIS_TOOL" level="trace"/>
<AppenderRef ref="stdout" level="error"/>
</Logger>
<Root level="error">
<AppenderRef ref="stdout"/>
</Root>
</Loggers>
<!-- <root>
<priority value="##PRIORITY##"></priority>
</root> -->
</log4j:configuration>