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

[bryanmay]

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

[Lake_Worth_BeachAdmin]

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

[bryanmay]

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.

[Lake_Worth_BeachAdmin]

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. 

[bryanmay]

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

[Lake_Worth_BeachAdmin]

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]

BUG-000109584

[NicolasGIS]

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

[CaraMoore]

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

[CaraMoore]

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