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; } } }

Attribute column not found error

DeeptiVB

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

Find more posts tagged with

Accepted answers

All comments

SelimMelih

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?

SamuelLopez

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.

RonnieRichards

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.

LindsyHales_Bentley

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

KeithAnderson

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.

JF7

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

ChrisWells

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.

ChrisWells

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

EthanGranger

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?

JamesSimard2

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

BrentEstrem

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

CherylCleghorn

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

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.