I know my files are in the app path, and the data file contains a record. When I ran the same query through WEBFOCUS Run Ad Adhoc Procedure, it retrieved one record, but it generated 0 record when it ran through a serious procedures including that simple query. It errored out with -Read failed as no records retrieved. What might be the cause of this type of strange issue (I pasted the portion of the code below)?

WHENCE EDABCD FOCUS
WHENCE EDABCD MASTER
? FILE EDABCD
-RUN
\\omawebfocus05\d$\tnt\DBR\DBRDATA\edabcd.foc
\\omawebfocus05\d$\tnt\DBR\DBRDATA\edabcd.mas
0 STATUS OF XFOCUS FILE: \\omawebfocus05\d$\tnt\DBR\DBRDATA\edabcd.foc ON 12/13/2011 AT 10.31.02
0 ACTIVE DELETED DATE OF TIME OF LAST TRANS
SEGNAME COUNT COUNT LAST CHG LAST CHG NUMBER
SEG01 1 07/05/2011 07.17.06 24
SEG02 24 07/05/2011 07.17.06 24
0 TOTAL SEGS 25
TOTAL CHAR 200
TOTAL PAGES 3
LAST CHANGE 07/05/2011 07.17.06 24
TABLE FILE EDABCD
PRINT END_DATE
BY END_DATE
ON TABLE SAVE
END
-RUN
BYPASSING TO END OF COMMAND
-TYPE Number of records retrieved: 0
Number of records retrieved: 0
-READ SAVE &EDATE.A8
0 ERROR AT OR NEAR LINE 33 IN PROCEDURE dbrptpdfcriteria
(FOC339) DIALOGUE MANAGER -READ FAILED: CHECK FILEDEF OR ALLOCATION FOR: -READ
SAVE &EDATE.A8

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

My environment is WF 7.7.03 in Windows Server 2008.

This works in WF 7.6.10 and Windows server 2003.

There may be other issues, too, but I believe release 7.7 requires the ending period after the format for the -READ. Try this:

-READ SAVE &EDATE.A8.

Once we changed ON TABLE HOLD AS HLDC601 FORMAT FOCUS to ON TABLE HOLD AS HLDC601 in the previous query, it started to work. Not sure why FORMAT FOCUS will cause this type of issue.