topic Re: Make Query Table problem in Geoprocessing Questions

Make Query Table problem

AndreasStelter — Thu, 22 Oct 2015 16:11:05 GMT

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

Re: Make Query Table problem

AndreasStelter — Thu, 29 Oct 2015 13:08:46 GMT

Same problem in ArcGIS 10.2.2.

Re: Make Query Table problem

JakeSkinner — Thu, 29 Oct 2015 13:23:17 GMT

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

Re: Make Query Table problem

AndreasStelter — Thu, 29 Oct 2015 13:29:39 GMT

Hi Jake,

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

Andreas

Re: Make Query Table problem

JakeSkinner — Thu, 29 Oct 2015 13:31:35 GMT

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

Re: Make Query Table problem

AndreasStelter — Thu, 29 Oct 2015 13:37:33 GMT

Screen shot:

Re: Make Query Table problem

CharalambosMattheou4 — Sat, 31 Oct 2015 07:11:29 GMT

I have the same problem here. Data are stored in the same workspase. Any advice? Is there a step by step tutorial with relevant dataset available?

Thanks

Charalambos

Re: Make Query Table problem

CharalambosMattheou4 — Sat, 31 Oct 2015 11:28:39 GMT

Solved . " " in sql statement was the problem.

regards

Charalambos

Re: Make Query Table problem

AndreasStelter — Mon, 02 Nov 2015 08:40:26 GMT

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

Re: Make Query Table problem

DanPatterson_Retired — Mon, 02 Nov 2015 08:47:54 GMT

for the benefit of others...what was it?

Re: Make Query Table problem

AndreasStelter — Mon, 02 Nov 2015 10:02:12 GMT

I left the model unchanged (so I didn't have to use Make Query Table) and retrieved the information I needed in C# code instead.

Re: Make Query Table problem

jessemaps — Wed, 30 Dec 2015 19:12:42 GMT

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.

Re: Make Query Table problem

RichardTruong — Wed, 03 Feb 2016 14:19:58 GMT

Yulp, remove the " " in the sql statement will resolve the issue. Thank you.

Re: Make Query Table problem

DrewDowling — Fri, 03 Jun 2016 19:55:15 GMT

Still an issue in 10.3.1

Re: Make Query Table problem

ShawnCarson — Tue, 29 Nov 2016 17:09:33 GMT

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