Focal Point
[Solved] URL to Run MRE Fex

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

March 06, 2009, 10:11 AM
bbollmann
[Solved] URL to Run MRE Fex
I'd like to run a MRE fex from the browser. It ran one time, but I can't get it to go again. Assuming the domain, folder, fex, user and password are correct, do you see anything wrong with this URL?

http://blis-server-01.com/ibi_...in&IBIMR_pass=george

TIA!
Brian

This message has been edited. Last edited by: bbollmann,


Brian Bollmann
Spartan Light Metal Products
WebFocus 7.6.4 / iSeries / WebSphere
March 06, 2009, 10:41 AM
susannah
Brian, put the whole url in code tags so we can see it.
and what is the error you're getting?
are you seeing the url in the browser window as a result of running the fex, and then trying to refresh it to run again? and it won't obey?
if that's what you're seeeing, yep, i see that same behaviour.
If not, please elaborate.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
March 06, 2009, 10:45 AM
Majid Jeddi
Hi,

Are you getting any error message?
Can you post it?

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
March 06, 2009, 11:38 AM
bbollmann
http://blis-server-01.com/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_domain=slmpprod/slmpprod.htm&IBIMR_folder=#prodrptmeltl&IBIMR_fex=app/prod_rpt_melt_summ_01_01.fex&IBIF_ex=app/prod_rpt_melt_summ_01_01.fex&IBIMR_drill=RUNNID&IBIMR_user=focus&IBIMR_pass=abc


I don't so much get an error; I get a page asking me to log into Managed Reporting with the text below

"Error Running Request.
Cannot execute the request. Please log into Managed Reporting.


Brian Bollmann
Spartan Light Metal Products
WebFocus 7.6.4 / iSeries / WebSphere
March 06, 2009, 12:36 PM
bbollmann
This one prompts for a log in, and after logging in, runs the report

http://blis-server-01.com/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_domain=slmpprod/slmpprod.htm&IBIMR_fex=app/prod_rpt_melt_summ_01_01.fex&IBIMR_drill=RUNNID&IBIMR_user=ifocus&IBIMR_pass=george&IBIMR_folder=#prodrptmeltl  


The only difference is the &IBIMR_folder=... ...is moved to the end!


Brian Bollmann
Spartan Light Metal Products
WebFocus 7.6.4 / iSeries / WebSphere
March 06, 2009, 01:04 PM
susannah
hmm, you're in windows
here's an idea
write yourself a fex that has a drilldown to itself.
send it to yourself in email
open outlook
click ont he drilldown
and see what shows up in the browser.
Do you have security on your system, so that your users have to log in to mre with their MRE id?
folder position shouldn't make a dif.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
March 06, 2009, 02:04 PM
bbollmann
This seems to work:

1. Used IBIC_user and IBIC_pass instead of IBIMR_user and IBIMR_pass
2. I think the # sign in #prodrptmeltl is part of the problem. Nothing worked until I accidentally moved that to the end.
3. Later when I added the parms for the date after the #prodrptmeltl, it didn't notice my parameters. When I moved the parms before the #prodrptmeltl, it picked up the parms just fine.

http://blis-server-01.com/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIC_user=ifocus&IBIC_pass=george&IBIMR_domain=slmpprod/slmpprod.htm&IBIMR_fex=app/prod_rpt_melt_summ_01_01.fex&IBIMR_drill=RUNNID&MMDDYYYY1=02/01/2009&MMDDYYYY2=02/28/2009&IBIMR_folder=#prodrptmeltl  


If anyone wants to explain, feel free!

Thanks all for your help!

===========================================================================

Ok, if I replace the # with %23, I can put the &IBIMR_folder anywhwere I want

Saw that in some posts earlier; guess it meant something -- duh.

This message has been edited. Last edited by: bbollmann,


Brian Bollmann
Spartan Light Metal Products
WebFocus 7.6.4 / iSeries / WebSphere