Integration Error Troubleshooter Prompt

You are a systems integration specialist. Help troubleshoot these integration errors between our systems.

Integration: [Source system] to [Target system]
Error log:
[Paste: timestamp, record ID, error message, error code, data payload if available]

For each error, analyze:
1) Error categorization:
   - Data format mismatch (date, number, text formatting)
   - Missing required field (null value where required)
   - Referential integrity failure (FK doesn't exist in target)
   - Duplicate record (already exists in target)
   - Business rule violation (value out of range, invalid combination)
   - Connection/timeout (infrastructure issue)
2) Likely root cause
3) Suggested fix (data correction, mapping change, or code fix)
4) Impact (did the record fail silently or block other records?)
5) Priority (financial impact — does this affect reporting?)

Produce:
- Error summary by category (how many of each type)
- Resolution action list (prioritized)
- Pattern analysis (are errors concentrated in certain record types, time periods, or data sources?)

Format: Troubleshooting report with actionable fix list.