I've seen an occurence for quite awhile now where a user dials in but gets
disconnected within one minute of being connected.
The problem is that when this happens, they show up in calls online, but
calls online doesn't seem to get updated again when they get bounced off!
This is my calls_insert trigger:
CREATE TRIGGER calls_insert ON Calls FOR INSERT AS UPDATE ServerPorts
Set ServerPorts.NasPortDNIS=i.NASPortDNIS,Serverports.UserName =
i.UserName,serverports.AcctStatusType = i.AcctStatusType,
serverports.CallDate = DateAdd(Second, 0-i.AcctDelayTime,
FROM Servers, ServerPorts, inserted i WHERE servers.IPAddress =
i.NASIdentifier AND servers.ServerID = serverports.ServerID AND
serverports.Port = i.NASPort AND
(DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) >= serverports.CallDate OR
serverports.CallDate IS NULL)
We have concurrency turned on, so when this happens, the user is unable to
log in until we manually clear him out of callsonine.
I can't see any reason why this happens. Does anyone have an idea on how I
could fix this problem?
For more information about this list (including removal) go to: