SAP BI 3rd party java agent integration

[former_member422662]

Hello,

We have some issues with some reports that the end users advised that are taking too long to generate in Business Intelligence ( web intelligence reports, accessed via BI launch pad ).

OS: Windows Server 2008 R2

SAP BusinessObjects BI Platform 4.1 Support Pack 7 Patch 1

Version: 14.1.7.1933

In our infrastructure we have the https://glowroot.org/ application integrated with other products that run sql queries and we are able to identify and optimize these queries.

Glow root is injected using the following statement in the java command line:

-javaagent:path/to/glowroot.jar

I tried to add this in the WebIntelligenceProcessingServer but didn't manage to make it work ( the jar is not loaded ). The SAP BI service account has read & write access over the folder, initially was on the root of the D:\ partition and then I moved it inside the application.

e.g.:

-javaagent "D:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/glowroot/glowroot.jar"

Does anyone knows how I could inject this properly ?

If we make it work, what would be the proper service to inject it into so we see the reports queries statistics ?

If this doesn't work, does SAP BI has any tools that can help us with this investigation ?

Thank you.

[denis_konovalov · Accepted solution]

Webi processing server is C++ app and can't be injected with java app.
BI Platform has built in tools to allow you to investigate why the reports take too long.
The reporting DBs those reports run against have tools to analyze queries being sent.

See Webi User guide and following KBA 1867416.

[ayman_salem]

In CMC, set the log level of "WebIntelligenceProcessingServer" to "high" and refresh the report.

after that, see the glf log file "webiserver_<server>.WebIntelligenceProcessingServer_trace.0000x.glf", and search for your report sql.

....

Be careful when setting the log level, as many very large files are generated. (So, just use it for a very short time, and do not forget to set it to "unspecified" again)

[former_member422662]

Thank you verry much for your feedbak on this.

[former_member422662]

update:

• the glowroot application can only be injected into java applications.
• the webi reports are generated using WIReportServer.exe ( correct me if i'm wrong ) which is a windows application

questions:

• is there a wait to initiate a java sub service under the WIReportServer.exe that would allow us to inject glowroot and capture the data ?
• is there another Java service in BI that we could inject in order to check the queries ?
• does SAP BI has any tools that can help us with the sql queries investigation ?

[former_member11696]

Ayman told you how to enable logging so you can get the SQL for it.

You can also enable DB logging and look for the WEBI server sending the SQL and capture it that way.

There is no option that would enable that JAR to interact with BOE, if it can optimize the SQL being sent then fix it in the Universe being used.

Once you get the SQL use some any third party SQL tool that will allow the Jar to interact with it and then fix the Universe.

Don