Re: [Emerald] Consolidation blues

Richard Sensale ( (no email) )
Thu, 19 Aug 1999 11:58:22 -0400

We have not been able to do a consolidation since the upgrade to 2.5 With
the older version we could consolidate but there were other major problems.
Our main problem now is that we have to shrink down that database and I want
everything tidy so I can do a replication to a new backup server.
-----Original Message-----
From: SysOp <>
To: <>
Date: Thursday, August 19, 1999 11:19 AM
Subject: Re: [Emerald] Consolidation blues

>I have a similar problem, but I have been unable to consolidate since
>last January.
>This has not been a big concern until this time, but soon I will
>actually have a need to bill for time.
>Prior to 2.5.278 it would start, but never complete, now it just says
>"File not found"?
>Richard Sensale wrote:
>> Hi
>> 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?
>> Richard Sensale
>For more information about this list (including removal) go to:

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