[CLOSED] WF8.201M Passing the fex name to an HTML parameter
I have a self-serve page that was created in an earlier release of WF. I inherited this self-serve app. A fex that lists all of the parameters needed to run the reports was created. Each control's parameter comes from that fex. The parameter fex is referenced in the Load and Run task in Tasks and Animations. The parameter that is binded to a list box that reads a table that has the fex names and display names no longer works. Therefore, the reports do not run. I get the message "FOCEXEC cannot be found." Pasted below are the 2 fexs that show how the fex name (&RPT_NAME) gets passed. I did not show all of the parameters since they are getting passed and work fine. Evidently, the new version of WF 8.201M is not accepting this method of passing the fex name. Thanks.
1) Parameter fex
-DEFAULT &RPT_NAME = '';
-DEFAULT &WFFMT = '';
-DEFAULT &SELF_SERV = 'Y';
-MRNOEDIT -INCLUDE fexname_parameter.fex
2) The include file that has the &RPT_NAME parameter
-DEFAULT &WFFMT='';
-DEFAULT &RPT_NAME = '';
-INCLUDE &RPT_NAME
This message has been edited. Last edited by: FP Mod Chuck,
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 03, 2018, 03:44 PM
Doug
I'm not exactly sure what you're doing here. But, check out the use of the &FOCFEXNAME variable.
February 05, 2018, 08:35 AM
Michele Brooks
quote:
Originally posted by Doug: I'm not exactly sure what you're doing here. But, check out the use of the &FOCFEXNAME variable.
Is this what you mean? -DEFAULT &RPT_NAME = '&FOCFEXNAME';
-INCLUDE &RPT_NAME
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 06, 2018, 07:18 AM
Frans
Check with your browser in your self service page with F12 the request that is being send to WebFOCUS. Do you see a parameter there called RPT_NAME with the right value?
Or just do a
-TYPE Report name: &RPT_NAME
Do you get the foexec not found message based on the first request, or when it tries to include the file?
Not sure what your other requirements are, but if you have the .fex name in the page, then you might as well call the fex directly instead of including it.
Frans, This version of WebFocus doesn't seem to like the -INCLUDE &RPT_NAME. I get the message FOCEXEC cannot be found when WebFocus comes to that -INCLUDE statement in the fex. I need to come up with another way to pass the fex name to the &RPT_NAME parameter that gets binded to a listbox. Thanks.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 07, 2018, 08:05 AM
Frans
You could try -MRNOEDIT -INCLUDE ...
But I would be suprised if that helps. Does the -TYPE show a correct filename?
Don't know if this will help, but that works for us.
WebFocus 8.201M, Windows, App Studio
February 07, 2018, 11:34 AM
Doug
quote:
his version of WebFocus doesn't seem to like the -INCLUDE &RPT_NAME
Have you tried: -INCLUDE &RPT_NAME.EVAL"?
February 07, 2018, 01:23 PM
Michele Brooks
Doug, thanks for the suggestion. I added the .EVAL after the &RPT_NAME, but got this message "(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND:," WF is not passing the &RPT_NAME parameter when it is defined as -DEFAULT &RPT_NAME = ''; When I put a fexname there WF does recognize the fex name. the problem with that is that there are 12 fexnames that need to be considered. I tried using -IF statements so that I can reference all 12 fexes, but with no success. The list box that this parameter is binded to lists 12 reports that will run when the fex display name gets clicked.
I need a way to pass all 12 fex names using the &RPT_NAME parameter. Thanks again.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 07, 2018, 01:48 PM
FP Mod Chuck
Michele
This might be an off the wall suggestion but I have used this in the past to solve other fex to fex parameter passing issues.
You can create a hold file in the foccache directory with the fex names in it and do a -READFILE of the foccache file to get them into the &RPT_NAME
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 07, 2018, 03:50 PM
Michele Brooks
Not quite catching what you mean. Can you send me a quick Car File example? Thanks.
2) The include file that has the &RPT_NAME parameter
-DEFAULT &WFFMT=''; -DEFAULT &RPT_NAME = '';
-INCLUDE &RPT_NAME
Which FOCEXEC is not found -- fexname_parameter.fex [in "-MRNOEDIT -INCLUDE fexname_parameter.fex", which becomes just "-INCLUDE fexname_parameter.fex" in the copy sent to the Reporting Server], or whatever fex &RPT_NAME points to?
I suggest you can throw in "WHENCE fexname_parameter.fex" before the first Include, and "WHENCE &RPT_NAME" before the second; and "? PATH" in both places.This message has been edited. Last edited by: j.gross,
- Jack Gross WF through 8.1.05
February 08, 2018, 10:22 AM
Michele Brooks
quote:
WHENCE
j.gross, the FOCEXEC NOT FOUND occurs in the second -INCLUDE fex (-INCLUDE &RPT_NAME). Is this what you mean when you said to add WHENCE before the -INCLUDE fexname? If so, I'm getting the error message: (FOC224) SYNTAX ERROR: ss_global_launch_app_ur.fex
Does &RPT_NAME include the fully qualified path to the fex? Without it, it will produce that error, can't find it because it doesn't know where to look (Domain/folder,etc.).
quote:
I added the .EVAL after the &RPT_NAME, but got this message "(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND:," WF is not passing the &RPT_NAME parameter when it is defined as -DEFAULT &RPT_NAME = '';
February 08, 2018, 02:41 PM
FP Mod Chuck
Michele
Nevermind my suggestion I played with it and couldn't get the results you are wanting...
Also whence appears to only be a UNIX/LINUX based command and does not work on Windows.
So what we need to know is where exactly is this fex on the reporting server or under the content folder in the WebFOCUS client.
If it on the reporting server Doug is right on you need to do -INCLUDE appfolder/fexname_parameter.fex
where you substitute the name of the appfolder it resides in the syntax above.
If it is in the content area on the WebFOCUS client you will need to locate it and right mouse click on it an choose properties. It will give you the full path to it something like...
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 08, 2018, 02:57 PM
Michele Brooks
Thanks Chuck. I've already done all of that. The problem appears to be the second fex that has the -INCLUDE &RPT_NAME. WF doesn't seem to want to pass that parameter.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 09, 2018, 10:01 AM
dbeagan
This worked for me.
IBFS:/WFC/Repository/Public/Parameter.fex
-----------------------------------------
-DEFAULTH &RPT_NAME = 'report1.fex';
-DEFAULTH &WFFMT = 'HTML';
-DEFAULTH &SELF_SERV = 'Y';
-MRNOEDIT -INCLUDE fexname_parameter.fex
baseapp/fexname_parameter.fex
-----------------------------
-INCLUDE &RPT_NAME
baseapp/report1.fex
-------------------
SET PAGE=NOLEAD,STYLE=WARM
TABLE FILE ibisamp/ggsales
SUM UNITS
BY REGION
ACROSS PCD
END
WebFOCUS 8.2.06
February 09, 2018, 11:36 AM
Michele Brooks
dbeagan, I tried your suggestion and I got the following error. Thanks.
0 ERROR AT OR NEAR LINE 6 IN PROCEDURE ADHOCRQ
(FOC224) SYNTAX ERROR: -
----------v
-MRNOEDIT -INCLUDE baseapp/ss_global_launch_app_ur.fex
This is what my fex files look like
ss_global_launch_content_ur.fex (baseapp Parameter fex)
-* File ss_global_launch_content_ur.fex
-DEFAULTH &RPT_NAME = 'report1.fex';
-DEFAULTH &WFFMT = 'HTML';
-DEFAULTH &SELF_SERV = 'Y';
-MRNOEDIT -INCLUDE baseapp/ss_global_launch_app_ur.fex
ss_global_launch_content_app_ur.fex (baseapp fexname parameter fex)
&RPT_NAME
report1.fex (baseapp report fex)
SET PAGE=NOLEAD,STYLE=WARM
TABLE FILE ibisamp/ggsales
SUM UNITS
BY REGION
ACROSS PCD
END
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 09, 2018, 12:36 PM
dbeagan
Yes so then your fex with the -MRNOEDIT is in an app folder not in a MR Domain. (I know you did say "self-service" in your original problem statement.)
So just remove the -MRNOEDIT so you have:
-INCLUDE baseapp/ss_global_launch_app_ur.fex
WebFOCUS 8.2.06
February 09, 2018, 01:01 PM
Michele Brooks
dbeagan, I used your example as a test and put all 3 fex files in the baseapp folder. In my application I do have the parameter fex in the domain folder so I know to put the -MRNOEDIT back in. The report did run, but how can I get it to run for 12 reports? Thanks.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 09, 2018, 01:34 PM
dbeagan
If you mean that you want to run any one of the 12 reports, something like this:
dbeagan, yes. The &RPT_NAME parameter gets passed to a list box that gets populated with the fex names via an XML file. When the user clicks on the display name in the list box that's associated with the fex name, the correct report needs to run. Thanks.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 09, 2018, 02:27 PM
j.gross
quote:
I suggest you can throw in "WHENCE fexname_parameter.fex" before the first Include, and "WHENCE &RPT_NAME" before the second; and "? PATH" in both places.
The -RUN ensures the ? PATH and WHENCE commands are completed before the -INCLUDE is encountered.
- Jack Gross WF through 8.1.05
February 09, 2018, 04:05 PM
Michele Brooks
dbeagan and j.gross thank you both so much. It appears that I got my self-serve page to run the reports. The correct report runs when I click on the fex display name from the list box. I am now, however, getting an error message once the self-serve page displays that says "Local/EWK-XXXX-X (the Xs are numbers that change each time I run the page. Any ideas. Thanks very, very much.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 09, 2018, 06:10 PM
FP Mod Chuck
Michele
Where does this message display? Does it happen with IE and Chrome etc?
I found no hits on techsupport..
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 13, 2018, 09:57 AM
Michele Brooks
Chuck, the message occurs when the report tries to display in IE
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 13, 2018, 11:09 AM
FP Mod Chuck
Michele
It may be some kind of IE setting but I don't know. You probably should open a case with techsupport.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats