When you create the DB there are three columns in the CDATA table
CFID: the CFID and the CFTOKEN together (415:75906134 )
APP: the application name as declared in <CFAPPLICATION...>
DATA: whatever
id1 is the index that forces CFID and APP to be unique when paired together.
Anyway...
What application is generating the error and when does it occur? Does it
occur during times of high traffic or low? Are you using cookies? Are you
passing CFID and CFTOKEN through the URL string? Do you have more than one
application with the same application name? How long are client vars kept
before deletion (according to the CF Administrator)?
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 7:10 AM
To: CF-Talk
Subject: Client var problem
We've got a shiny new SQL 2000 server storing our client vars - we're
periodically seeing this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'CDATA' with unique index 'id1'.
Has anyone else seen this?
Ian
Portent Interactive
Helping clients build customer relationships on the web since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com
Talk with us: http://projects.portentinteractive.com
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
