Troubleshooting.md

+# Troubleshooting
+
+## Common Issues
+
+### Scheduler Not Running
+
+1. Check if process is running:
+   ```bash
+   python utils/check_scheduler_status.py
+   ```
+
+2. Verify `.env` file exists and is configured correctly
+
+3. Check virtual environment is activated
+
+4. Review console output for errors
+
+### Jobs Not Executing
+
+1. Verify scheduler times in `.env`:
+   - `QUEUE_SYNC_HOUR=13`
+   - `QUEUE_SYNC_MINUTE=0`
+   - `PRE_MIGRATION_EMAIL_HOUR=13`
+   - `PRE_MIGRATION_EMAIL_MINUTE=30`
+   - `MIGRATION_EXECUTION_HOUR=18`
+   - `MIGRATION_EXECUTION_MINUTE=0`
+
+2. Ensure `TEST_SCHEDULER_MODE=False` in `.env`
+
+3. Check master summary log for errors
+
+### Emails Not Sending
+
+1. Verify SMTP settings in `.env`
+
+2. Check `TEST_EMAIL_MODE=False` for live execution
+
+3. Verify `MONITORING_EMAIL` is set (receives BCC copies)
+
+### Migration Issues
+
+1. **PST Export Not Starting:**
+   - Check if batches exist for the server
+   - Verify Hafnium connectivity
+   - Check master summary log
+
+2. **GWME Not Triggering:**
+   - Verify PST export completed
+   - Check if batches exist for the server
+   - Review GWME logs on migration servers
+
+3. **GCDS Sync Failing:**
+   - Verify Xenon server connectivity
+   - Check SSH key configuration
+   - Review GCDS logs on Xenon
+
+### Database Issues
+
+1. **Database Locked:**
+   - Ensure only one process is accessing the database
+   - Check for hung processes
+
+2. **Data Not Updating:**
+   - Verify database file permissions
+   - Check for errors in logs
+
+## Logs
+
+- **Master Summary:** `D:\automated-email-migration\logs\daily_summary\YYYY-MM-DD_master_summary.log`
+- **Application Logs:** Console output or `migration.log`
+- **Database:** `migration_queue.db`
+
+---
+
+**See also:** [Operations](Operations.md), [Configuration](Configuration.md)
+