RE: [Emerald] 2.5.2xx Duplicate Records in CallsHistory

Rudy Komsic ( (no email) )
Thu, 25 Feb 1999 04:34:56 -0500

Read my messaage about the Calls Table Primary Key... You can apply the same
technique to fix your problem. Quite simple but a bit time consuming. Need
to do it overnight to reduce downtime.

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Ronnie D. Franklin
> Sent: Thursday, February 25, 1999 12:25 AM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] 2.5.2xx Duplicate Records in CallsHistory
>
>
> I am not doing usage billing.. I simply want to be able to consolidate....
>
> You had me to setup the indexes.. but unfortunally I had tried to
> consolidate prior to that and the consolidation routine wrote about 40
> duplicate records in the CallHistory. I tried to delete the records.. but
> couldn't.. You stated that I would probably have to use a cursor
> to get rid
> of the records.. Those records are preventing me from adding the proper
> indexes to the CallsHistory table.. and thus preventing me from
> consolidating....
>
>
>
> > -----Original Message-----
> > From: emerald-request@iea-software.com
> > [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> > Sent: Wednesday, February 24, 1999 11:14 PM
> > To: emerald@iea-software.com
> > Subject: Re: [Emerald] 2.5.2xx Duplicate Records in CallsHistory
> >
> >
> > "Ronnie D. Franklin" wrote:
> > >
> > > I am still looking for a way to delete the duplicate records
> that are in
> > > CallsHistory..
> >
> > What is your key on your CallHistory table? It needs to be changed
> > for 2.5 when you are doing any usage billing.
> >
> > --
> >
> > 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
> >
>
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>

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