Skip to main content

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 familyPayroll useFreshness symptom
Employee Payroll profileEligibility and workforce inputsEmployee absent, inactive state unexpected, or required profile data unavailable
Attendance snapshotRequired native calculation inputEmployee calculation rejected or attendance totals stale
Leave snapshotOptional calculation inputApproved/rejected/cancelled leave effect absent or stale
Approved expense snapshotOptional calculation inputApproved/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.cs
  • microservices/src/payroll-service/Infrastructure/PayrollDbContext.cs

See Also

Keywords

  • Payroll troubleshooting
  • Payroll Projection Freshness Troubleshooting

Revision Information

  • Status: Draft
  • Last reviewed: 2026-07-15
  • Review cycle: Quarterly