Items are not repriced, they show a black X, and in the Price Check tab error says "DB update failed: Query is too complex"

If you randomly get this error message in the Price Check tab for items you try to reprice then the database has become corrupt and you need to recreate it. To recreate your database follow instructions provided here.

If recreating the database doesn't solve this problem uninstall and reinstall the software.