# Plus2 Start of Day, Record Locks and Error Messages

HTML version: [Plus2 Start of Day, Record Locks and Error Messages](https://support.gladstonesoftware.cloud/plus2/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)

1. **Log in again**
   - If the message says Start of Day is locked, cancel out and log in again.

2. **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**.

3. **Raise a case (if you don't have Plus2 Tools)**
   - [Raise a support case](../guides/raising-a-support-case.md). Gladstone support clears the locks, then you run Start of Day manually.

4. **Run Start of Day**
   - Run (or re-run) **Start of Day** manually.

### Memberships didn't roll forward or overdue sales are missing

1. **Run Start of Day manually**
   - Start of Day didn't complete. Run **Start of Day** manually.

2. **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.

1. **Show all booking sheets**
   - Click the arrow to see all booking sheets.

2. **Remove the default**
   - Right-click the sheet shown in **bold** and remove the default.

3. **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](how-to-add-and-manage-member-actions-in-plus2.md).
  - 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](../guides/raising-a-support-case.md)):
  - 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.