InterviewerSyncSessions table

Developer Documentation Library > Interviewer - Server > Administration and maintenance > Databases > UNICOM Intelligence Interviewer synchronization tables > InterviewerSyncSessions table

The InterviewerSyncSessions table records when each remote device synchronizes with the server.

Fields

The unique identifier, assigned by the SQL Server, for this table. The Id in unique for each session.

Data type: int

DeviceId

The device ID.

Data type: nvarchar(256)

InterviewerId

The interviewer that was logged in at the time of the synchronization. This field will be NULL if no interviewer was logged in.

When the interviewer is logged in during synchronization, the Synchronization Console only synchronizes projects that are assigned to the logged in user.

When an interviewer is not logged in during synchronization, the Synchronization Console synchronizes projects for all users in all clusters.

Data type: nvarchar(200)

ServerHostName

The hostname of the server hosting the session. This is useful when there are multiple synchronization servers.

Data type: nvarchar(256)

ClientHostName

The client computer name. This is used to identify the computer that initiated the synchronization.

Data type: nvarchar(256)

ClientUserName

The user name that is logged into the client computer that initiated the synchronization.

Data type: nvarchar(256)

StartTime

The synchronization session start time.

Data type: datetime

EndTime

The synchronization session end time.

Data type: datetime

Result

The result code, returned from the client, at the end of the synchronization session.

Data type: int

Notes

The Id, DeviceId, ServerHostName, ClientHostName, ClientUserName, and StartTime columns are populated when the synchronization session starts. The EndTime and Result columns are populated when the client ends the synchronization session.

The EndTime and Result columns are also populated when the server is forced to terminate the synchronization session (for example, when the SyncService application is terminated by an IISRESET).

When the client does not make any requests to the server for one hour, the synchronization web service timeouts the synchronization session and populate the EndTime and Result columns . This timeout value is configurable by settings a SyncSessionTimeout value (in minutes) that is specified in the web.config file. The default value is 60 minutes with a minimum value of 1 minute and a maximum value of 1440 minutes (one day).

The StartTime field is indexed in order to allow old entries in the InterviewerSyncSessions table to be removed quickly and efficiently.

Result codes

Result code	Description
0 = success	The synchronization completed successfully.
1 = error - cachefiles	An error occurred when uploading cache files.
2 = error - siteinfo	An error occurred when updating SiteInfo.
4 = error - project files	An error occurred when updating the project.
8 = error - log files	An error occurred when uploading the client log to the server.
16 = user abort	A user manually canceled the synchronization.
32 = error - console configuration	An error occurred when updating the console configuration.
64 = error - sample data	An error occurred when updating sample data.
128 = error - quota data	An error occurred when updating quota data.
256 = error - project data - participant and quota	An error occurred when downloading project data (for example, participant and quota data).
512 = error - shared content files	An error occurred when updating shared content.
1024 = error – respondent files	An error occurred when uploading respondent files.

The result codes are sent from the client to the server at the end of the synchronization session and are used to indicate if the synchronization was successful (from the client's point of view), or to indicate if there was a problem. The result codes are bit flags and can therefore be combined when multiple errors occur.

This list can be extended to support the server result codes for the session:

Server result codes

Result code	Description
2048 = Error – Server Restarted	An error occurred because the server restarted.
4096 = Error – Session Timed Out	An error occurred because the session timed-out.