When trying to add a layer from SM you get message that:
"Layer is not loaded"
This error usually means that the layer is not registered in the SDE metadata. To check this:
In case the Refresh metadata does not solve the issue:
Try to add the layer from the standard ArcMap [Add Data] button. If you get an error that "The SQL statement was not a select statement" it means that there is something wrong with the ArcSDE metadata. I came across this error when there was no entry for this theme in the SDE.COLUMN_REGISTRY table.
To add values in this table you can copy the values ONLY for the spatial column and the PK column (the ROWID_COLUMN for this layer as defined in the SDE.TABLE_REGISTRY table). Ignore the other columns, if the layer displays ok, the entries in the SDE.COLUMN_REGISTRY table will be inserted automatically.
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!