Plus2 Start of Day, Record Locks and Error Messages
Problem
Duty managers and site administrators who open Plus2 first thing need to know what to do when Plus2 is locked after Start of Day, memberships haven't rolled, or a common Plus2 error appears.
Resolution
"Database is locked by another user" (auto Start of Day user)
Log in again
- If the message says Start of Day is locked, cancel out and log in again.
Clear the locks (if your site has Plus2 Tools)
- Log in to Plus2 Tools with that day's daily password (from Gladstone support).
- Click Clear User Locks and Clear Record Locks.
Raise a case (if you don't have Plus2 Tools)
- Raise a support case. Gladstone support clears the locks, then you run Start of Day manually.
Run Start of Day
- Run (or re-run) Start of Day manually.
Memberships didn't roll forward or overdue sales are missing
Run Start of Day manually
- Start of Day didn't complete. Run Start of Day manually.
Check it completes
- Once it completes, subscriptions roll and sales are raised.
"Program error intercepted" opening booking sheets (one user only)
This usually happens when the user has set a very busy booking sheet as their default.
Show all booking sheets
- Click the arrow to see all booking sheets.
Remove the default
- Right-click the sheet shown in bold and remove the default.
Log out and back in
- Log out of Plus2 and log back in.
Notes
- Before you start:
- Start of Day rolls subscriptions forward, raises sales, applies future Member Actions and creates the day's sessions for indefinite reservations. If it doesn't finish, these don't happen. See How to Add and Manage Member Actions in Plus2.
- Note the exact error message and when it started before you do anything.
- Subscriptions only roll and raise sales when Start of Day finishes.
- Apostrophes cause errors. An apostrophe (') in comments, web comments or user fields stops them saving. Use a backtick (`) instead.
- Hidden tab characters in descriptions (often from copying and pasting) cause similar errors. Retype the text.
- "Run-time error – subscript out of range" is a known issue. No Plus2 fix is planned because this area is being replaced by Centre Manager. If it stops you removing a specific exception, Gladstone support can remove it.
- Plus2 doesn't log who viewed a record, so you can't see which staff member looked at a member record. The Event Log report shows the event, user ID and date, but not what changed.
- Users 9990 and 9991 in booking logs are the online booking system. Stale unpaid online bookings are removed automatically by the Unverified Bookings Manager (sometimes called the Unpaid Booking Manager) so someone else can book, including £0 classes where the member didn't finish the "pay" step. Stale unpaid online sales are removed the same way by the Unverified Sales Manager. By default they run every 20 minutes, and this can be changed.
- Troubleshooting:
- Nobody can log in, locked by the auto Start of Day user: Start of Day didn't finish and left locks. Clear locks with Plus2 Tools, or raise a case. Then run Start of Day manually.
- Memberships not rolled; overdue sales missing: Start of Day didn't complete. Run Start of Day manually.
- Error saving a booking comment or user field: there is an apostrophe in the text. Replace it with a backtick (`).
- Error saving a description: hidden tab characters from copy and paste. Retype the text.
- "Program error intercepted" on booking sheets for one user: a busy booking sheet is set as their default. Remove the default (bold) sheet and log back in.
- "Run-time error – subscript out of range": known issue. If it blocks removing an exception, raise a case.
- Online booking disappeared, removed by user 9990/9991: the booking wasn't paid in time, so the Unverified Bookings Manager removed it. This is expected. The member needs to book and complete payment again.
- When to contact Gladstone support (raise a support case):
- You can't clear locks yourself. Include the exact message and when it started.
- Start of Day won't complete when you run it manually.
- A run-time error stops you removing an exception. Include the area or booking details and a screenshot.
- You need the daily Plus2 Tools password.