Invalid expression error, but expression works in different environment

Anonymous User — Sun, 12 Dec 2021 04:26:19 GMT

Hello,

I have a script that I created that automates a join and field calculation process across multiple feature classes. The script works when I test locally, but when I move it to another test environment, I receive an Invalid Expression error. Wondering if this could potentially be a permissions issue, or what could be causing this. The only differences between environments are the connection paths.

Here is the error message:

Traceback (most recent call last):
File "C:\Users\vueworks\Desktop\MDCETL\Testing_Logging.py", line 64, in <module>
vwfcin = arcpy.MakeTableView_management(sde+"\\"+vwfc, vwt)
File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\management.py", line 7047, in MakeTableView
raise e
ExecuteError: ERROR 000358: Invalid expression
Failed to execute (MakeTableView).

And the script.

import arcpy, sys, string, os, subprocess, logging

def getLogger():
    # Logs to console and log file
    logger = logging.getLogger()
    formatter = logging.Formatter("%(asctime)s [%(threadName)-12.12s] [%(levelname)-5.5s]  %(message)s")
    fileHandler = logging.FileHandler("MDC_ViewtoGIS_Automated.log")
    fileHandler.setFormatter(formatter)
    logger.addHandler(fileHandler)
    consoleHandler = logging.StreamHandler()
    consoleHandler.setFormatter(formatter)
    logger.addHandler(consoleHandler)
    logger.setLevel(logging.INFO)
    return logger

log = getLogger()
     
gdb = r'C:\Users\vueworks\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\MDC_ETL.sde'

gdbsdeds = "MDC_ETL.DBO."

sde = r'C:\Users\vueworks\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\MDCTest_1025.sde'

sdeds = "MDCTest_1025.dbo.ViewETL_FacilityType_"

gdbee = gdbsdeds+"Exterior_Electrical"
gdbem = gdbsdeds+"Exterior_Mechanical"
gdbfs = gdbsdeds+"Facility_Site"
gdbfp = gdbsdeds+"Fish_Production"
gdbg = gdbsdeds+"Generic"
gdbhm = gdbsdeds+"Hydrology_Management"
gdbr = gdbsdeds+"Range"
gdbswm = gdbsdeds+"Storm_Water_Management"
gdbwm = gdbsdeds+"Wastewater_Management"
gdbwc = gdbsdeds+"Water_Conveyance"

gca = vca = "Conservation_Area_Name"
gcn = vcn = "Conservation_Area_Number"
gn = vn = "Network"
gan = van = "Asset_Name"

gfi = "Field_ID"
gai = "Asset_ID"
gt1n = "Tier_1_System_Name"
gt1t = "Tier_1_System_Type"
gt2n = "Tier_2_Major_Subsystem_Name"
gt2t = "Tier_2_Major_Subsystem_Type"
gt3n = "Tier_3_Minor_Subsystem_Name"
gt3t = "Tier_3_Minor_Subsystem_Type"

vfi = "FieldID"
vai = "AssetID"
vt1n = "Tier_1_Name"
vt1t = "Tier_1_Type"
vt2n = "Tier_2_Name"
vt2t = "Tier_2_Type"
vt3n = "Tier_3_Name"
vt3t = "Tier_3_Type"

gdfc = gdbsdeds+"Phase_Converter_Exterior"
gdfcin = arcpy.MakeFeatureLayer_management(gdb+"\\"+gdbee+"\\"+gdfc, gdfc)

vwfc = sdeds+"PhaseConverterExterior"
vwfcin = arcpy.MakeTableView_management(sde+"\\"+vwfc, vwfc)

slct = gdfc+"."+gai+" IS NULL OR ("+gdfc+"."+gai+" <> "+vwfc+"."+vai+")"

try:
    arcpy.AddJoin_management(gdfc, gfi, vwfc, vfi)
    arcpy.SelectLayerByAttribute_management(gdfc, "NEW_SELECTION", slct)
    arcpy.CalculateField_management(gdfc, gdfc+"."+gai, "["+vwfc+"."+vai+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gca, "["+vwfc+"."+vca+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gcn, "["+vwfc+"."+vcn+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gn, "["+vwfc+"."+vn+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gt1n, "["+vwfc+"."+vt1n+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gt1t, "["+vwfc+"."+vt1t+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gt2n, "["+vwfc+"."+vt2n+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gt2t, "["+vwfc+"."+vt2t+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gt3n, "["+vwfc+"."+vt3n+"]", "VB", "")
    arcpy.CalculateField_management(gdfc, gdfc+"."+gan, "["+vwfc+"."+van+"]", "VB", "")
except:
    log.error(arcpy.GetMessages()) # log everything as ERROR (but should preserve order of messages)
     #log.warning(arcpy.GetMessages(1)) # log warning messages as WARN
    #log.error(arcpy.GetMessages(2))# log error messages as ERROR

arcpy.RemoveJoin_management(gdfc)
arcpy.SelectLayerByAttribute_management(gdfc, "CLEAR_SELECTION", "")
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Invalid expression error, but expression works in different environment

MichaelMiller2 — Mon, 21 May 2018 18:53:57 GMT

You might want to rethink the paths for gdb and sde, maybe create/copy the database connection to a shared location.

Re: Invalid expression error, but expression works in different environment

Anonymous User — Mon, 21 May 2018 18:58:00 GMT

I won't have control of the paths moving forward. For testing, I guess I can put them where ever, but once this is moved to another server, the default paths will be what I have to work with. I know named user paths can potentially introduce complications from what others have told me. Just confusing because the paths on my local machine are essentially the same, just with me as the user instead of a generic one, and the expression works fine.

topic Re: Invalid expression error, but expression works in different environment in Python Questions

Invalid expression error, but expression works in different environment

Re: Invalid expression error, but expression works in different environment

Re: Invalid expression error, but expression works in different environment