How to enable Debug in BI Publisher

When we develop reports or data models, many times it throws errors and they are not much helpful to find the cause of the error. Enable Debug in BI Publisher helps the developer to find and troubleshoot the cause of Data Model & Report errors.  We are going to set Trace:32 as BI Log level which is the finest level of debug mode. Also, don’t enable debug in a Production environment.

 

TRACE:32 

Very detailed traces or debug information that can help Oracle Support diagnose problems with a particular subsystem.

 

Enable Debug in BI Publisher

 

1. Login into WebLogic Enterprise Manager with your WebLogic username & password. The URL would be http://HOST:PORT/em

2. Expand the Application Deployment, Expand bipublisher, and select bipublisher

On 11G: Right click on the bipublisher, Logs, and Log Configuration; Skip Step 3

 

041017_0300_Howtoenable1 How to enable Debug in BI Publisher

 

3. Select Application Deployments >> Logs >> Log Configuration

 

041017_0300_Howtoenable2 How to enable Debug in BI Publisher

 

4. Search for Oracle.xdo and apply Oracle Diagnostic Logging Level to Trace:32(FINEST). That’s it. We
enabled finest debugging level for BI Publisher. We need to restart the BI Publisher (Admin & Managed Server) for the changes takes effect. After that debug logs will be written to the server logs

 

041017_0300_Howtoenable3 How to enable Debug in BI Publisher

 

Where to see the Log Files and Error Messages of BI Publisher

 

5. On the same window, Click Application Deployments and select view Log Messages

 

041017_0300_Howtoenable4 How to enable Debug in BI Publisher

 

6. This page displays all the error messages. Click on the Target Log Files to see the log file

 

041017_0300_Howtoenable5 How to enable Debug in BI Publisher

 

7. Select the log file and click on View Log File to view on the window and Download to download it

 

041017_0300_Howtoenable6 How to enable Debug in BI Publisher

 

 

Also, Enable Debugging in Data Model 

 

8. Login into XMLPServer, Administrator, Properties under Runtime Configuration and set Enable Data Model Diagnostic to True

 

041217_0127_1 How to enable Debug in BI Publisher

 

Restart the WebLogic Admin & Managed servers.  The Data Model & Report debug logs will be written on the server logs. 

govindan How to enable Debug in BI Publisher
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to enable Debug in BI Publisher
Connect me
By | 2017-04-11T20:34:02+00:00 April 9th, 2017|Categories: OBIEE|Tags: , , |0 Comments
Like us on Facebook.
Connect!