Re: [Emerald] Consolidation blues

Dale E. Reed Jr. ( (no email) )
Thu, 19 Aug 1999 09:49:08 -0700

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 makes
> it continue sort of, after 12 hours last night, it only had processed about
> 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 sp5.
> 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: