Re: [Emerald] Calls Consolidation Process

Dale E. Reed Jr. ( (no email) )
Fri, 26 Mar 1999 19:24:14 -0800

"Robert H. Clugston" wrote:
>
> List,
> I'm trying to run a consolidation on 24,000 calls and I keep getting:
>
> SQL Error Adding CallHistory Item
>
> It appears to be progressing although its been running for 4 hours and its
> only completed about 35 users. Any ideas?

First, run the instindx.sql script on your database from Emerald
2.5 to make sure you have all the indexes for the calls table.
Secondly, run the latest checkdb.sql script, to make sure the
stats on your indexes are up to date.

The key on the CallHistory table is too restrictive, if you are doing
any usage billing. You can use Enterprise manager to remove the key
and it should allow the records to be inserted correctly. All you
need on the CallHistory table is a duplicates allowed index on the
AccountID (which you should already have).

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com





For more information about this list, including removal,please see http://www.iea-software.com/maillist.html