I'm hoping someone has seen this before and has a solution. I've exhausted all my ideas. I having problems with the selection and identify tool in ArcMap.
I have a point feature class, zlevels, and an Oracle spatial view, sv_zlevels, created from zlevels. I've created a new map in ArcMap 9.3 and added both of them in. When I use the Identify tool and Select Feature tool on the original feature class layer, it works fine. When I try to do the same on the view layer, I get no results. I've checked that it is selectable, and that it can Identify from All Layers. The layer draws fine. I can change its symbology and labeling. I can Select By Attribute under the Selection menu but I get no results back when I do a Select By Location. Its like its not there. If I do the same Select By Location on the original feature class, it works fine. I have the same set up with a polyline feature class, streets, and I don't have any problems with it. Streets and zlevels came from the same place - NAVTEQ. The weird thing is the zlevels had been working. I can't pinpoint exactly when it stopped since I'm not always working directly in ArcMaps. And I've had this happen before with zlevels. I restarted my machine and it seemed to work after that but that may have been a coincidence. Other have the same problem on their machine when trying to select from sv_zlevels.
What I've tried with no success:
*Dropping and recreating the view in Oracle
*Restarting my machine
*Restarting the server and re-registering the spatial views
Has anyone ever experienced something like this before?
We are running ArcSDE 9.3.1 with Service Pack 1 and ArcGIS Server 9.3.1 with Service Pack 1. Our version of Oracle is Oracle 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production. At the end of the week we are going to be updating everything.