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

[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

[BrentEstrem]

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

[JamesSimard1]

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

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

[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?

[ChrisWells]

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

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

[JoaoFerra]

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

[LindsyHales_Bentley]

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