Re: Call Consolidation Problems

James Sandusky ( )
Wed, 29 Apr 1998 08:26:31 -0500

I did what you suggested and still get the same error. Any other
suggestions. When I run the checkdb.sql against the server it comes up with
hundreds of lines of feedback. It mentions somethings about errors, but I
can't remember what. If it would help I can e-mail you directly the
compelete query return.

James Sandusky

-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
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)
with an
>> 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
and all
>> 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. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List