Re: [RadiusNT] ServerPorts problem with Rowguid Column

Peter Deacon ( peterd@iea-software.com )
Thu, 14 Sep 2000 06:34:30 -0700 (Pacific Daylight Time)

On Thu, 14 Sep 2000, Graeme Slogrove wrote:

> Hi there,

> We are using replication on our tables and therefore the ROWGUID column.
> This is giving Radius a problem -

I've got two replies :)

ServerPorts is a hot table who's constantly being updated
while anyone logs on/off at the moment. It just keeps track of "who's
online".

If your replicating in real-time chances are constantly pushing
updates are not worth the overhead/concurrancy cost.

If one is scheduling replication the data in ServerPorts will be too old
to be useful. ServerPorts should be cleared if you start using
the replicated database.

Therefore I'd exclude the ServerPorts table from replication, even if
ROWGUID is not a problem.

If your replicating the calls table and have the calls trigger installed
on the replicated database it can keep it's own server-ports
table synchronized.

My second idea is to use the database triggers who come /w
Emerald/RadiusNT and turn off manual calls update.

Have Fun!
Peter

> -----
>
> SQL Statement: UPDATE ServerPorts SET
> AcctSessionId='7C001BEE',UserName='savp',AcctStatusType=1,ConnectInfo='34000
> LAPM/V42BIS',CallerId='0113460069',FramedAddress='196.22.188.95',CallDate='2
> 0000912 7:18:20',CostPerMinute=NULL,rowguid=NULL,MaxSessionTime=NULL FROM
> Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND
> COALESCE(sp.IPAddress,s.IPAddress)='196.22.160.103' AND sp.Port=0 AND
> ('20000912 7:18:20' >= sp.CallDate OR sp.CallDate IS NULL)
>
> ODBC Error [37000] 20062:[Microsoft][ODBC SQL Server Driver][SQL
> Server]Update of columns with the rowguidcol property is not allowed.
> [UPDATE ServerPorts SET
> AcctSessionId='7C001BEE',UserName='savp',AcctStatusType=1,ConnectInfo='34000
> LAPM/V42BIS',CallerId='0113460069',FramedAddress='196.22.188.95',CallDate='2
> 0000912 7:18:20',CostPerMinute=NULL,rowguid=NULL,MaxSessionTime=NULL FROM
> Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND
> COALESCE(sp.IPAddress,s.IPAddress)='196.22.160.103' AND sp.Port=0 AND
> ('20000912 7:18:20' >= sp.CallDate OR sp.CallDate IS NULL)]
>
> -----
>
> Radius is trying to set the rowguid to NULL, something that is not allowed.

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart