Viz Pilot User Guide

Version 8.5 | Published December 16, 2019 ©

Graphic Hub Database

This section describes how to manually configure the Graphic Hub database connection, and contains the following topics:

Graphic Hub comes with its own tools for maintenance tasks, such as importing and exporting data, backup and replication, automated cleanup tasks for Viz Pilot data elements and the Viz Pilot change log, and an integrity check. For more information see the Graphic Hub User Guide.

Graphic Hub Database Configuration

Configuration

The Graphic Hub database needs to be configured in three places:

  1. For client applications, use the Viz Pilot Configuration Tool, either during the Viz Pilot System Installation, or afterwards.

  2. For the Pilot Data Server, use the installation interface during Pilot Data Server Installation.

  3. For the Media Sequencer, in Director go to Tools > Media Sequencer Configuration > Database Tab.

    Note: For a detailed procedure, see the Viz Pilot Database Management section in the Graphic Hub User Guide.

Workflow

In Viz Pilot 6.x and earlier, the Media Sequencer connected directly to Oracle for change notifications and to fetch Pilot data.

In Viz Pilot 7.x an alternative setup has been introduced. The Pilot Data Server now exposes all the data needed by the Media Sequencer through its REST interface. It also provides Change Notifications (see the Pilot Data Server Administrator Guide) using the Stomp protocol. It is possible to configure the Media Sequencer to connect to the Pilot Data Server instead of the Pilot database.

Note: This setup requires Media Sequencer 4.0 or later.

Troubleshooting Pilot Database on Graphic Hub

When using a Graphic Hub as the Pilot database:

  • Graphic Hub and Graphic Hub REST are both needed. They install separately and must both be running.

  • The Media Sequencer, the clients, and the Pilot Data Server all need network access to Graphic Hub REST.

  • The Media Sequencer needs access to the Pilot Data Server as well if it is configured to go directly to Oracle.

  • In addition to the existing log files, there is also one specifically for the Graphic Hub client in client applications (Viz Pilot News, Director, Template Wizard) and the Pilot Data Server. The log is located in %PROGRAMDATA%/vizrt/Logs/GraphicHub and %PROGRAMDATA%/vizrt/Viz GH Pilot. For more details, see the Graphic Hub User Guide.

  • The Status Indicators in Director indicates the status of the Media Sequencer's database connection (bottom right). However, the indicator may be green even if the Media Sequencer is connected to a different database than the Director (for example Director is connected to Graphic Hub, while the Media Sequencer is connected to Oracle). If this occurs, an error will occur and the configuration must be changed.

  • Media Sequencer 4.0 or later is required for Viz Pilot 7.x. If you are connected to an older Media Sequencer, the Media Sequencer configuration’s Database tab in Director looks the same as prior to Pilot 7 (see Media Sequencer 3.x and earlier).
    For troubleshooting on the Graphic Hub side, see the Graphic Hub User Guide.