Had a fault call from a client last week, to cut a long story short none of their standard reports were working and we trapped it down to a GFE in SYSLISTS. The Fix GFE utility was run several times and failed on every occassion, CLEAR_TABLE would not work on a System file so in the end had to recover the file from backup. The file overflow is hideously large and will fall over again shortly, advice please!!!

Mike-

If you ever need to clear the file again, try running the command

RUN DELETE_ROW 'SYSLISTS','*'

Many thanks, will pass on to site.

What could we be doing wrong to get such a large file, can OI be configured to time stamp the lists and clear after so long?

Mike-

If you use named lists, be sure to clean them out with Delete_Saved_Select.

You could also write a process/program that would delete temporary list records- starting with a T*, with a certain date, etc.

Here's one I wrote for a client some years ago. I'd usually run it when there was no one else in the system, and run it a number of times, deleting 150 records at a clip.

SUbroutine Clean_Lists(Parent)

Declare Subroutine Rlist
Declare Function Msg, Utility

Open 'SYSLISTS' to f_syslists else
	x=msg('','Unable to open the syslists file')
	return 0
End

DEL_CNT=0

x=Utility('CURSOR','H')
ClearSelect
Rlist('SELECT 150 SYSLISTS STARTING "T*" OR STARTING "W*"  OR STARTING "Q*" ', 5, '', '', '')
if @reccount < 1 then
	x=msg('','No records to clean out')
	Return 0
End


done='
loop
readnext id else done=1
until done
	delete f_syslists, id then
		del_cnt += 1
	end else
		x=msg('','Unable to delete syslists record |':id)
	end
Repeat

x=Utility('CURSOR','A')
x=msg('',del_cnt:' syslist records were deleted.')

Return 0

Hope ot helps.

That's great, thanks!

We've had this a number of times.

At first it can be really hard to track down as you found. Intermittent problems with reports etc.

Usually FIXLH doesn't fix it.

Unless there is anything you want to keep in SYSLISTS, easiest solution is to copy a couple of good REV files over the top of the syslists rev files, then do a clearfile on syslists.

We get this error from time to time, happens mostly after logging off.

We designed a form where we can enter a file name which then clears the file.

As long as you dont store any critical data in there that is the best way to do it.

You dont even have to copy empty files over the top.

Gerry van Niekerk

Csoft

View this thread on the Works forum...