ArcSDE 9.3.1 - three tier for admin, two tier for user access
SQLServer 2008 64-bit
I'm trying to schedule a weekly batch job that pulls a flat file via FTP from a third-party and loads it into an SDE layer. The layer is registered with USER maintained RowID column defined as INT NOT NULL IDENTITY. Registration is handled with this command:
sdelayer -o register -l onecalls,shape -e np -C onecalls_id,USER -i devdb -u xxxx -p xxxx -x -180,-90,1000000 -G 4326 -t GEOMETRY
Data gets pulled via FTP fine, SSIS is used to read resulting flat file and load data into a table. Two of the columns are Latitude and Longitude, and last step in the SSIS import is to generate point geometry from these two columns and write to Shape column (of type geometry) using STPointFromText(). Entity type of the layer is 'np'.
When viewed in ArcMap the layer looks fine, and zoom/pan works great. If I open the attribute table I am able to view all of the data very nicely. However, if I try to select any of the features, whether by clicking in the Attribute table, selecting with a rectangle, or by SQL query, ArcMap 'encounters a serious error' and goes away. I suspect problems with RowID, but not sure what would be the issue.
Any ideas appreciated.
