How To: Validate and restore missing tools/objects post upgrade

Relates to versions - from Geobank 2020 (11.0.636.0) to 2025 SP2 (25.0.1903.2)

This guide has been produced to assist Administrators and End Users when evaluating data post-upgrade and possible steps to resolve missing data.

Overview:

There are instances when you may notice that some tools/objects are missing following a software upgrade. Fortunately, several steps can be taken to verify that this is indeed the case and resolve or restore any missing tools or objects.
In this case, we for example expect (remember) a 9th object in the list below, but we cannot see it now:

Validation:

If you have experience working with SQL Server Management Studio, you can manually verify the missing objects from the backup created before the upgrade. For this, you need to compare tables in your “Configuration” database. They will be named [GB].[GB***_CONFIG_OBJ], where *** indicates a unique Geobank version.
For example, the following query will display inconsistencies between the currently installed version of Geobank and the backup from the previous version. For reference, the current version is 2023 SP2 with a version number of 230, and the previous version of 2023 SP1, Version number 225:

SELECT *
FROM   [GB].[GB225_CONFIG_OBJ] G225
LEFT JOIN [GB].[GB230_CONFIG_OBJ] G230 ON G230.OBJ_ID = G225.OBJ_ID
WHERE G230.OBJ_ID IS NULL

The output might look something similar to this example:

Here we can see that the Advanced Reporting object is missing from our new dataset.

Restoration:

Restoring missing objects is quite a simple task, and also provides some element of validation, however this isn't available until after the objects have been restored.

To restore the missing objects:

1. Click on the 'File' menu at the top left of your screen
2. Select the 'Configuration' menu item
3. Select the Configuration Connection (If Required)
4. Here you will find the number of missing objects based on previous upgrades
5. Press 'Copy to 23.0' to restore the missing objects
   
   
   
   
6. The prompt will show the objects that will be restored.
   Pressing 'OK' will initiate the recovery process.
   
   

After restoration, we can see the expected output, displayed correctly in the newer version:

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access