Re: [Emerald] Creating New Service

Dale E. Reed Jr. ( (no email) )
Wed, 03 Nov 1999 15:34:21 -0800

Todd Coward wrote:
> We're having a problem creating a new service in Emerald Admin. Getting an
> error message as follows:
> SQL Server Error: 515 Cannot Insert the value NULL into column 'Taxable,'
> table 'Emerald25.dbo Account Types,' column does not allow nulls. INSERT
> FAILS. State = 2, severity = 16
> OK, so I then created a tax item of 6%. But I still get the same error, no
> matter whether I leave the taxable field at "none" or at "6%".
> What's up?

I think that Emerald 2.2 schema had a taxable field on the AccountTypes
table, when it should not have. Just go into Emterprise Manager, drill
down to the AccountTypes table, and add a default value to the taxable
column, value 0, and save the changes. Then you should be fine.


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

For more information about this list (including removal) go to: