I have some state ids which do not exist in sde.versions table. They are found in sde.states and sde.state_lineages.
Is this a normal thing or does it mean there is a problem in our database?
Thanks
That is normal.
The Versions table shows the current state that the Versions are pointing to.
This link should give you more details about the System Tables: System tables of a geodatabase stored in Oracle—Help | ArcGIS for Desktop
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.