2016-08-13

Hi There,

I'm testing LoadRunner for Oracle Application R12.2.5 load testing and keep running into below error and I found JsessionIDForms is not replaced in the first occurance according to replace log but can't find any clue.

Action.c(205): Error: nca_connect_server: cannot communicate with host ovs.monash.net on port 8090

1.This is part of RecordingLog.txt and found JsessionIDForms is fist occured after /forms/frmservlet call

[Web Request (2994:2f60)] "GET /OA_JAVA/oracle/apps/fnd/formsClient/OracleApplications.dat"
[Network Analyzer (2994:2f60)] (Sid: 1) Client -> Server @ : 525 bytes (Service=HTTP)
[Network Analyzer (2994:2f60)] (Sid: 1) Server -> Client : 198 bytes (Service=HTTP)
[Web Request (2994:2f60)] "GET /OA_JAVA/oracle/apps/fnd/jar/fndlist.jar"
[Network Analyzer (2994:2f60)] (Sid: 1) Client -> Server @ : 562 bytes (Service=HTTP)
[Network Analyzer (2994:2f60)] (Sid: 1) Server -> Client : 198 bytes (Service=HTTP)
[Web Request (2994:2f60)] "GET /OA_JAVA/oracle/jinitiator/ProxySettings.class"
[Network Analyzer (2994:2f60)] (Sid: 1) Client -> Server @ : 396 bytes (Service=HTTP)
[Network Analyzer (2994:2f60)] (Sid: 1) Server -> Client : 382 bytes (Service=HTTP)
[Web Request (2994:2f60)] "GET /forms/frmservlet?play=&record=names&lang=US&lookAndFeel=ORACLE&colorScheme=SWAN&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='AMERICAN_AMERICA'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'+FORMS_TZFILE='timezlrg.dat'+FORMS_DATETIME_SERVER_TZ='America%2FChicago'+FORMS_DATETIME_LOCAL_TZ='GMT'&form_params=+config='VIS'+icx_ticket='.lVDnjML3ViVvt1QJ_v6R6Q..'+resp='SYSADMIN%2FSYSTEM_ADMINISTRATOR'+secgrp='STANDARD'+start_func='FND_FNDCPVCM'+other_params=''&encoding=UTF-8&fsst=2.18262283278568450965358732583791582647E38&fsvt=17019084645679200546992425985068087089&acceptLanguage=en-US&ifcmd=startsession"
[Network Analyzer (2994:2f60)] (Sid: 1) Client -> Server @ : 1143 bytes (Service=HTTP)
[Network Analyzer (2994:2f60)] (Sid: 1) Server -> Client : 468 bytes (Service=HTTP)
[Web Request (2994:2f60)] "GET /forms/lservlet;JsessionIDForms=gKeCCZD8Nb2vRg7a9Op_ZIrgLDf0qYVbmjPnGZqRS4DX8hfl1jsu!49832174?ifcmd=getinfo&ifhost=MYPC&ifip=192.168.56.1"
[Network Analyzer (2994:2f60)] (Sid: 1) Client -> Server @ : 611 bytes (Service=HTTP)
[Network Analyzer (2994:2f60)] (Sid: 1) Server -> Client : 287 bytes (Service=HTTP)
[Network Analyzer (2994:2f60)] (Sid: 1) Client -> Server @ : 618 bytes (Service=HTTP)
[Web Request (2994:2f60)] "POST /forms/lservlet;JsessionIDForms=gKeCCZD8Nb2vRg7a9Op_ZIrgLDf0qYVbmjPnGZqRS4DX8hfl1jsu!49832174"

2.This is part of CodeGenerationLog.txt and found that the Server responded with JSessionIDForms in the cookie header after /forms/frmservlet call

****** Request Header For Transaction With Id 366 ******
GET /forms/frmservlet?play=&record=names&lang=US&lookAndFeel=ORACLE&colorScheme=SWAN&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='AMERICAN_AMERICA'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'+FORMS_TZFILE='timezlrg.dat'+FORMS_DATETIME_SERVER_TZ='America%2FChicago'+FORMS_DATETIME_LOCAL_TZ='GMT'&form_params=+config='VIS'+icx_ticket='.lVDnjML3ViVvt1QJ_v6R6Q..'+resp='SYSADMIN%2FSYSTEM_ADMINISTRATOR'+secgrp='STANDARD'+start_func='FND_FNDCPVCM'+other_params=''&encoding=UTF-8&fsst=2.18262283278568450965358732583791582647E38&fsvt=17019084645679200546992425985068087089&acceptLanguage=en-US&ifcmd=startsession HTTP/1.1
Cache-Control: no-cache
Pragma: no-cache
User-Agent: Mozilla/4.0 (Windows 7 6.1) Java/1.8.0_77
Host: xxx.yyy.net:8000
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
Cookie: oracle.uix=0^^GMT+00:00^p; treemenu1=none open; JSESSIONID=usaCCV_p7M4s2I6dQ2Etl0yBK_IRWbEkuDwvKDclkxdLSG_bV1HJ!-2132229040; VIS=bXQlMRDFZW0rpgtkURT9LXfu9O
$$$$$$ Request Header For Transaction With Id 366 Ended $$$$$$

****** Response Header For Transaction With Id 366 ******
HTTP/1.1 200 OK
Date: Sat, 13 Aug 2016 03:54:40 GMT
Server:
Content-Length: 93
X-ORACLE-DMS-ECID: 005EUjpNFPu7i4WFLzvH8A0001dD0000Au
Set-Cookie: JsessionIDForms=gKeCCZD8Nb2vRg7a9Op_ZIrgLDf0qYVbmjPnGZqRS4DX8hfl1jsu!49832174; path=/; HttpOnly
X-Frame-Options: SAMEORIGIN
Keep-Alive: timeout=15
Connection: Keep-Alive
Content-Type: text/plain
Content-Language: en
$$$$$$ Response Header For Transaction With Id 366 Ended $$$$$$

3.Based on the result from #1 and #2, I placed below in the HTTP-based script

web_reg_find("Text=Oracle E-Business Suite R12 ",LAST);
web_reg_save_param("NCAJServSessionId","LB=", "RB=", "Search=Noresource", LAST);
web_reg_save_param_regexp("ParamName=JsessionIDForms","RegExp=JsessionIDForms=(.*?);",SEARCH_FILTERS,"Scope=Headers","IgnoreRedirections=No",LAST);
web_url("runforms.jsp",
"URL=http://xxx.yyy.net:8000/OA_HTML/runforms.jsp?icx_ticket={icx_ticket}&resp_app=SYSADMIN&resp_key=SYSTEM_ADMINISTRATOR&secgrp_key=STANDARD&start_func=FND_FNDCPVCM&other_params=",
"Resource=0",
"RecContentType=text/html",
"Referer=",
"Snapshot=t8.inf",
"Mode=HTML",
EXTRARES,
"URL=../OA_JAVA/oracle/forms/registry/Registry.dat", ENDITEM,
"URL=../OA_JAVA/oracle/apps/fnd/formsClient/OracleApplications.dat", ENDITEM,
"URL=../OA_JAVA/oracle/apps/fnd/jar/fndlist.jar", ENDITEM,
"URL=../forms/frmservlet?play=&record=names&lang=US&lookAndFeel=ORACLE&colorScheme=SWAN&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='AMERICAN_AMERICA'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'+FORMS_TZFILE='timezlrg.dat'+FORMS_DATETIME_SERVER_TZ='America%2FChicago'+FORMS_DATETIME_LOCAL_TZ='GMT'&form_params=+config='VIS'+icx_ticket='.{icx_ticket}'+resp='SYSADMIN%2FSYSTEM_ADMINISTRATOR'+secgrp='STANDARD'+start_func='FND_FNDCPVCM'+other_params=''&encoding=UTF-8&fsst=2.18262283278568450965358732583791582647E38&fsvt=17019084645679200546992425985068087089&acceptLanguage=en-US&ifcmd=startsession", ENDITEM,
"URL=../forms/lservlet;JsessionIDForms={JsessionIDForms}?ifcmd=getinfo&ifhost=MYPC&ifip=192.168.56.1", ENDITEM,
"URL=../OA_JAVA/oracle/apps/fnd/jar/fndaolj.jar", ENDITEM,
"URL=../OA_JAVA/oracle/apps/fnd/jar/fndxmlparserv2.jar", ENDITEM,
"URL=../OA_JAVA/oracle/apps/fnd/jar/fndutil.jar", ENDITEM,
LAST);

4.However when I replay the script, it seems {JsessionIDForms} is not replaced in the first occurence
This is part of Apache access_log showing {JsessionIDForms} is not replaced

GET /OA_JAVA/oracle/forms/registry/Registry.dat HTTP/1.1" 200 4117
GET /OA_JAVA/oracle/apps/fnd/formsClient/OracleApplications.dat HTTP/1.1" 200 1361
GET /forms/frmservlet?play=&record=names&lang=US&lookAndFeel=ORACLE&colorScheme=SWAN&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='AMERICAN_AMERICA'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'+FORMS_TZFILE='timezlrg.dat'+FORMS_DATETIME_SERVER_TZ='America%2FChicago'+FORMS_DATETIME_LOCAL_TZ='GMT'&form_params=+config='VIS'+icx_ticket='.cf0oURLL12TLJU5WIoG_-g..'+resp='SYSADMIN%2FSYSTEM_ADMINISTRATOR'+secgrp='STANDARD'+start_func='FND_FNDCPVCM'+other_params=''&encoding=UTF-8&fsst=2.18262283278568450965358732583791582647E38&fsvt=17019084645679200546992425985068087089&acceptLanguage=en-US&ifcmd=startsession HTTP/1.1" 200 293
GET /forms/lservlet;JsessionIDForms={JsessionIDForms}?ifcmd=getinfo&ifhost=MYPC&ifip=192.168.56.1 HTTP/1.1" 200 83
GET /OA_JAVA/oracle/apps/fnd/jar/fndaolj.jar HTTP/1.1" 200 536388
GET /OA_JAVA/oracle/apps/fnd/jar/fndutil.jar HTTP/1.1" 200 141990
GET /OA_JAVA/oracle/apps/fnd/jar/fndxmlparserv2.jar HTTP/1.1" 200 1638608
GET /forms/frmservlet?play=&record=names&lang=US&lookAndFeel=ORACLE&colorScheme=SWAN&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='AMERICAN_AMERICA'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'+FORMS_TZFILE='timezlrg.dat'+FORMS_DATETIME_SERVER_TZ='America%2FChicago'+FORMS_DATETIME_LOCAL_TZ='GMT'&form_params=+config='VIS'+icx_ticket='.cf0oURLL12TLJU5WIoG_-g..'+resp='SYSADMIN%2FSYSTEM_ADMINISTRATOR'+secgrp='STANDARD'+start_func='FND_FNDCPVCM'+other_params=''&encoding=UTF-8&fsst=2.29529557332574272210922245776776831487E38 HTTP/1.1" 200 47460

5.Replay log file also shows that {JsessionIDForms} is not reaplced in the first occurence but it was found and saved later on (Line 274354, 274365)

188959 Action.c(181): Downloading resource "http://xxx.yyy.net:8000/forms/frmservlet?play=&record=names&lang=US&lookAndFeel=ORACLE&colorScheme=SWAN&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='AMERICAN_AMERICA'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'+FORMS_TZFILE='timezlrg.dat'+FORMS_DATETIME_SERVER_TZ='America%2FChicago'+FORMS_DATETIME_LOCAL_TZ='GMT'&form_params=+config='VIS'+icx_ticket='.cf0oURLL12TLJU5WIoG_-g..'+resp='SYSADMIN%2FSYSTEM_ADMINISTRATOR'+secgrp='STANDARD'+start_func='FND_FNDCPVCM'+other_params=''&encoding=UTF-8&fsst=2.18262283278568450965358732583791582647E38&fsvt=17019084645679200546992425985068087089&acceptLanguage=en-US&ifcmd=startsession" (specified by argument number 15) [MsgId: MMSG-26577]
188960 Action.c(181): Downloading resource "http://xxx.yyy.net:8000/forms/lservlet;JsessionIDForms={JsessionIDForms}?ifcmd=getinfo&ifhost=MYPC&ifip=192.168.56.1" (specified by argument number 17) [MsgId: MMSG-26577]

274354 Action.c(181): Set-Cookie: JsessionIDForms=XxWCDWIb3NArH4Uhs6OHSJgBc85iCUfNnyWLJtuR2ekD8KWoOAVD!49832174;
274365 Action.c(181): Notify: Saving Parameter "JsessionIDForms = XxWCDWIb3NArH4Uhs6OHSJgBc85iCUfNnyWLJtuR2ekD8KWoOAVD!49832174".

My question is if,

1.Appropriate correlation is being used for JsessionIDForms in the script, IE, web_reg_save_param_regexp("ParamName=JsessionIDForms","RegExp=JsessionIDForms=(.*?);",SEARCH_FILTERS,"Scope=Headers","IgnoreRedirections=No",LAST);

2.The location of the correlation for JsessionIDForms in the script is in right position or order

Any advice or comments would be very much appreciated

Cheers,

Jason

Show more