RE: Call Consolidation Problems

Ronnie D. Franklin ( )
Mon, 27 Apr 1998 09:53:01 -0500

I had the same problem several times....

I now run the following script Before I do Consolidation.. and have never
had the problem again....

delete radlogs where radlogmsgid > 0
Delete From RadLogs Where DateDiff(Day, LogDate, GetDate()) > 2
Delete From Calls Where AcctStatusType=1
Delete From Calls
Where NOT Exists
(Select Login From SubAccounts
Where SubAccounts.Login = Calls.Username
OR SubAccounts.Shell = Calls.Username
OR SubAccounts.Email = Calls.Username )

I realize that some of the above script probably duplicates what is done in
consolidation and some are not necessary...., but I have not had to "jump
through hoops" to get consolidation to work since I began running it...

BTW.. the script was derived from several suggestions on this list... I
just consolidated them into one!!

On Monday, April 27, 1998 9:43 AM, James Sandusky
[] wrote:
> I get this error after running call consolidation for about 12 hours
straight 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
coupld 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 call
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.
> Any help would be appreciated.
> James Sandusky
> ViaGrafix
> << File: ATT00005.htm >>