nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Way to find version of SDE

FarooqMunir

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

Vind meer berichten getagd met

Accepted answers

All comments

EricPaitz

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.

VinceAngelo

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

EricPaitz

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

WillWhite1

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

VinceAngelo

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

WillWhite1

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

RussellBrennan

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,

SachinChand

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

VinceAngelo

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

SachinChand

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.

VinceAngelo

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

SachinChand

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.

VinceAngelo

Correct. Direct Connect is its own ArcSDE server.

- V

SachinChand

Thanks for the clarifications!

VinceAngelo

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

NorlizaAbdul_Rahman

sqlplus sde/password;

select all from sde.version;

Bud

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.

arahman_mdmajid

This worked for me. Thanks

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.