Hi Guys, The records are being deleted as scheduled. I installed the fix for this. Take a look at http://www.macromedia.com/v1/Handlers/index.cfm?ID=22730&Method=Full This fixed that problem for me.
However, I still get the CDATA insert failure about once every two weeks. I am using the long version of the cftoken so I really don't understand why CF is getting a duplicate problem. I might open a ticket, but I hate their policy of needing a CC number. A stupid policy... Another question comes to mind.. I am running about 100 datasources on one machine. Each holds cdata and cglobal data for its application. Is it better to use one source for cdata and cglobal per machine/CF instance, or is it better to hold this data in each applications own database? What are your thoughts on this.... Thanks, Joe ----- Original Message ----- From: "Kwang Suh" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, January 12, 2003 12:39 AM Subject: Re: CDATA Insert problem > Yeah, I've had the same problem as well. > > We ended up creating a SQL Server job that nuked old records instead. > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 11, 2003 10:10 PM > Subject: Re: CDATA Insert problem > > > > I should have been more clear... > > > > They had configured the CFMX Administrator to delete inactive records > after > > 3 days. When we looked at the CDATA and CGLOBAL tables there were records > > going back to June of 2001! > > > > The site is an extranet site, not a public web server... and no, they're > not > > THAT busy. ;-) > > > > Nothing was being deleted... and nothing ever had been deleted from those > > tables. > > > > I've experienced this same thing on some of my own systems as well. > > > > -Novak > > > > ----- Original Message ----- > > From: "Kwang Suh" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, January 11, 2003 9:00 PM > > Subject: Re: CDATA Insert problem > > > > > > > > You might want to check your CDATA and CGLOBAL tables and make sure > you > > > > don't have a ton of records in there. It has been my experience that > > the > > > > CDATA and CGLOBAL tables DO NOT get purged like they're supposed to. > > For > > > > example, if you tell the CF Administrator to clear records older than > 3 > > > days > > > > it simply doesn't happen. I've experienced this problem in CF5 and > > CFMX. > > > > In fact, just the other day a client of mine (who had it set to clear > > > > records older than 3 days) discovered over 2.8 million records in each > > > > table! > > > > > > Perhaps his site is very busy? Also, CF only deletes inactive records > > after > > > X days. > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4