Re: [Emerald] Malformed Data in Calls Table

Brian ( )
Thu, 29 Jun 2000 07:43:53 -0400

"Robert H. Clugston" wrote:

> List,
> I'm reviewing my calls table to see if I can find out why some of my users
> are getting "over login limit" errors. I ran this query:
> DISTINCT Calls.UserName,
> Calls.AcctSessionTime,
> Calls.NASIdentifier,
> Calls.NASPort,
> Calls.CallDate,
> Calls.CallerID
> Emerald.dbo.Calls Calls
> Calls.UserName = 'user'
> Calls.CallDate ASC
> When I was searching throught the results I noticed that there was alot of
> data that looked corrupt. Any idea if this is a problem or is this is
> normal?
> For more information about this list (including removal) go to:

If your NAS crashes (no BBU) or for any other reason does not send the Stop packet.
Emerald will believe they are still online and they must be cleared from the Online
screen manually.

I was also getting duplicate packets (Session IDs) that it was not receiving properly
for obvious reasons.
I cleared old data, older than 2 months (or the affected period) and the accounting
began working properly again.


--------------------------------------------------------Thank You,Brian DooleyClassic Service

`````````````````````````````````````````````````````````` - Man cannot survive except by gaining knowledge, and reason is his only means to gain it.-

Ayn Rand

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