Select Failure (OpenInsight Specific)
At 14 APR 1998 10:10:04PM Matt Crozier wrote:
I can't for the life of me work this out! On our main development system (OI3.5) this simple RList statement - RUN RLIST "LIST AUDIT BY AUDITED_FILE", 1 - chugs away for a short time and then reports
"FS111: No more records available."
The AUDIT file is fairly large. Usually this error only happens on the second time the statement is run. I've tried doing a CLEARSELECT before the RList statement to no avail.
What's more, when I log into a slightly older backup version of the system (same OI version) and attach the AUDIT file at the same location, the RList statement works every time I run it. Changing the Sort Path setting has no effect, but I figure there must be something different about the application environment but can't find what.
Any ideas greatly appreciated.
Matt Crozier.
At 15 APR 1998 01:14AM Jeff Blinn wrote:
I can't for the life of me work this out! On our main development system (OI3.5) this simple RList statement - RUN RLIST "LIST AUDIT BY AUDITED_FILE", 1 - chugs away for a short time and then reports: "FS111: No more records available."
Is the 'Audited_File' field indexed?
At 15 APR 1998 05:36PM Matt Crozier wrote:
No, the AUDIT file has no indexes at all. Nor does it have any other MFS' on it.
At 16 APR 1998 08:53AM Cameron Revelation wrote:
Matt,
Can you check the file for GFE's? Is it possible for you to zip and send the file here so we could try to reproduce the problem?
Cameron Purdy