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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcpy Script Error Message - Function had no effect

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

<SPAN class="comment token"># Import system modules</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os

<SPAN class="comment token"># set workspace</SPAN>
workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"E:/sde/SDE_Data_Owner.sde"</SPAN>

<SPAN class="comment token"># set the workspace environment</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace

<SPAN class="comment token"># NOTE: Rebuild indexes can accept a Python list of datasets.</SPAN>

<SPAN class="comment token"># Get a list of all the datasets the user has access to.</SPAN>
<SPAN class="comment token"># First, get all the stand alone tables, feature classes and rasters.</SPAN>
dataList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListRasters<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Next, for feature datasets get all of the datasets and featureclasses</SPAN>
<SPAN class="comment token"># from the list and add them to the master list.</SPAN>
<SPAN class="keyword token">for</SPAN> dataset <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN>dataset<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; dataList <SPAN class="operator token">+=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># reset the workspace</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace

<SPAN class="comment token"># Get the user name for the workspace</SPAN>
userName <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>connectionProperties<SPAN class="punctuation token">.</SPAN>user<SPAN class="punctuation token">.</SPAN>lower<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># remove any datasets that are not owned by the connected user.</SPAN>
userDataList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ds <SPAN class="keyword token">for</SPAN> ds <SPAN class="keyword token">in</SPAN> dataList <SPAN class="keyword token">if</SPAN> ds<SPAN class="punctuation token">.</SPAN>lower<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".%s."</SPAN> <SPAN class="operator token">%</SPAN> userName<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Execute rebuild indexes</SPAN>
<SPAN class="comment token"># Note: to use the "SYSTEM" option the workspace user must be an administrator.</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>RebuildIndexes_management<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> userDataList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Rebuild Complete'</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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.

Najděte více příspěvků označených jako

Accepted answers

All comments

ChrisCool

Hi,

Having had the same problem and after studying the code, the problem comes from an error in the sample code from ESRI.
In fact, the first "." in the "find" function is too much!

Code before fix:
userDataList = [ds for ds in dataList if ds.lower().find(".%s." % userName) > -1]

Code after fix:
userDataList = [ds for ds in dataList if ds.lower().find("%s."% userName) > -1]

Chris

RonnieRichards

We are experiencing this same issue when running the ESRI example code with python. We have been running this code for several years and this never used to happen.

Performed a repair on the desktop install as Adityaraj Chavada mentioned above. This seemed to make Catalog work once and then it went back to reporting the "Function had no effect" error.

We are on 10.7.1 . What finally worked for us was to upgrade our geodatabases from 10.5.1. -> 10.7.1 and the Analyze & Rebuild Indexes function worked as expected. Wish the tool would report such issues it is capable of knowing the GDB and software releases and should report this clearly to the administrator!!!

In past versions the maintenance tools were rather stable working between versions of the geodatabase but that seems to be a new scenario which needs to be tested in future upgrades. bummer.

AdityarajChavada

Nevermind. I fixed the above issue by running repair on ArcGIS Desktop 10.4.1. Thank you for your support.

AdityarajChavada

Thanks for your reply, Joshua! So, I printed out the userDataList and it says []. Does this mean the list is empty?

bixb0012

Have you printed out the userDataList to make sure: 1) it is populated, and 2) it is populated correctly?

AdityarajChavada

Hi Dan!

Yes, the username exists. I tried using the Print Statement.The username in my GDB is GISUSER (all caps). Perhaps, the making it lower case is throwing it off?

DanPatterson_Retired

does the username exist? y

ou should throw a print statement in to see if it is matches one of yours

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Přihlásit se
Registrovat

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.