This is Jon D. with ESRI Support Services Geodata Unit. I have a question for you: What version of ArcSDE are you using? The question seems simple enough; however, you may be surprised how often the answer is incorrect or unknown.
ArcSDE can be thought of as two separate entities:
- The repository that is created within your database during the post installation process
- The ArcSDE binaries that are located on the machine that ArcSDE is installed on and that are located in %SDEHOME% - this is also the portion of the installation that enables SDE command line scripts to be run and that contains the DLL files necessary for application service connections.
The initial installation of ArcSDE creates the SDEHOME, which houses the SDE binaries and DLL files on your machine. The post install is necessary to set up or upgrade your geodatabase to the release that has been installed. This process may be run through the command line or the Post Install Wizard any time a new release or service pack is installed on your server. When in doubt of whether or not you have upgraded your geodatabase, there are a few ways to determine which version of ArcSDE is being used:
- Within your ArcSDE respository is a table named “VERSION” that contains the major and minor release and the build of the ArcSDE repository in which you are working. An ESRI Support Analyst can work with you to determine which release of the software you are using with the information stated above.
- You can query which version is being used within your geodatabase by using the following: “Select * from sde.version; (or sde.sde_version if using SQL Server”.
- The Patchfinder utility can help to determine which releases, service packs, and patches you have installed. This will indicate the version of ArcSDE you have installed, which you can then compare with the release your geodatabase is using.
Keep in mind it can never hurt to re-run the Post Install Wizard if you are unsure as to whether the geodatabase has been upgraded. (Just be sure that no users are connected at the time.) This action will automatically apply the latest releases of the software installed.
We always want you to have the most up-to-date functionality available! Also, ESRI Support Services is always here to help you in figuring out the version of software you are using or for any other issues you many run into when using our software.
I encourage you to ask questions or leave comments in the comments section. NOTE: You must be logged into your ESRI Global Account to leave comments.
- Jon D., Geodata Support Analyst, ESRI Support Services