Payroll Projection Freshness Troubleshooting
Summary
This page records confirmed payroll projection freshness troubleshooting behavior and marks incomplete boundaries explicitly.
Audience
Payroll users, developers, QA and support engineers, architects, and implementation reviewers.
Symptoms
Employees or Attendance, Leave, or Expense inputs are missing, duplicated, or stale in Payroll.
Cause
The upstream event may be missing, lack tenant/entity identity, be older than stored projection state, be a duplicate, fail processing, or remain queued after a worker/broker issue. Attendance is required for native calculation; Leave and Expense are optional inputs.
| Projection family | Payroll use | Freshness symptom |
|---|---|---|
| Employee Payroll profile | Eligibility and workforce inputs | Employee absent, inactive state unexpected, or required profile data unavailable |
| Attendance snapshot | Required native calculation input | Employee calculation rejected or attendance totals stale |
| Leave snapshot | Optional calculation input | Approved/rejected/cancelled leave effect absent or stale |
| Approved expense snapshot | Optional calculation input | Approved/rejected/paid expense effect absent or stale |
Resolution
Identify the affected projection family and period, review sanitized worker/audit/processed-event evidence, and compare last occurrence/update time. Correct upstream delivery or use an approved backfill/reconciliation path. Do not edit projection rows directly.
Duplicate and older events can be intentionally ignored by the consumer. Therefore, a skipped delivery is not automatically an error: compare its occurrence order and identity with the stored projection. For a requeued exception, verify worker recovery and successful processed-event evidence before recalculating.
Validation
Confirm a newer projection timestamp, processed-event evidence, and expected calculation input. Validate Attendance, Leave, and Expense independently.
Source References
microservices/src/payroll-service/Messaging/PayrollReadModelConsumer.csmicroservices/src/payroll-service/Infrastructure/PayrollDbContext.cs
Related Articles
See Also
Keywords
- Payroll troubleshooting
- Payroll Projection Freshness Troubleshooting
Revision Information
- Status: Draft
- Last reviewed: 2026-07-15
- Review cycle: Quarterly