Re: Error Adding Main Invoice

Will LaSala ( )
Thu, 1 May 1997 12:53:46 -0400

I didn't find any strange characters at all.
They are all just names nothing special.

Does anyone have any other ideas?
It's now time for the CC's to be processed and I can't cuase I can't figure
this out.
Any help would be great.

Will ,,,=^. .^=,,,
* GreenNet========================================*
* "Link Locally ~ Surf Globally" *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225*
From: Josh Hillman <>
Date: Tuesday, April 29, 1997 12:14 PM
Subject: Re: Error Adding Main Invoice

>> When ever I go to create credit card invoices or renewal (I haven't
>> Invoice)
>> I get about half way through the section then it gives me an error
>> "SQL Error Adding Main Invoice"
>> then
>> "Rolling Back Last Invoice"
>I had this problem a few times too...
>Run the batch process one more time and note how many invoices it went
>through before displaying the error.
>It turned out that the problem was caused by some character that was in a
>database field that Emerald uses while processing invoices. I'm not sure
>exactly where it was located, but check for odd-ball characters (such as
>those above the numbers on the keyboard) in the following areas:
>Emerald Admin / config database:
> Service Types (dashes are ok)
> Name
> Description
>Also take a look in the MBRs and Services that are being invoiced and
>for the same types of characters. It's easiest to run a script to look
>the info, such as:
>SELECT * FROM MasterAccounts
>WHERE CreateDate > "Mar 15 1997" (replace the date with the
> approx date of the last
> successful invoice run)
>SELECT * FROM SubAccounts
>WHERE SignDate > "Mar 15 1997" (same as above)
>The reason I specified a date above, is because in my case, the problem
>popped up after I created a new user with an accounttype that no one else
>used, therefor I was able to narrow it down a bit. You don't need to
>specify a date, but if you haven't changed any existing accountypes since
>the last invoice run, then chances are the problem has something to do
>a user or service added since that last run.
>After changing the names or descriptions for whatever was creating the
>problem on my end, I re-batched the invoices. Look at the first x
>that were created, and VOID any that have partial or no data in them -- x
>represents the number of invoices that were starting to be processed
>the original error showed up. After VOIDing these, rerun the batch and
>should only create invoices for those that were just voided. Go through
>them and look for any screwy invoices again. If you don't find any,
>everything should be alright. If you still find a couple bad invoices,
>VOID them again and repeat the process until all new invoices are ok.
>Hope it helps!
>Josh Hillman
> ----------------------------------------------------------
> Emerald Mailing List