Unanswered

Issues with import export data, 0x80040203 error

(1) Share

Report

Posted on by ferris

Hey all,

So I've been stuck for a few days attempting to import data from one environment to another. I've tried using dataflows (OAuth and Excel), one time imports through a number of spreadsheet formats, doing it from within the app, doing it from the environment editor, using the new and legacy tools, pretty much everything. Consistently, it always looks like it is going to work (I get to the part where I can assign mappings, and everything looks like it is where it should be) but then fails with the same{"error":{"code":"0x80040203","message":"Changing security attributes is not allowed in stage 20 plugins."}}. I'm not sure what I am doing wrong here, I have imported spreadsheets to dataverse before and it was not difficult. I can't think of any major changes made to our organization that would suddenly make data imports impossible.

All I can think of is there is some setting buried in a menu somewhere that is simply preventing any and all imports, maybe security roles, etc. I have myself checked as System Administrator, System Customizer, and Environment Maker. The import is to a table that is a carbon copy or the source (same solution).

Also, the Export to Excel option within the environment editor is also not working for me:

Export failed: There was an error adding a table to the project.

Any and all help is appreciated, I'm getting nowhere trying to figure this out.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (12)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

Hi @ferris,

Strange error, it seems perhaps there's a custom plugin step (at stage pre-operation) that is triggering and causing the error. Try looking at the plugins and temporarely disable any custom plugins to ensure it's not that causing the exception. The easiest way is to look at them with the Plugin Registration Tool (PRT) which is part of the SDK or the XrmToolBox: https://www.xrmtoolbox.com/plugins/Xrm.Sdk.PluginRegistration/. Look for any plugin that does not start with Microsoft.
More info on PRT: https://docs.microsoft.com/powerapps/developer/data-platform/tutorial-write-plug-in \

Hope this helps!

Was this reply helpful? Yes No
ferris 42 on at

Like (1)

Report

Hey EricRegnier,
I tried your solution but unfortunately it looks like all the plugins are standard Microsoft assemblies, no custom anything there. I opened a support ticket with MS and spoke to them on Friday--as far as they can tell I'm everything correctly, so they are opening up a ticket on their end with another dpmt.

Kinda bummed to be stalled at this point, getting really close to being able to deploy something useful but can't really do it without getting this import stuff to work. Thank you for taking the time to read my post and suggest a solution for me.

Was this reply helpful? Yes No
ferris 42 on at

Like (0)

Report

Well still stuck here, haven't heard back from Microsoft after the first support meeting. Once again, any kind of data import activity, whether it be through a dataflow, and import through the legacy Dynamics interface, through the new Unified Interface, or even just manually editing data in Excel, all will always return the same error: "Changing security attributes is not allowed in stage 20 plugins." If anyone out there has seen this issue and resolved it please let me know what you did, my app progress has been dead in the water for weeks because of this.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (1)

Report

I don't have any good reason to think this will help, but since you're dead in the water there's no reason not to try...

Look at your installed first-party solutions from the admin.powerapps console. From there, see if any of them have pending updates and install every update out there. Maybe you got a bad update at some point and just haven't updated it away?

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

if the ticket is not set as urgent Microsoft Support can take some time to respond. Try getting in touch or open a new urgent ticket. They’re pretty quick to response on urgent, but you always need to keep following up.

Was this reply helpful? Yes No
ferris 42 on at

Like (0)

Report

Thanks for the help guys. I will follow up with the support ticket this week and see where it's at. Fortunately I have plenty of other work to do around here.

Was this reply helpful? Yes No
ferris 42 on at

Like (0)

Report

I want to try your idea but I'm a little lost. Are you referring to something in the power platform admin center or Microsoft.PowerApps.Administration.PowerShell, or maybe something else I haven't stumbled across?

Sorry I constantly find I'm learning something new with this platform every time I think I've got it.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (1)

Report

Sure, from the admin.powerplatform.com UI, go to your environments and pick the one that's giving you trouble. In the lower Right, you will see a Resources panel. This will have various stuff in it, depending on the specifics of your environment, but you will probably see a "Dynamics 365 Apps" item in that list:

Click it and you will see a list of the first-party apps installed in your environment. If you are on vanilla Dataverse, this list will be small but if you are on a D365 org, it will be longer.

See if any of these apps are showing as "Update Available" or "Installation Failed" and if so, click on them to install the latest version of that app:

Was this reply helpful? Yes No
ferris 42 on at

Like (0)

Report

Thanks I figured it was that. Everything looked normal there, but I decided to just hit install on Powerapps checker to see what happened (already said it was enabled). List completely refreshed with different items, one with update available so I will look into this and let you know how it goes.

Was this reply helpful? Yes No
halifaxious 217 on at

Like (0)

Report
I just started having the same export issue last night.
Export failed: There was an error adding a table to the project.
It is happening in at least 2 environments on the same tenant. Since I can't export, I haven't been able to determine if I also have a similar import problem.

Things I've done that have made no difference:
update all plugins with updates (only Powerapps Checker). My plugins only include the default set
completely log out of everything, reboot and re-login
check another environment on the same tenant. (same problem there)
try exporting from Default solution (same problem there)
try 'Edit data in Excel' option on Data tab, which produced a file with correct column headers but no data
Things that continue to work:
I can run fetch queries from XrmToolBox with no difficulty. So it doesn't appear to be a data problem
I can export to Excel from my application's UI (one would think this would fail the same way the 'Edit data in Excel' function in the backend fails)
@ferris did you ever come to a solution?

Was this reply helpful? Yes No