Error: Staff [ID] must be assigned to the schedule item...

Project [number]: Generation failed. Staff [ID] must be assigned to the Schedule Item because they are scheduled for it in the future.

Cause

The project recurrence is set to generating using the current project's
Assigned selections
and
Calendar entries
.
A staff person was assigned and scheduled for the project or task, but the assignment was removed leaving the current assignment blank.

Solution

Select
File
Print Reports
.
Select the
Calendar Listing
report in the
Staff Management
folder.
On the
Selection
tab, use the
Detail line
field to choose a date range that includes the affected project dates.
In the
Filtering
section, choose
Client ID
or
Client Name
as the
Filter
.
Select
is
in the
Method
field.
Select the client from the
Select..
field.
Select
Preview Selected
.
The report will list all calendar entries for this client over the specified date range. You'll need to repeat the rest of these steps for each calendar item associated with the project.
Find a schedule item for this project and make a note of the staff listed for that item on the report. Select the item in the report to open it.
In the
Assigned
section, select the ellipsis button next to the
Staff
field.
Select the staff who was listed for this item on the report (check your note from the previous step).
Select
OK
to save the change.
You'll now be able to manually generate the next occurrence of the task by right-clicking project and choosing
Generate Next Project
.

Set the correct expectation with the user. The standard turnaround time for queries is 1-2 business days. Again, once they get the report, they will be responsible for re-assigning the schedule items.
Obtain a backup of the firm's database.
See the Resolver for instructions on submitting the database.

Restore the database.
In SQL Management Studio, run the query PCS-ScheduleEntryAndScheduleItemAssignmentMismatches-01.sql that can be found in the CF Queries folder.
Return the output from the query to the rep.