Skip to Content
Author's profile photo Greg Myers

The Season for Logs; Yule and otherwise – Part 2

I’ll admit it openly to the SCN community. I’m a geek. On Christmas Morning,
instead of making a real fire in my real wood-burning fireplace, I will instead
search around and find one of many channels on the television that show hours
of footage of the Yule Log and accompanying beautiful Christmas music. It’s so
much easier to apply technology to solve the problem than to build an actual
fire. And my fireplace doesn’t play music. But I digress.

other type of logs that I want to give some holiday cheer to are
BusinessObjects Enterprise trace logs. They may make many shudder and cringe,
but I learned a few things about these logs recently and think the community
could definitely benefit.


use Trace Logs?

will apologize up front if you use other reporting tools, but I presently work
for a Webi only shop, so focus of this will be on WebIntelligence. The
information holds for other tools/services, but individual results may vary.

a BusinessObjects Administrator, I often get asked why reports are “so
slow”. It takes some effort to describe the internal processes of BOE to
developers, managers, and other lay people. How the report request moves from
the web browser, to the BOE server, how it is processed, and how long each step
takes. I won’t cover this in detail here, but know that this information is a
part of what used to be called the BusinessObjects Certified Professional
certification, and is now called SAP Certified Application Associate for
BOE.  At a high level, here is what

  • User logs in to InfoView and clicks on a report
  • If there are prompts, the
    prompt window is returned with it’s List of Values
  • User will select prompts, and
    click Run Query
  • The query will be generated,
    and passed to the source Database
  • Data will be returned to the
    Webi report
  • The report will be rendered
  • The report will be ‘painted’
    on the user’s screen

you can use a web based tool such as HTTPWatch to see what is going on in your
browser window, you will miss much of the behind-the-scenes processing
information. That detail is available in the Trace Logs.

trace turns on verbose logging on your server of choice.  This means that every action taken by the
server (service) is written to a log file. As you can imagine, there is a
definite cost to performance for turning trace on. You also need to watch your
disk space, since these files can grow rapidly, and quickly eat up any free
space you might have.  Cautions aside,
you can learn much from a carefully executed trace.

you start, you create a test plan. It doesn’t need to be intricate, but before
you start you should know what reports you want to investigate and what order
you are going to run them in. You should also, if possible, run this test with
no other users on the system. This will help keep extra clutter out of your
trace logs and make them easier to analyze. One final recommendation I would
make is that if you run multiple Webi servers (like I do) shut all of them down
except one. This way you know for sure which one is handling your request, and
also cuts down on the clutter in the logs.


to Enable Trace

BusinessObjects XI r2, trace is merely a factor of On or Off.  In Windows, you open the CCM tool and edit
the startup string for the server adding the ‘-trace’ switch, and restart the
server. In Non-Windows (Linux or UNIX), you edit the ccm.config file, add the
‘-trace’ switch and restart the server using

log files will go to the default logging folder.

In XI 3.x you have more options. You can set the level of verbosity you want
trace to use, and you can specify a target folder for the logs to be placed in
overriding the default.

set up trace in XI 3.x, first you must create an .ini file.  Open up your favorite text editor, and create
a new file with the following values:

= true;

= xs;

= true;

= ‘E’;

= true;

= 100 * 1000;

Specify your target folder in this line, default_ /BusinessObjects
Enterprise 12.0/logging on WIN32 and /bobje/logging 

example for WINDOWS

example for UNIX 


can choose your level of verbosity in the file by changing the value of the
“importance=” tag.

have the following verbosity options to choose from:

or ‘<<‘    Lowest level (most
verbose option). All details.

or ‘<=’    Low level: at/or above the
low level.

or ‘==’    Normal level: at/or above the
normal level.

or ‘>=’        High level: at/or above
the high level.

or ‘>>’    Highest level (least
verbose option). Highest level.

the file with the following name and extension based on your OS: 

(On Windows)


then place your file where the monitored process resides.


Enteprise 12.0\win32_86


[BusinessObjects install folder]\bobje

one final configuration change. Edit the file in
\BusinessObjects Enterprise
platform]\dataAccess\connectionServer\cs.cfgEach traced activity
will have an tag where the operation starts, and an tag where it
completed along with a duration. The duration timestamp goes down to the

Here is my test
report again, and the entry for how long it took this report to be retrieved
from the FRS:

[Fri Dec 10 19:39:06 2010] 6895 92 trace message: TraceLog:   dg_srm_storeWIQT:RetrieveFromRepo: 0.734

Note this is the
entry, and RetrieveFromRepo is the keyword, and the task took 0.734

Keep walking through
your log and you will see the logical progression of the report generation as
described earlier. The SQL statement will get generated, and you will even see
the SQL Statement before and after the refresh in the log files.  You will find the tag for the refresh,
so you know how long it took BOE to get the data from your database:

[Fri Dec 10 19:42:47 2010] 6895 92 trace message: TraceLog:   C3_RefreshInfo:refresh_info::stream::Refresh: 3:38.882

Mine took 3 minutes,
38.882 seconds

Another important
piece is how long it took to render the page. Applying fonts, determining how
many pages, page breaks, formatting, etc. all takes some time:

[Fri Dec 10 19:43:43 2010] 6895 108 trace message: TraceLog:   repeng:RERender::Render: 40.597

My report took
40.597 seconds to render.


There is much, much
more detail in the trace logs for you to discover. Take your time and go
through them and you can see all of the different pieces involved between that
user request for the report, and the finished product being displayed on the
screen. Keep in mind that many operations happen simultaneously, so keep your eye on the timestamp so you don’t get lost in the flood of information. Use your contemporaneous log from the test run to keep track of where you are in the test process, and you’ll be amazed at what you start learning about your BOE system and where it spends its time. 

Hope you find this
useful, and that your Holidays will be filled with many happy Logs!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Useful stuff, dumbed-down almost enough for me to digest!
      Author's profile photo Susan Keohan
      Susan Keohan
      Even though I am not yet BOBJ-enabled, I enjoy your blogs because they're fun, but packed full of knowledge that someday I hope to apply.
      Keep up the great work!
      Author's profile photo John Clark
      John Clark

      Greg, thanks for this post.  I will try your instructions for getting tracing setup.  There seem to be multiple documents with multiple ways to set up tracing but I haven't been able to get any of them to work as I think they should.

      I have one question.  In your blog you mention editing the cs.cfg file but you don't say what to edit.  Are you saying to turn the Traces option to Yes in this file?

      Author's profile photo Greg Myers
      Greg Myers
      Blog Post Author

      Hi John,

      Wow, this blog post is nearly 2 years old. Some of this info has changed, but some remains relevant. What version of BusinessObjects are you on now that is giving you trouble with enabling trace?

      Author's profile photo John Clark
      John Clark

      Yes, it is old but you never know when it will come back to haunt you.

      We are currently on XI3.1sp5.

      I've tried the instructions from the Admin Guide (which are known to have errors).  I've tried the setup in SAP Note 1335757 and the set up discussed in "Tracing in SAP Business Objects Enterprise XI3.1" by Brian Thomas of SAP but I haven't been able to get anything to work the way I understand that it should be working.

      I ran across this blog post when I set up an RSS feed for you posts and it was downloaded.  I thought I would give it a try also.

      Author's profile photo Greg Myers
      Greg Myers
      Blog Post Author

      Have you also tried adding "-trace" to the end of your server command line in the CMC, then restarting the service? That is the easiest way to get them going on XI 3.1.

      Author's profile photo John Clark
      John Clark

      I've done that but I was hoping for better control than that.  That is the only thing that I've been able to have any success with at all though.  I was hoping you might have some new information.  Thanks for the help.

      Author's profile photo Greg Myers
      Greg Myers
      Blog Post Author

      My only other suggestion would be to try a tool like Splunk.

      There is a free version. It allows you to load in a whole directory of trace log files, and makes them searchable. Much easier than using Notepad one file at a time.

      Author's profile photo John Clark
      John Clark

      Thanks.  I'll give that a try.  It sounds very handy.