Extension install / upgrade error: The role wasn't found for the user. Verify the role and try again

[AndySteeple]

I have migrated an M1 system to M2 and all seems to have gone well.

My problem comes to installing or updating extensions. I get the error:

Running schema recurring...The role wasn't found for the user. Verify the role and try again.

The outcome is that extensions fail to create attributes they may rely on and the database column 'data_version' in the 'setup_module' table fails to be updated.

I have checked log files and don't see anything obvious related to this so am totally stumped.

Has anyone come across this before? I have seen similar issues but not this particular one.

Any help appreciated
Andy

[Manish Mittal]

@AndySteeple 

I am not sure about your magento version but as it seems related to roles you can check ACL file:

https://stackoverflow.com/questions/48811151/magento-2-setup-upgrade-error-we-cant-find-the-role-for...

Few article saying to disabled Shopial_Facebook and it work, check if you also have same.

[AndySteeple]

Thank you for the reply Manish.

I am on v2.3.4-p2 currently.

I do not have the shopial extension installed so it's not that. The principal may be the same though with another extension causing this issue. Which one I would not know though as there's no specific error pointing to one.

[Manish Mittal · Accepted solution]

@AndySteeple 

Can you check ACL file suggested here:

https://stackoverflow.com/questions/48811151/magento-2-setup-upgrade-error-we-cant-find-the-role-for...

Just debug there, you will find it which role it is looking or is there any other issue

[AndySteeple]

Following that link, the extension installed ok which is great news, thank you. 

No errors were thrown though so it looks like I need to source the role issue?

As a side note, the last line needs leaving in I believe as that did throw an error on update.

if (!$role) {
$allowedResources = array();
}
$allowedResources = $this->getAllowedResourcesByRole($role->getId());

[Manish Mittal]

@AndySteeple 

Great! Happy to help you!