December 27, 2007, 10:13 AM
<BrianS>ERROR: (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED:
I am receiving the following error, but cannot figure out why. The error is below, followed by the query.
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: ANNUALBILLS
BYPASSING TO END OF COMMAND
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD1
BYPASSING TO END OF COMMAND
-SET &DBDATA='/users/1/nsuser/ibi/webfocus71/ibi_html/publish/cfo';
APP MAP TEMP2 &DBDATA
APP APPENDPATH TEMP2
FILEDEF ANNUALBILLS DISK -
/users/1/nsuser/ibi/webfocus71/ibi_html/publish/cfo/annualbills.csv
-RUN
TABLE FILE ANNUALBILLS
PRINT *
ON TABLE HOLD AS HOLD1
END
TABLE FILE HOLD1
PRINT *
ON TABLE PCHOLD FORMAT EXL2K
END
December 27, 2007, 11:27 AM
PrarieDo You have a Master for annualbills? The reason is obvious why you are getting the error for HOLD1...it is never getting created because annualbills is not being found.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
December 27, 2007, 11:59 AM
<BrianS>Here is the master file for annualbils
FILENAME=ANNUALBILLS, SUFFIX=COM,$
SEGNAME=ANNUALBILLS,$
FIELDNAME=VENDOR_NAME,ALIAS=E1,USAGE=A50,ACTUAL=A50,$
FIELDNAME=BAN,ALIAS=E2,USAGE=A20,ACTUAL=A20,$
FIELDNAME=BILLING_CYCLE,ALIAS=E3,USAGE=A6,ACTUAL=A6,$
FIELDNAME=PYMT_SYSTEM,ALIAS=E4,USAGE=A4,ACTUAL=A4,$
FIELDNAME=INVOICE_DT,ALIAS=E4,USAGE=A10,ACTUAL=A10,$
December 28, 2007, 09:22 AM
cburttYou're using the ... DISK {path} form of FILEDEF, but {path} lacks a drive designation. It looks like a network location. Is this legitimate? I've always referenced a DISK location as 'C:\...' and never had a problem.
WIN/2K running WF 7.6.4
Development via DevStudio 7.6.4, MRE, TextEditor.
Data is Oracle, MS-SQL.
December 28, 2007, 09:26 AM
jgelonaAre you sure the folder where annualbills.mas is located is in the APP PATH?
Also, you don't indicate what platform you're using. If your Reporting Server is UNIX or LINUX, filenames and masters can be case sensitive.
We are LINUX and all .fex, filenames, .mas and .acx files are lower case. For example, the file names annualbills.mas, ANNUALBILLS.MAS or AnnualBills.Mas would all name different files in UNIX or LINUX.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
December 28, 2007, 12:09 PM
Leahquote:
FILEDEF ANNUALBILLS DISK -
/users/1/nsuser/ibi/webfocus71/ibi_html/publish/cfo/annualbills.csv
In your filedef you need to be sure the 'drive' noted is one the application path recognizes. We have similar situations and all of our 'files' are on the 'd:' drive of the server. How is yours defined?
Leah
December 31, 2007, 11:48 AM
Darin Leeall very good suggestions. The main thing to think about is that when you TABLE FILE it is looking for the MAS in the app path. The FILEDEF is irrelevant for now.
An easy way to check this - from the WF Help files:
APP LIST app [HOLD] Lists the applications under approot.
If the HOLD option is used, it lists the applications under approot and writes the output to a temporary file called focappl.ftm, which you can then use in a report request.
APP QUERY app [HOLD] Lists all files in the application.
If the HOLD options is used, it lists all files in the application and writes the output to a temporary file called focappq.ftm, which you can then use in a report request.
If you can see your application folder and MAS file using the above commands, things are good. If not, change your path or move the MAS to a folder in the path.
Second, if the MAS is in the path, but the filedef is incorrect/invalid, you would not get this error. Instaead, it would run but you would get 0 records. If the data file is in a static location, the easiest thing to do is add a DATASET attribute in the MAS file (as described in the documentation.) Then you don't have to worry about doing a FILEDEF every time you need to use the file. The MAS always knows where its data is located.
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
January 11, 2008, 04:45 PM
BradI'd like to introduce a twist to this error. I used the SQL wizard to create a report which runs great before I add parameters. I added a couple parameters to support account # selection, etc using report options and the Where tab. When I run the report, I receive the same error above. The file name is "SQLOUT".
Using Dev Studio 7.62 on Windows XP with Server running on Linux SUSE10.
Thanks
WebFOCUS 7.6.2
Linux