laptop and a wrench

Bug

arcpy.ArcSDESQLExecute() cannot return Global ID (GUIDs) for datasets in an SQL Server database.

Last Published: July 23, 2019 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000087275
SubmittedApril 27, 2015
Last ModifiedJanuary 28, 2021
SeverityMedium
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
Operating SystemWindows
Operating System Version7 64 Bit
StatusNon-Reproducible

Additional Information

Unable to reproduce this issue as submitted. If this is still an issue in the current version, please contact Esri Support Services.

Workaround

Convert the Global ID field to nvarchar. For example: conn= arcpy.ArcSDESQLExecute(r'Database Connections\sde_user1.sde') conn.execute('select convert(nvarchar(50),GlobalID)from sde.user1.cities')

Steps to Reproduce

Bug ID: BUG-000087275

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback