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
