topic Re: Failed Exporting from Enterprise GDB 10.6.1 in ArcMap Questions

Failed Exporting from Enterprise GDB 10.6.1

Lake_Worth_BeachAdmin — Tue, 18 Sep 2018 12:56:06 GMT

I am running ArcGIS Desktop 10.6.1 with SQL Server 2016 as my enterprise GDB.

When I import a FC into Arcmap from the Enterprise GDB and right click tyhe layer, export to shapefile I get the following error.

I can reproduce this behavior on ALL* 2k+ Feature classes in my database.

the only way for me to export a FC to shapefile is to do so via the Catalog Pane.

is this a known BUG in 10.6.1?

Re: Failed Exporting from Enterprise GDB 10.6.1

MichaelVolz — Tue, 18 Sep 2018 13:53:05 GMT

I am seeing the same error when exporting Oracle SDE feature classes out to shapefiles. The Oracle SDE database is still version 10.5.1 as the desktop software is 10.6.1. Did you already upgrade your SQL Server 2016 SDE database to 10.6.1?

Re: Failed Exporting from Enterprise GDB 10.6.1

Lake_Worth_BeachAdmin — Tue, 18 Sep 2018 14:22:29 GMT

Yes the SQL Server is running 10.6.1 geodatabase release.
I just tried to upgrade it again to verify and it failed stating that its already running the latest release.

Re: Failed Exporting from Enterprise GDB 10.6.1

BillFox — Wed, 19 Sep 2018 15:09:45 GMT

BUG-000115801

Workaround -

In the layers attribute table, select all the rows

Then try export again

Re: Failed Exporting from Enterprise GDB 10.6.1

Lake_Worth_BeachAdmin — Wed, 19 Sep 2018 15:25:06 GMT

meh, hassle in my workflow. do you know if this will be patched in the next 10.6.+ release?

Re: Failed Exporting from Enterprise GDB 10.6.1

BillFox — Wed, 19 Sep 2018 15:34:43 GMT

"the esri developer team is reviewing the bug"

Re: Failed Exporting from Enterprise GDB 10.6.1

bbieb — Thu, 27 Sep 2018 14:03:17 GMT

We also ran into this. Seems to work fine in ArcCatalog. Basic functionality broken.....

Re: Failed Exporting from Enterprise GDB 10.6.1

Lake_Worth_BeachAdmin — Thu, 27 Sep 2018 17:37:51 GMT

Any response from ESRI addressing this issue?

Re: Failed Exporting from Enterprise GDB 10.6.1

bbieb — Wed, 17 Oct 2018 19:43:07 GMT

I had them add my Support call to the bug # above. Their suggestion was to use a selection set. My impression is that it wasn't a high priority since they had a work around.

brian

Re: Failed Exporting from Enterprise GDB 10.6.1

Anonymous User — Wed, 07 Nov 2018 15:45:53 GMT

We are seeing this error as well. We can export via ArcCatalog and Pro, and it works when data is selected first in ArcMap.

Re: Failed Exporting from Enterprise GDB 10.6.1

Anonymous User — Tue, 20 Nov 2018 20:14:22 GMT

I have the same issue as well with a 10.6.1 desktop, SQL database (2012) SDE owned schema, I am only able export from the stand alone ArcCatalog application.

Re: Failed Exporting from Enterprise GDB 10.6.1

WilliamRice — Mon, 07 Jan 2019 17:15:40 GMT

I also encountered this issue today. Using the ArcMap Data > Export Data tool, I am also unable to export any feature classes or tables from our Enterprise SQL Server Geodatabase without selecting any records first. This new behavior with 10.6.1 breaks functionality that has been around since version 8.x . I am able to export data from File Geodatabases without selecting any records first.

Re: Failed Exporting from Enterprise GDB 10.6.1

DavidAllen — Mon, 21 Jan 2019 14:32:39 GMT

Same issue - but I'm trying to export the Cartographic Representation geometry override. Can't do that in Catalog. And even though it used to do this, it apparently doesn't any more.

I have my water system with hydrant locations. The symbolized location isn't always exactly on top of the true location because of readability. But I have a representation override that has a new symbol that has been placed exactly over every hydrant. I need to export the representation location but that no longer works.

Re: Failed Exporting from Enterprise GDB 10.6.1

CCGISCOOP — Wed, 23 Jan 2019 17:10:02 GMT

I would like to know is there's any response from Esri (or any update to that bug ticket) - people don't like extra clicks, especially when this has always worked before... please restore this basic functionality!

Re: Failed Exporting from Enterprise GDB 10.6.1

DavidLok2 — Fri, 25 Jan 2019 01:28:05 GMT

This bug should really be fixed ASAP - not only from the user standpoint but also from the standpoint of supporting other GIS users in an organization.

Thanks for those who share the tips and the workaround works - by selecting records first, it will export. Yet, this is NOT the proper way to export data. It is very hard to expect in support role we tell user to deal with this kinds of problem by asking user to do this kind of work around.

The experience was as what the other stated here - when exporting the data (hosted in Oracle Enterprise), it always cites the error and the message is also somewhat misleading. When copying the data out to a local new geodatabase, it will export. Alternatively (as the others said) selecting all records first, it will export (data hosted in Oracle Enterprise), Yet, this is really not a proper workflows to export data.

This is very basic function and is broken!

ESRI, please fix this bug ASAP.

Re: Failed Exporting from Enterprise GDB 10.6.1

JeffreyHolden — Tue, 19 Feb 2019 21:49:04 GMT

We are getting this issue at Washington State Department of Natural Resources after upgrading to ArcGIS 10.6.1 Desktop and Oracle SDE 10.6.1.

We hope it is fixed soon, but if you select all or some records you can then export.

Re: Failed Exporting from Enterprise GDB 10.6.1

RichardDaniels — Wed, 20 Feb 2019 17:21:44 GMT

Same Issue with SQL Server 2016 etc. Issue exists when exporting to a Shapefile or file Geodatabase. Workarounds are to use 'All features In View Extent' or 'Selected features' during the Data Export. Note - Export of Shapefile to File Geodatabase works without error.

Re: Failed Exporting from Enterprise GDB 10.6.1

RichardDaniels — Wed, 20 Feb 2019 17:22:12 GMT

We upgraded this week too! :-0

Re: Failed Exporting from Enterprise GDB 10.6.1

Robert_LeClair — Wed, 20 Feb 2019 17:35:43 GMT

Looks like a ArcGIS Desktop 10.6.1 Exporting Data from a Layer Patch was released 2/8/2019 to resolve BUG-000115801. You can download it from here.

Re: Failed Exporting from Enterprise GDB 10.6.1

RichardDaniels — Wed, 20 Feb 2019 18:06:23 GMT

and it appears to work without causing side effects (unlike the TLS patch for 10.5.1 which resets all your ESRI ArcGIS Desktop 10.5.1 reg settings to factory default ;-).