Message 2: Re: Email with Emerald
from David Khoury <dave@flex.com.au>
Message 3: unsubscribe
from Mike Cowan <mikec@accnorwalk.com>
Message 4: Cannot Add Subaccounts!
from "Mike Davis" <mkdvs@naxs.com>
Message 5: Re: Cannot Add Subaccounts!
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: Re: Cannot Add Subaccounts!
from "Mike Davis" <mkdvs@naxs.com>
Message 7: Re: Cannot Add Subaccounts!
from "Mike Davis" <mkdvs@naxs.com>
Message 8: RE: Cannot Add Subaccounts!
from David Kerr <dkerr@phonet.com>
Message 9: Re: Cannot Add Subaccounts!
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Email with Emerald
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Mon, 22 Jun 1998 23:55:11 -0700
Chris A. Christopher wrote:
>
> It's 2.1.11
Try installing Emerald 2.2 on a machine and seeing if that will email the
invoices correctly.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Email with EmeraldFrom: David Khoury <dave@flex.com.au>Date: Tue, 23 Jun 1998 17:29:22 +1000
>From: "Dale E. Reed Jr." <daler@iea-software.com>>>Chris A. Christopher wrote:>> >> Yes, the invoice has a charge on it. I voided the original invoice, double>> checked the send methods, and recreated the invoice. I am trying to send>> them individually if that helps.>>I think it also has something to do with the charge, although I>am not positive. I do remember an issue like this. What version>of Emerlad are you using?
We have the occasional problem with e-mail. The solution is to go intothe InvoiceItems table and shorten the description of the charge. As soonas this is complete, the e-mail is sent without any problems.
Delete, then re-create the invoice, but try a shorter description.Hopefully this will work for you. --------------------------------------#------------------------------------ David Khoury | "Where's the KABOOM ?? Technical Manager & Comms Engineer | There was supposed to be an dave@flex.com.au | earth shattering KABOOM!!" http://www.flex.com.au/~dave | Marvin the Martian--------------------------------------#------------------------------------
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribeFrom: Mike Cowan <mikec@accnorwalk.com>Date: Tue, 23 Jun 1998 07:43:53 -0400
unsubscribe
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Cannot Add Subaccounts!From: "Mike Davis" <mkdvs@naxs.com>Date: Tue, 23 Jun 1998 11:45:58 -0400
database went into recover after a reboot, turned flag off per microsoft,database came back. All other functions work fine exept we cannot addsubaccounts. Get "Sql Command Failed". Any ideas on what's going on????Kinda hard to sign up new folks like this.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Cannot Add Subaccounts!From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 23 Jun 1998 10:21:14 -0700
Mike Davis wrote:> > database went into recover after a reboot, turned flag off per microsoft,> database came back. All other functions work fine exept we cannot add> subaccounts. Get "Sql Command Failed". Any ideas on what's going on????> Kinda hard to sign up new folks like this.
In the event of bad crashes like this, I would recommend creating afresh database and using the DB transfer to copy the data into a knownclean database. This may be an identity problem, though. Tryrunning the DBCC CheckIdent(SubAccounts) and see if it correctsthe problem (its one of the lines in the checkdb.sql file).
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Cannot Add Subaccounts!From: "Mike Davis" <mkdvs@naxs.com>Date: Tue, 23 Jun 1998 13:26:21 -0400
dbtransfer??
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Tuesday, June 23, 1998 1:27 PMSubject: Re: Cannot Add Subaccounts!
>Mike Davis wrote:>>>> database went into recover after a reboot, turned flag off per microsoft,>> database came back. All other functions work fine exept we cannot add>> subaccounts. Get "Sql Command Failed". Any ideas on what's going on????>> Kinda hard to sign up new folks like this.>>In the event of bad crashes like this, I would recommend creating a>fresh database and using the DB transfer to copy the data into a known>clean database. This may be an identity problem, though. Try>running the DBCC CheckIdent(SubAccounts) and see if it corrects>the problem (its one of the lines in the checkdb.sql file).>>-->Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Cannot Add Subaccounts!From: "Mike Davis" <mkdvs@naxs.com>Date: Tue, 23 Jun 1998 13:40:13 -0400
checkident fixed. I'm still running sql 6.0 (not by choice). Is the"dbtransfer" you mentioned not an option with 6.0 or is it just a script??
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Tuesday, June 23, 1998 1:27 PMSubject: Re: Cannot Add Subaccounts!
>Mike Davis wrote:>>>> database went into recover after a reboot, turned flag off per microsoft,>> database came back. All other functions work fine exept we cannot add>> subaccounts. Get "Sql Command Failed". Any ideas on what's going on????>> Kinda hard to sign up new folks like this.>>In the event of bad crashes like this, I would recommend creating a>fresh database and using the DB transfer to copy the data into a known>clean database. This may be an identity problem, though. Try>running the DBCC CheckIdent(SubAccounts) and see if it corrects>the problem (its one of the lines in the checkdb.sql file).>>-->Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Cannot Add Subaccounts!From: David Kerr <dkerr@phonet.com>Date: Tue, 23 Jun 1998 12:38:02 -0500
I believe if you just right click on the Emerald database in enterprise manager you'll see the transfer cmd.
On Tuesday, June 23, 1998 12:36 PM, Mike Davis wrote:> checkident fixed. I'm still running sql 6.0 (not by choice). Is the> "dbtransfer" you mentioned not an option with 6.0 or is it just a script??> > > -----Original Message-----> From: Dale E. Reed Jr. <daler@iea-software.com>> To: emerald@iea-software.com <emerald@iea-software.com>> Date: Tuesday, June 23, 1998 1:27 PM> Subject: Re: Cannot Add Subaccounts!> > > >Mike Davis wrote:> >>> >> database went into recover after a reboot, turned flag off per microsoft,> >> database came back. All other functions work fine exept we cannot add> >> subaccounts. Get "Sql Command Failed". Any ideas on what's going on????> >> Kinda hard to sign up new folks like this.> >> >In the event of bad crashes like this, I would recommend creating a> >fresh database and using the DB transfer to copy the data into a known> >clean database. This may be an identity problem, though. Try> >running the DBCC CheckIdent(SubAccounts) and see if it corrects> >the problem (its one of the lines in the checkdb.sql file).> >> >--> >Dale E. Reed Jr. (daler@iea-software.com)> >_________________________________________________________________> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> > Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Cannot Add Subaccounts!From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 23 Jun 1998 12:05:14 -0700
Mike Davis wrote:> > checkident fixed. I'm still running sql 6.0 (not by choice). Is the> "dbtransfer" you mentioned not an option with 6.0 or is it just a script??
Actually, under 6.0, I believe it was its own program called SQLTranfer Manager in the program group. In 6.5, its a part of theEnterprise Manager.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com