Make Query Table - ERROR 000152: Invalid input data

Question

Original User: sstrand@ocwd.com
Original Date: 2013-04-18T13:54:51-0600

I am trying to use the Make Query Table to join two tables in a one to many situation.

I don't want to link the entire script because it is huge. Here is the piece of code within the larger script:sqltable = "sqltable_" + InfoRequestNum
inList = ["wellresult","westbays"]
wellsList = ["wellresult.STAID1_T","wellresult.STAID2_T","westbays.STAID4"]
arcpy.MakeQueryTable_management(inList, sqltable, "USE_KEY_FIELDS", wellsList, "", "")

Some info about the script:
Everything is taking place in a file geodatabase.
wellresult is a point featureclass
westbays is a table
Each point has a STAID1_T but there are multiple STAID4 that relate to one STAID1_T
The output should be sqltable.

The error:
ERROR 000152: Invalid input data

Clip_951.jpg

Clip_950.jpg

Clip_953.jpg

Clip_952.jpg

Screenshot 2026-02-24 092317.png

1000377379.png

Screenshot 2026-02-24 162028.png

screenshot 2.png

MikeVolz · Answer

Sorry about that.  I copied your script call to MakeQueryTable_management in Google, but I did not pay enough attention that it found MakeQueryLayer_management instead.

I would suggest simplifying your call to MakeQueryTable_management to get it working and then add your more complex calls one-by-one until you find out what the current problem is.

I would also suggest some sort of logging or print statements to see if your variables are getting populated as expected.

Anonymous User · Answer

Original User: SStrand

You linked a different tool which, yes, only works with SDE. Make Query Table does work with file geodatabases though:

http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000006r000000Unless I'm reading something wrong, the documentation at the below link says Query layers will only work with enterprise databases.  A file geodatabase is not a valid input workspace.

http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000174000000

I hope this does not cause problems to get this data into SDE.

MikeVolz · Answer

Unless I'm reading something wrong, the documentation at the below link says Query layers will only work with enterprise databases.  A file geodatabase is not a valid input workspace.

http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000174000000

I hope this does not cause problems to get this data into SDE.