Question
Feature Count Mismatch
After migrating data using FME from ArcGIS geodatbase 9.3.1 to ArcGIS geodatbase 10.2, it is found that most of the feature classes with less than 1000 records are not reflected in the geodatabase and also the feature class counts are rounded to the nearest 1000. (ie if feature count of a feature class in FME log is 23841, the corresponding feature count in geodatabase is 23000 and if the feature count is less than 1000 in FME log, there is no record for the corresponding feature class in geodatabase. Can some one help is solving this issue?
Hi,
Which underlying database (Oracle, PostGIS, MSSQL, DB2) are you using? And how are you counting the records in the database?
David
Hi,
I am using SQL Server as the database and using ArcCatalog and SQL Management Studio to check the count in the database.
Vasanth
Hi,
sounds like it could be related to the transaction size, which is 1000 by default. Try changing the transaction size ("Features to write per transaction" under Advanced) to e.g. 500 and see if the number of features written change.
Also check that there are no invalid features that are skipped during writing. There is a setting under Advanced called "Ingore failed features" you should verify is set to "no".
David
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.