Focal Point
Report works but get FOC205 error when in Command Console

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

May 12, 2008, 08:36 AM
Jeff_Rowland
Report works but get FOC205 error when in Command Console
Hi,
I'm a relative newbee to WebFocus. I have a application that I created and am able to create and run reports against the master files in my application. When I go to Command Console to run a query to list the records from one of my tables I get a:
(FOC205) The Description cannot be found from file Named: Act

The syntax I'm using is:

TABLE FILE ACT
PRINT NUMBER
END

The table ACT only has the one field (NUMBER).

I created a report that runs successfully that prints out records from the ACT table but just can't seem to figure out why I'm getting the error in Command Console?


7.7.02 Windows7
HTML/Excel/PDF
May 12, 2008, 08:44 AM
FrankDutch
Is the master description in your application path?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

May 12, 2008, 09:04 AM
Waz
Frank is right.

Which app is your fex in ?

You can use the command
APP SHOWPATH
to list what is currently in the path.

If it is not in the path you can either



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

May 12, 2008, 10:37 AM
Jeff_Rowland
Could you tell me how I can check if
the master description is in my application path


7.7.02 Windows7
HTML/Excel/PDF
May 12, 2008, 10:57 AM
GinnyJakes
Do an APP SHOWPATH assuming that you know what directory your master is in. It is always a good idea to put the APP PREPENDPATH in your program anyway just in case when you run from a browser and the directory in not in the edasprof app path, the program knows where the master is.


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
May 12, 2008, 11:22 AM
Tony A
You should also be able to use WHENCE to tell you where the master file would be used from -

WHENCE CAR MASTER

generally gives -

C:\ibi\apps\ibisamp\car.mas


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
May 12, 2008, 12:07 PM
Darin Lee
Are you talking about the command console in DevStudio? It functions only on the local WF server available to DevStudio, so unless you are doing local development (as opposed to server/MRE development) that server will not have access to file same files. I suspect this is your issue.

If you are talking about the Web console for the WF server, then APP QUERY or APP SHOWPATH should show you the files you have available or use the WHENCE as Tony suggests to tell you the location of the specific MFD you are looking for.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
May 12, 2008, 12:39 PM
Jeff_Rowland
Thanks to all your replies. I was successfull in adding the app to the path and this fixed the problem with getting the FOC205 error.


7.7.02 Windows7
HTML/Excel/PDF