Survey respondents cached?

[rgenter]

I have successfully implemented a stored procedure that bulk loads respondents into the Checkbox database. An issue I have, however, is that the respondents are not allowed to enter the survey until I go into the Administrator interface and view the respondents list for the survey. I don't have to make any changes; simply viewing the list is sufficient to allow the respondents to enter the survey.

Before I view the list, when a respondent logs in they get a screen that says something like "You are not enabled to take this survey." After I view the list, when a respondent logs in they are taken to the first page of the survey.

It appears that there is some sort of caching mechanism involved. Is there some way I can tell Checkbox to flush its cache?

[pwiesner]

Is response template caching enabled? You can confirm by checking the value of EnableResponseTemplateCaching in the ckbx_Settings table. When enabled a ResponseTemplate and its access control list is cached in memory. Because you are making your changes directly in the database Checkbox is unaware that the ACL has changed.

There are a couple of things you could do to work around the caching.
1 - You could disable this setting, although this will result in a decrease in performance.
2 - You could use the direct API to alter a property of the ResponseTemplate, this will force the application to reload the cache.
3 - You could recycle the application pool.