[Emerald] Time Online

Alexander Blauvelt ( online@olg.com )
Wed, 10 Feb 1999 14:16:05 -0500

Our calls online table seems to be working great, but the individual
info under each sub account on the time online tab doesn't appear to
work. Putting emerald in debug mode and then hitting update returns
the following error.

SQL Server Error: 207 Invalid column name 'AcctTerminateCause'.
State=2, Severity=16.

Pasting from the clibboard the SQL statement:

Select Start=DateAdd(Second, (0-AcctSessionTime-AcctDelayTime),
CallDate), (AcctSessionTime/60)+1, (AcctInputOctets/1000)+1,
(AcctOutputOctets/1000)+1, Location, UserName, AcctTerminateCause,
Server, NASPort, ConnectInfo From Calls, Servers Where
(UserName='xxxxxx') and CallDate >= '990131' and CallDate <= '990228'
and AcctStatusType=2 and NASIdentifier=IPAddress Order by Start

It appears we're missing the column in the table.

This is emerald 2.5.236. Started with a 2.1 database that was upgraded
with to a 2.5 type database. This isn't crucial, however it would be
nice to get it working.

Alex Blauvelt
Online Gateway

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html