topic Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset? in Data Management Questions

Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

bryanmay — Tue, 11 Apr 2017 14:49:39 GMT

Using a script that I found on Stack Exchange(attached), I am able to replicate everything in my enterprise geodatabase to file geodatabase except the Facilities dataset. Can anyone help with why only the Facilities Dataset fails to copy?

When I isolate the Facilities Dataset in the code it does copy properly but always fails in the scheduled script and in the the full script. My enterprise geodatabase is based on the LGIM. We are in ArcGIS 10.5 on SQL Server The script is called from Windows Task Scheduler. I get this error

[INFO] [04/10/2017 05:32:29 PM] [75] - Atempting to Copy Facilities to C:\AC\BackUps\20170410AC_Pro.gdb\Facilities
[INFO] [04/10/2017 05:33:12 PM] [79] - Unable to copy Facilities to C:\AC\BackUps\20170410AC_Pro.gdb\Facilities
[INFO] [04/10/2017 05:33:12 PM] [80] - ERROR 000260: Failed to copy C:\Users\bmay\AppData\Roaming\ESRI\Desktop10.5\ArcCatalog\AC_Pro.sde\AC_Pro.DBO.Facilities into C:\AC\BackUps\20170410AC_Pro.gdb\Facilities
ERROR 000260: The table already exists.--The item was not found.--The item was not found.
Failed to execute (Copy).

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

Lake_Worth_BeachAdmin — Wed, 12 Apr 2017 13:16:29 GMT

Is there a duplicate facilities dataset? the error says its not found and then says it already exists.... lol

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

Lake_Worth_BeachAdmin — Wed, 12 Apr 2017 14:05:47 GMT

I used this same script also getting....

RROR 000260: Failed to copy C:\Users\fefefefef\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\myDB.sde\myDB.DBO.COMM_SUST_PLANNING_ZONING into C:\Users\fefefefefefeffef\Desktop\SDE_Replica\SDE_replica_4.12.gdb\COMM_SUST_PLANNING_ZONING

got a 3 of these errors but the 745+ features copied successfully.... not sure whats rasing this error.

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

bryanmay — Wed, 12 Apr 2017 16:56:06 GMT

The script creates a new gdb but it does create the Facilities Dataset 5 times Facilities_1, .._2 etc. and copies 5 of the 25 or so feature classes.

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

bryanmay — Wed, 12 Apr 2017 16:57:16 GMT

So are the datasets that if fails on for you non- Facilities?

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

Lake_Worth_BeachAdmin — Wed, 12 Apr 2017 17:22:13 GMT

I noticed that the datasets that raised errors had incomplete feature classes (empty/blank). Once I removed those feature classes it seemed to work fine.

I would go back and review the data sets that caused the errors to ensure the data is not corrupted.

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

GeorgeKatsambas — Thu, 29 Mar 2018 17:34:35 GMT

BUG-000109584

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

NicolasGIS — Wed, 23 Jan 2019 07:39:17 GMT

Hi,

I just upgraded from 10.4.1 to 10.6 and now my script is failing with the same error:

ERROR 000260: The table already exists.--The item was not found.--The item was not found. Failed to execute (Copy)

No table has the same name and this script ran successfully on 10.4.1.

Feature classes has attachments : BUG-000109584

BUG-000109584: The Copy tool does not execute successfully in ArcGIS Desktop when copying feature datasets with image attachments.

Thanks

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

MicahBabinski — Thu, 11 Apr 2019 22:24:34 GMT

Does the facilities dataset have related tables?

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

CaraMoore — Mon, 01 Jul 2019 22:10:28 GMT

I am having the same issue with a model that worked fine on 10.5, but now fails in 10.6.1.

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

CaraMoore — Mon, 01 Jul 2019 22:13:45 GMT

"ERROR 000260: The table already exists.
ERROR 000260: The table already exists.
Item not found in this collection.
Failed to execute (Make Feature Layer)."

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

CaraMoore — Mon, 01 Jul 2019 23:50:58 GMT

Just got off the phone with ESRI, we cleared the caches and that seemed to do the trick. They are located at:

C:\Users\Username\AppData\Local\Temp·

C:\Users\Username\AppData\Local\ESRI\Local Caches

Re: Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset?

Kathleen_Crombez — Wed, 27 Oct 2021 14:30:51 GMT

we have the same issue. Script ran fine in ArcMap version 10.4.2

it was never fixed and continued all the way through to version 10.8.1

Was hoping they would have fixed this in Pro, but this bug appears to still exist in Pro 2.8.4