topic Re: Make Query Table in Geoprocessing Questions

Make Query Table

JeffWard — Tue, 30 Sep 2014 22:26:52 GMT

I am having trouble running the Make Table Query tool. I have run the tool before with success. I am trying to create a new feature class with one polygon per related record in a table. The error I get is :

ERROR 999999: Error executing function.

Attribute column not found [42S22:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'V__574.GISID'.] [sde.DBO.QueryTable]

Attribute column not found [42S22:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'V__574.GISID'.] [InputFeatures]

The table was not found. [OutputFeatureClass]

If I run the tool in a model by itself, I get no errors, it's when I try to export the features to a feature class using "Copy Features" that I get the above error.

I am running version 10.2.2

Thanks for any insight in advance

Jeff Ward

Summit County GIS

Re: Make Query Table

SusanJones — Tue, 30 Sep 2014 23:23:09 GMT

Can you export your model to a python script and copy the code to another window?

It's heaps easier to troubleshoot that way.

Re: Make Query Table

curtvprice — Thu, 02 Oct 2014 13:52:07 GMT

Please post your query expression.

Re: Make Query Table

JeffWard — Thu, 02 Oct 2014 22:36:56 GMT

I ended up uninstalling 10.2.2 and reinstalling 10.2 and it worked. Has anyone been able to run the Make Table Query in 10.2.2?

Re: Make Query Table

SusanJones — Thu, 02 Oct 2014 23:13:50 GMT

ouch

Re: Make Query Table

MitchellWiniecki — Wed, 22 Oct 2014 15:27:12 GMT

I have not been able to successfully use this tool since upgrading to 10.2.2. Just another problem in the LONG list of ESRI issues. I never ceases to amaze me how a worldwide company can put out a product that simply doesn't work.

ESRI Premium Support < GIS Stack Exchange

Re: Make Query Table

JeffWard — Wed, 22 Oct 2014 17:23:17 GMT

I have submitted a support request.

Re: Make Query Table

SusanJones — Wed, 22 Oct 2014 19:53:10 GMT

Good to know I am not the only one struggling to do this.

All I need to be able to hook up with database tables and publish them without needing to first register with ArcSDE and the Geodatabase.

Always worked Cool at ArcGIS 10.0 and ArcGIS 10.1 flavours.

Re: Make Query Table

JeffWard — Fri, 24 Oct 2014 17:11:33 GMT

Julia at tech support was able to run the tool. It turns out the query builder was adding double quotes around my fields, causing something to go wrong with the query. If I remove the double quotes I am able to run the tool and get the results I need.

I will post further updates as I hear back from tech support

Re: Make Query Table

curtvprice — Sat, 25 Oct 2014 18:21:14 GMT

Be sure and post a bug # if you get one.

Re: Make Query Table

JeffWard — Mon, 27 Oct 2014 14:23:01 GMT

This is the bug number they gave me. It says it is fixed though.

Re: Make Query Table

DylanKennard — Thu, 19 Mar 2015 15:23:16 GMT

This needs to be clarified for ArcGIS Desktop 10.2.2. Hopefully it will save some folks hours as this destroyed my morning. Yes removing all quotes in an SDE/SQL Database does work for example: SANDBOX.DBO.TABLE.PrimaryKey = SANDBOX.DBO.TABLE.Primary_Key HOWEVER if you run the tool without unchecking your "OBJECTID" fields within "Field Names" the tool will output for a lack of a better term "Full Join" or FAIL. For example I had 100 polygons and 300 records. It outputted 30,000 plus polygons with lots of false joins! In essence with OBJECTID checked It duplicates everything and joins to everything (and maybe ignores your query?). I then ran the same thing again and it failed. Remember this tools keeps everything in memory.

Lastly to get on the fog horn to ESRI This tool is key to almost any GIS user....why since it has been released has it not been stable? Good luck trying to use it in Python or Geoprocessing Model. It took me hours to get that correct too! Export to Python Snippet doesn't work well for this tool either without some editing.

Re: Make Query Table

LanceShipman — Mon, 23 Mar 2015 23:01:53 GMT

The handling of double quotes in the Query Builder is NIM102585. We are review the issues with single quotes resulting in a cross join. Once we get a handle on it we will post an additional bug number.

Re: Make Query Table

TiffanySelvidge1 — Mon, 14 Dec 2015 18:13:41 GMT

I have tried both the work-arounds mentioned but neither one works. I am unable to do any Make Query Table functions.

Re: Make Query Table

LanceShipman — Mon, 14 Dec 2015 18:22:21 GMT

Can you post your Query. What data source are you using? What version of the software?

Re: Make Query Table

TiffanySelvidge1 — Mon, 14 Dec 2015 19:00:37 GMT

"ArcDev.GISOWNER.OIDTest_sites_2015i_2016"."Modified" > max("ArcDev.GISOWNER.Geocoded_allrecords"."Modified")

I am using ArcMap 10.2.2 and working in ModelBuilder. My data is from an SDE geodatabase.

The error occurs no matter which columns I select and no matter which tables I use. 'Make Query Table' is fine with the columns if I do not use a 2nd table in the query but anytime another table is added, I cannot do anything.

I have tried the default double quotes, single quotes and the shown-above multiple double-quotes.

Re: Make Query Table

LanceShipman — Mon, 14 Dec 2015 20:03:29 GMT

Have you tried the query without the max function?

Re: Make Query Table

TiffanySelvidge1 — Mon, 14 Dec 2015 21:10:01 GMT

Yes, it still does not work.

Re: Make Query Table

LanceShipman — Mon, 14 Dec 2015 21:28:54 GMT

1) What error is returned?

2) Is the second table registered with the GeoDatabase (includes an ObjectID)?

3) Does the second table include a geometry column?

Re: Make Query Table

TiffanySelvidge1 — Mon, 14 Dec 2015 21:57:52 GMT

The error returned is "Invalid Column Name"

The second table is registered and includes a "Shape" geometry column.

If I use the double double quotes then I received the error: "The multipart identifier ArcDev.GISOWNER.OIDTest_sites_2015i_2016"."Modified" could not be bound. Same for single quotes.