This is something that we ran into with a similar server configuration. The
big problem here is that this user cannot return to the site at all with the
cookies on their machine.
We had to clear out the database tables on a regular basis to remove the
problem. (If this is something you can do it is a valid work-around.)
Looking forward to any other comments.
Signed,
Bill King
HostWorks INC
http://www.hostworks.com
-----Original Message-----
From: Daniel Daugherty [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 10:02 AM
To: Fusebox
Subject: OT: weird client variable problem
Has anyone see the following error before?
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'CDATA' with unique index 'id1'.
We have had this error pop up on 3 or 4 occasions. The set up is 2 web
server with Round Robin DNS and a 2 server SQL Cluster behind that. Client
variables are being stored in a database on the SQL cluster. From what I
can tell of the error some how it appears that CF Server is trying to insert
the same client variable record into the database twice. The server are not
under high load and everything else is functioning this error has just
started appearing. If you have any ideas suggestion please let me know.
Thanks
Daniel Daugherty
Nucleus Tech.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
