Payroll lag error when submitting time sheet

Symptoms
When submitting the time sheet, an error message appears.

Error
Some unsubmitted time entries are beyond the payroll lag and can no longer be submitted.  Please contact your System Administrator.

Resolution
This means that there is unsubmitted time before the configured payroll lag. To find these time entries, either scroll back in the time sheet, week by week. Or run a SQL query to find these records:

select * from time where resourceid='1234....' and certified=0
select * from requesttime where resourceid='1234....' and certified=0
select * from standardtasktime where resourceid='1234....' and certified=0

Once the past unsubmitted records found, please increase the payroll lag value in the resource profile and submit these past unsubmitted time entries.