Focal Point
[SOLVED] calling a fexprocedure from jsp

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3917061336

August 30, 2013, 05:59 AM
TKMAN
[SOLVED] calling a fexprocedure from jsp
hi.

we tried the following code to call a fexprocedure.

quote:
out.println(fileName+" was successfully uploaded as "+ newFileName+FileExt +".

");
//URL hp = new URL("https://someurl.somedoamin.com:myport/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,blablabla/blablabla.htm&IBIF_ex=app/create_user_hold");
URLConnection hpCon = hp.openConnection();
connection.setDoOutput(true) ;


with math.random() at the end of the urlstring and without.

Unfortunately we are getting HTML500 Error and the trace is not realy explaining what the error/soloution might be.

With out the urlcall the jsp is continuing correctly.

Has anyone an idea?

TIA
Marcus

This message has been edited. Last edited by: <Kathryn Henning>,


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output
August 30, 2013, 06:14 AM
linnex
Hi,

I have not tried to launch a WF report / page with JSP yet, but I would try to url-escape the strings after ?var=name you mentioned.

e.g.

 IBIF_ex=app/create_user_hold 


should read

 IBIF_ex=app%2Fcreate_user_hold 


Maybe this will help

Cheers Linne


WebFOCUS 7.7.03
September 01, 2013, 05:28 PM
Waz
If this is MRE, you need to login first.

Can you run the URL in a browser ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

September 04, 2013, 05:55 AM
santu
In your URL you are giving MRE and EDASERVE attributes.Don't mix both.

If you are trying to access the fex procedure from EDASERVE then use below URL's

/ibi_apps/WFServlet?IBIC_server=EDASERVE&IBIF_webapp=/ibi_apps&IBIAPP_app=application_name&IBIF_ex=fexprocedure_name

if you want to access procedure from MRE then use below

/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_fex=fexprocedure_name&IBIMR_folder=foler_name&IBIMR_domain=domain_name


Web FOCUS 7.7.03
PDF
September 09, 2013, 01:12 AM
TKMAN
thx guys for your help. It helped to use the response command from the jsp

response.sendRedirect("https://somedomain.com:myport/ibi_apps/WFServlet?IBIF_webapp=%2Fibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIMR_folder=%23standardm1ta&IBIMR_drill=X,blablabla%2Fblablabla.htm&IBIF_ex=app%2Ferstelle_user_hold.fex");


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output