topic Re: Attribute column not found error in Data Management Questions

Attribute column not found error

DeeptiVB — Mon, 14 Mar 2011 18:28:44 GMT

While using "Make Query Table" tool on an ArcSDE feature class(versioned) and an attribute view, the functions fails to execute saying "Attribute column not found". The multi-part identifier SDE featureclass.columnname could not be bound.

What I am trying to do is a join between the feature class and table on A.x = B.y
A= SDE feature class
B = attribute view
x & y are text fields, 20 character long. The error says column x in feature class A cannot be found.

If I try the same join from SQL server backend on the same feature class and view it works perfectly.

Any idea what is happening on the arc client?

Thanks in advance,

-Deepti

Re: Attribute column not found error

CherylCleghorn — Tue, 15 Mar 2011 14:43:50 GMT

deeptivb

Can you specify your sde configuration including database version info? Are you seeing the column x when you look at the properties of the feature class in ArcCatalog? Does column x also exist on the A table for that feature class?

Thanks
Cheryl

Re: Attribute column not found error

BrentEstrem — Wed, 20 Jul 2011 18:33:31 GMT

Was there any resolution to this problem? I'm doing the same thing and experiencing the same error message.

Re: Attribute column not found error

JamesSimard1 — Tue, 30 Aug 2011 13:05:41 GMT

I am alos having the same problem. Anyone?

While using "Make Query Table" tool on an ArcSDE feature class(versioned) and an attribute view, the functions fails to execute saying "Attribute column not found". The multi-part identifier SDE featureclass.columnname could not be bound.

What I am trying to do is a join between the feature class and table on A.x = B.y
A= SDE feature class
B = attribute view
x & y are text fields, 20 character long. The error says column x in feature class A cannot be found.

If I try the same join from SQL server backend on the same feature class and view it works perfectly.

Any idea what is happening on the arc client?

Thanks in advance,

-Deepti

Re: Attribute column not found error

EthanGranger — Fri, 25 Jan 2013 22:03:50 GMT

I'm having the exact same problem. I'm using 10.1 with postgresql 9.1.3 database. I'm porting a script from 9.3.1 that worked perfectly, but won't work in 10.1. Anyone get this sorted?

Re: Attribute column not found error

ChrisWells — Thu, 13 Jun 2013 20:09:41 GMT

Same issue. Running 10.1 against SQL Server Express 2012 DB.

Re: Attribute column not found error

ChrisWells — Thu, 13 Jun 2013 20:37:14 GMT

Put single quotes around the column names. So instead of A.x = B.y it's 'A.x' = 'B.y'. That worked for on SQL Server Express and a FGDB.

Re: Attribute column not found error

JoaoFerra — Fri, 21 Jun 2013 08:28:02 GMT

Hi

I have the same trouble. I'm using arcgis 10.1 with sql server 2008 server.
I tried with quotes and the same message "attribute column not found".

My sql command works fine in the sqlserver, but not working in arcgis.

Any solution?

Thanks
joao

Re: Attribute column not found error

KeithAnderson — Thu, 01 Oct 2015 18:09:56 GMT

Same issue.

In this case I could not join a SQL Server view to a Featureclass in the Map Document.

I had to delete the SQL View from within ArcCatalog rather than a drop and create from within SSMS.

Re: Attribute column not found error

LindsyHales_Bentley — Fri, 29 Jan 2016 16:15:53 GMT

I am having the same error. If anyone found resolution to this I'd love to hear it.

Re: Attribute column not found error

RonnieRichards — Fri, 28 Jul 2017 22:20:34 GMT

This is an old thread but have any of you tried removing all quotes conveniently added by the tool?

#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.

Re: Attribute column not found error

SamuelLopez — Mon, 15 Jun 2020 02:33:46 GMT

Hi guys, I solved this issue by right-clicking on the layer, click on properties then source, edit the query, remove everything in the query box then double click on the list of tables (The table that you are using), click on validate, once the validate button is disabled then click on next, select the unique identifier field then OK and that should fix it.

Re: Attribute column not found error

SelimMelih — Wed, 30 Oct 2024 13:20:32 GMT

Hello,

when i try to "Enable Archiving" i got the same error "attribute column not found" ERROR 999999

EnableArchiving: Attribute column not found.

Can someone help me please?