This chapter describes management of Viz Pilot databases when the Graphic Hub is used as a Viz 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.
When a proxy is used in front of Graphic Hub REST or the Pilot Data Server, it must be configured for failover, not load balancing. Viz Pilot aggregates requests by transaction ID. Splitting these requests across multiple service instances causes transaction failures.
The schema version is bound to the Graphic Hub version:
Graphic Hub Version | Viz Pilot Schema Version | Import Using |
|---|---|---|
Graphic Hub 3.6.0 or later | 6, 7, 8.0, 8.3.0, 8.4.0 and 8.7.0 Note: Use Graphic Hub REST 2.6.0 or later to expose all 8.7.0 schema changes. | Graphic Hub Manager version 5.6.0 or later |
Graphic Hub 3.4.0 - 3.5.2 | 6, 7, 8.0, 8.3.0 and 8.4.0 Note: 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 Viz 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 Viz Pilot clients can work on newer Graphic Hub and Graphic Hub REST versions, but newer Viz 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 later.
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 later.
Starting with PDS 8.4 and Viz Pilot 8.5, all future Viz 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
Viz Pilot Schema Version | Graphic Hub | GH REST | GH Manager Version |
|---|---|---|---|
8.7.0, Viz Pilot 8.5.0 or newer, Pilot Edge using 8.7.0 schema | 3.6.0 or later | 2.6.0 or later | 5.6.0 or later can import schema 6, 7, 8, 8.3.0, 8.4.0, 8.7.0 |
8.4.0, Viz 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, Viz 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, Viz 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, Viz Pilot 7, Viz Pilot 7.1, Viz Pilot 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 Viz Pilot data or clean the schema on Graphic Hub 3.0.2 or later with GH Manager 5.0.1 or 5.0.0, as this writes the wrong schema version to the Graphic Hub.
Graphic Hub Manager 5.0.0 with Graphic Hub 3.0.2 or later:
Clean: Sets schema version number to 7.0.0.
Import: Sets schema version number to 6.0.0.
Graphic Hub Manager 5.0.1 with Graphic Hub 3.0.2 or later:
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 later)
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 later)
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 later)
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 later)
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
Viz Pilot official documentation