Resource Reservations

I am having more than the usual weirdness with R6 Resource Reservations db. I get users complaining all the time that they are trying to book a resource that claims to be available, but their request is rejected, saying the resource is busy.

While trying another vain attempt to track down this problem, I see that some documents show up in the view Reservations/By Date, and not in Reservations/By Resource!

After checking the design, I found that both have the exact same view selection formula. How is this possible?

Any suggestions as to what the heck is going on here? I have tried a Ctrl-Shift-F9 view rebuild, no effect.

Subject: Resource Reservations

try deleting busytime (or clubusy) and let it rebuild. To doi this with the server up stop the “sched” and “calconn” tasks at the console then delete the db via the OS. Restart the 2 tasks and the db should recreate an rebuild from scratch. Let me know if this helps.