What Causes "File Table Exceed Limit" Error?
The message “File Table Exceed Limit” is caused by a programming bug. Elliott reserves an internal table that allows handling of up to 200 open files at the same time. If your particular Elliott application exceeds this limit, then you will get the “File Table Exceed Limit” message.
In any Elliott application, it is just not possible to open more than 200 files at any given moment even if you do a multiple-level drill down. The reason this message can still appear is because one of the Elliott programs has a bug, which causes the program to open a file but does not close it when it is done and exits that program. We call this situation a “file leak.” After the Elliott application calls this program over and over again for a while, the system leaves a lot of open files, and eventually you will exceed the 200 open file limit and see this message. When you get this message, you will be given an opportunity to see a list of open files. If you choose to see it and print out that list, it will help to debug the system. You can send that information to our support staff to help identify the problem. If your program has been customized, you should give this information to your developer and get their involvement for further debugging.
When you get this "File Table Exceed Limit" message and exit Elliott, you typically won't be able to easily duplicate the same problem when you come back into the program again. This is because it will take a while to build the file leak to the point where it exceeds 200 open files.
One utility in Elliott that can help to debug this problem is to use the Ctrl-Shift-O key, which will produce a list of open files. The following is an example of a window that appears when you press Ctrl-Shift-O at the Elliott main menu level. The files in the attached example are open by Elliott's System Manager. But if you see additional files that repeat themselves over and over again (usually at the end of this list), that is a “file leak.” If you can identify the process you perform that causes this list to grow, then it will help us to investigate further why that process/program did not close the file.
Related Articles
What Causes Load Error 198?
Modified Date: 6/7/2019 Q - One of our computers received an error 198 load error randomly. The message looked like the following sample screen: Load error: file "SYCONSEL" error code: 198, pc=0, call=15, seq=0 or Load error: file "SYACTCHK" error ...What Causes Error 166 (Recursive Call) in Elliott?
Release Date: 09/14/2023 Version: 8.5 & Up Q - I received the following error message in Elliott: Execution error: file 'EL850U.LBR\NWSMEVTH' error code: 166, pc=0, call=24, seq=0 If I click "OK," the following window shows up: Btrieve Error 039 on ...What Is the *.^01 File for My PSQL Btrieve Table?
Q - I see in my data folder, for my NOTE table, the corresponding data file is NOTE.BTR. But I also see another file NOTE.^01. See sample screen below. What is that file? Do I need to back up the NOTE.^01 file? A - The PSQL engine can create a ...What Causes Btrieve Error 010 on IMITMFIL (Item File)?
Release Date: 8/8/19 Version: 8.2 & Up Q - We're having the following issue with the IMITMFIL (Item Master File): Received a 010 error. Tried to rebuild using the pervasive utility, but it did not fix the problem. Did a restore from a backup of that ...Btrieve Error 035 on XCOFORM D-Y-O-I Form Table File
Release Date: 03/05/2019 Version: V7.x and up Q - I have created a new Picking Ticket form using DYO. When the users attempt to print a PT, they receive an error message: EL800P: Btrieve Error 035 on XCOFORM D-Y-O-I Form Table File See sample screen ...