Hello Daniel,
The scan date implies that there was a problem when generating the ciscat_results table. You may have to delete it so that it can be regenerated from scratch. Before you do, would you be able to identify if any agents are being correctly scanned? If there are any, then you won't need to remove the table off of them.
Keep in mind that you need to stop the wazuh manager service before modifying the database or you will risk corrupting it.
Regards,
Gonzalo