topic Re: Arcpy Script Error Message - Function had no effect in Python Questions

Arcpy Script Error Message - Function had no effect

AdityarajChavada — Sat, 11 Dec 2021 17:03:25 GMT

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.

Re: Arcpy Script Error Message - Function had no effect

DanPatterson_Retired — Sun, 21 Jan 2018 12:57:17 GMT

does the username exist? y

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

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Sun, 21 Jan 2018 13:48:13 GMT

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?

Re: Arcpy Script Error Message - Function had no effect

JoshuaBixby — Sun, 21 Jan 2018 16:00:30 GMT

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

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Sun, 21 Jan 2018 16:09:07 GMT

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

Re: Arcpy Script Error Message - Function had no effect

JoshuaBixby — Sun, 21 Jan 2018 16:10:08 GMT

Yes, you have an empty list, thus the function has "no effect."

Re: Arcpy Script Error Message - Function had no effect

DanPatterson_Retired — Sun, 21 Jan 2018 16:11:20 GMT

[] is an empty list, so you had better back up a few lines and see where the empty lists are being passed. Also, the list would be empty if the index had already been rebuilt and doesn't need rebuilding for that user

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Sun, 21 Jan 2018 16:12:24 GMT

Is there any way to correct the script to correctly populate the list?

Re: Arcpy Script Error Message - Function had no effect

DanPatterson_Retired — Sun, 21 Jan 2018 16:14:54 GMT

see my previous post and check the affect that 'lower' has on the tests as well.

Print statements are cheap, but make sure you are printing what is being passed into your tests since you are changing text case in places

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Sun, 21 Jan 2018 16:18:34 GMT

Okay. I printed the dataList and it is printing the entire list. Does that mean that line 26 and 29 are creating issues with list. So, when I try to pass this dataList directly to the tool (after commenting line 26 and 29), python freezes and crashes.

Re: Arcpy Script Error Message - Function had no effect

DanPatterson_Retired — Sun, 21 Jan 2018 16:26:41 GMT

your lines numbers quoted versus those in the original post aren't in sync which lines exactly

In this line

userName = arcpy.Describe(workspace).connectionProperties.user.lower()

print(username) # check the username versus the 'user'

# remove any datasets that are not owned by the connected user.

Add these two lines before the userDataList line

for ds in dataList:

print(ds, ds.lower(), userName )

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

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Sat, 11 Dec 2021 17:03:28 GMT

Thanks again for your help, Dan! The following lines below commented out.

# 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]

The reason is that we only have one data owner - GISUSER (all caps). Would it make sense to take the above lines out and directly pass the dataList variable to the tool?

for dataset in arcpy.ListDatasets("", "Feature"):
    arcpy.env.workspace = os.path.join(workspace,dataset)
    dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets()

Re: Arcpy Script Error Message - Function had no effect

DanPatterson_Retired — Sun, 21 Jan 2018 19:07:34 GMT

Why not try it, you are the only one that can test

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Mon, 22 Jan 2018 04:06:04 GMT

I tried it couple times and python crashes. See below.

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Mon, 22 Jan 2018 05:19:26 GMT

I printed the DataList and it is printing all the tables and feature classes (without the feature dataset in front). I believe the tool needs the inputdataset in the following format. Please correct me if I am wrong.

Can this be added automatically in list?

"user"+ "." + feature dataset" + "\" + user + "." + "feature class"

Re: Arcpy Script Error Message - Function had no effect

AdityarajChavada — Wed, 24 Jan 2018 08:12:31 GMT

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

Re: Arcpy Script Error Message - Function had no effect

RonnieRichards — Tue, 23 Jun 2020 19:51:43 GMT

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.

Re: Arcpy Script Error Message - Function had no effect

ChrisCool — Wed, 08 Mar 2023 22:41:26 GMT

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