X

Proactive insights, news and tips from Oracle Fusion Middleware Support. Learn Oracle from Oracle.

Tracing in Oracle Reports 12c

Alexandra David
Principal Technical Support Engineer

Just in case tracing is needed, here is a summary of steps needed to enable Reports Server Engine/Server/Servlet trace in Oracle Reports 12c:

Open the Enterprise Manager console.  
From the WebLogic Domain menu, select "System MBean Browser".

Depending on the type of trace needed, choose the corresponding section below:

 

In-process Reports Server engines Go to "Application Defined MBeans"
Expand "oracle.logging --> Server: WLS_REPORTS --> Application: reports --> LogConfig":
  • Click on "LogConfig" and go to the "Operations" TAB.
  • Click on row #11 "setLoggerLevel" operation.
  • For "loggerName", enter in the Value field "oracle.reports.engine". 
  • For "levelName", enter in the Value field any of the following values: INCIDENT_ERROR:1,         ERROR:1, WARNING:1, NOTIFICATION:1 (This is the default value), NOTIFICATION:16,        TRACE:1, TRACE:16, TRACE:32
  • Click on the "Invoke" button.
In-process Reports Server and Servlet

Go to "Application Defined MBeans"
Expand "oracle.logging --> Server: WLS_REPORTS --> LogRuntime" :

  • Click on "WLS_REPORTS" and go to the "Operations" TAB
  • Click on row #6 "setLoggerLevel" operation.
  • For "loggerName", enter in the Value field "oracle.reports.server" for Reports Server trace or "oracle.reports.servlet" for Reports Servlet trace.
  • For "levelName", enter in the Value field any of the following values: INCIDENT_ERROR:1,  ERROR:1, WARNING:1,
    NOTIFICATION:1 (This is the default value), NOTIFICATION:16, TRACE:1, TRACE:16, TRACE:32
  • Click on the "Invoke" button.
Stand-alone Reports Server and Engine

Go to "Configuration MBeans"
Expand "oracle.logging --> LogConfig" :

  • Click on "[Reports Server Name]" and go to the "Operations" TAB.
  • Click on row #11 "setLoggerLevel" operation.
  • For "loggerName", enter in the Value field "oracle.reports.server" for Reports Server trace or "oracle.reports.engine" for Reports Server Engine trace.
  • For "levelName", enter in the Value field any of the following values: INCIDENT_ERROR:1,  ERROR:1, WARNING:1,
    NOTIFICATION:1 (This is the default value), NOTIFICATION:16, TRACE:1, TRACE:16, TRACE:32
  • Click on the "Invoke" button.

Re-start the Reports Server.

 Log Files Location:

    Reports Servlet trace file: DOMAIN_HOME/servers/WLS_REPORTS/logs/reports/rwservlet_diagnostic.log
    In-process Reports Server trace file:  DOMAIN_HOME/servers/WLS_REPORTS/logs/reports/rwserver_diagnostic.log
    In-process Reports Server Engine file: DOMAIN_HOME/servers/WLS_REPORTS/logs/reports/rwEng-X_diagnostic.log
    Stand-alone Reports Server trace file: DOMAIN_HOME/servers/[Reports Server Name]/logs/reports/rwserver_diagnostic.log
    Stand-alone Reports Server Engine file: DOMAIN_HOME/servers/[Reports Server Name]/logs/reports/rwEng-X_diagnostic.log

More information on this topic can be found in:  Note 2070743.1

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.