BI 4.1 SP6 Load Testing with JMeter

[Former Member]

Hi all, we are using BI 4.1 SP6 version of Business Objects and were planning to use JMeter for load testing. I have gone through this document by James Raap (very useful and nice document) http://scn.sap.com/docs/DOC-45507    .  But , when I record my scripts with JMeter Tool, I am not getting the exact information that this article talks about. for eg:

1) I don't see an option "HTTP Proxy Server, but see "HTTP(s) Test Script Recorder" under Add->Non-Test Elements. I am guessing this could be a JMeter version specific Change and "HTTPS(S) Test Script Record" is latest , we should be using in place of HTTP Proxy. Hope I 'm thinking correctly here

2) Following "Performance Testing in BI 4.1" article mentioned in same document,  I don't get a request "ViewDocument.jsp" to look for "sEntry" string like it talks in this article. I don't see "sEntry" anywhere in the script file (jmx) if I open this in notepad and search. what am I missing? I am trying to browse to a web intelligence document and right click and VIEW and then do a "REFRESH" in the View mode and close the document.

I might find more differences, but for now I am stuck at getting sEntry or Viewdocument.jsp in my request list. Any help you can provide in identifying what's the issue, would be a great help

Thanks

[Former Member · Accepted solution]

An update (additional information).

All the requests that I see while opening a Web intelligence report or refreshing it are URL///.Gateway . I don't get any clear request URL ..

eg:39 /BOE/portal/1601111302/rebean3ws/services/Gateway

Thought this might help anyone looking into this issue

Thanks

[jmsrpp · Accepted solution]

Hi there,

For 1 you are correct ... JMeter has renamed the HTTP Proxy Server to HTTP(s) Test Script Recorder. It works the same way.

For the 2nd problem, what type of Webi report are you using? We just completed a pattern book that covers 4.1 SP6 as a baseline, though all versions of BI 4.1 are similar.

BI Platform 4.x Performance Testing Pattern Book - Business Intelligence (BusinessObjects) - SCN Wik...

Check the section, "Creating Test Plans". If you're still having problems you will need to add a Debug Sampler and View Results Tree to troubleshoot the breakdown.

[Former Member · Accepted solution]

Thank you so much for your response. I am actually able to record the test scripts without any issues, but for some reason my requests are all coming with a same URL when I open and Refresh Webi Reports.

This is what it shows for everything: :39 /BOE/portal/1601111302/rebean3ws/services/Gateway

I couldn't see any string with sEntry. so, not sure if adding Listeners like "View samples in a tree" or "Debug Samples" would help. But I'll try again. Meanwhile, if you think there is some setting I'm missing to get correct URLs, please let me know.

Again, thank you so much and appreciate all your help

[jmsrpp · Accepted solution]

Please double-check the process as outlined in the pattern book document I shared above. This means that the HTTP(s) Test Recorder is only capturing this web service call. Are you possibly using the java panel for this?

[Former Member · Accepted solution]

Do you mean, if I'm using Java Panel to view Web intelligence report instead of HTML, yes. I have gone through the new document you pointed here, and I'm doing the same as per this one.

Any other thoughts?

Thanks

[jmsrpp · Accepted solution]

That's your problem then ... switch to HTML viewer and you should be ok. The Java Panel operates as it's own process and interacts with the platform via the web service calls you identified above. I haven't covered use of this viewer and have no plans to do so. For performance testing purposes, I recommend you use the HTML viewer.

[Former Member · Accepted solution]

Thanks James. that did the trick. I could get the HTTP Requests correctly and can find sEntry strings now. That's great. Also, When I ran this test for 5 sample users (and had a timer for 30 secs for each user after login) I don't see these sessions in the system at all. JMeter 's View results tree shows successful for 5 users, all greens but don't find them on Sessions in CMC..am I again missing something here ?

Thanks

[jmsrpp · Accepted solution]

Make sure you have an HTTP Cookie Manager attached to the test plan and review the response body of the first view logon requests. If the sessions don't increment it means either you didn't get a bttoken or you didn't pass credentials properly.

[Former Member · Accepted solution]

James, I Have HTTP Cookie Manager attached to the Test plan. I am also able to see the users are being picked up properly (in Debug Sampler) and iterating for each user. However, there are no session in CMC

Thanks

[jmsrpp · Accepted solution]

Probably bttoken then ... check the debug sampler in the view results tree component to make sure you are extracting it properly. Use the logon request body to confirm it is enumerating with an actual bttoken value.

[Former Member · Accepted solution]

Thanks James. You are right again. I was missing bttoken value for those users and after fixing it can see these users in CMC Sessions. I guess I am all set now .. Thanks a lot for everything. Also another quick question

(this is mostly on JMeter setup than an SAP BI Issue). I have setup my current thread group in the following manner:

Thread Group:

     Simple Controller:

          Login Controller (Transaction Controller)

          Web intelligence View (Simple Controller)

          web intelligence Refresh (simple controller)

     Logout Controller ( Transaction Controller)

I am trying to

1) get all users to login first

2) run a webi report and refresh

3) wait for 30 seconds

4) then start logging out all users

I have set 30 sec Timer under Logout controller, and when I run this test for 5 users, I see that logout transaction is failing and all the users got stuck in the system (unable to logout). If I remove this timer, they are all logged out properly but it's random. user 1 logins in and then user 2 logs in and before user 3 logs in, user 1 is logged out. I could not see all 5 users in the CMC Sessions before user 1 gets logged out.

Is there any way to achieve this? Sorry this is a very long explanation to read..but thought would give you full picture

again, thanks a ton for helping me out and others