Before You Begin - Geodatabase Manager

Before beginning the Geodatabase Manager configuration, be sure to follow the steps outlined in this topic.

Database Notes:

Oracle Databases: You must always be logged in as the SDE user.

SQLServer Databases: You must always be logged in as the SDE user, and you must be logged into the SDE database.

Be sure to have a DBA maintain the general health of your database to ensure efficient performance. For example, sde.log files can become full and impact the post and reconcile operations.

Process Framework Upgrade

If you plan to use Geodatabase Manager to reconcile and post versions associated with sessions, designs, or both, you will need to do the configuration discussed at the bottom of the Upgrade to 9.3 Rev2 page in the Set Up Process Framework section (Set Up Process Framework Tools > Upgrade Session Manager > 9.3 Rev2).

Geodatabase Scripts

Geodatabase Manager is installed with SQL and Oracle scripts that add the necessary tables to your geodatabase to support this new functionality. Follow the steps below to run the appropriate script on your geodatabase before beginning the configuration.

By default, the Geodatabase Manager scripts are installed here: C:\Program Files (x86)\Miner and Miner\ArcFM Solution\Documentation\Process Framework Enterprise\. Run the script that corresponds to your database type (Oracle or SQL). These scripts MUST be run under the SDE user.
Once the script has completed, you will need to register the new tables with the geodatabase. Do not register these tables as versioned.
Next grant the appropriate privileges to the new tables.
These scripts create the following tables:
- GDBM_NO_RECONCILE_VERSIONS
- GDBM_PROCESS_LOG
- GDBM_VERSION_DELETE_QUEUE
- GDBM_POST_QUEUE
- GDBM_RECONCILE_HISTORY
- GDBM_POST_HISTORY

Disable Esri License Timeout Warning

By default, 15 days prior to license expiration, Esri will popup a message box to warn the user about the impending expiration. This behavior is not good for an unattended backroom server (e.g., Geodatabase Manager services). If you're running Geodatabase Manager services the message box may not be displayed, but block the services anyhow. This issue is easily resolved by disabling this timeout message.

Look for AdvancedArcMapSettings.exe, which is installed here: Program Files (x86)\ArcGIS\Desktop10.1\Utilities. This executable cannot be opened using an Esri ArcGIS for Desktop Basic license.
Double-click AdvancedArcMapSettings.exe to open it.
Select the Miscellaneous tab.
Uncheck the License Timeout Warning as shown in the screenshot below.

Click Apply.
Click the red X in the top right corner to close the executable.
If ArcMap was running while you performed this task, restart ArcMap to implement the change.