Traveltransactionlog is not enabled (SuperOffice Onsite)

Overview

When you have a SuperOffice Onsite environment and start using Synchronizer for SuperOffice, you can get below error when creating a profile:

Open

You get this message because Travel is not enabled in your database. Synchronizer for SuperOffice needs this for the syncing process.

Solution

In earlier SuperOffice versions, it was possible to enable Travel in SuperOffice Admin, but with versions 9.x and 10.x this is not possible anymore.
Therefore, this needs to be enabled by adding an SQL record to the SuperOffice database.

How to

Open SQL Management Studio and perform the following query on the SuperOffice database:

DECLARE @userprefnext_id int;
SET @userprefnext_id=(select next_id from [CRM].[SEQUENCE] where id = 66)
UPDATE [CRM].[SEQUENCE] SET next_id=@userprefnext_id+1 where id = 66;
INSERT INTO CRM.USERPREFERENCE VALUES (@userprefnext_id, 2, 0, 0, 'Travel', 'EnableTravel', 1, '1760-01-01 00:00:00.000', 0, '1760-01-01 00:00:00.000', 0, 0)

NOTE: Replace CRM with the corresponding prefix for the database