...

Summary

Your AutomationTool is properly set up, but it seems to not sync your systems?
This is a 50 seconds video of how a successful connection should looks like: 

Error

-------------------------
AppVersion: 19.2.1.0 - Branch: - ChangeSet: 25046 - ReleaseDate: 2019.7.8
2019.08.12|15:14:21
Cannot start service SyncService on computer '.'.
-------------------------

...

• PerformerSuiteSyncService.log (C:\PerformerSuite\Services\logfile)

Cause - Unknown

To reproduce and fix your issues, we need to know why your services stop responding on your machine.

1. Start services.msc (on the machine that is running the services) if both services are currently running
   
2. Check the Recovery Properties for both services to automatically restart the service
   
3. Start eventvwr (on the machine that is running the services) and check for Application Error for PerformerSuiteServices.exe
   Image Modified

Cause - Authorization

There is a connection issue between the AutomationTool to the Performer Suite DB.
In most cases, it is missing write permission on the DB or a firewall blocking the connections.

Solution - Authorization

1) SQL Authorization

1. Go to: "Change connection"
2. Check: "Use SQL Authorization" (Windows Authorization does not work)
   
   
   
3. Check the PerformerSuiteSyncService.log for any error. (C:\PerformerSuite\Services\logfile)
   
   
4. Do you see the error "Database connect: DbVersionTableDoesntExist"?
   If yes:  Give your DB-User write-rights to the table DbVersion.
   
   
5. Make sure the SyncService grabs all the changes, by doing the following steps:
   
   1. "Stop sync service"
   2. "Uninstall sync service"
   3. "Install sync service" again
   4. "Start sync service" again.
      
      
6. Done. Schedule the next sync to the next 5min to run the sync test.
   
   
7. Check the PerformerSuiteSyncService.log for sync-lines (C:\PerformerSuite\Services\logfile):
   
   
   
8. Check the Performer Suite itself for the correct Sync timestamp:
   

2) Compare DB connections

Double-check, if the following two connections are identical:

1. AutomationTool: Mouse-over to see the tooltip showing the DB the AutomationTool is connected to.
2. Performer Suite: Mouse-over to see the tooltip showing the DB the Performer Suite is connected to.
   

Cause - Windows Authorization

In rare cases, the right-click, and "open as administrator" is not enough to be able to install the Services.

Solution - Windows Authorization

Log into Windows directly as an Administrator and install the Performer Suite services through the AutomationTool.

Cause - DB outdated

Your AutomationTool is outdated.
The AutomationTool tries to connect to an incompatible version of your Performer Suite DB.

Solution - DB outdated

Update your AutomationTool to the same version as the Performer Suite DB.

Possible further error

-------------------------
AppVersion: 19.3.0.0 Beta - Branch: Beta - ChangeSet: 25624 - ReleaseDate: 2019.9.18
2019.09.18|15:31:04

System.InvalidOperationException
Message:
Exception occurred while initializing the installation:
System.IO.FileNotFoundException: Could not load file or assembly 'file:///C:\Docu Performer\SyncService\DocuPerformerSyncService.exe' or one of its dependencies. The system cannot find the file specified..

Additional details:
   at System.Configuration.Install.ManagedInstallerClass.InstallHelper(String[] args)
   at ProjectB.AutomationTool.MainForm.UninsallOldSyncService()
   at ProjectB.AutomationTool.MainForm.OnInstallServicesButtonClick(Object sender, EventArgs e)

-------------------------

...