AnsweredAssumed Answered

Make Query Table

Question asked by jmward on Sep 30, 2014
Latest reply on Dec 14, 2015 by tselvidge

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

Outcomes