Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] WF8.201M Passing the fex name to an HTML parameter
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] WF8.201M Passing the fex name to an HTML parameter
 Login/Join
 
Platinum Member
posted
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
I'm not exactly sure what you're doing here.
But, check out the use of the &FOCFEXNAME variable.
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Guru
posted Hide Post
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.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 415 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Guru
posted Hide Post
You could try -MRNOEDIT -INCLUDE ...

But I would be suprised if that helps. Does the -TYPE show a correct filename?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 415 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi,

We had to fully qualify the fex name by including the Full Path for the fex. Like below ...

Old version:

-INCLUDE common_proc

New version:

-INCLUDE IBFS:/WFC/Repository/your_folder/Standard_Reports/common/common_proc.fex

Don't know if this will help, but that works for us.


WebFocus 8.201M, Windows, App Studio
 
Posts: 223 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
his version of WebFocus doesn't seem to like the -INCLUDE &RPT_NAME


Have you tried: -INCLUDE &RPT_NAME.EVAL"?
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1749 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Not quite catching what you mean. Can you send me a quick Car File example? Thanks.


WF 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by Michele Brooks:
...

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


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
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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


  

-MRNOEDIT -INCLUDE WHENCE ss_global_launch_app_ur.fex
? PATH


WF 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
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 = '';
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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...


IBFS:/WFC/Repository/foldername/fexname_parameter.fex


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1749 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 147 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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  


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 147 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Platinum Member
posted Hide Post
If you mean that you want to run any one of the 12 reports, something like this:

-TYPE &RPT_NAME.(report1.fex,report2.fex,report3.fex).
-DEFAULTH &RPT_NAME  = 'report1.fex';
-DEFAULTH &WFFMT     = 'HTML';
-DEFAULTH &SELF_SERV = 'Y';
-MRNOEDIT -INCLUDE fexname_parameter.fex


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 147 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


Make that:
-? &RPT_NAME
? PATH
WHENCE &RPT_NAME
-RUN

-INCLUDE &RPT_NAME


The -RUN ensures the ? PATH and WHENCE commands are completed before the -INCLUDE is encountered.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1749 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Chuck, the message occurs when the report tries to display in IE


WF 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1749 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] WF8.201M Passing the fex name to an HTML parameter

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.