topic Re: Find Layers With Versioning in Data Management Questions

Find Layers With Versioning

User35489 — Wed, 27 Nov 2013 08:00:29 GMT

Good Day Gents,

I am looking for a query or a method which can list me all the 'layers with versioning' in a geodatabse.
Please let me know.

Thanks
-AS

Re: Find Layers With Versioning

EmadAl-Mousa — Wed, 27 Nov 2013 08:14:46 GMT

you didn't specify which geodatabse version you are using....

check this tool: http://www.arcgis.com/home/item.html?id=218fb05252cd4746be21b9565f648b5b

Also, you can use "python" scripting to list "versioned feature classes".

Re: Find Layers With Versioning

KimPeter — Wed, 27 Nov 2013 20:08:47 GMT

There are also SQL examples here:
http://resources.arcgis.com/en/help/main/10.2/#/Determining_which_data_is_versioned/006z000000v1000000/

Re: Find Layers With Versioning

User35489 — Thu, 28 Nov 2013 09:20:40 GMT

Thanks all for your excellent information.

I tried the tool, it worked fine for ArcGIS Desktop 10 and ArcSDE 10.1, but when i tried to run it on ArcGIS Desktop 10 and ArcSDE 9.3. It failed with below error.
Please advise

"An error appearsThe index passed was not within the valid range"

Regards
-AS

Re: Find Layers With Versioning

EmadAl-Mousa — Thu, 28 Nov 2013 09:41:08 GMT

try rebuilding/analyze the indexes for the layers the error complained about.

Re: Find Layers With Versioning

User35489 — Thu, 28 Nov 2013 09:44:08 GMT

try rebuilding/analyze the indexes for the layers the error complained about.

Actually the tool works on 'SDE connection' file, not on particular layer/dataset.
I tried both direct and advanced server connections.

If you have 9.3 ArcSDE and 10.0 Desktop, you may try it and check whether it is working fine with you.

-AS

Re: Find Layers With Versioning

NidhinKarthikeyan — Thu, 28 Nov 2013 09:54:59 GMT

I tried the tool, it worked fine for ArcGIS Desktop 10 and ArcSDE 10.1, but when i tried to run it on ArcGIS Desktop 10 and ArcSDE 9.3. It failed with below error.
Please advise

"An error appearsThe index passed was not within the valid range"

It might be because the storage in 9.3 Geodatabase is Low Precision.

Re: Find Layers With Versioning

User35489 — Thu, 28 Nov 2013 09:56:52 GMT

It might be because the storage in 9.3 Geodatabase is Low Precision.

Yes you are correct. The storage is low precision.
What could be the workaround for this situation.

-AS

Re: Find Layers With Versioning

NidhinKarthikeyan — Thu, 28 Nov 2013 10:28:28 GMT

You can try the following in a test environment:

Take a complete backup of the database and upgrade it to 10 or >. I don't think it is feasible for you to do it.

Vince will be here. You can wait for his suggestion.

Re: Find Layers With Versioning

WilliamCraft — Thu, 28 Nov 2013 18:45:37 GMT

In Oracle, this should give you the list of VERSIONED object classes for a 9.3.1 geodatabase along with their respective A, D, F, and S tables:

SELECT r.OWNER, r.TABLE_NAME, r.ADDS_TABLE, r.DELETES_TABLE,
CASE
    WHEN l.LAYER_ID IS NOT NULL THEN ('F'||l.LAYER_ID)
    ELSE ' '
END feature_table,
CASE
    WHEN l.LAYER_ID IS NOT NULL THEN ('S'||l.LAYER_ID)
    ELSE ' '
END spatial_table
FROM (
SELECT OWNER, TABLE_NAME, OBJECT_FLAGS,
substr('A'||registration_id,1,10) adds_table,
substr('D'||registration_id,1,10) deletes_table
FROM SDE.TABLE_REGISTRY
WHERE OBJECT_FLAGS IN ('11', '15', '16399', '114693') AND OWNER IN ('[schema you care about]')
ORDER BY OWNER, TABLE_NAME) r
LEFT JOIN SDE.LAYERS l ON l.OWNER = r.owner AND l.TABLE_NAME = r.TABLE_NAME;

Re: Find Layers With Versioning

User35489 — Sun, 01 Dec 2013 02:44:26 GMT

Thank you all, esp Emad and William.

Best Regards
-AS

Re: Find Layers With Versioning

FrédéricPRALLY — Thu, 05 Dec 2013 10:55:39 GMT

Hi,
You can used one of this two tools :
List info versioned in ArcCatalog
List versioned data

Hope this can help you,

Fred