I belive CF5.0 Client variables size was 120K. Docs say you can increase the size of client vars by increasing the size of the DB storage fields... Have you tried increasing the size of DB fields? U are also getting a precision error.. u can try resetting the DB field precision as well.
Joe Certified Advanced ColdFusion Developer ----- Original Message ----- From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 4:56 PM Subject: CFMX and client variables (size limit?) > 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 clien t > 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 > > > > ______________________________________________________________________ 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 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
