From: Dale E. Reed Jr. <email@example.com>
To: firstname.lastname@example.org <email@example.com>
Date: Monday, April 27, 1998 3:23 PM
Subject: Re: Call Consolidation Problems
>> James Sandusky wrote:
>> I get this error after running call consolidation for about 12 hours
>> in Emerald. A box pops up saying (Error deleting old records table)
>> OK button.
>> The database has 300mb of space with 130mb free. After trying this a
>> of times it had 0mb free. I then ran the checkdb.sql script against the
>> database and it put me back to 128mb free.
>> Any idea what would cause this? I ran checkdb.sql before I did the call
>> consolidation, also. Another bit of information is that I've never ran
>> consolidation before. I did manually delete all call records for 1997
>> statustype = 1 records. So I'm trying to consolidate around 4 months of
>> activity for 700 users.
>Most likely you are running out of log space. What I would recommend is to
>split your log device. To do this, go into Enterprise Manager and create a
>new Database device that is about 200mb. Call it EmeraldLog. Then edit
>Emerald Database and expand JUST your log segment onto this new database
>This should free up some of your 300mb, but most importantly, you'll be
>to differentiate between the two. I'm guessing if your calls table is
>150mb, you will need that much log space available, which you don't, in
>to delete the call information. There is a DeleteCalls stored procedure
>in Emerald 2.2 that you can manually run to delete the call records (just
>something like "DeleteCalls 2") if the summary portion finished OK.
>Dale E. Reed Jr. (firstname.lastname@example.org)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
> Emerald Mailing List email@example.com