nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

All comments

ShawnCarson

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

DrewDowling

Still an issue in 10.3.1

RichardTruong

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

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.

AndreasStelter

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.

DanPatterson_Retired

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

AndreasStelter

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

CharalambosMattheou4

Solved . " " in sql statement was the problem.

regards

Charalambos

CharalambosMattheou4

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

jskinner

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

AndreasStelter

Hi Jake,

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

Andreas

jskinner

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

Same problem in ArcGIS 10.2.2.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.