I am trying to register a feature class as a version, and I got this error:
(Failed to register as versioned, Cannot find the object "d153" because it doesn't exist or you don't have permissions)
Here what I did before, the feature class was already registered as versioned moving the edits to base so I wanted to un-register then register without moving the edits to the base. to do that I compressed the database to state 0 then unregistered the feature class and when I tried to register it again I got this message!
This message doesn't make any sense:
1- because I am using the data owner user "sde" ( the database was configured with the sde user as the owner) so I think I have the permission to that.
2- the message reference the delete table "d153" which was droped when the feature class was un-registered as versioned.
what might be the issue here?
I remembered that I restored the database from the backup before doing that, and I didn't Re-sync the sql sever logins after restoring, so I executed this query in SQL
EXEC sp_change_users_login 'Update_One', 'sde', 'sde'
As a result of this I got a new error when I try to register as version
it says that the column 'sde_sate_id' is the geometry table is specified more than once.!!