still versioned after unregistering?

482
4
03-02-2020 12:56 PM
forestknutsen1
MVP Regular Contributor

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%'
0 Kudos
4 Replies
George_Thompson
Esri Frequent Contributor

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.

--- George T.
0 Kudos
forestknutsen1
MVP Regular Contributor

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).

0 Kudos
George_Thompson
Esri Frequent Contributor

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

--- George T.
0 Kudos
forestknutsen1
MVP Regular Contributor

Fair enough George. Thanks for the input.

0 Kudos