Documentation Center

Graphic Hub Administrator Guide

Version 3.3 | Published March 12, 2019 ©

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:

    • On Graphic Hub 3.2.0 and 3.3.0, Pilot schema 8.3.0 can be imported using Graphic Hub Manager version 5.2.0 or 5.3.0.

    • On Graphic Hub versions 3.0.2 through 3.1.1, Pilot schema 6, 7 and 8 can be imported using Graphic Hub Manager versions 5.0.2 through 5.1.1.

    • On Graphic Hub versions 3.0.0 and 3.0.1, Pilot schema 6 and 7 can be imported using Graphic Hub Manager 5.0.1.

    • Graphic Hub versions 3.0.2 through 3.1.0 require Graphic Hub Manager 5.1.0 or 5.0.2 to clean the schema.

    • Graphic Hub versions 3.0.0 and 3.0.1 require Graphic Hub Manager 5.0.1 to clean the schema.

  • Media Sequencer 4 is required for Pilot 7, 7.1, and 7.2.

  • 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 versions 3.2.0 and 3.3.0 automatically upgrades the data directory to schema version 8.3.0.

    • Graphic Hub versions 3.0.2 through 3.1.0 automatically upgrade the data directory to schema version 8.

    • Graphic Hub versions 3.0.0 and 3.0.1 automatically upgrade the data directory to schema version 7.

  • 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.

Important!

Make sure to have the documentation for Graphic Hub and Viz Pilot at hand before proceeding with the installation. The latest documentation is always 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.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 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

See Also