Error - system registry

[The ScareCrow]

Hi All,

I have a problem with a hosted site.

There is a search facility, the result set can be very large. So I created a
sp to only return 1000 records at a time.
There is also a next/previous naviagation to traverse through the 1000 records.

Now I wanted to store the query result set in a session variable, to limit the
numbr of db hits.
When I include the session management in the cfapplication tag, the following
error occurs

Error Occurred While Processing Request
Error Diagnostic Information
Error attempting to get the client (Client ID = '283944').

A problem was encountered trying to access the system registry. Error number
1450 occurred.

Now I know what the error is and how to fix it, but the host has said they
will not flush the registry.

I know I could use cookies, but what if the user has cookies turned off ??
I know I could also save to a db, but this then goes against the whole point
of the session variable.

So does anyone have another option ??

Any thoughts or ideas ??

Ken

[philh]

Hi Ken, Registry, DB, what's the difference? Stability, that's what. Are you
actually using client variables in your application? Horror story: I wrote an
app that created an index page of work orders from a database. I then wrote a
simple view page that was the target of all the hrefs on the index page. Then
I wrote a nifty crawl in Sharepoint, starting at the index page and going one
level deep. The outcome was that all of the salient info in my work order
database was now indexed and searchable through the Sharepoint interface
(search box). This went on happily for a week, then I received the 1450.
Multiple times. Brought the production CF server to its knees and we couldn't
bring it up again. Why? I had client management turned on, with the default
location (registry), and every iteration of the SharePoint crawler created a
new entry in the registry. ~255K entries, if I'm not mistaken. Well, we
rebuilt the box; I pointed the client variables at our SQL DB, and turned off
client mgmt for those apps that don't need it. And, yes, there's a TechNote
out there, STRONGLY recommending that you override the default setting and
point your client variable storage at a DB. I second that.

[The ScareCrow]

Thank's for the reply Phil.

I checked the application.cfm page again and it appears that somehow I included

clientmanagement="Yes"

in it. I don't usually include this, so I have asked my client to upload the
correction and see if it resolves the problem.

Ken