topic Re: SDE 10.5.1 Permissions Issue in Geodatabase Questions

SDE 10.5.1 Permissions Issue

MichaelVolz — Wed, 16 Aug 2017 12:34:03 GMT

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?

Re: SDE 10.5.1 Permissions Issue

Asrujit_SenGupta — Wed, 16 Aug 2017 12:37:52 GMT

What exact error message do you observe?

Tried creating a new FC after the migration and upgrade?

Re: SDE 10.5.1 Permissions Issue

MichaelVolz — Wed, 16 Aug 2017 12:46:45 GMT

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.

Re: SDE 10.5.1 Permissions Issue

Asrujit_SenGupta — Wed, 16 Aug 2017 12:54:42 GMT

The new FC creation was suggested just as a Test to make sure the all permissions are in place. That has got nothing to do with this issue in particular.

Re: SDE 10.5.1 Permissions Issue

MichaelVolz — Thu, 17 Aug 2017 12:22:34 GMT

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)

Re: SDE 10.5.1 Permissions Issue

Asrujit_SenGupta — Sun, 20 Aug 2017 17:06:51 GMT

Anything logged in the Direct connect log file while executing this?

Re: SDE 10.5.1 Permissions Issue

MichaelVolz — Mon, 11 Sep 2017 16:41:41 GMT

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.

Re: SDE 10.5.1 Permissions Issue

BobNutsch1 — Mon, 11 Sep 2017 20:03:27 GMT

Thanks for posting this BUG. We've been running into some sporadic issues, both using 10.5.1 python and desktop. 10.4.1 is just fine. I hope we can get a patch soon!

Re: SDE 10.5.1 Permissions Issue

SherrieKubis — Fri, 15 Sep 2017 14:46:23 GMT

Yes, thank you for the post. We are planning to upgrade to Oracle 12.2 and 10.5.1 from Oracle 12.1 and 10.4.1 soon, and I was hoping for no problems

Sherrie

Re: SDE 10.5.1 Permissions Issue

DanielMcAlister — Thu, 21 Sep 2017 16:23:51 GMT

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

Re: SDE 10.5.1 Permissions Issue

BobNutsch1 — Mon, 02 Oct 2017 18:54:00 GMT

I can confirm that this bug is present with 10.5.1 (including 64-bit Python) and Oracle 11g. The "workaround" for us, both renaming feature classes with ArcCatalog and running Python scripts, is to either go back to 10.4.1 or to remove a read-only role, leaving us with just a write role. Esri support was unable to tell me if a patch will come out or if it will be fixed in 10.6.x.

Re: SDE 10.5.1 Permissions Issue

BobNutsch1 — Tue, 14 Nov 2017 13:56:30 GMT

Esri recently released a patch http://support.esri.com/en/download/7548 which I have installed on my 10.5.1 installation and wahoo, the bug as I observed it has been fixed.

Re: SDE 10.5.1 Permissions Issue

MichaelVolz — Tue, 14 Nov 2017 16:03:10 GMT

Bob:

Are you saying that the patch fixed this issue in your environment which is Desktop 10.5.1 used against an Oracle 11g database? If not, what is the specific version of Oracle that you are using?

Re: SDE 10.5.1 Permissions Issue

BobNutsch1 — Tue, 14 Nov 2017 18:18:20 GMT

Hi Michael,

Yes, Desktop 10.5.1 against Oracle 11gR2

Regards, Bob