Documentation Center

Graphic Hub Administrator Guide

Version 3.1 | Published July 11, 2018 ©

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.1.0 down to 3.0.2, Pilot schema 6, 7 and 8 can be imported using Graphic Hub Manager 5.1.0 or 5.0.2.

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

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

    • Graphic Hub versions 3.0.1 and 3.0.0 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 3.1.0 down to 3.0.2 automatically upgrade the data directory to schema version 8.

    • Graphic Hub 3.0.1 and 3.0.0 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 or higher.

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

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.0.0, Pilot 8, Pilot Edge

3.1.0 down to 3.0.2

2.1.0 down to 2.0.2

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

7.0.0, Pilot 7, Pilot 7.1, 7.2

3.0.1 or 3.0.0

2.0.1 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 will write 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.


See Also

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