Make a new Emerbackup database and run that script within the Emerbackup
database. This will recreate your database structure in Emerbackup.
Then after it is created, goto Databases > Emerbackup > Tables > Calls and
remove the primary keys.
Once the primary keys are removed, Recreate the primary keys in this
following order
NASIdentifier
NASPort
UserName
AcctSessionID
AcctStatusType
Save that key with the default features.
Then do a transfer of database FROM Emerald Into EmerBackup
After transfer is complete, you Generate SQL Script ONLY for the calls table
with DRI.
Switch to the Emerald Database and DROP your Calls Table. Once that table
is dropped, run the script or Transfer the calls table back over to the
Emerald Database from Emerbackup and your Duplicate rows should disappear.
IMPORTANT: ALWAYS Make a backup before you do anything BIG like this.
Hope this helps.
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Nada Syriani
> Sent: Thursday, February 25, 1999 3:25 AM
> To: emerald@iea-software.com
> Subject: [Emerald] calls table primary key
>
>
> Hello,
>
> I seems that we need to change the primary key of the calls table
> in order not to have duplicate calls. Our primary key is :
> acctsessionid
> nasidentifier
> acctstatustype
>
> Should I change it ?
> I have reported earlier an error like this one and the call was not
> added to the calls table, thus the record will not be duplicated but
> the user will work for free!!!
>
> Did I miss anything here???
>
> Have a nice day,
> Nada.
> MIS Department,
> IncoNet SAL.
>
> 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