I wrote a script, and when I run it, it fails at the same spot for me and my colleagues every time. Here is a screen shot of the error:
The script is working with features located in a SDE environment, and given the part of the error "Underlying DBMS error [ORA-25402: transaction must roll back]" I'm thinking it has something to do with trying to access that database?
Additionally, if I copy the line of code that includes the SelectLayerByLocation function and enter that into the python window manually, it works fine. I can run the rest of the script, and there are no issues. It's only when the script is run from the beginning that it fails.
ArcGIS Pro 2.4.1 is being used.
I'm wondering if anyone has any experience or insight with this function and errors with working with data in an SDE.
I attached images of the script itself.