Interviewer - Server > Administration and maintenance > Databases > mrInterviewData database stored procedures > UNICOM Intelligence Interviewer synchronization tables > InterviewerSyncSessions table
 
InterviewerSyncSessions table
The InterviewerSyncSessions table records when each remote device synchronizes with the server.
Fields
Id
Data type: int
The unique identifier, assigned by the SQL Server, for this table. The Id in unique for each session.
DeviceId
Data type: nvarchar(256)
The device ID.
InterviewerId
Data type: nvarchar(200)
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.
ServerHostName
Data type: nvarchar(256)
The hostname of the server hosting the session. This is useful when there are multiple synchronization servers.
ClientHostName
Data type: nvarchar(256)
The client computer name. This is used to identify the computer that initiated the synchronization.
ClientUserName
Data type: nvarchar(256)
The user name that is logged into the client computer that initiated the synchronization.
StartTime
Data type: datetime
The synchronization session start time.
EndTime
Data type: datetime
The synchronization session end time.
Result
Data type: int
The result code, returned from the client, at the end of the synchronization session.
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 be populated when the server is forced to terminate the synchronization session (for example, when the SyncService application is terminated by an IISRESET).
The Synchronization Web Service will timeout the synchronization session and populate the EndTime and Result columns when the client does not make any requests to the server for one hour. This timeout value is configurable via 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.
See also
UNICOM Intelligence Interviewer synchronization tables