I have a user at a remote site that is getting the message:

"*Fatal Error -36 reading row *"

I can't figure out what -36 refers to. I assume that it refers to an error message but I can't find one with that as the key. Any suggestions?

How the user is getting this message is by running a LIST statement of "LIST INV_KEYWORDS KEYWORD KEYWORD_DESC BY KEYWORD".  If they remove the "BY KEYWORD" then the list works and they don't get the error message.  The KEYWORD column is BTREE indexed and the KEYWORD_DESC is Cross-Ref indexed.  In my testing, I've rebuilt all of the indexes (these two) for this table.  I still get this error message.  I've run a "LIST KEYWORDS DET-SUPP" to see if there are any GFEs and none were found.  The user tells me that they (at their remote site) occasionly gets this error message on other LIST statements but nothing consitant.

I assume that I'm missing an error table or that it's damaged, can anyone tell me which file this message is pointing to so that I can try to recover it? Can anyone give me an idea of what to check or what to do to fix the problem this error is trying to tell me about?

Thank you for your time,

Michael Slack

From the looks of it, it appears to be either a OS error or a Network error. I don't think that there are any error messages in AREV with a negative number.

Don Miller

C3 Inc.

You didn't mention the size of the table. This problem may be caused because the OS cannot create another temporary OS file for sorting the table. Look in the \ directory for a bunch of files starting "ROS" and a file extension like "VF1" or "VF2". The \ directory has a limit to the number of files it can contain, even if the hard drive is not full.

You can safely delete all of those temporary tables if no one is using the system.

Dave

Dave et all ..

That is a distinct possibility. The AREV view files are usually REVnnnnn.VF? You might also want to check for Temporary Sort files in the same subdirectory. The extension is .SF?. In fact, I would look for any filename with the extension .VF? or .SF? and delete them. Make sure nobody's using the system. The negative error code is still an error being returned from DOS (via a network or somesuch).

Don Miller

C3 Inc.

Thanks to both of you for your suggestions.

We have found a few *.VF? and *.SF? files. We are working to delete those files but our remote site is virtually a 24 hour site and we have to coordinate a couple of things before we'll be able to see if that helps us or not.

Can anyone tell me where I would find information on what is the upper limit of the number of files within a directory and/or sub-directory for an AREV 3.12 operating system? If we have an idea of where the limit is then we can keep an eye on it and hopefully avoid a situation like this in the future.

Thanks,

Michael Slack

View this thread on the forum...