Spatial View Polygons Don't Display After Base Table Trun / Append in ArcGIS

Discussion created by kreuzrsk on Apr 23, 2014
Latest reply on Apr 23, 2014 by vangelo-esristaff
I've had this problem for a couple years now.  I regularly Truncate and Append feature classes that are used as the base feature class in a ArcSDE spatial view.  It's rare, but occassionally the spatail view displays the tabular data but the polygons don't display unless I nuke and recreate the view.  Any ideas?  I really don't want to stop map services so I cand delete and recreate the spatial view.  Plus, I've gone to direct connects so there was no need to install the SDE command line tools.

If I replace the SDE view with a SQL view will it work if the spatial column is the SDEBinary or does it have to be one of the SQL spaital data types?

Env: ArcSDE 10.1 SP1, SQL 2012.