topic Re: Create Role Error in Geodatabase Questions

Create Role Error

newbieGIS — Sat, 14 May 2016 20:27:47 GMT

I'm trying to Create Role using GP tool and encounter error.

[Operation succeeded with warning messages written to error log file] Error creating role. Failed to execute (CreateRole). Connected as sa. SQL Server 2014. ArcGIS Desktop 10.4.

Can anyone figure out what is wrong.

Re: Create Role Error

AdrianWelsh — Sun, 15 May 2016 02:17:12 GMT

Hi,

Have you tried following the steps at the following page:

Add logins and users to SQL Server—Help | ArcGIS for Desktop

Re: Create Role Error

AsrujitSengupta — Sun, 15 May 2016 13:10:34 GMT

You seem to be hitting a Bug:

BUG-000093032 - ‘Create Role’ tool fails with ‘Error Creating Role’ error for SQL Server geodatabases at 10.4

The workaround is to create the Role from the Database end.

For more information on this and to make sure you are hitting that Bug, please contact Esri Tech Support.

Re: Create Role Error

newbieGIS — Mon, 16 May 2016 05:10:32 GMT

Thanks for your suggestion Adrian Welsh. The logins. user, and privileges are Okay.

Thank you Asrujit SenGupta for the info regarding BUG .

Re: Create Role Error

WWalker — Fri, 06 Oct 2017 14:20:00 GMT

Is there any update regarding this bug?

Re: Create Role Error

Asrujit_SenGupta — Fri, 06 Oct 2017 14:39:57 GMT

As details of that Bug is not public, you will need to contact Esri tech Support for a status update mentioning the Bug#.

Re: Create Role Error

JayantaPoddar — Fri, 06 Oct 2017 14:41:32 GMT

Looks like it's fixed in ArcGIS 10.5.

NIM102049: Unable to revoke database roles from SQL Server 2012..

Re: Create Role Error

WWalker — Fri, 06 Oct 2017 17:17:13 GMT

While waiting for ESRI support to respond, I found a work around. Using the pyodbc python library, I was able to replace the following line in my script

arcpy.CreateRole_management(my_connection.sde, "EDITOR", "GRANT", "My Domain\Domain Users")

with

import odbc
conn = pyodbc.connect(r'DRIVER={ODBC Driver 11 for SQL Server};SERVER=MySqlServerInstance;DATABASE=my_database_name;Trusted_Connection=yes;')
cursor = conn.cursor()
cursor.execute("CREATE ROLE EDITOR AUTHORIZATION DBO")
cursor.execute("CREATE USER [My Domain\Domain Users]")
cursor.execute("EXEC sp_addrolemember 'EDITOR', 'My Domain\Domain Users'")
conn.commit()
conn.close()

I hope it helps someone else who doesn't like to wait

-WW

Re: Create Role Error

WWalker — Mon, 09 Oct 2017 16:13:55 GMT

ESRI support states this bug is fixed at 10.4.1.