Creating object of type OQL.CSVDownload failed for security reasons.

1
I have completed the Accademy course: Crash Course. Mendix v10.1.1 I imported  CommunityCommons 10.0.1 OQL 2.12            2.12 which matches with the Solution (end of Chapter 10).   When running the Unassigned Shifts report, microflow, I get the below 2 warnings and 1 error. When debugging the microflow, the first Action Create Query completes successfully, but the Export OQL to CSV fails. I have no other information. I have spent 3 hours triple checked everything (reconciled my module with the solution) (yes, I have obviously still missed something) but cannot see what the difference / problem is.   Can anybody help / suggest? If you require more information, let me know.   User 'MxAdmin' attempted to create an object of type 'OQL.CSVDownload', but does not have the required permissions. Creating object of type OQL.CSVDownload by user MxAdmin failed for security reasons: User 'MxAdmin' attempted to create an object of type 'OQL.CSVDownload', but does not have the required permissions. Creating object of type OQL.CSVDownload failed for security reasons. Error: Creating object of type OQL.CSVDownload failed for security reasons.     at m (http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:66:22721)     at async http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:66:5510     at async a (http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:66:20865)     at async g (http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:66:22225)     at async http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:66:55730     at async g.executeMicroflow (http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:64:29285)     at async http://localhost:8080/mxclientsystem/mxui/mxui.js?638272704497225349:64:5870 
asked
2 answers
0

Hi Andrew,

You might have forgotten to add the OQL admin role to your app admin role.

If you open App security settings and navigate to the tab “User roles” you can give the administrator access to the OQL module!

answered
0

Hi,

you are encountering a permissions-related issue while running the Unassigned Shifts report microflow in your Mendix application. The error message indicates that the user 'MxAdmin' does not have the required permissions to create an object of type 'OQL.CSVDownload'.

  1. Check Entity Access in OQL Module:

    • Go to "App" > "Marketplace modules" > "OQL" > "Security" > "Entity Access".
    • Look for the 'OQL.CSVDownload' entity and verify that the Administrator role (or the specific role assigned to 'MxAdmin') has the required permissions, especially the "Create" permission.

  2. Verify Role Hierarchy:

    • Double-check that the Administrator role you have assigned to 'MxAdmin' is the correct one and is associated with the required permissions.
    • Make sure that there are no conflicting permissions or role assignments that might be affecting the access.
answered