Load Runner - stress test for BI java report(WAD 7.0) error

[Former Member]

Dear all:

Our project implement the SAP Portal 7.0(NW2004s, BW/EP SP14) and before we go-live, we use the Load Runner 8.0 to test the performance of SAP BW Java reports.

1. We develop the BI report basing WAD 7.x, setup Iview in sap EP for BI report and get the BI report URL.

2. We fill the report URL in IE(6.0) to run this report and display the bi report successfully ,

eg: http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher?s...

3. Use the LOADRUNNER to make one performance testing for this URL:

1)We record the BI report's URL basing HTML protocal and replay it successfully. But when we run the script with the more than 2 Vusers, there are errors.

2)The record script can only run with 1 Vusers! If we run with 2 or more Vusers, the error display. The error like this:

Action.c(525): Error -26612: HTTP Status-Code=500 (Internal Server Error) for "http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher"

3) We try to use the SAP WEB protocol to test it ,the same error like this:

Action.c(98): Error -26612: HTTP Status-Code=500 (Internal Server Error)for "http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher?sap-bw-iViewID=pcd%3aportal_content%2fcom.ahepc.BI%2fcom.ahepc.iView%2fcom.ahepc.FI%2fcom.ahepc.BI_I_ZWAFI_006&sap-ext-sid=1"

4) Choose one report which no selection variable screen ,the user access the URL and get the result page directly. we can do the test for this type report with more than 10 Vusers using LoadRunner 8.0.

Make analysis with the two type report's script,we found the BI report which have selection variable screen recorded the scripts like this:

web_submit_data("com.sap.ip.bi.web.portal.integration.launcher_4", "Action=http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher",

"Method=POST",

"RecContentType=text/html", "Referer=http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher?sap-bw-iViewID=pcd%3Aportal_content%2Fcom.ncgc.pct.folder.ncbw%2Fcom.ncgc.pct.folder.ncbw.role%2Fcom.ncgc.pct.bw.role.ydjcykhaqgl%2Fzyfx%2FZANCCSM01_Q_101&sap-ext-sid=pAYYK3imMNNJjTjL*mKg4Aggw7o2cRS_TL1fx2I2jeGg&NavPathUpdate=false&buildTree=false", "Snapshot=t21.inf", "Mode=HTMLITEMDATA,

"Name=BI_COMMAND", "Value=", ENDITEM, "Name=BI_COMMAND-TARGET_DIALOG_REF", "Value=DLG_VARIABLE", ENDITEM,

"Name=BI_COMMAND-BI_ADVANCED", "Value=DLG_VARIABLE_vsc_DropdownVariants", ENDITEM,

"Name=BI_COMMAND-BI_COMMAND_TYPE", "Value=PASSIVE_VALUE_TRANSFER", ENDITEM,

"Name=BI_COMMAND-PASSIVE_ID", "Value=DLG_VARIABLE_vsc_DropdownVariants_combobox", ENDITEM,

"Name=BI_COMMAND-PASSIVE_VALUE", "Value=", ENDITEM,

"Name=BI_COMMAND_1", "Value=", ENDITEM, "Name=BI_COMMAND_1-TARGET_DIALOG_REF""Value=DLG_VARIABLE",ENDITEM,

"Name=BI_COMMAND_1-BI_ADVANCED", "Value=DLG_VARIABLE_vsc_CommonVariablesList_VAR_1_INPUT", ENDITEM, "Name=BI_COMMAND_1-BI_COMMAND_TYPE", "Value=PASSIVE_VALUE_TRANSFER", ENDITEM,

"Name=BI_COMMAND_1-PASSIVE_ID", "Value=DLG_VARIABLE_vsc_CommonVariablesList_VAR_1_INPUT_inp", ENDITEM,

"Name=BI_COMMAND_1-PASSIVE_VALUE", "Value=2009.06 - 2009.07", ENDITEM, "Name=BI_COMMAND_2", "Value=", ENDITEM,

"Name=BI_COMMAND_2-TARGET_DIALOG_REF", "Value=DLG_VARIABLE", ENDITEM,

"Name=BI_COMMAND_2-BI_COMMAND_TYPE", "Value=OK", ENDITEM

"Name=PAGE_ID", "Value=1_cEFZWUszaW1NTk5KalRqTCptS2c0QS0tZ2d3N28yY1JTX1RMMWZ4MkkyamVHZy0t", ENDITEM,

"Name=REQUEST_ID", "Value=1", ENDITEM, EXTRARES,

maybe the loadrunner could not compile/replay the BI_COMMAND rows successfully?

For the performance test for the BI java report, have any idea about that error? Or any difference special I should pay attention for BI/EP java report?

Thanks again.

[Former Member]

Have you worded out you problem, I got the same problem, I check the anser, but how can I get my sap-ext-sid.

can you give some advice.

[Former Member]

Thanks ! I also had the problem but could solve with your info.

In my environment, LB is slightly different. I'm not sure the reason but

leave it for reference.

#####

web_reg_save_param("MY_SAP_EXT_SID",

"LB/IC=name=\"sap-ext-sid\" value=\"",

"RB=\"",

"Ord=1",

"RelFrameId=1",

"Notfound=warning",

LAST);

#####

Sekikawa

[Former Member]

Your LB a is a little different because you added the /IC which mean to "Ignore Case" which means whether the left boundary is in small case or upper case, the function will locate it. it is also applicable for the right boundary RB parameter.

[Former Member]

when you use MY_SAP_EXT_SID, I gess it must be paremeter, how can I get the value.

Thank you for your solution.

[Former Member]

Action.c(525): Error -26612: HTTP Status-Code=500 (Internal Server Error) for http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher";

I see that the BI Server is not able to process the request,

What exactly are you looking for? Modification in the script or How to do Stress Testing?

[Former Member]

Dear,

We have exactly the same error. Is this related to loadrunner, or should we dig into the backend logs?

Regards,

Sander Loosveld

[Former Member]

Fowllow below point :

1. the page_id correlation

2. auto-correlation of SAP-ext-id using URL-based script.

You might want to consider to correlate sap-ext-id and page_id. Hope thatu2019s helps.

// Sample code

web_reg_save_param("SAP_EXT_ID",

"LB=sap-ext-sid=",

"RB=\"",

"Ord=2",

"RelFrameId=1",

"Search=body",

LAST);

//Initial value was xxxxx

web_reg_save_param("PAGE_ID",

"LB/IC=sapbi_page.m_pageIdValue = \"",

"RB/IC=\";",

"Ord=1",

"RelFrameId=1",

"Notfound=warning",

LAST);

//End of code

[Former Member]

Action.c(525): Error -26612: HTTP Status-Code=500 (Internal Server Error) for http://epserver:50000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher";

I see that the BI Server is not able to process the request,

What exactly are you looking for? Modification in the script or How to do Stress Testing?

[Former Member]

thanks. yes ,i've tested that,add think time,but the same error.I'm confused with the BI_COMMAND rows,maybe Loadrunner could not play well with that?or any correlation need?

[Former Member]

Or any difference special I should pay attention for BI/EP java report?

I do not know how about BI, but for our EP i can use Load Runner without problem ... But need some time

to understand how it work's correctly, some bug's are present ....

Regards.

[Former Member]

The record script can only run with 1 Vusers! If we run with 2 or more Vusers, the error display.

Try to add the pause --> "Think time" between call's. Regards.