On the System Status page there was a pink warning triangle next to the production tenant API key. When pushing on the Info button the same error message is displayed "Failed to execute due to User not found or select user is inactive.". Pressing on the fix button did not work.
To check the API Key login into the Admin UI and navigate to Security Control -> API Keys
Select OpsConsoleAPIGroup and click Edit on the key who's id matches that in OpsConsoles.
the On Behalf Of field give the user that will be impersonated by the OpsConsole. This is the user that it is referred to in the error message.
You can check this user by navigating to Users and Permissions -> Users and searching for them.
It also worth checking that they are a member of the role found in the API Key settings