The SQL Optimized Reports would fail with a duplicate record error if one line-item on a document had a Zip Code Tax Schedule and another line-item on the same document had the Zip Code Exempt Schedule for the same Tax Location.
The error was Unknown Error Number 54.