FOCEXEC Procedure Not Found When Procedure Copied to Reporting Server

I have a Maintain application that calls Maintain programs and Executes fex procedures. Everything works fine if the application is deployed to the reporting server.

But since their is more than one programmer working on the application, it is painful to deploy all programs together. We can copy our maintain programs to the reporting server by themselves with no problems. We also can copy fex programs that are run as Web links.

The programs that are not found are fex programs that are run from a "EXEC ProgramName" statement in the calling Maintain program.

The message is "(FOC03828) From Server LOOPBACK ==> THE FOCEXEC PROCEDURE CANNOT BE FOUND: ProgramName"

I tried adding the "AT ServerName" after the EXEC ProgramName" but that didn't help.

Kent

Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE

Posts: 63 | Location: Ft. Wayne, IN | Registered: February 20, 2007

GinnyJakes

Expert

posted

Hide Post

Kent,

What directory are the 'not found' programs in? Is this directory in the global application path? If not, can you call them from the MAINTAIN using the directory as a qualifier?

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Show Post

Maintain Wizard

Master

posted

Hide Post

Kent
When Maintain does the deploy to a server it automatically inserts the AT SERVER name for CALLS and EXECs. It takes the server name that you have told Maintain to use; ie the server you are deploying to. Please note that this is also the case with images, javascripts and any other resource files, so be careful if you are just copying files.

Adding the AT SERVER name SHOULD allow Maintain to find the proper files on the server even if they are not deployed. You may need to include the PATH statement as well so Maintain can find the specific procedures:
EXEC proc AT server PATH "path1 path2 ..."

My recommendation is use the deploy tool to deploy some files. Then, look at the deployed files and see exactly what was included in that Maintain file. Use the code from the deployed files in the files you just want to copy over.

Mark

Posts: 663 | Location: New York | Registered: May 08, 2003

Ignored post by Maintain Wizard posted

Show Post

KentO

Gold member

posted

Hide Post

Thanks, Mark!

I just needed to add the PATH to my EXEC statement. Funny that it is not required on the CALL statements.

Kent

Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE

Posts: 63 | Location: Ft. Wayne, IN | Registered: February 20, 2007

Ignored post by KentO posted

Show Post