Import XML error - Permission Dinied

[Kohei4]

Hello,

I have faced an issue I have not faced before.

When I try to import an xml file to QA instance, that is dinied with below error.
Skipping record for table sys_user_role and id <sys_id> - permission denied

Because I am using security admin user, not expected to this issue.

Do you have any advice for me?
Do you know if this issue is related to SanDiego upgrade?

[Muralidharan BS · Accepted solution]

HI Kohei,

It may not be because of security admin but because of the wrong scope, you may be in. 

You have to be on the same exact scope to which the XML belongs and then try to import it. If you use a different application and import files to another one, it won't work. 

Thanks

[Kohei4]

Thanks! It worked after scope change

[Rachel Gomez]

When multiple XML data files are selected to import and Excel fails to find a matching XML map for any specific files among these multiple files.

A file whose name is mentioned in the title bar, you need to import the appropriate schema for it first. After then import the file one more time.

Import an XML data file as an XML table
Tap to the Developer tab and then on the Import
Now on your screen the dialog box of Import XML In this box brose and choose the XML data files you are willing to import.
Then tap to the import
If your XML file doesn’t have any schema then Excel concludes the schema through the XML file.

Now from the dialog box of Import Data, choose any of the options:
XML table in the existing worksheet: this option will import the data of the XML file into the XML table within a specified location in your worksheet.
XML table in the new worksheet: choosing this option will import entire file data into the XML table of a new worksheet.
You will see that the XML data file’s schema appears in the task pane of XML Source.

If in case the XML data file fails to refer to the schema, then in such a situation Excel will conclude the schema of the XML data file.
For making changes in the XML data behavior such as format, data binding, and layout just make a tap on the Properties option. This will open the dialog box of XML Map properties.

Regards,

Rachel Gomez