If you are using the Demandforce sync and have the Demandforce Data Service running on your server, you may occasionally receive a message inside of WorkSpace that indicates the Demandforce Data Service encountered a problem. This guide is meant to help explain the most common messages and help you get everything running perfectly again once one has been encountered.
Problem # 1: ‘Error connecting with SSL’ or ‘SSL Socket Error ####’
This error can be caused by a few things, but the most common is that the Demandforce Data Service experienced an internet connection failure during the time it was attempting to send your data to the Demandforce servers.
When this error occurs, you can simply dismiss it because it will usually resolve itself. But if it occurs twice in a row (two consecutive extracts), you will need to go on your server (that hosts the Demandforce Data Service), go to Control Panel -> Administrative Tools -> Services, select the ‘Office Tools Demandforce Data Service’ entry, and click ‘Restart’. This should resolve the problem for future extracts.
Problem # 2: ‘Error During Sync: Retrieving the COM class factory for component with CLSID…’
This error is rare, but sometimes occurs after a system reboot on your server. When this happens, you need to go on your server and navigate to the Demandforce Data Service install directory (default is ‘C:\Program Files (x86)\Office Tools\Demandforce Data Service’). Once in the install directory, locate the file called ‘D3ComSvr.dll’ and note the full path to the file. Now open a command prompt (windows xp & server 2003 : Start -> Run -> cmd.exe, Vista & server 2008+ : Start -> cmd.exe), and type in the following (without the single quotes at the beginning and end) : ‘regsvr32 “[PATH TO D3ComSvr.dll FILE]”‘ and press ‘Enter’. You should get a message that states ‘DllRegisterServer in ‘[path to file]’ succesded.’
Replace the [PATH TO D3ComSvr.dll FILE] text with the path to the file we located earlier. In most cases the command will be: ‘regsvr32 “C:\Program Files (x86)\Office Tools\Demandforce Data Service\D3ComSvr.dll”‘.
If you do not get the ‘Succeeded’ message when running the command, you will need to run the command prompt as an administrator. On Windows Vista (Server 2008) and newer systems, Click Start and type in ‘cmd’, but instead of pressing ‘Enter’, right-click on ‘Command Prompt’ and select ‘Run As Administrator’. Click ‘Yes’ to the UAC prompt that will then show, and attempt to type in the regsvr32 command again. It should now succeed.
Problem #3: ‘Cannot open log for source ‘OTPM_DFService’. You may not have write access’
This error is caused by insufficient user rights on the ‘Local System’ account profile. In order to function properly, the Demandforce Data Service requires Create/Write access to the Windows Event Log. In order to correct this issue, you must either: A) add the required user rights to the ‘Local System’ user profile, or B) Inform the service to run under a different user profile (one with sufficient privileges).
To add the required user rights, you must see your system or network administrator.
To update the service to use a different account:
- go to (Control Panel -> Administrative Tools -> Services)
- Right-Click on ‘Office Tools Demandforce Data Service’ in the list, and click ‘Properties’
- Switch to the ‘Log On’ tab
- Click the ‘This Account’ option, and use the ‘Browse…’ button to select an account with the proper permissions
- Enter in the password for the account, then confirm the password
- Click ‘OK’
- Right-Click on ‘Office Tools Demandforce Data Service’ in the list again, and click ‘Restart’
The user rights required for the Demandforce Data Service to function properly are:
- Create/Write access to the Windows Event Log
- Read/Write/Create access to [%ProgramData%\Office Tools Professional]
- Unrestricted internet access to the Demandforce and Office Tools Professional web servers
- Unrestricted network access to the Office Tools SQL Database instance