topic Re: Export XML failed whit relationship class into SQL Server sde connection in Geodatabase Questions

Export XML failed whit relationship class into SQL Server sde connection

cursoprueba — Tue, 23 Jun 2015 16:11:03 GMT

Hi everybody,

I have ArcGIS for Desktop 10.3.1 (Advanced), I am trying to export my database (in SQL Server) with the XML exporting option, but an error appears:

This DB has 2 non-spatial tables,1 feature class and a relationship class between the feature class (points) and one of the non-spatial tables which was created using the geocode toolbar in order to locate addresses, I don't know if it happens because of the relationship.
I have exported my other DB without any problem.

I will appreciate if someone could help me with this issue.

Re: Export XML failed whit relationship class into SQL Server sde connection

AsrujitSengupta — Tue, 23 Jun 2015 17:01:46 GMT

Try simple Copy\Paste. Does that work?

Re: Export XML failed whit relationship class into SQL Server sde connection

cursoprueba — Tue, 23 Jun 2015 19:54:31 GMT

Hi Asrujit,

I have tried to do that but the following message appears:

Re: Export XML failed whit relationship class into SQL Server sde connection

AsrujitSengupta — Tue, 23 Jun 2015 20:11:47 GMT

Run 'Check Geometry' on the data and check if that reports anything.

Also, try to simply Export the data to the sde gdb (it won't carry the Relationship Class) and check if that works. This is just for testing.

Re: Export XML failed whit relationship class into SQL Server sde connection

cursoprueba — Thu, 25 Jun 2015 17:46:24 GMT

I can't run 'Check Geometry' because it is SDE geodatabase, so automatically checks the validity of the geometry.

Then I have exported the SDE geodatabase without the relation and the result was successfully.

So maybe the problem is related to the 'relationship classes'? I am thinking that it comes from the geocoding, because when the locations are generated from the addresses of a table, the link or relation is between the following fields:

And as I know a relation shouldn't use the ObjectID but there is no options to change or even choose the fields to make the relation before running the process.