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,

I'm not exactly sure what you're doing here.
But, check out the use of the &FOCFEXNAME variable.

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

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.

You could try -MRNOEDIT -INCLUDE ...

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

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.

quote:

his version of WebFocus doesn't seem to like the -INCLUDE &RPT_NAME

Have you tried: -INCLUDE &RPT_NAME.EVAL"?

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.

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

Not quite catching what you mean. Can you send me a quick Car File example? Thanks.

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,

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

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 = '';

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


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.

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

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





 

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  

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.

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

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.

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.

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.

Michele

Where does this message display? Does it happen with IE and Chrome etc?

I found no hits on techsupport..

Chuck, the message occurs when the report tries to display in IE

Michele

It may be some kind of IE setting but I don't know. You probably should open a case with techsupport.