Re: [Emerald] Consolidation blues

Richard Sensale ( (no email) )
Thu, 19 Aug 1999 17:52:37 -0400

Hi Dale, I emailed you the info you needed. Shawn had me run his calldump
script to shrink the database. That killed about 80% of our call records,
but as stated, consolidation still will not run. Kurt told me I need to
increase the RAM on our server to 256MB. I was wondering, do you think it
would help- at all if I were to re-run the calldump script and specify 31
days instead of 93 to shrink it even more. We are not concerned about the
call logs since we don't do time based billing anyways and maybe removing
60% of the remaining records might help. Also is it normal for it to be so
slow, I have a 32MB tempdb and am running about 64MB RAM for the database.
-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
Date: Thursday, August 19, 1999 12:51 PM
Subject: Re: [Emerald] Consolidation blues

>Richard Sensale wrote:
>> We have been (unsuccessfully) trying to run a consolidation for about 6
>> months now, we have over 73000 call records. After doing the summary, we
>> click charges and it appears to work for a while then we start getting
>> constant "unable to add item to calls table" errors but a click on OK
>> it continue sort of, after 12 hours last night, it only had processed
>> 3000 calls and then we got an "SQL type mismatch" error and the procedure
>> bombed out the client. We are running 2.5.278 client, our sql is 6.5
>> Any ideas?
>Send me your SQL connection information and I will take a look at it.
>You need to remove the key from the Call History table if you are
>doing time based billing, or you will get the duplicate key error
>you report.
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: