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

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

August 14, 2020, 11:43 AM
PHIL1234
[SOLVED] (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SA_ZZZ
Hi,

I am facing an issue but was unable to find solution to it.

Last week, the webfocus site was working great without any issue. On Monday, when I tried to access the same site, I got this error.

I have asked Admin to restart WebFocus server and Front line IIS server. But it did not make any difference.

I checked the other similar questions in this forum such as setting application path correctly. There was no changes done.

What other steps I need to check to make it work again?

(I am new to this.) Suggestions welcomed.


Thanks.

This message has been edited. Last edited by: FP Mod Chuck,


WEBFOCUS - 8202
OS - Windows
Output - PDF, Excel, HTML, txt.
August 14, 2020, 11:49 AM
FP Mod Chuck
Phil

The fex sa_zzz is not found, do you know where it was created (ie in a domain or on the reporting server) You need to see if you can find it. If on the reporting server then have your admin log in directly and search for it under the \ibi\apps directory structure. If it is in a domain then you need to log into the WebFOCUS environment and search for it there. What are you doing that produces this error? Also Apache Tomcat is the application server and you might want them to recycle that as well.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 14, 2020, 12:09 PM
PHIL1234
Thanks Chuck.

Admin have recycle it several times.

Action:
when it is called by the WebFOCUS front end using: /ibi_apps/WFServlet?&IBIAPP_app=Apple&IBIF_focexec=SA_ZZZ&SA_ID=tree%5C1234567890&APP_LOC=http://servername/root/Apple/firstscript.asp

, SA_ZZZ is not found


SA_ZZZ.fex is never moved to new location.

Admin and I can see the file in the location.


Thanks.


WEBFOCUS - 8202
OS - Windows
Output - PDF, Excel, HTML, txt.
August 14, 2020, 01:15 PM
MartinY
Verify that SA_ZZZ.fex is published
Verify security on the fex and on its location


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 14, 2020, 02:38 PM
PHIL1234
Thanks MartinY.

Only if the file is in MRE, they need to be published.

But it is on the Server. So they dont need to be published.

The permission level for that file have both read and execute rights. I believe its enough.

Thanks.


WEBFOCUS - 8202
OS - Windows
Output - PDF, Excel, HTML, txt.
August 14, 2020, 02:43 PM
Tom Flynn
The folder - APPLE - needs to be on the APP PATH


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
August 14, 2020, 02:49 PM
PHIL1234
Thanks Tom.

Yes confirms that it is on the APP PATH.

Thanks.

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


WEBFOCUS - 8202
OS - Windows
Output - PDF, Excel, HTML, txt.
August 18, 2020, 03:29 PM
FP Mod Chuck
Phil

If this is still an issue you should open a case with techsupport. All your answers sound like everything is in place correctly so they will need to help you debug this.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 26, 2020, 11:16 AM
PHIL1234
Thanks everyone for the help and suggestions.

Earlier I had given read and execute rights for that file, it didnt work.

This time I gave "full control" to the file, it works.

Thanks again.


WEBFOCUS - 8202
OS - Windows
Output - PDF, Excel, HTML, txt.