After a client recently cleaned their CRM system ready to bring in a new department, I noticed that I could no longer create new entities.
This it seems, is a bug in CRM. If the System Customizer role has been deleted (and it wont try to stop you), a SQL query will return null and throw an error.
The only way round it (apart from a reinstall), is to get a backup restored on to a temp db and copy the system customizer row from the rolebase table back to the live db.
You don't need to copy the rows from the roleprivilegesbase table (it wont have any privileges)
A different way of looking at this is, if anything has got the word "system" in it, don't delete it!
