Highlighted
Valued Contributor.
Valued Contributor.
684 views

OracleForms Application: LR Controller can't connect to the nca server

Jump to solution

Dear all, yesterday I downloaded the community edition (version 12.60, on a VirtualBox Virtual Machine 8GB RAM, 2 CPUs, Windows 10 OS with all the last updates, run from a Linux Ubuntu Host) in order to perform a POC against an OracleForms application. I was able to record a navigation, to correlate and parameterize it, included a navigation within applet functions. Then I  replayed the script within VUGen, and everything went fine (no errors, the applet was able to connect to the server, and to replay the navigation I recorded). After that I run the same script from within the LR Controller, and I'm getting a connection error. I correlated all the parameters (icx_ticket, JSessionIdForms, oas, etc, etc) but nothing worked, and when the script performs the request:

 

nca_connect_server("(myservername)", "(myserverport)", "module=$FND_TOP/forms/I/FNDSCSGN fndnam=APPS  config='TEST' icx_ticket='.{icx_ticket}' resp='AR/AR_UTENTE_AMM_ATT_MEDICA' secgrp='STANDARD' start_func='AR_ARXCWMAI_QIT' other_params=''::NLS_LANG='ITALIAN_ITALY' FORMS_USER_DATE_FORMAT='DD-MON-RRRR' FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR HH24:MI:SS' NLS_DATE_LANGUAGE='ITALIAN' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS=',.'");

 

it gets always the following error message:

 

OracleFormsInteraction.c(49): Error: Can't find file (myservername)

Moreover, I can't find detailed log files in order to have some more details.

Following an excerpt from my script:

 

	web_reg_save_param_ex(
		"ParamName=oas",
		"LB/IC=oas=",
		"RB/IC=&",
		SEARCH_FILTERS,
		"Scope=Body",
		"RequestUrl=*/OA.jsp*",
		LAST);


	web_url("OA.jsp", 
		"URL=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=http://myserver:myport/OA_HTML/AppsLocalLogin.jsp", 
		"Snapshot=t4.inf", 
		"Mode=HTML", 
		LAST);

	web_url("detachTable.js", 
		"URL=http://myserver:myport/OA_HTML/cabo/oajsLibs/detachTable.js", 
		"Resource=0", 
		"RecContentType=text/plain", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t5.inf", 
		"Mode=HTML", 
		EXTRARES, 
		"Url=../images/skyros/navBarUnderTopTabsBg.gif", "Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		LAST);
	


	web_custom_request("RF.jsp", 
		"URL=http://myserver:myport/OA_HTML/RF.jsp?function_id=MAINMENUREST&security_group_id=0", 
		"Method=POST", 
		"Resource=0", 
		"RecContentType=application/xml", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t6.inf", 
		"Mode=HTML", 
		"EncType=application/xml", 
		"Body=<params><param>RESPLIST</param><param>HOMEPAGE</param></params>", 
		EXTRARES, 
		"Url=../OA_MEDIA/folder_ena.png", "Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		LAST);
	

/*Correlation comment: Automatic rules - Do not change!  
Original value='3iE8sntIVT12lq3cjcYE9Q..' 
Name ='icx_ticket' 
Type ='Rule' 
AppName ='OracleApps' 
RuleName ='gv15'*/
	web_reg_save_param_ex(
		"ParamName=icx_ticket",
		"LB/IC=gv15=",
		"RB/IC=&",
		SEARCH_FILTERS,
		"Scope=Body",
		"RequestUrl=*/RF.jsp*",
		LAST);
/*Correlation comment - Do not change!  Original value='STANDARD' Name ='secgrp_key' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=secgrp_key",
		"RegExp=gv4=(.*?)&gp5",
		SEARCH_FILTERS,
		"Scope=Headers",
		"IgnoreRedirections=No",
		"RequestUrl=*/RF.jsp*",
		LAST);

/*Correlation comment - Do not change!  Original value='AR_ARXCWMAI_QIT' Name ='start_func' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=start_func",
		"RegExp=gv5=(.*?)&gp6",
		SEARCH_FILTERS,
		"Scope=Headers",
		"IgnoreRedirections=No",
		"RequestUrl=*/RF.jsp*",
		LAST);

	web_url("RF.jsp_3", 
//		"URL=http://myserver:myport/OA_HTML/RF.jsp?function_id=1696&resp_id=53038&resp_appl_id=222&security_group_id=0&lang_code=I&oas=i9qpeMCr3BYC3b7XGMbYvw..&formsLink=yes", 
		"URL=http://myserver:myport/OA_HTML/RF.jsp?function_id=1696&resp_id=53038&resp_appl_id=222&security_group_id=0&lang_code=I&oas={oas}&formsLink=yes", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t12.inf", 
		"Mode=HTML", 
		EXTRARES, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndforms.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndewt.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndbalishare.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndaol.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndctx.jar", "Referer=", ENDITEM, 
		LAST);

/*Correlation comment - Do not change!  Original value='3.16777484313662904949100876554212934168E38' Name ='fsst' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=fsst",
		"RegExp=fsst=(.*?)\\\r\\\n",
		SEARCH_FILTERS,
		"Scope=Headers",
		"IgnoreRedirections=No",
		"RequestUrl=*/runforms.jsp*",
		LAST);

/*Correlation comment - Do not change!  Original value='2.71826422805107075855157310187584245472E38' Name ='fsvt' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=fsvt",
		"RegExp=fsvt=(.*?)&\\#38",
		SEARCH_FILTERS,
		"Scope=Body",
		"IgnoreRedirections=Yes",
		"RequestUrl=*/frmservlet*",
		LAST);



	return 0;
}
	web_url("runforms.jsp",
		"URL=http://myserver:myport/OA_HTML/runforms.jsp?icx_ticket={icx_ticket}&resp_app=AR&resp_key=AR_UTENTE_AMM_ATT_MEDICA&secgrp_key={secgrp_key}&start_func={start_func}&other_params=",
		"Resource=0",
		"RecContentType=text/html",
		"Referer=",
		"Snapshot=t13.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=../OA_JAVA/oracle/forms/registry/Registry.dat", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/formsClient/OracleApplications.dat", ENDITEM,
		LAST);

	web_reg_save_param("NCAJServSessionId", 
		"LB=", 
		"RB=", 
		"Search=Noresource", 
		LAST);
	
	web_reg_save_param_regexp("ParamName=JsessionIDForms",
	                          "RegExp=JsessionIDForms=(.*?);",
	                          "Ordinal=1",
	                          SEARCH_FILTERS,
	                          "Scope=All",
	                          LAST);
	web_url("frmservlet",
		"URL=http://myserver:myport/forms/frmservlet?lang=I&colorScheme=OLIVE&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='ITALIAN_ITALY'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='ITALIAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS=',.'&form_params=+config='TEST'+icx_ticket='.{icx_ticket}'+resp='AR%2FAR_UTENTE_AMM_ATT_MEDICA'+secgrp='{secgrp_key}'+start_func='{start_func}'+other_params=''&encoding=ISO-8859-1&fsst={fsst}&fsvt={fsvt}&acceptLanguage=it-IT&ifcmd=startsession",
		"Resource=0",
		"RecContentType=text/plain",
		"Referer=",
		"Snapshot=t14.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=lservlet;JsessionIDForms={JsessionIDForms}?ifcmd=getinfo&ifhost=DESKTOP-FT34OR1&ifip=172.27.5.98", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/jar/fndlist.jar", 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);

	nca_set_connect_opt(INITIAL_DISP_SIZE, 1920, 1008);

	nca_set_connect_opt(FONT_FACE, "dialog");

	nca_set_connect_opt(SCALE_INFO, 8, 18);

	nca_connect_server("myserver", "myport", "module=$FND_TOP/forms/I/FNDSCSGN fndnam=APPS  config='TEST' icx_ticket='.{icx_ticket}' resp='AR/AR_UTENTE_AMM_ATT_MEDICA' secgrp='STANDARD' start_func='AR_ARXCWMAI_QIT' other_params=''::NLS_LANG='ITALIAN_ITALY' FORMS_USER_DATE_FORMAT='DD-MON-RRRR' FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR HH24:MI:SS' NLS_DATE_LANGUAGE='ITALIAN' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS=',.'");

	nca_set_window("...");

	nca_button_press("634");

	nca_set_window("...");

	nca_button_press("562");

	nca_set_window("...");

	nca_win_close("Transazioni");

	nca_set_window("...");

	nca_win_close("...");

	nca_set_window("...");

	nca_menu_select_item("N", "File;Esci da Oracle Applications");

	nca_set_window("Attenzione");

	nca_popup_message_press("Attenzione", "OK");

 

 I'm a complete newbie with LR: am I missing something critical?

Daniele

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Valued Contributor.
Valued Contributor.

Re: OracleForms Application: LR Controller can't connect to the nca server

Jump to solution

Dear all, I newly recorded and parameterized the script (adding a correlation rule for JsessionIdForms), and now everything works!

Following an excerpt of my script which can be useful for someone else:

 

	web_set_max_html_param_len("1024");

/*Correlation comment: Automatic rules - Do not change!  
Original value='2nIT_Izd3WdYY3fWac4uOQ..' 
Name ='icx_ticket' 
Type ='Rule' 
AppName ='OracleApps' 
RuleName ='gv15'*/
	web_reg_save_param_ex(
		"ParamName=icx_ticket",
		"LB/IC=gv15=",
		"RB/IC=&",
		SEARCH_FILTERS,
		"Scope=Body",
		"RequestUrl=*/RF.jsp*",
		LAST);

	web_url("RF.jsp_3", 
		"URL=http://myserver:myport/OA_HTML/RF.jsp?function_id=1696&resp_id=53038&resp_appl_id=222&security_group_id=0&lang_code=I&oas=-XJxVS8XHbe33zV4VJaBZA..&formsLink=yes", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t12.inf", 
		"Mode=HTML", 
		EXTRARES, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndforms.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndewt.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndbalishare.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndaol.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndctx.jar", "Referer=", ENDITEM, 
		LAST);

/*Correlation comment - Do not change!  Original value='3.2544649123596256677970682219257568644E38' Name ='fsst' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=fsst",
		"RegExp=fsst=(.*?)\\\r\\\n",
		SEARCH_FILTERS,
		"Scope=Headers",
		"IgnoreRedirections=No",
		"RequestUrl=*/runforms.jsp*",
		LAST);

/*Correlation comment - Do not change!  Original value='3.32505483108279616805081611074452013955E38' Name ='fsvt' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=fsvt",
		"RegExp=fsvt=(.*?)&\\#38",
		SEARCH_FILTERS,
		"Scope=Body",
		"IgnoreRedirections=Yes",
		"RequestUrl=*/frmservlet*",
		LAST);

	web_url("runforms.jsp",
		"URL=http://myserver:myport/OA_HTML/runforms.jsp?icx_ticket={icx_ticket}&resp_app=AR&resp_key=AR_UTENTE_AMM_ATT_MEDICA&secgrp_key=STANDARD&start_func=AR_ARXCWMAI_QIT&other_params=",
		"Resource=0",
		"RecContentType=text/html",
		"Referer=",
		"Snapshot=t13.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=../OA_JAVA/oracle/forms/registry/Registry.dat", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/formsClient/OracleApplications.dat", ENDITEM,
		LAST);

	web_reg_save_param("NCAJServSessionId", 
		"LB=", 
		"RB=", 
		"Search=Noresource", 
		LAST);

	web_url("frmservlet",
		"URL=http://myserver:myport/forms/frmservlet?lang=I&colorScheme=OLIVE&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='ITALIAN_ITALY'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='ITALIAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS=',.'&form_params=+config='TEST'+icx_ticket='.{icx_ticket}'+resp='AR%2FAR_UTENTE_AMM_ATT_MEDICA'+secgrp='STANDARD'+start_func='AR_ARXCWMAI_QIT'+other_params=''&encoding=ISO-8859-1&fsst={fsst}&fsvt={fsvt}&acceptLanguage=it-IT&ifcmd=startsession",
		"Resource=0",
		"RecContentType=text/plain",
		"Referer=",
		"Snapshot=t14.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=lservlet;JsessionIDForms=xf7ygW96_OI7x3IPFY3jwYTRVgj1DW-CLb-TSFtGgEN_Gx7g-iO3!1072158974?ifcmd=getinfo&ifhost=DESKTOP-FT34OR1&ifip=172.27.5.98", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/jar/fndlist.jar", 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);

	nca_set_connect_opt(INITIAL_DISP_SIZE, 1920, 1008);

	nca_set_connect_opt(FONT_FACE, "dialog");

	nca_set_connect_opt(SCALE_INFO, 8, 18);

	nca_connect_server("myserver", "myport", "module=$FND_TOP/forms/I/FNDSCSGN fndnam=APPS  config='TEST' icx_ticket='.{icx_ticket}' resp='AR/AR_UTENTE_AMM_ATT_MEDICA' secgrp='STANDARD' start_func='AR_ARXCWMAI_QIT' other_params=''::NLS_LANG='ITALIAN_ITALY' FORMS_USER_DATE_FORMAT='DD-MON-RRRR' FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR HH24:MI:SS' NLS_DATE_LANGUAGE='ITALIAN' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS=',.'");

 

There's only one strange thing left: while replaying the script in the VUGen works always fine, in LR Controller I had to schedule an execution with several executions of my navigation, because with just one iteration the nca_connect_server fails always. Instead having several iterations, the probability of having a successful connection increases and several iterations ended successfully.

In runtime settings I increased the number of retries to 10.

 

View solution in original post

4 Replies
Highlighted
Valued Contributor.
Valued Contributor.

Re: OracleForms Application: LR Controller can't connect to the nca server

Jump to solution

I did a small change, and removed a JSessionIDForms correlation:

Before:

 

web_url("frmservlet",
		"URL=http://myserver:myport/forms/frmservlet?lang=I&colorScheme=OLIVE&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='ITALIAN_ITALY'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='ITALIAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS=',.'&form_params=+config='TEST'+icx_ticket='.{icx_ticket}'+resp='AR%2FAR_UTENTE_AMM_ATT_MEDICA'+secgrp='{secgrp_key}'+start_func='{start_func}'+other_params=''&encoding=ISO-8859-1&fsst={fsst}&fsvt={fsvt}&acceptLanguage=it-IT&ifcmd=startsession",
		"Resource=0",
		"RecContentType=text/plain",
		"Referer=",
		"Snapshot=t14.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=lservlet;JsessionIDForms={JsessionIDForms}?ifcmd=getinfo&ifhost=DESKTOP-FT34OR1&ifip=172.27.5.98", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/jar/fndlist.jar", 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);

 

 

After:

web_url("frmservlet",
		"URL=http://myserver:myport/forms/frmservlet?lang=I&colorScheme=OLIVE&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='ITALIAN_ITALY'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='ITALIAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS=',.'&form_params=+config='TEST'+icx_ticket='.{icx_ticket}'+resp='AR%2FAR_UTENTE_AMM_ATT_MEDICA'+secgrp='{secgrp_key}'+start_func='{start_func}'+other_params=''&encoding=ISO-8859-1&fsst={fsst}&fsvt={fsvt}&acceptLanguage=it-IT&ifcmd=startsession",
		"Resource=0",
		"RecContentType=text/plain",
		"Referer=",
		"Snapshot=t14.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=lservlet;JsessionIDForms=2BPs267yBod33aQ9AhcMLA_x_7xLTcwz_N359CvwJmCYHpSFjN8w!1072158974?ifcmd=getinfo&ifhost=DESKTOP-FT34OR1&ifip=172.27.5.98", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/jar/fndlist.jar", 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);

I simply replaced with the value recorded.

Now the error message is much more clear:

 

OracleFormsInteraction.c(49): Error: nca_connect_server: cannot communicate with host myserver on port myport

 

Again: replaying the script within VUGen goes fine, running it within LoadRunner controller produces the previous error message.

What am I missing?

 

 

0 Likes
Highlighted
Valued Contributor.
Valued Contributor.

Re: OracleForms Application: LR Controller can't connect to the nca server

Jump to solution

Dear all, I newly recorded and parameterized the script (adding a correlation rule for JsessionIdForms), and now everything works!

Following an excerpt of my script which can be useful for someone else:

 

	web_set_max_html_param_len("1024");

/*Correlation comment: Automatic rules - Do not change!  
Original value='2nIT_Izd3WdYY3fWac4uOQ..' 
Name ='icx_ticket' 
Type ='Rule' 
AppName ='OracleApps' 
RuleName ='gv15'*/
	web_reg_save_param_ex(
		"ParamName=icx_ticket",
		"LB/IC=gv15=",
		"RB/IC=&",
		SEARCH_FILTERS,
		"Scope=Body",
		"RequestUrl=*/RF.jsp*",
		LAST);

	web_url("RF.jsp_3", 
		"URL=http://myserver:myport/OA_HTML/RF.jsp?function_id=1696&resp_id=53038&resp_appl_id=222&security_group_id=0&lang_code=I&oas=-XJxVS8XHbe33zV4VJaBZA..&formsLink=yes", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t12.inf", 
		"Mode=HTML", 
		EXTRARES, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndforms.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndewt.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndbalishare.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndaol.jar", "Referer=", ENDITEM, 
		"Url=../OA_JAVA/oracle/apps/fnd/jar/fndctx.jar", "Referer=", ENDITEM, 
		LAST);

/*Correlation comment - Do not change!  Original value='3.2544649123596256677970682219257568644E38' Name ='fsst' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=fsst",
		"RegExp=fsst=(.*?)\\\r\\\n",
		SEARCH_FILTERS,
		"Scope=Headers",
		"IgnoreRedirections=No",
		"RequestUrl=*/runforms.jsp*",
		LAST);

/*Correlation comment - Do not change!  Original value='3.32505483108279616805081611074452013955E38' Name ='fsvt' Type ='ResponseBased'*/
	web_reg_save_param_regexp(
		"ParamName=fsvt",
		"RegExp=fsvt=(.*?)&\\#38",
		SEARCH_FILTERS,
		"Scope=Body",
		"IgnoreRedirections=Yes",
		"RequestUrl=*/frmservlet*",
		LAST);

	web_url("runforms.jsp",
		"URL=http://myserver:myport/OA_HTML/runforms.jsp?icx_ticket={icx_ticket}&resp_app=AR&resp_key=AR_UTENTE_AMM_ATT_MEDICA&secgrp_key=STANDARD&start_func=AR_ARXCWMAI_QIT&other_params=",
		"Resource=0",
		"RecContentType=text/html",
		"Referer=",
		"Snapshot=t13.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=../OA_JAVA/oracle/forms/registry/Registry.dat", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/formsClient/OracleApplications.dat", ENDITEM,
		LAST);

	web_reg_save_param("NCAJServSessionId", 
		"LB=", 
		"RB=", 
		"Search=Noresource", 
		LAST);

	web_url("frmservlet",
		"URL=http://myserver:myport/forms/frmservlet?lang=I&colorScheme=OLIVE&serverApp=OracleApplications&digitSubstitution=CONTEXT&env=NLS_LANG='ITALIAN_ITALY'+FORMS_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR+HH24%3AMI%3ASS'+NLS_DATE_LANGUAGE='ITALIAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS=',.'&form_params=+config='TEST'+icx_ticket='.{icx_ticket}'+resp='AR%2FAR_UTENTE_AMM_ATT_MEDICA'+secgrp='STANDARD'+start_func='AR_ARXCWMAI_QIT'+other_params=''&encoding=ISO-8859-1&fsst={fsst}&fsvt={fsvt}&acceptLanguage=it-IT&ifcmd=startsession",
		"Resource=0",
		"RecContentType=text/plain",
		"Referer=",
		"Snapshot=t14.inf",
		"Mode=HTML",
		EXTRARES,
		"URL=lservlet;JsessionIDForms=xf7ygW96_OI7x3IPFY3jwYTRVgj1DW-CLb-TSFtGgEN_Gx7g-iO3!1072158974?ifcmd=getinfo&ifhost=DESKTOP-FT34OR1&ifip=172.27.5.98", ENDITEM,
		"URL=../OA_JAVA/oracle/apps/fnd/jar/fndlist.jar", 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);

	nca_set_connect_opt(INITIAL_DISP_SIZE, 1920, 1008);

	nca_set_connect_opt(FONT_FACE, "dialog");

	nca_set_connect_opt(SCALE_INFO, 8, 18);

	nca_connect_server("myserver", "myport", "module=$FND_TOP/forms/I/FNDSCSGN fndnam=APPS  config='TEST' icx_ticket='.{icx_ticket}' resp='AR/AR_UTENTE_AMM_ATT_MEDICA' secgrp='STANDARD' start_func='AR_ARXCWMAI_QIT' other_params=''::NLS_LANG='ITALIAN_ITALY' FORMS_USER_DATE_FORMAT='DD-MON-RRRR' FORMS_USER_DATETIME_FORMAT='DD-MON-RRRR HH24:MI:SS' NLS_DATE_LANGUAGE='ITALIAN' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS=',.'");

 

There's only one strange thing left: while replaying the script in the VUGen works always fine, in LR Controller I had to schedule an execution with several executions of my navigation, because with just one iteration the nca_connect_server fails always. Instead having several iterations, the probability of having a successful connection increases and several iterations ended successfully.

In runtime settings I increased the number of retries to 10.

 

View solution in original post

Highlighted
Frequent Contributor.
Frequent Contributor.

Re: OracleForms Application: LR Controller can't connect to the nca server

Jump to solution

Hello Daniele,

Thank you for your post. After reading your post I have one question, how are you getting passed the login step (The first 3 steps from your script)?

When I recorded a script to login to Oracle R12, the Vugen generated almost simillar code like yours. But I am unable to get pass the login step. Below is the custome request being generated and during reply I am unable to get pass this.

 

web_custom_request("AppsLocalLogin.jsp_3",
"URL=http://<Servername>/OA_HTML/AppsLocalLogin.jsp?",
"Method=POST",
"Resource=0",
"RecContentType=text/html; charset=UTF-8",
"Referer=http://<Servername>/OA_HTML/AppsLocalLogin.jsp",
"Snapshot=t3.inf",
"Mode=HTML",
"Body=username=<UserName>&password=<Password>&_lAccessibility=N&displayLangCode=US",
LAST);

When I checked the response, the recording response I am getting as a webservice call. But while reply the same step is generating multiple calls. Do we need to correlate any values before this login step?

Any help in this matter would be much appreciated. Thanks in advance.

After login step, the steps below are identical to your script as below.

	web_reg_save_param_ex(
		"ParamName=oas",
		"LB/IC=oas=",
		"RB/IC=&",
		SEARCH_FILTERS,
		"Scope=Body",
		"RequestUrl=*/OA.jsp*",
		LAST);


	web_url("OA.jsp", 
		"URL=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Resource=0", 
		"RecContentType=text/html", 
		"Referer=http://myserver:myport/OA_HTML/AppsLocalLogin.jsp", 
		"Snapshot=t4.inf", 
		"Mode=HTML", 
		LAST);

	web_url("detachTable.js", 
		"URL=http://myserver:myport/OA_HTML/cabo/oajsLibs/detachTable.js", 
		"Resource=0", 
		"RecContentType=text/plain", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t5.inf", 
		"Mode=HTML", 
		EXTRARES, 
		"Url=../images/skyros/navBarUnderTopTabsBg.gif", "Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		LAST);
	


	web_custom_request("RF.jsp", 
		"URL=http://myserver:myport/OA_HTML/RF.jsp?function_id=MAINMENUREST&security_group_id=0", 
		"Method=POST", 
		"Resource=0", 
		"RecContentType=application/xml", 
		"Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", 
		"Snapshot=t6.inf", 
		"Mode=HTML", 
		"EncType=application/xml", 
		"Body=<params><param>RESPLIST</param><param>HOMEPAGE</param></params>", 
		EXTRARES, 
		"Url=../OA_MEDIA/folder_ena.png", "Referer=http://myserver:myport/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE", ENDITEM, 
		LAST);

 

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Re: OracleForms Application: LR Controller can't connect to the nca server

Jump to solution

Hi Daniele, Can you please help me with my below request. Thank you.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.