Hi folks... I've got a stumper and I'm hoping someone out there in CF-Talk-land can shed some light on this.
Vital statistics: CFMX 6,1,0,6395**8, MS SQL Server 7. I've got a bit in my app that allows people to add/edit content, textual and/or HTML. Hitting save takes them to a page that will insert or update the record in question, a 'text' datatype. 99.99% of the time, it works great. But every blue moon, someone will submit content that makes everything go blooey. I've got two webservers, both using the same DB - and when the issue occurs, not only does the webserver that the user is on crash, the OTHER webserver crashes. (The CF service crashes, not the entire server, FYI.) The first server remains up long enough for the try/catch to catch the error, and send me an email alerting me - but then blammo. If the same content is submitted again (i.e. the user has a text file and is cutting/pasting the exact same content), same thing happens. BUT - if the content is CHANGED in any way - just the addition of a simple space, even - the DB write goes through and everything is fine. I've chatted with a SQL Server guru pal of mine, and he doesn't think it's a DB issue - but if it wasn't, why would the second webserver (sharing the common DB) crash at that point as well? The CF error I get back is just a simple "4096" - type "java.lang.ArrayIndexOutOfBoundsException". Nothing in cfcatch.detail. Any thoughts? --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223886 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
