Diagnose Run Failure
diagnose_run_failureIdentify why a Coalesce run failed and get actionable fixes by analyzing each node's error classification and run metadata.
Instructions
Diagnose a failed Coalesce run. Fetches run metadata and per-node results, classifies each failure (SQL error, missing object, permission issue, data type mismatch, timeout, configuration error), and returns actionable fix suggestions.
Use this when a run has failed and the user wants to understand what went wrong and how to fix it. Works best with completed (failed) runs — for in-progress runs, use run_status instead.
Returns: run summary, per-node failure diagnosis with error classification, and prioritized recommendations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runID | Yes | The numeric run ID (integer, e.g. '401'). Use the runCounter value from start_run or run_status responses — not the UUID from run URLs. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runID | No | ||
| endTime | No | ||
| runType | No | ||
| summary | No | ||
| failures | No | ||
| warnings | No | ||
| runStatus | No | ||
| startTime | No | ||
| analyzedAt | No | ||
| environmentID | No | ||
| recommendations | No |