[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Select Failure (OpenInsight Specific) ====
=== At 14 APR 1998 10:10:04PM Matt Crozier wrote: ===
{{tag>"OpenInsight Specific"}}
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]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."[/i]
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
info@revelation.com
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=970DA3AB3FFD236F852565E7000BE8B2|View this thread on the forum...]]