Query Layer and Database state ID's

[DanielBamford]

Hi,

I am trying to create a query layer on a sql server feature class. The query layer is created but does not include features I have recently added. The version for these edits has been reconciled, posted and deleted and the dastabase compressed but the query layer does not show the new features I have added. There are other versions open but it is difficult for us to get our databases back to 0. Is there a way to query a particular version state (i.e. sde.default not state 0)? Or is there a way I can get these new features into a query layer?
thanks,
Daniel.

[JakeSkinner]

Hi Daniel,

You won't have to compress to a state of 0, but a few things you will have to do:

1.  If you have any replicas, synchronize each one.

2.  Reconcile each other version.  If you are using ArcGIS 10.1, you can see the other versions to reconcile and perform the reconciliation by looking at the Reconcile Order tab.

3.  Make sure no other users are connected, this includes ArcGIS Server services.  You can disconnect users at 10.1 as well.

After the above criteria is met, you can compress the database, and the edits will be reflected in your Query Layer.