Post upgrade procedures

Properties for managing the database connection pool, file handles, and the repository cache are set in the Management Console by the administrator (admin).

After upgrading to version 2020.1.0 or higher, the administrator must check the Spectrum Spatial property settings to ensure that they are up to date for new features. Spectrum Spatial maintains the settings from previous versions. As a result, some settings will not include new feature options.

To ensure your upgrade includes new properties and property settings:

  1. Open a web browser and go to http://server:port/managementconsole

    Where:

    server is the IP address or hostname of your Spectrum Technology Platform server.

    port is the HTTP port used by Spectrum Technology Platform. The default is 8080.

  2. Log in using the admin account.
  3. From Resources, click Spatial.
  4. Expand each of the Java Properties, Environment Variables, or Process arguments lists and check for the settings listed below.
  5. To change the value of an existing property, click on the value and type your changes.

    To add a new field in the Java Properties list, click the Add button. This creates a new property field at the end of the Java Properties list. Enter the new property name, and then enter its value.

  6. Click Save.

Changes to these properties take effect immediately.

Java Properties

If you do not see these properties after upgrading Spectrum Spatial, then you must add them. The default values to use are provided in the Initial Value column in the below table.

Property Initial Value

pool.database.autoRegisterMBean

false

pool.database.jdbcInterceptors

 
QueryTimeoutInterceptor(
  queryTimeout=-1)

timeout.feature.value

 -1

timeout.mapping.value

 -1

For a description of these settings, see Spatial Java Properties in the Spectrum Spatial Guide.

Environment Variables

The LD_LIBRARY_PATH environment variable must be set to the following after upgrading Spectrum Spatial.

${g1.server.modules.dir}/spatial/lib:${g1.server.modules.dir}/spatial/lib/native/fgdb:${g1.server.modules.dir}/../bin

If it is not, then you must edit this property and add the information that is in bold.

Process arguments

The Process arguments property must be set to the following after upgrading Spectrum Spatial.

-Dspatial

-Dcom.pb.midev.dp.fgdb.native.dir=../modules/spatial/lib/native/fgdb

-Dcom.pb.midev.raster.mrr.native.dir=../modules/spatial/lib

-Dcom.pb.midev.dp.jfal.native.dir=../modules/spatial/lib/native/efal

-Dcom.pb.midev.dp.gpkg.native.dir=../modules/spatial/lib

-DpoolingDataSourceFactoryClass=com.pb.spectrum.spatial.component.remote.PoolingDataSourceFactory

-Djava.rmi.server.useCodebaseOnly=true

If -Dcom.pb.midev.dp.fgdb.native.dir=../modules/spatial/lib/native/fgdb is missing, then you have to add it (you can append to what is already there).