derby leeds blog

While exporting SystemSecurityUserRoleOrganizationEntity to BYOD database in Dynamics 365 F&O, I was getting the below error.

Export execution failed for entity SystemSecurityUserRoleOrganizationEntity: Export failed while copying data from staging to target

To solve this error, open the SystemSecurityUserRoleOrganizationStaging table in BYOD database in design mode. Then increase the datatype size of USERID column to 100. Save the changes to the table design.
From “Data Management”, export the data entity again. The export job should run successful.