I've had this problem with focus database's in the past. Try purging the logs.

how do I purge the logs?
A search on IBI's site didn't give me much.

Chapter 10 of the "Report Caster Development and Administration" manual (wf761rcadmin.pdf) is entitled "Maintenance Functions for a FOCUS Repository" and it has a section on purging log records.

You can download this manual from the IBI web site. It should contain all that you need for running the log purge which should be done on a routine basis.

Those of us fortunate enough to have a relational repository have the log purged every day for a specified interval, the default being 30 days.

We've got a solution from all of your help.

We set up a reminder in outlook to purge the logs once a month now, reportcaster is running much better and the process to use the GUI to clear the botlog and botlog2 only takes a few minutes each month.

Thanks again!

Why not just set up a job in ReportCaster itself to clean out its own logs files?

We have a procedure cleanlogs.fex in app folder rcaster which contains:

-* File cleanlogs.fex
CREATE FILE rcaster/botlog DROP
-RUN
CREATE FILE rcaster/botlog2 DROP
-RUN

It's scheduled every two weeks and takes care of itself, with a notification to me of successful completion.

Darin,

He is using FOCUS files for his repository and I don't think your code will work as is. Since the files are owned by a sync machine, the sync has to be down in order to do any maintenance on the files.

If you are using relational tables, there is an autolog purge that runs every morning at 1am by default and purges records older than 30 days, also by default.

If you already know this stuff, just ignore the post.