Make Query Table problem

[AndreasStelter]

Hi,

I am trying to join three tables from the same FGDB via Make Query table.

Validation in Model Builder shows no errors. If I run my tool from Model Builder the following error messages are displayed:

ERROR 999999: Error executing function.

An expected Field was not found or could not be retrieved properly. [S_LX_Abzugsbefreiungen_Query]

An expected Field was not found or could not be retrieved properly. [OID]

Failed to execute (Make Query Table).

What's wrong? S_LX_Abzugsbefreiungen_Query is the name of the table that should be created.

The error persists even if I remove the SQL query, so the reason cannot be a syntax error in th query.

BTW: I'm using ArcGIS 10.0 SP5.

Thanks for any help

Andreas

[AndreasStelter]

Same problem in ArcGIS 10.2.2.

[JakeSkinner]

Hi Andreas,

This is a bug:

NIM102585:  In ArcGIS Desktop 10.2.2, the quotes have to be either removed or modified in the Expression column of the Make Query table tool to run the tool successfully.

Remove the quotes around your SQL expression and it should work.  Ex:

Change:

"centroid_1301.BlockLotQ" = "Municipality_1301.BlockLotQ"

to:

centroid_1301.BlockLotQ = Municipality_1301.BlockLotQ

[AndreasStelter]

Hi Jake,

I already tried that, but it didn't solve my problem.

Andreas

[JakeSkinner]

Can you send a screen shot of how you have the tool setup?

[AndreasStelter]

Screen shot:

[jessemaps]

A note on removing the quotes from the field names in the expression...

After removing quotes from field names you will still get the error if you "verify" in the Query Builder, but when you run the tool it will execute successfully despite the warning in Query Builder.

[ShawnCarson]

Thanks for this info Jesse. I just spent 45 minutes trying to avoid the error. 

[DrewDowling]

Still an issue in 10.3.1

[AndreasStelter]

I found a solution for my problem without changing the model.