Re: Fw: [Emerald] Invoice problems

Dale E. Reed Jr. ( (no email) )
Wed, 24 Mar 1999 09:46:14 -0800

Ed Miller wrote:
> Any help from IEA-Software? Re-submit this problem. I really need to get
> this fixed. :-)
> This morning I tried to run renewal and was getting a Primary Key error on
> Invoices. I then went to Emerald Admin. and ran the check database and I
> could then generate new invoices.
> Life is good.
> I ran ICVerfy and tried to import the paid invoices back into Emerald and
> got errors on every one. When I go to pay any invoice and I get 'SQL Error
> Couldn't Insert Payment. Account and Invoices Not updated! ' This does not
> make since I have been using 2.5 for months. Did the check database mess
> things up in Emerald?
> What gives?
> Any ideas out there?

The Emerald Admin Check Database only does a consistency
check. Run the checkdb.sql script, which also includes checking
the identities. You probably have an identity problem on your
payments table.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list, including removal,please see