Documentation Center

Graphic Hub Administrator Guide

Version 3.7 | Published August 05, 2022 ©

Viz Pilot Database Management

This chapter describes management of Viz Pilot databases when the Graphic Hub is used as a Pilot data back end server.

In this section, you find the following information:

Important Pre-installation Information

Before setting up Graphic Hub as a back end database for Viz Pilot, observe the following:

  • The server must meet the minimum hardware requirements for Graphic Hub as Viz Pilot back end system which may vary depending on the size of the installation.

  • Viz Pilot requires Graphic Hub REST . The server running the GH REST service needs to meet the Graphic Hub REST Requirements.

The schema version is bound to the Graphic Hub version:

Graphic Hub Version

Pilot Schema Version

Import Using

Graphic Hub 3.6.0 - 3.7.0

6, 7, 8.0, 8.3.0, 8.4.0 and 8.7.0

images/s/cc3o4x/8703/98yf4s/_/images/icons/emoticons/warning.svg Use Graphic Hub REST 2.6.0 or later to expose all 8.7.0 schema changes.

Graphic Hub Manager version 5.6.0

Graphic Hub 3.4.0 - 3.5.2

6, 7, 8.0, 8.3.0 and 8.4.0

images/s/cc3o4x/8703/98yf4s/_/images/icons/emoticons/warning.svg Use Graphic Hub REST 2.4.2 or later, as 2.4.0 and 2.4.1 fail to expose all 8.4.0 schema changes.

Graphic Hub Manager version 5.4.2 through 5.5.2

Graphic Hub 3.2.0 and 3.3.0

6, 7, 8.0 and 8.3.0

Graphic Hub Manager version 5.2.0 or 5.3.0

Graphic Hub 3.0.2 - 3.1.1

6, 7 and 8

Graphic Hub Manager versions 5.0.2 through 5.1.1.

Graphic Hub 3.0.0 and 3.0.1,

6 and 7

Graphic Hub Manager 5.0.1

Graphic Hub 3.4.0 - 3.4.2

To clean the schema

Graphic Hub Manager 5.4.2, 5.4.1 or 5.4.0

Graphic Hub 3.2.0 and 3.3.0

To clean the schema

Graphic Hub Manager 5.2.0 or 5.3.0

Graphic Hub 3.0.2 - 3.1.0

To clean the schema

Graphic Hub Manager 5.1.0 or 5.0.2

Graphic Hub 3.0.0 and 3.0.1

To clean the schema

Graphic Hub Manager 5.0.1

  • All Pilot data is stored in the configured data directory. It is included in the Graphic Hub Terminal internal backup, and when the data directory is copied.

  • The schema is automatically upgraded when the Graphic Hub is started on a data directory.

Graphic Hub Version

Upgrade to Schema

Graphic Hub 3.6.0 - 3.7.0

8.7.0

Graphic Hub 3.4.0 - 3.5.2

8.4.0

Graphic Hub 3.2.0 and 3.3.0

8.3.0

Graphic Hub 3.0.2 - 3.1.0

8

Graphic Hub 3.0.0 and 3.0.1

7

  • In general, old Pilot clients can work on newer Graphic Hub and Graphic Hub REST versions, but newer Pilot clients cannot work on older versions.

    • Schema 7 clients (VCP 7, 7.1, 7.2) and 8 clients (VCP 8, Pilot Edge) can work on GH REST 2.0.2/GH 3.0.2 and higher.

    • Schema 8 clients (VCP 8, Pilot Edge) can not work on GH REST 2.0.1/GH 3.0.1 and lower.

    • Schema 8.3.0 clients can work on GH REST 2.2.0/GH 3.2.0 and higher.

    • Starting with PDS 8.4 and Pilot 8.5, all future Pilot releases will be able to work with all future GH versions greater than version 3.3.0,
      with potentially reduced functionality when used with older GH/GHRest versions. Therefore it is recommended to keep the versions aligned.

Important! Make sure to have the documentation for Graphic Hub and Viz Pilot at hand before proceeding with the installation. The latest documentation is available at www.vizrt.com.

Version Requirement Summary

Pilot Schema Version
Pilot Client Version

Graphic Hub
Version

GH REST
Version

GH Manager Version
to Import / Clean Schema

8.7.0, Pilot 8.5.0 or newer, Pilot Edge using 8.7.0 schema

3.6.0, 3.7.0

2.6.0, 2.7.0

5.6.0-5.7.0 can import schema 6, 7, 8, 8.3.0, 8.4.0, 8.7.0

8.4.0, Pilot 8.5.0, Pilot Edge using 8.4.0 schema

3.4.2, 3.4.1 (avoid 3.4.0)

2.4.2 (avoid 2.4.1, 2.4.0)

5.4.0, can import schema 6, 7, 8, 8.3.0, 8.4.0

8.3.0, Pilot 8.3.0, Pilot Edge using 8.3.0 schema

3.2.0 or 3.3.0

2.2.0 or 2.3.0

5.2.0 or 5.3.0, can import schema 6, 7, 8, 8.3.0

8.0.0, Pilot 8, Pilot Edge using 8.0.0 schema

3.0.2 through 3.1.1

2.0.2 through 2.1.1

5.1.1 or 5.0.2, can import schema 6, 7, 8

7.0.0, Pilot 7, Pilot 7.1, 7.2

3.0.0 or 3.0.1

2.0.0 or 2.0.1

5.0.1, can import schema 6, 7

Important: Always use the correct versions as listed above. Do not import Pilot data or clean the schema on Graphic Hub 3.0.2 or higher with GH Manager 5.0.1 or 5.0.0, as this writes the wrong schema version to the Graphic Hub.

Manager 5.0.0 with Graphic Hub 3.0.2 or higher:

  • Clean: Sets schema version number to 7.0.0.

  • Import: Sets schema version number to 6.0.0.

Manager 5.0.1 with Graphic Hub 3.0.2 or higher:

  • Clean: Sets schema version number to 7.0.0.

  • Import: Does not overwrite present schema version.

Schema Changes

The following schema changes are performed automatically on Graphic Hub startup.

7.0.0 (Graphic Hub 3.0.0, 3.0.1) to 8.0.0 (Graphic Hub 3.0.2 or higher)

Adds three additional columns to the templates table:

  • authored_model STRING NULL WITH DEFAULT NULL

  • master_template_modified DATE NULL WITH DEFAULT NULL

  • authored_model_modified DATE NULL WITH DEFAULT NULL

8.0.0 (Graphic Hub 3.0.2 to 3.1.1) to 8.3.0 (Graphic Hub 3.2.0 or higher)

Adds an additional column to the templates table:

  • template_kind SHORT NOT NULL WITH DEFAULT = 0

8.3.0 (Graphic Hub 3.20 or 3.3.0) to 8.4.0 (Graphic Hub 3.4.0 or higher)

Adds an additional column to the templates table:

  • master_template_xml STRING NULL WITH DEFAULT NULL

Adds additional columns to the template_concepts table:

  • template_thumbnail_type SHORT NOT NULL WITH DEFAULT = 0

  • template_thumbnail_text STRING NULL WITH DEFAULT NULL

  • thumbnail_last_modified DATE NULL FOREIGN KEY WITH DEFAULT NULL

8.7.0 (Graphic Hub 3.6.0 or higher)

Adds an additional template_script_html table with the following columns:

  • template_id BIGINT NOT NULL PRIMARY KEY

  • type_script STRING NULL

  • java_script STRING NULL

  • created DATE NULL WITH DEFAULT SYSDATETIME

  • created_by STRING NULL WITH DEFAULT = 'PILOT'

  • modified DATE NULL WITH DEFAULT SYSDATETIME FOREIGN KEY,

  • modified_by STRING NULL WITH DEFAULT = 'PILOT' FOREIGN KEY

See Also