Focal Point
[SOLVED] (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND

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

October 20, 2017, 11:09 AM
Don Garland
[SOLVED] (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND
I've been working and searching on this for a couple of hours and it's time to ask for help.

I have a simple form with a single text box input.

-DEFAULTH &COUNTRY = '_FOC_NULL'


-HTMLFORM BEGIN

	<html>
		<head>

		</head>

		<body>

		<form action="/ibi_apps/WFServlet" method="get">
			<input type="hidden" name="IBIF_ex" value="country_cars.fex">
			Enter the NPI Number (a partial num will return multiple rows): 
			<input type="EDIT" name="COUNTRY" value="">
			<input type="submit">
		</form>

		</body>
	</html>

-HTMLFORM END  



I'd like to enter a number (ex: 10) as the input and then call a pretty simple procedure, passing the parameter.

 -DEFAULT &COUNTRY = '_FOC_NULL'

TABLE FILE CAR
PRINT CAR
BY COUNTRY
WHERE COUNTRY EQ '&COUNTRY'
END
 


Both files are in the same content directory, right off the content root. But, WF can not find the procedure.

How do I help it?

This message has been edited. Last edited by: Don Garland,


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
October 20, 2017, 11:20 AM
FP Mod Chuck
Hi Don

When you run a WFServlet request the way you have it coded, it is looking for the procedures on the reporting server in any app folder in the APP PATH. I think there is a way to run WFServlet pointing to the content area but not sure what the syntax is.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 20, 2017, 11:24 AM
BabakNYC
If the fex is in the repository you can reference it like this:

IBFS:/WFC/Repository/domain_folder_name/country_car.fex


WebFOCUS 8206, Unix, Windows
October 20, 2017, 11:25 AM
j.gross
quote:
form action="/ibi_apps/WFServlet" method="get"
input type="hidden" name="IBIF_ex" value="country_cars.fex"


I believe with that set of execution parameters the reporting server will expect the fex to reside on the server, not in "content" on the client.


- Jack Gross
WF through 8.1.05
October 20, 2017, 11:32 AM
Don Garland
quote:
it is looking for the procedures on the reporting server in any app folder in the APP PATH.


Chuck,

I thought of that and put the fex in a few locations within the app path but it still doesn't find it. Back in 7.65 we used to set a series of variables. That method was given to me by an IBI Prof Serv person at DG and it worked but I can't find documentation that matches that method for 8.09.

My first efforts were to get this to work in HTML Composer. And if the FEX is in the HTML Document, it works and it's fast to put together, but calling an external fex and passing an input variable seems to be more difficult.

NOTE: WF does find the fex if I save it to baseapp. This validates what was suggested but I'm hoping to find a configuration solution to this.

Honestly, a HTML Composer solution would be the best way to get this done. Just like adding a report to an HTML document which does allow me to pass parameters to it (or set them and refresh would be more accurate).

This message has been edited. Last edited by: Don Garland,


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
October 20, 2017, 11:40 AM
FP Mod Chuck
Don

This is just a guess but try taking the .fex off of the end..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 20, 2017, 11:50 AM
Don Garland
quote:
try taking the .fex off of the end


Chuck, appreciate those "get out of the box" thoughts but it didn't fix the problem.

Thank you,


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
October 20, 2017, 12:26 PM
FP Mod Chuck
Don

I took your code as is and ran it in 8.1.05 with a fex in the app folders and it ran just fine. Not sure why it is not working for you.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 20, 2017, 12:35 PM
Don Garland
It does, thanks everyone.


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL