7.1.1 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.

This topic provides a sample of the logging information in the 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</FileName>
      <PatternLayout>
        <Pattern>[%d{E  dd/M/yyyy hh:mm:ss}] [CALENDER_MANAGER] [%5p] - %m%n</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>
<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>