My organization is upgrading from ArcGIS 10.3.1 to 10.5.1 where our SDE data is also being migrated from an Oracle11g to Oracle 12c database. The SDE Administrator needed to update an SDE feature class where the database needed to be compressed to state 0 and then a truncate and append needed to be performed on the SDE feature class as it's update procedure. This procedure failed with insuffucient permissions for the schema owner in Desktop 10.5.1, but this procedure worked as the schema owner in Desktop 10.3.1. As such it appears that there is a permissions issue when working with a 10.5.1 Oracle 12c database when using a 10.5.1 Desktop client.
Has anyone else encountered a similar permissions issue with SDE when working with 10.5.1?
The SDE Administrator will provide more detail on the error message later today.
Why should I need to create a new fc after the migration and upgrade to update a feature class in SDE using the above mentioned truncate and append method? I would potentially need to do this for all other SDE feature classes in the database which was not necessary with previous upgrades.
Here is the error message:
Executing: DeleteRows "Database Connections\ Default.sde\PHYSIOGRAPHIC.GEOLOGY_USGS"
Start Time: Wed Aug 16 12:31:24 2017
ERROR 999999: Error executing function.
Insufficient permissions [PHYSIOGRAPHIC.GEOLOGY_USGS][STATE_ID = 0]
Failed to execute (DeleteRows).
Failed at Wed Aug 16 12:31:24 2017 (Elapsed Time: 0.08 seconds)
The SDE Admin at my org created a case with ESRI tech support and they were able to replicate the permissions issue. The bug is noted as follows:
BUG-000107904-Insufficient permissions creating a new feature class in a feature dataset or deleting an existing feature class as the data owner in ArcGIS Desktop 10.5 and 10.6 with an Oracle database.
We are currently testing 10.5.1 with Oracle 12.2 on Windows 2016. I know 12.2 isn't supported but 12.1 of Oracle isn't supported on Windows 2016. We are getting weird permissions issues with deleting layers, by their owner. However the "Delete" toolbox in Data Management works (will delete the layers).