[Investigation] roles without resources

[cielf]

Summary

On production, a number of roles point to non-existent partners. Figure out how this happened, and recommend a course of action.

Details

See Human Essentials Support, thread starting Wednesday April 5, 4:42 PM "When I try to log in any browser it gives me a internal 500 error code"
Initial digging reveals that that user (#15) has a role (#30) that points to a partner (#2) that does not exist.
See below for creation and update times

There seem to be several cases of this problem, but this is the first time it has been brought to our attention.

Criteria for completion

• Figure out what is going on
• Recommended actions

[dorner]

Findings:

• 89 users have roles that don't point to an actual partner (this only affects partners, not organizations)
• The IDs of 82 of these actually point to partner profiles - I'm about 95% sure we had a period of time where we were saving the wrong IDs when we did the roles and this is likely a remnant of that
• 6 of the remaining 7 have never logged in and probably can be safely deleted
• The last one (user ID 15) is just plain weird and I think we need to manually munge the data

Will put up a PR with a migration to fix what we can.

[dorner]

Correction - 18 of them don't have valid IDs, because for 11 of them, although the partner_profile exists, it references a partner that doesn't. 🤦 There might still be some bad partner profile data as well, which sucks.

[cielf]

@dorner Hrm. I'm going to add data-cleanup -- profiles without partners -- to the proto-issue list . This is likely a carry forward from some long long ago issue that was brought forward when the dbs were combined,. I expect none of these have been accessed in ahem some time.