We have ESRI ArcMap 10.0 (build 4400) ArcGIS Desktop 10 Service Pack 5. SQL Database 10.0.4000.
We are trying to Compress our Versioned tables but for some reason it's not pulling the changed records into the SQL Tables.
I have checked the SDE_compress_log and can see the Compression was successful but the start_state_count is 5 and the end_state_count is 5 so I think this means nothing was released from the delta tables? Is that true? I also noticed that the end_state_count never seems to be zero. Why is that?
I checked the SDE_versions table and there is only 1 record with the latest state_id, however there are multiple updates that still need to be compressed. There are no related replicas. The compression worked last prior to July 7th 2016 but now nothing is updated. Should the SDE_versions table contain a record for each pending compression or just the last one?
I did some research and created the following query. It returns 5 rows. One for each pending update.
SELECT mv.[state_id], mv.[registration_id], tr.table_name, s.creation_time, sl.lineage_name, sl.lineage_id, lm.time_last_modified FROM [sde].[SDE_mvtables_modified] mv JOIN sde.SDE_table_registry tr ON mv.registration_id = tr.registration_id JOIN sde.SDE_states s ON mv.state_id = s.state_id JOIN sde.SDE_state_lineages sl ON s.lineage_name = sl.lineage_name JOIN sde.SDE_lineages_modified lm ON sl.lineage_name = lm.lineage_name JOIN sde.SDE_versions v ON s.state_id = v.state_id
Can anyone explain what might be happening? It's like there is an unfinished transaction that is preventing the release of the delta data.
This is what I see in my SDE_state_lineages table. Is this normal?
lineage_name lineage_id 0 0 15908 0 41477 0 15908 32512 41477 32512 15908 41276 41477 41276 41477 41548 41477 41552
This is the SDE_versions table
name owner version_id status state_id description parent_name parent_owner parent_version_id creation_time DEFAULT sde 1 1 41572 Instance default version. NULL NULL NULL 2011-07-07 14:03:14.000
The table registration_id is 292 so I looked in a292 and there are 2300+ rows in there. Should this "a" table empty out once the compression has successfully pushed the data to the destination SQL table?