XML Workspace document import duplicate error

Question

I have exported an XML workspace schema for an enterprise geodatabase using ArcMap 10.4.1. Now that when I am trying to import it to a local file geodatabase, it gives the following error

\ArcGIS\sde_ExportXMLWorkspaceDocume.xml SCHEMA_ONLY #
ERROR 999999: Error executing function.
Cannot create a table with a duplicate column.
Cannot create a table with a duplicate column.
The operation was attempted on an empty geometry.
Failed to execute (ImportXMLWorkspaceDocument).

I even used ArcCatalog to see if the conflicts were indicated by the red color, but there was none, yet still, when running the tool, it gives the above error. I am only exporting the schema without the data.

What might be an issue here? I looked into other posts, but there was an issue with using different versions of ArcMap. But in my case, I am using the same version for importing and exporting.

@MelissaJarman, @JoshWhite, and @Asrujit_SenGupta, can you have a look at this issue.

MelissaJarman · Answer

Sorry I don't have a specific solution to recommend. XML workspace documents do allow schema only option, so this is a reasonable workflow for you to attempt.

To troubleshoot this I would try the process of elimination to isolate the culprit that is causing the import to fail. Perhaps exclude the views in your first pass and go from there to see if the cause can be determined.

arahman_mdmajid · Answer

I would appreciate it if you or any other expert could recommend how to export and share the schema. Since it is an old database and has multiple relations, removing these relationships might not be possible. There is got to be another way around it.

@George_Thompson, @JayantaPoddar

Thanks

arahman_mdmajid · Answer

Thanks @MelissaJarman  for the reply.

There are some relationship classes and topologies in some data sets. Also, there are some Views created.

I wanted to share the schema of our current EGDB without the data, so I generated the XML workspace document.

I also tried it with ArcGIS Pro version 2.8.2. I first exported the new XML document and then imported it in an empty File GDB, but I am getting the same error.

However, this time the error was a bit specific, here at this link.

So how do we share such EGDB that have relationships and topologies in them?