topic Re: still versioned after unregistering? in Geodatabase Questions

still versioned after unregistering?

forestknutsen1 — Sun, 12 Dec 2021 10:44:24 GMT

After unregistering as versioned all objects in a schema the simple relationships still show up as versioned when I check with sql. There is also one feature dataset that has the same problem. When I check the feature dataset with ArcCatalog it gives me the option to register as versioned. So, I think the sql query is not telling the whole story... Why is this happing?

select i.name as name, t.name as type
 from sde.gdb_items_vw i
 join sde.gdb_itemtypes t
 on i.type = t.uuid
where i.definition like '%Versioned>true%'‍‍‍‍‍

Re: still versioned after unregistering?

George_Thompson — Mon, 02 Mar 2020 21:14:14 GMT

I tested this in my test SQL Server DB and it worked as expected when I unversioned a FC. I looked at the xml file within the gdb_items table.

Re: still versioned after unregistering?

forestknutsen1 — Mon, 02 Mar 2020 22:06:45 GMT

So, it looks a little buggy to me--like the xml in the gdb_items_vw is not getting updated when the other sde system tables are. (We are on Oracle).

Re: still versioned after unregistering?

George_Thompson — Tue, 03 Mar 2020 11:10:06 GMT

I would recommend working with Tech Support and an analyst on this behavior.

Re: still versioned after unregistering?

forestknutsen1 — Tue, 03 Mar 2020 17:52:49 GMT

Fair enough George. Thanks for the input.