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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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