There are several possible causes:
Intuit recommends more than one solution for this problem. The first solution may solve your problem, or you may need to try all of them to resolve the issue. For best results, perform the solutions in the order shown.
You may need to include the inactive items as you go through your lists.
If damaged transactions are the root cause of your issue, they should be easy to find.