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

1820
12
04-11-2017 07:49 AM
bryanmay
New Contributor II

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).

0 Kudos
12 Replies
Lake_Worth_BeachAdmin
Regular Contributor

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

0 Kudos
bryanmay
New Contributor II

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.

0 Kudos
Lake_Worth_BeachAdmin
Regular Contributor

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. 

0 Kudos
bryanmay
New Contributor II

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

0 Kudos
Lake_Worth_BeachAdmin
Regular Contributor

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. 

GeorgeKatsambas
Occasional Contributor III

BUG-000109584

0 Kudos
NicolasGIS
Regular Contributor

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

0 Kudos
CaraMoore
New Contributor II

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

0 Kudos
CaraMoore
New Contributor II

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

0 Kudos