Re: [Emerald] Can't delete MBR

WayneG ( (no email) )
Mon, 28 Jun 1999 16:37:52 -0500

O.K. I deleted all payments and charges and voided all invoices, except one
Charge that causes the same 547 Error listed below when I try to delete it.

-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
Date: Monday, June 28, 1999 2:44 PM
Subject: Re: [Emerald] Can't delete MBR

>WayneG wrote:
>> I get the following errors when trying to delete a certain MBR with ver
>> 2.5.278:
>> SQL Server Error: 547 DELETE statement conflicted with COLUMN REFERENCE
>> constraint 'FK_CallHisto_Charg_471C9436'. The conflict occurred in
>> 'Emerald', table 'CallHistory', column 'ChargeID' State= 2, Severity= 16
>> SQL Server Error: 3621 Command has been aborted. State= 0, Severity= 0
>> Error Deleting Charges Items
>> Also, when trying to VOID an invoice in this account, I get a "Run-time
>> error '13' Type mismatch" and Emerald closes.
>Go into the MBR, and delete any charges from the history list that
>is associated to a usage charge. Then you should be able to
>delete the MBR. This should be fixed in the next update.
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.