KingdomFirst
Email addresses not imported from F1 into person table
I did have all tables checked. Now I get a key error. What I am missing is the email in the person table. Communications seems to have all of the group emails and communications sent from Rock RMS or F1.
The first error indicates that the GroupsAttendance table may be corrupt or unreadable in the MDF. You'd have to mount the MDF on your server and run an integrity check on it.
For the dictionary error, it looks like you have multiple financial batches with the same ForeignId. If you run this code SELECT ForeignId FROM FinancialBatch GROUP BY ForeignId HAVING COUNT(1) > 1 that will point you at the Rock Batch(es) that needs to be updated so Excavator can read the table.
Ran integrity check, no issues found. Ran Query, no records returned. Financial batch table is empty as is Groups Attendance.