I have a python script that does a simple delete and append which updates feature class's in a GDB daily.
The updates come from a source database (Oracle 220.127.116.11.0)(10.0 GDB).
The target GDB is ArcGIS 10.5.
The original python script was hosted on a ETL server (windows 2003 -ArcGIS 10.0/Python 2.6).
This script was working perfectly for years running the updates from the Oracle database out to the target Geodatabases.
I recently moved the ETL script to a newer server with newer software (windows 2008 -ArcGIS 10.3.1/Python 2.7).
This immediately started causing issues with Geodatabases.
It caused the website that displays the data to hang and when viewed in ArcMap the feature classes took 3/4 times as long to draw and even longer to query.
When I rolled back my upgrade and put the scripts back on the old server, everything was perfectly fine again.
I have narrowed it down to the append process in ArcGIS 10.3.1.
The reason is not the obvious (that I am appending data from a 10.0 GDB to 10.5.1 using a python script in 10.3.1).
I know this because I have copied the target GDB to my ETL server and the feature class works fine in ArcMap. If I then run the delete and append script from a second copy of the GDB the issue arises. The data is identical in both GDBs so I am wondering is this an issue with the append tool in ArcGIS 10.3.1?
Has anyone else experienced this issue? I am at a loss as to how to proceed