Select to view content in your preferred language

X,Y event layer and not all rows

1910
10
11-09-2011 09:13 AM
LorindaGilbert
Frequent Contributor
Hi All,
Has anyone else run into this?  I have a view in Oracle that I am using for an x,y event layer in ArcMap (and by way of publishing, a mapping service).  I have over 21K rows in the view when I query in Oracle.  When I open the layer file in ArcMap, I SEE all of the points (at least the ones that have valid x y coords - there are a few nulls), but when I open the attribute table there are only 2048 in the list.  Yet, I can go to one that is not showing in the attribute list and do an info tool and get the data.
What kind of quirkiness is this?
ETA:  Win7 x64, Arc10 SP1, Oracle 10g, our server for SDE is SQL Server 2008
Thanks.
Tags (2)
0 Kudos
10 Replies
by Anonymous User
Not applicable
I found this to start happening when we upgraded to ArcGIS10.  Any non-GIS data i.e. excel, access, odbc connection, sde, if you have more than 2048 records after the first time you look at the table, this is all you see.  I have to reload the table to be able to see all the records again.  This did not happen before.  It will verify as well when you select by attributes, but if it's not in the 2048 records and you can't see the record it actually found.  Yes, and my custom app. is having the same problem of not be able to access all the records in my table.  I've been looking to for a solution.
0 Kudos