AnsweredAssumed Answered

Delete/Append Python script causes data issues after upgrade from 10.0 to 10.3.1

Question asked by shaneber on Sep 16, 2019
Latest reply on Sep 17, 2019 by shaneber

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

 

Outcomes