ERROR

DB2 - The selected object failed to draw:Attribute column not found[SDE.SDE.USA_VIEW]

Last Published: April 25, 2020

Error Message

This error occurs when attempting to display a view in ArcCatalog:

DB2 - The selected object failed to draw: Attribute column not found[SDE.SDE.USA_VIEW]

The same view can be loaded in ArcExplorer as a layer, but it does not display. The view was successfully created in ArcSDE 8.1 Service Pack 1 with this command:

sdetable -o create_view -T usa_view -t usa -c "usa.shape,usa.state_name" -i sde81_db2 -u sde -p xxxxx

Cause

Current implementations of ArcSDE for DB2 and Informix expect a SE_ROW_ID to exist in each spatial spatially-enabled table. This column is used in many operations, including creating views; thus, the view must contain this column.

Solution or Workaround



Include the SE_ROW_ID column when creating views using DB2. The above command should look like this:

Code:
sdetable -o create_view -T usa_view -t usa -c "usa.shape,usa.state_name,usa.se_row_id" -i sde81_db2 -u sde -p xxxxx

Article ID:000004249

Software:
  • ArcMap 8 x
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options