Identify Top Transaction Failure Points

You are given a transaction error log and need to identify the most common failure point, similar to summarizing the issue in an Excel pivot table. Write a PostgreSQL query that returns the failure point with the highest error count and its count, excluding successful transactions and rows where the failure point is unknown.