I am getting a problem with the spatial join using Arc10.0, SP4 using ArcSDE 9.2 SP6 feature classes using ~150,000 points overlaid with a polygon file of ~18 polygons, both SDE feature classes. All of the records appear, but all but the first row of attributes are "null". In the first row all of the input fields are populated, but the spatial join field(s) are null, too. Output is SDE feature class.
Running from OS is Windows 7 Pro, 32-bit, SP-1 accessing an Oracle 10g relational database.
I selected about 20000 records interactively in ArcMap of the point feature class, then ran the spatial join and the data was populated as expected for the selected records. The output was only of the selected point features.
Was running fine on Arc10 SP2 with the full data set.
Ran successfully with the full data set on Arc 9.3.1 using the same ArcSDE 9.2 SP6 data.
Ran successfully with full data set in Arc10 SP 3 using the same ArcSDE 9.2 SP6 data.
Ran approximately 12000 out of the 150,000 of the records were processed. It appears the process broke when the spatial join encountered a null value in the polygon layer for the shapefile data. This was not the case for SDE feature classes.
I have a Python script that performs a number of Spatial Joins that I perform the Spatial Joins as well as other routines using SDE data. Scripts and ArcGIS Toolbox routines run successfully to completion, but produce "null" output as described above. We have typically run these scripts over the last 4 years on a monthly basis.
The "Name" field is the only field that is added as part of the Spatial Join operation, in this case. See the attached document.
I would need to FTP or send data via a different method to provide data.
Thank you,
Nate