topic Re: Way to find version of SDE in Data Management Questions

Way to find version of SDE

FarooqMunir — Fri, 30 Apr 2010 16:14:54 GMT

Hi,

Just wanted to ask, is there an easy way to find out the version of SDE running either from ArcCatalog or just by logging onto Oracle ?

Thanks,

FM

Re: Way to find version of SDE

EricPaitz — Fri, 30 Apr 2010 16:56:11 GMT

There is an SDE system table called SDE_version. This table contains all the major, minor and bugfix version numbers. This could be done with a simple query using your RDBMS. Technically you could write a custom command for ArcCatalog that could query this table and display the version information. I think you can also run any of the SDE commands from a DOS prompt and it will display the version number as part of the command syntax. If you are running the SDE command on a different computer then where you have SDE installed you will have to supply the -i parameter.

Re: Way to find version of SDE

VinceAngelo — Sun, 12 Dec 2021 01:18:40 GMT

Actually, that table has a history of not being fully modified during upgrade. If you have an
older version of ArcSDE that was upgraded from something even earlier, it's doubtful that
the contents are correct.

The definitive authority on ArcSDE version is the output of the SE_connection_get_release
function, which is what is exposed by the 'sdeping' utility of se_toolkit --

C:\>sdeping -u ***** -p ***** -i sde_eval93

ArcSDE 9.3 Connection Test Utility       Fri Apr 30 14:03:04 2010
------------------------------------------------------------------------
         Server: localhost
       Instance: sde_eval93
       Database: eval93
       Username: *****
          RDBMS: PostgreSQL
        Version: 9.3.1
    Description: PostgreSQL Build 2784(PostgreSQL)
     Build Date: Tue Oct 27 10:51:14  2009
        Release: 93005

As Eric mentioned, the ArcSDE command-line utilities expose the 'desc' member
of the SE_RELEASE structure (which 'sdeping' splits for readability):

C:\>sdelayer -o describe -u foo -p ***** -i sde_eval93 -O bar

ArcSDE 9.3.1  for PostgreSQL Build 2784 Tue Oct 27 10:51:14  2009
Layer    Administration Utility
-----------------------------------------------------
Bar does not own any layers OR user foo does not have access to any of bar's layers.

- V

Re: Way to find version of SDE

EricPaitz — Fri, 30 Apr 2010 17:14:06 GMT

Hey Vince, thanks for the correction. Do what he said. 😄

Re: Way to find version of SDE

WillWhite1 — Tue, 25 Sep 2012 15:11:06 GMT

I would like to be able to use sdeping for ArcSDE 10.1 but I'm not sure that there is an se_toolkit available for this version? If not, is there another way to determine the version of the database (ie what version of ArcGIS was used to create the ordinal geodatabase)? Thanks in advance

Will

Re: Way to find version of SDE

VinceAngelo — Tue, 25 Sep 2012 15:22:07 GMT

As posted above, commands like 'sdelayer' report the contents of the SE_RELEASE structure.

'se_toolkit-10.1' will be released after I work around some new "features" that are causing
my regression tests to fail. But 10.0 clients like 'sdeping' are able to connect to 10.1 servers,
so the current se_toolkit-9.3 release for 10.0 should suffice.

- V

Re: Way to find version of SDE

WillWhite1 — Wed, 26 Sep 2012 11:10:25 GMT

As posted above, commands like 'sdelayer' report the contents of the SE_RELEASE structure.

'se_toolkit-10.1' will be released after I work around some new "features" that are causing
my regression tests to fail. But 10.0 clients like 'sdeping' are able to connect to 10.1 servers,
so the current se_toolkit-9.3 release for 10.0 should suffice.

- V

Great - thanks for the information.

Will

Re: Way to find version of SDE

RussellBrennan — Thu, 27 Sep 2012 16:56:49 GMT

For almost all use cases you should be able to use python to get at the information you are looking for. Take a look at the workspace describe properties:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Workspace_properties/018v0000002v000000

Use the release property to find the geodatabase release:

arcpy.Describe('Database Connections\\test.sde).release

Use the currentRelease property to find out if the geodatabase is current:

arcpy.Describe('Database Connections\\test.sde).currentRelease

With service pack updates the geodatabase version typically does not change but we do sometimes update geodatabase internals such as stored procedures. You can use the currentRelease property to determine if stored procedures may have been updated at the service pack and thus need to be updated on your server. The currentRelease property compares the version of Desktop (or Server) you are using to run Python to the geodatabase you are describing.

Hope this helps,

Re: Way to find version of SDE

SachinChand — Thu, 15 Nov 2012 17:19:33 GMT

I believe the steps above give the version of the geodatabase installed. Is there a way to check the version of ArcSDE itself?

Thank you

Re: Way to find version of SDE

VinceAngelo — Thu, 15 Nov 2012 17:30:49 GMT

There shouldn't ever be a difference between the version of the geodatabase and the ArcSDE
in which it lives. And the client ArcSDE should always be the version of the ArcGIS client.

- V

Re: Way to find version of SDE

SachinChand — Thu, 15 Nov 2012 17:54:20 GMT

Vince, thanks for the quick response. What about an instance where all versions are 10. ArcGIS Desktop is then updated to v10.1. From desktop, the sde geodatabase is upgraded to v10.1 which would still leave ArcSDE at v10.

Re: Way to find version of SDE

VinceAngelo — Thu, 15 Nov 2012 18:10:00 GMT

No, after you upgrade the geodatabase, the SDE is at that level. If you have an application
service, and you fail to delete and recreate it, that's an error.

- V

Re: Way to find version of SDE

SachinChand — Thu, 15 Nov 2012 18:29:17 GMT

Ok, so with the scenario I presented, an sde service would need to be recreated, understood. Direct connect should work fine though (after upgrading the geodatabase to v10.1 using desktopv10.1), right.

Re: Way to find version of SDE

VinceAngelo — Thu, 15 Nov 2012 18:40:37 GMT

Correct. Direct Connect is its own ArcSDE server.

- V

Re: Way to find version of SDE

SachinChand — Thu, 15 Nov 2012 18:46:47 GMT

Thanks for the clarifications!

Re: Way to find version of SDE

VinceAngelo — Fri, 07 Dec 2012 12:52:01 GMT

Please start new questions in a new thread.

Views are just views; there's nothing release-specific about a view. Any necessary changes would
either happen to the underlying ST_GEOMETRY object, or to the base table's triggers.

- V

Re: Way to find version of SDE

NorlizaAbdul_Rahman — Wed, 18 May 2022 01:42:14 GMT

sqlplus sde/password;

select all from sde.version;

Re: Way to find version of SDE

Bud — Wed, 18 May 2022 02:40:25 GMT

I was able to use that query from a user/schema/owner other than SDE (a ROADS user):

--Oracle 18c
select * from sde.version;

It produced the correct information.

Re: Way to find version of SDE

arahman_mdmajid — Thu, 22 Aug 2024 11:40:50 GMT

This worked for me. Thanks