GlobalID

Question

Could someone tell me how to register a column as GlobalID using a script.

First I create table in database with sql script.

Next I register it as sdelayer -o register -l M_SIGN_INVENTORY,GEOM -u %USERID% -p %USERPASSWORD% -e 3npM -x 0,0,3048 -z 0,10000 -P HIGH -t SDO_GEOMETRY -G file=%CRSFILE%

My table has column [GLOBALID], how do I tell esri to use that column as GlobalID.

If I use ArcCatalog and right click on my FeatureClass and select Add GlobalID it creates new column, [GLOBALID1].

HeatherMcCracken · Answer

fyi - In ArcObjects you can register a GUID field as a GlobalID field (or vice versa) using the IClassSchemaEditEx interface

http://help.arcgis.com/en/sdk/10.0/vba_desktop/componenthelp/index.html#/IClassSchemaEditEx_Interface/001w000000v0000000/

AlexProtyagov · Answer

Ok, I got the python scrip working.

I changed in_dataset = "AMS_AA.M_SIGN_INVENTORY"

to in_dataset = "M_SIGN_INVENTORY"

and the connection file, MySDEdata.sde, copied it from my 
c:\Users\xyz\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\ams_aa.py. In connection properties I set to save user name and password in that file..

AlexProtyagov · Answer

I did try what you suggested:
sdelayer -o register -l M_SIGN_INVENTORY,GEOM -C OBJECTID -u %USERID% -p %USERPASSWORD% -e 3npM -x 0,0,3048 -z 0,10000 -P HIGH -t SDO_GEOMETRY -G file=%CRSFILE%

sdetable -o add_uuid_column -t M_SIGN_INVENTORY -u %USERID%  -p %USERPASSWORD% -c GLOBALID

The add_uuid_column, as I found, has nothing to do with GlobalID because after replication of feature layers the features are read-only which implies that GlobalId is not defined as esri sees that.

Last thing to try is a python script:
# Import system modules
import arcpy
from arcpy import env

# Set workspace
env.workspace = "C:/Data/MySDEdata.sde"

# Set local variables
in_dataset = "AMS_AA.M_SIGN_INVENTORY"

# Execute AddGlobalIDs
arcpy.AddGlobalIDs_management(in_dataset)

Where AMS_AA is schema name, [M_SIGN_INVENTORY] is feature class name, the same as Oracle table. However, the scrip above fails with errorExecuteError: ERROR 000582: Error occurred during execution.
Failed to execute (AddGlobalIDs).

However, I do not know anything about python, I just took above script from documentation and replaced feature class name with mine.