Select to view content in your preferred language

create query table doesn't work in a model

3162
12
09-07-2016 12:11 AM
AntoniaCreese
Emerging Contributor

I need to use the create query table tool. When I do it manually it works fine but will NOT work in a model.

I have both table and spatial layer in athe same personal geodatabase. I have tried using different syntax, double quotes, single quotes, square brackets around table and field expression. All deliver empty results and error 1.

Tags (2)
0 Kudos
12 Replies
DanPatterson_Retired
MVP Emeritus

Why don't you do it manually and copy the syntax used from the Results window?

AntoniaCreese
Emerging Contributor

Thanks Dan,

I have tried that and the expression and create table works manually outside of the model window but not within it. Same expression, same inputs.

0 Kudos
DanPatterson_Retired
MVP Emeritus

it probably has something to do with the input path names.  Are there any spaces and other characters in the paths? any non-simple characters (internationalization)?  Anything you can provide as to the inputs both through the common interface and through the model would be useful.  Also, check your environment settings, I doubt you have provided any within the model, but there may be some being used through the tool

AntoniaCreese
Emerging Contributor

No spaces or characters. I have found [layer].[field] = [tableName].[field] with both fields sharing the same data format in this case text and even the same size works well outside the model. I will check environment settings but suspect as a later comment suggests it is an esri "feature" aka bug.

0 Kudos
BruceHarold
Esri Regular Contributor

Hi, it is a known issue that the expression in Make Query Table may not validate when it is correct and vice versa.

For File GDB inputs build the expression without double quotes.

0 Kudos
DanPatterson_Retired
MVP Emeritus

even in 10.4.1?  Is there a bug number? when was the error introduced?  Times like this, I wish they would like bugs/issues to the help files

0 Kudos
AlanRex1
Esri Contributor

Yes, the bug Bruce mentioned was logged for 10.4.1 (although I think it may have existed at 10.4 as well):

BUG-000097508 - The Query Builder of the Make Query Table geoprocessing tool uses inconsistent delimiter syntax, returns inconsistent errors, and leads to inconsistent results in ArcGIS 10.4.1 for Desktop.

The bug is not directly related to ModelBuilder, but it may be causing some extra confusion in this case.  Since the tool is working outside of ModelBuilder I suspect that the bug Robert mentions below might be the main problem.  BUG-000097508 is related to various incorrect errors which are thrown when validating syntax generated by the Query Builder.  While it's possible that Antonia is hitting some of these incorrect errors, if she's got it working in the standalone tool then it should also work in ModelBuilder.

JoshuaBixby
MVP Esteemed Contributor

I will believe it when I see it, but the status was recently updated to say it will be addressed in 10.5.1:

BUG-000097508: The Query Builder of the Make Query Table geoprocess..

Robert_LeClair
Esri Notable Contributor

By chance are you running the Table to Table GP tool prior to the Make Query Table GP tool in ModelBuilder?  If so, this is a known bug - BUG-000088138 : The 'Table to Table' tool fails in ModelBuilder if the input is a query layer. 

0 Kudos