topic Re: makeQueryTable fails to execute in Python Questions

makeQueryTable fails to execute

DaveTaylor — Thu, 31 Oct 2013 11:45:23 GMT

I had this working on my local computer but when switching it over to the server it is failing with the following error:

Failed to execute. Parameters are not valid.
ERROR 000793: Invalid data element type
ERROR 000840: The value is not a Raster Layer.
Failed to execute (MakeQueryTable).

I think is has something to do with the OLE DB connection...when I open the connection in arcCatalog it takes a longgggg time to open. Maybe it is timing out in the script and thus that is why it is failing? I have included my code below too.

    tableList = ["DATABASE CONNECTIONS/prod.odc/sales"]
    fieldList = ["sales.id",'id']
    whereClause = "sales.CREATED_DATE between to_date(sysdate, 'DD-MON-YYYY') AND SYSDATE"
    keyField = "sales.id"
    lyrName = "live_sales"

    #Create the spatial reference for the output layer.
    sr = arcpy.SpatialReference("WGS 1984 UTM Zone 12N")
    # Create a query layer
    arcpy.MakeQueryTable_management(tableList, lyrName,"USE_KEY_FIELDS", keyField, fieldList, whereClause)
     # save the created query layer
    arcpy.SaveToLayerFile_management(lyrName,"I:/sales.lyr", "ABSOLUTE")
# Print the total rows
    print arcpy.GetCount_management(lyrName)

Thanks in advance!

Re: makeQueryTable fails to execute

MattSayler — Sat, 11 Dec 2021 16:04:25 GMT

Might be your fieldList variable. Looking at the docs, I think that should be a list of lists.

fieldList = [["sales.id",'id']]

Also: http://forums.arcgis.com/threads/48475-Please-read-How-to-post-Python-code

Re: makeQueryTable fails to execute

DaveTaylor — Sat, 11 Dec 2021 16:04:28 GMT

sorry about the code...here it is...I tried changing fieldList too and that didnt work either:

tableList = ["DATABASE CONNECTIONS/prod.odc/sales"]
fieldList = ["sales.id",'id']
whereClause = "sales.CREATED_DATE between to_date(sysdate, 'DD-MON-YYYY') AND SYSDATE"
keyField = "sales.id"
lyrName = "live_sales"

#Create the spatial reference for the output layer.
sr = arcpy.SpatialReference("WGS 1984 UTM Zone 12N")
# Create a query layer
arcpy.MakeQueryTable_management(tableList, lyrName,"USE_KEY_FIELDS", keyField, fieldList, whereClause)
# save the created query layer
arcpy.SaveToLayerFile_management(lyrName,"I:/sales.lyr", "ABSOLUTE")
# Print the total rows
print arcpy.GetCount_management(lyrName)