Monday, June 25, 2012 5:56 AM
our application runs in web farm and DB is mirrored. We have enabled SQL dependent caching it works fine until DB flips; routines using SQL dependent caching starts throwing error :"when using sqldependency without providing an options value sqldependency.start must be called for each server that is being executed against".
We need to restart app pool of our web application to get it working.
Seems i am missing some configuration/setting.
- Edited by Docait Monday, June 25, 2012 5:59 AM
Tuesday, June 26, 2012 6:15 AMModerator
This issue occurs because the existing dependencies are invalidated when the database mirroring failover occurs.
To resolve this issue, add code to monitor database mirroring failovers. Then, re-execute the relevant commands that are used together with the dependencies.
For more information, please see:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marked As Answer by Iric WenModerator Monday, July 02, 2012 9:56 AM