R25 Pending Reservation Lock

 Problem Description : 

There is a space conflict when attempting to make an assignment in R25. However, when looking at the space calendar, the space appears to be available.

 Resolution : 

The SpeedBook/Edit Event forms create records in SP_PEND_RSRV (and RS_PEND_RSRV for resources) as soon as you press the Assign button on page 2 (or 3). When you save the event, those pending reservations are converted into real reservations (in SP_RESERVATIONS/RS_RESERVATIONS) and the records in SP_PEND_RSRV (and RS_PEND_RSRV) are removed.

Therefore if you have made an assignment, but haven't yet saved the event when your PC crashes, then you'll be left with pending assignments and hence no one else will be able to schedule into that space. These pending reservations are not exposed on any of the matrices.

Remedy

First, make sure that all of your users are logged out of R25 v3.x

Then perform the operation listed below:

Run a select query against the SP_PEND_RSRV table and see if any rows are fetched.

select * from sp_pend_rsrv;

If any rows are returned then these are the culprits and they need to be deleted.

delete from SP_PEND_RSRV;

After this has been done access R25 v3.x and see if the problem still persists.

The same principle applies to resources and the RS_PEND_RSRV table.

 Revision Date : 7/25/2007