I'm getting a lot of client variable errors after upgrading to MX. I get intermittent failed client variable operations when using a SQL7.0 database as a client variable repository. I am the only user using the site, so the deadlocked processes and failed transactions are very suspicious.
We had no problems at all with the exact same setup on early versions of CF. I've had a number of errors, one reporting that there had been 500 failed transactions on the client variable datasource. And the funny thing is that this error was written to the browser using the H2 tag while debugging was disabled. Interesting. Now I can reproduce this error whenever my client variables are "too" big. As I said this was not a problem on earlier versions. ---------------------------------------------- Operation failed on the data source named "skyline_clientvars". Reason of failure "[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value" ---------------------------------------------- This length of client variable string works fine on CF4.5. I also dropped and recreated the client variable reference in the administrator because I heard some one mention that there was an issue that was easily solved by forcing the administrator to write to a prefs/config file just by "hitting" it. I'm not sure if this is the correct way to calculate the size of the client var data, but I used <cfdump> to output it and then cut and paste it into a notepad and the doc weighed 17k. In general the application's client var string will almost never be this big, I was just testing. But in CF4.5 I thought the size limit was around 32k. It was definetly bigger than 17k! Has any one seen something similar? Can some one test this by doing a <cffile action="read" file="my17kfile.txt" variable="client.myclientvar"> or something similar while client variables are enabled for DB storage. Brook Davies ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
