Configuring HVR Auto-Start on Windows
This section describes the steps to enable the automatic restart of Fivetran HVR processes (HVR Agent Listener and HVR Hub Server) after a Windows system reboot or an application failure.
Before performing the configurations on this page, ensure that the Windows user account running the HVR services is a member of the Administrator group and has the Log on as a service privilege.
Add HVR to Windows Startup
Adding applications to Windows Startup ensures they start automatically when the operating system boots.
If you installed HVR using the installer (HVR Hub or HVR Agent), the HVR processes are automatically added to Windows Startup.
If you installed HVR using the ZIP file (HVR Hub or HVR Agent), the HVR processes are not added to Windows Startup. In this case, you need to manually add HVR to Windows Startup to ensure they start automatically after a Windows boot:
Add HVR Agent Listener Service to Windows Startup
To add the HVR Agent Listener service to Windows Startup:
- Open the Windows Services Manager and locate the Fivetran HVR Agent Listener service.
- Right-click the service and select Properties from the context menu.
- Navigate to the General tab and set the Startup type to Automatic.
- Click OK.
Reboot your Windows system and check the Windows Services Manager to ensure the HVR Agent Listener service starts automatically.
Add HVR Hub Server Service to Windows Startup
To add the HVR Hub Server service to Windows Startup:
- Open the Windows Services Manager and locate the Fivetran HVR Hub Server service.
- Right-click the service and select Properties from the context menu.
- Navigate to the General tab and set the Startup type to Automatic.
- Click OK.
Reboot your Windows system and check the Windows Services Manager to ensure the HVR Hub Server service starts automatically.
Configure Automatic Restart for HVR Hub Server After Failure
In addition to enabling auto-start of HVR processes after Windows boot, we recommend configuring the HVR Hub Server service to restart automatically if it encounters a failure.
This configuration applies to both installer and ZIP-based installations.
To configure the HVR Hub Server service to restart automatically if it fails during operation:
- Open the Windows Services Manager and locate the Fivetran HVR Hub Server service.
- Right-click the service and select Properties from the context menu.
- Navigate to the Recovery tab and set Restart the Service for the first and subsequent failures.
- Click OK.
Configure HVR Hub Server Service Dependency on DBMS
The HVR Hub Server service should depend on a Database Management System (DBMS) service to ensure it does not attempt to start before the database is ready. To configure this dependency, use the sc config command.
This configuration applies to both installer and ZIP-based installations.
For example, if the DBMS service is OracleServiceOHS, use the following command:
sc config hvrhubserver_service_name depend=OracleServiceOHS
To list all services related to HVR and verify their names, run the following command:
sc queryex | find "hvr"