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:

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

[email protected]

View this thread on the forum...