IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    FOCEXEC Procedure Not Found When Procedure Copied to Reporting Server
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Silver Member
Posted
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


Win2003 Server, WebFOCUS 7.6.0 Developers Studio and MRE
 
Posts: 36 | Location: Ft. Wayne, IN | Registered: February 20, 2007Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
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.6.5 with 7.6.5 WFRS; AIX 5.2; WebSphere 6.1.0.15
Dev: WF 7.6.5 with 7.6.5 WFRS; AIX 5.2; WebSphere 6.1.0.15
Primarily self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable
 
Posts: 1461 | Location: BNSF: Fort Worth, TX | Registered: April 05, 2006Reply With QuoteEdit or Delete MessageReport This Post
Guru
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: 257 | Location: New York | Registered: May 08, 2003Reply With QuoteEdit or Delete MessageReport This Post
Silver 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


Win2003 Server, WebFOCUS 7.6.0 Developers Studio and MRE
 
Posts: 36 | Location: Ft. Wayne, IN | Registered: February 20, 2007Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    FOCEXEC Procedure Not Found When Procedure Copied to Reporting Server

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