It's all about the answers!

Ask a question

How do I enable extra ETL logging


0
1
Sandy Grewal (1.6k1223) | asked Apr 16 '14, 12:22 p.m.
JAZZ DEVELOPER
edited Jul 14 '14, 1:14 p.m.
How do I enable extra ETL logging to capture information when ETL's fail.

One answer



permanent link
Sandy Grewal (1.6k1223) | answered Apr 16 '14, 12:27 p.m.
JAZZ DEVELOPER
edited Apr 16 '14, 12:30 p.m.
Got the log4j.properties of the application.
It is located in {RTC_install_folder}/server/conf/<application>

Edit the ETL's section, it should look like snippet below.
Reload the log4j file using a web browser:
https://<server_public_url>/<application_context_root>/admin#action=com.ibm.team.repository.admin.reloadLoggingSettings
Click the 'Reload Log Setting' button.
Reproduce the issue.
A file called '<app>-etl-driver.log' will be generated in the folder with the other logs.

log4j.properties file ETL's section after edit:

################################
#            ETL's             #
################################
#Turn off Rational XML JDBC driver logging by default. This is only needed for troubleshooting the ETLs
#log4j.logger.com.ibm.rational.drivers.jdbc.xml=OFF
#log4j.logger.com.ibm.rational.etl=OFF
#Comment the above 2 lines and uncomment the lines below to turn on logging
log4j.logger.com.ibm.rational.drivers.jdbc.xml=INFO, etlDriver
log4j.logger.com.ibm.rational.etl=INFO, etlDriver
log4j.additivity.com.ibm.rational.drivers.jdbc.xml=false
log4j.additivity.com.ibm.rational.etl=false
log4j.appender.etlDriver=org.apache.log4j.RollingFileAppender
log4j.appender.etlDriver.MaxFileSize=10MB
log4j.appender.etlDriver.MaxBackupIndex=5
log4j.appender.etlDriver.File=logs/ccm-etl-driver.log
log4j.appender.etlDriver.layout=org.apache.log4j.PatternLayout
log4j.appender.etlDriver.layout.ConversionPattern=%d{ISO8601} [%30t] %5p %-50.50c - %m%n

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.