Latest Contributions by AdityarajChavada

Hi, We are using ArcGIS Desktop 10.4 with Python 2.7.10.  We trying to automate the task of rebuilding the indexes on tables/feature classes owned by the user account part of the regular multi-user geodatabase maintenance. We can rebuild the indexes on the user tables manually without any problems using Data Owner account. However, when using the python script example provided in the Esri's help - Rebuild Indexes—Help | ArcGIS Desktop (pasted below), # Import system modules import arcpy, os # set workspace workspace = "E:/sde/SDE_Data_Owner.sde" # set the workspace environment arcpy.env.workspace = workspace # NOTE: Rebuild indexes can accept a Python list of datasets. # Get a list of all the datasets the user has access to. # First, get all the stand alone tables, feature classes and rasters. dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters() # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy.ListDatasets("", "Feature"):     arcpy.env.workspace = os.path.join(workspace,dataset)     dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() # reset the workspace arcpy.env.workspace = workspace # Get the user name for the workspace userName = arcpy.Describe(workspace).connectionProperties.user.lower() # remove any datasets that are not owned by the connected user. userDataList = [ds for ds in dataList if ds.lower().find(".%s." % userName) > -1] # Execute rebuild indexes # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy.RebuildIndexes_management(workspace, "NO_SYSTEM", userDataList, "ALL") print('Rebuild Complete')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Unfortunately, the python script throws following error message for line 33 above. I feel that it is not liking the userDataList variable?  Any assistance in resolving this would be appreciated.  Thank you. ... View more

I have read the documentation here - Geodatabase compression—Help | ArcGIS Desktop. As per this documentation, it is required to delete all the versions if you require to FULLY compress the geodatabase. For a normal/routine compression, do you require to delete the versions? Does Esri recommend to delete all the versions to compress the SDE? We have over 25 user versions in the SDE. If we delete and create the user versions, the data editors are getting issues in the MXD (snapping needs to be reset). We are using Oracle 11g RDBMS with ArcGIS 10.4. Any insight on the subject matter will be hugely appreciated. Thank you. ... View more