(RADIATOR) insert errors

[Jesús M Díaz]

Hello,

i had the same problem too, but whit the pair
'nas-identifier/nas-port'. i could solve it changing the AddQuery
sentence at 'session sql' clause from 'insert into ...' to 'replace
into ...'.

the problem, as i could see, is when due an error or any other
reason, Radiator keeps a session entry but that sessions is not real
yet.

regards


--Original Message Text---
From: manager
Date: Tue, 16 Oct 2001 17:45:22 +1000

I keep getting this error

                ('username', 'Oct 16, 2001 14:23', 1, 0, '00000019',
'patton1.domain.com.au', 6)': Server message number=2627 severity=14
state=1
line=3 server=ntserver procedure=calls_insert text=Violation of
PRIMARY KEY
constraint 'pk_ServerPorts': Attempt to insert duplicate key in
object
'ServerPorts'.Server message number=3621 severity=0 state=0 line=3
server=ntserver procedure=calls_insert text=Command has been aborted.

My set up is
Radiator using emerald.cfg to back into platpus
I have 3 portmaster3 which don't cause this problem
And 2 (recently added) patton2800 NAS boxes which cause the above
problem.

>From what I can see is when the patton boxes are switch off and on again
the session id or " '00000019'" part from above resets back to zero.
and you end up with  '00000019' from patton box 1 and then again from
patton
box 2.

Is there a fix for this or work around for this problem ?

Thanks for any help
Matthew



Jesus M Diaz <jesus.diaz at telia-iberia.com>

ONO Service Provider
Planificación y Diseño de Red
Tfno: +34 91 623 2909
Fax:  +34 91 623 2911

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20011016/66507624/attachment.html>