Error during XML Data Import : File " XML FILE NAME " is not a valid XML and has been deleted

[pardhiv]

I exported data from table in one Instance and tried to import data into a new instance. Scope is same in both Instances (Global).

At the end of Import it says : File " XML FILE NAME " is not a valid XML and has been deleted.

I did this before for 5 records and they worked fine . This XML has more records and it throws the above error

[Saurav11]

Hello,

This generally happens when the data contains any character or element which is not considered in xml and then it throws an error. There many be one or few records which has some field which contains data causing this issue.

Please try the below XML validator and see it it gives any error:-

https://codebeautify.org/xmlvalidator

Please mark my answer as correct based on Impact.

[pardhiv]

Thanks, this is the error .

Invalid '[ "unload", "sys_attachment_doc"]' found.

Do you know how this can be fixed ? (can XML be edited to remove these statements and have all rest of data migrated ?)

[Saurav11]

To me it seems that there is an attachment causing the issue. You can just remove the record from the list which ahs that attachment and then export the XML and import it should do the trick.

Please mark my answer as correct based on Impact.

[pardhiv]

There are around 3000 of them on 400 records . Will removing them impact any attachment data.