Follow

Configure the Discovery Hub Scheduler Service

During the installation of Discovery Hub, a service is installed on the local machine call "Discovery Hub Scheduler. This service initiates scheduled execution packages that handle the recurring updates of database tables and semantic models in Discovery Hub.

Create the Service Account used to run the Scheduler Service (link to section)

This service will run during the specified schedule to update the tables and semantic models, similar to how a user might execute stored procedures in SQL Server. In this way, the user account configured to run the service will require sufficient user rights within the SQL server to read and write to these tables. So the service must be configured to "Log On As" a user account with the sufficient user rights.  We recommend using a Service Account for this purpose which should be created when you Configure User Accounts & Permissions.

Assign the Service Account to a Project Repository (link to section)

To successfully run execution packages, the Service Account must access the metadata stored in the Discovery Hub project repository. The steps below explain how to link the service account with the correct project repository database.

  1. Log into windows using the service account that will be used to run the scheduler service and launch Discovery Hub. Alternatively, you can navigate to the timextender.exe application file in the Discovery Hub installation directory and press Shift+Right-Click and choose Run as different user.

    RunAsDifferentUser.png

  2. Enter the credentials for the Service Account and click OK. This will run the Discovery Hub application as the Service Account user.

    mceclip0.png

  3. Discovery Hub will ask you to enter the SQL Server and Database name for the project repository. Enter the server and database for the repository you want to associate with the scheduler service. Click OK/Next to confirm your settings. 

    mceclip1.png

  4. Close the instance of Discovery Hub running as the Service Account.

 

Configure the Service (link to section)

  1. Open Discovery Hub from the start menu.
  2. In the Tools menu of Discovery Hub, click on Windows service Setup.

    mceclip2.png

  3. If upgrading from a previous version of Discovery Hub, Stop & Disable previous versions of the service.
    1. Click Options > Filters > All Versions
      mceclip3.png
    2. Find the previous version of the service that's running, Right click > Stop Service. Then, Right-click > Start Mode > Manual. This will stop and disable the previous version of the service.
      mceclip5.png
  4. Find the current version of the Discovery Hub Scheduler service in the list. Right-Click > Start Mode > Automatic Delayed

    mceclip0.png

  5. Right-Click the scheduler service > Change User Name and Password. Enter the credentials for the service account. Click Update and you should receive a confirmation if the credentials were accepted. 

    mceclip2.png
    mceclip3.png

  6. Right-Click the scheduler service > Start Service.

    mceclip4.png

  7. If the configuration was done correctly, the service should start and show "Running"

Configure Auto-restart of the Service (Optional)

  1. Open the Services dialog in Windows. 

    mceclip5.png

  2. Right-click the Discovery Hub Server Scheduler service and select "Properties".
  3. On the Recovery tab, the First failure and subsequent failures should be set to "Restart the service".

    Install19.PNG

Scheduler Service Troubleshooting (link to section)

  1. If you receive a message that the service started and then stopped the most common reasons are listed below:
    1. The Service Account has not been properly assigned to the project repository. Please go back to this section and follow the steps. 
    2. The Service Account does not have the necessary permissions in SQL Server. Please review the article Configure User Accounts & Permissions and ensure the Service Account is either SysAdmin or dbOwner on the Project Repository database. Alternatively, you can use SQL authentication when connecting to the repository from Discovery Hub, as long as that SQL user has the permissions mentioned above. 
  2. If you have started the service, but scheduled executions result in errors regarding the wrong repository, It could be that the old version of the service is still running. 
    1. Find the previous version of the service that's running
      1. Right click > Stop Service.
      2. Right-click > Start Mode > Manual. This will disable the previous version of the service.
        mceclip5.png
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.