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.