Attribute column not found error

8855
11
03-14-2011 11:28 AM
Highlighted
New Contributor II
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
Reply
0 Kudos
11 Replies
Highlighted
Occasional Contributor
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
Reply
0 Kudos
Highlighted
New Contributor III
Was there any resolution to this problem?  I'm doing the same thing and experiencing the same error message.
Reply
0 Kudos
Highlighted
New Contributor III
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
Reply
0 Kudos
Highlighted
New Contributor III

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.

Reply
0 Kudos
Highlighted
New Contributor
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?
Reply
0 Kudos
Highlighted
New Contributor II
Same issue.  Running 10.1 against SQL Server Express 2012 DB.
Reply
0 Kudos
Highlighted
New Contributor II
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.
Highlighted
New Contributor
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
Reply
0 Kudos
Highlighted
New Contributor III

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

Reply
0 Kudos