ReplicationSyncRequestInfo
- Last UpdatedMar 10, 2025
- 3 minute read
Contains one row for each replication synchronization request. (This is used exclusively for tiered historian installations.)
|
Column |
Data Type |
Description |
|---|---|---|
|
SourceTagName |
TagNameType |
The name of the source tag used for the replication tag. |
|
ReplicationServerName |
nvarchar(255) NULL |
The name of the replication server. |
|
DestinationTagName |
TagNameType |
The name of the destination tag. |
|
EarliestExecutionDateTimeUtc |
datetime2(7) NULL |
The earliest execution date (in UTC) for the replication synchronization request. |
|
ModStartDateTimeUtc |
datetime2(7) NOT NULL |
The start time (in UTC) for the replication synchronization request. |
|
ModEndDateTimeUtc |
datetime2(7) NOT NULL |
The end time (in UTC) for the replication synchronization request. |
|
ReplicationSyncRequestKey |
bigint NOT NULL |
The unique identifier for the replication synchronization request. |
|
ReplicationTagEntityKey |
int NOT NULL |
The unique identifier for the replication tag entity. |
|
RequestVersion |
smallint NOT NULL |
The version type. 0 = Initial version; 1 = Latest version. |
|
ExecuteState |
tinyint NOT NULL |
Value automatically changes as the rep service processes the sync queue. 0 = ready to process; 1 = currently being processed; 2 = rows needs merging/unmerging. |
|
CurrentEditor |
tinyint NULL |
Used to specify which application or editing environment controls the tag definition. Tags imported from the InTouch HMI software use InTouch as the current editor. If modifications are made to an imported tag in the historian Configuration Editor, then the current editor for the tag is changed to AVEVA Historian. If a re-import is performed, any modifications made using the Configuration Editor are preserved. You can manually maintain InTouch as the current editor for re-importing; however, all changes made to the tag using the Configuration Editor are lost during the re-import. Tags (attributes) that are initially configured using AVEVA Application Server use the ArchestrA Integrated Development Environment (IDE) as the current editor. If you modify an Application Server tag using the historian Configuration Editor, then the current editor for the tag is changed to AVEVA Historian. However, the next time you redeploy the engine, the changes are not preserved. 0 = AVEVA Historian; 1 = InTouch; 2 = AVEVA Application Server. |
|
DestinationTagID |
uniqueidentifier NULL |
The unique identifier for the destination tag. |
|
MaximumStates |
tinyint NULL |
Maximum number of states to track for state summary tags. |
|
ReplicationGroupKey |
int NULL |
The unique identifier for the replication group. |
|
ReplicationServerKey |
int NULL |
The unique identifier for the replication server. |
|
Status |
tinyint NULL |
Automatically updated by the system if a change is made to the replication server: 0 = No change; 1 = Insertion; 2 = Modification; 3 = Deletion. |
|
AuthenticateWithAAUser |
bit NULL |
1 if the login should be authenticated using the the Network Account (previously called the ArchestrA User); otherwise, 0 to authenticate with the UserName and Password. |
|
Bandwidth |
int NULL |
The bandwidth in kbps used between tier-1 and tier-2. -1 = unlimited. |
|
BufferCount |
int NULL |
The number of buffers. |
|
Description |
nvarchar(512) NULL |
The description of the replication server. |
|
MinSFDuration |
int NULL |
The minimum duration, in seconds, for the replication service server node to function in store-and-forward mode. The replication service server node functions in store-and-forward mode for this length of time even if the condition that caused replication service server node to function in store-and-forward mode no longer exists. The maximum duration is 3600 seconds, and the minimum is 0 seconds. |
|
Password |
nvarchar(512) NULL |
The password for logging in to the replication server. (AuthenticateWithAAUser must be 0.) |
|
SFFreeSpace |
int NULL |
The free space for the store-and-forward path in MB. |
|
SFPath |
nvarchar(260) NULL |
The local store-and-forward path associated with the replication server for this instance of AVEVA Historian. |
|
ServerDefaultSimpleReplicationNamingScheme |
nvarchar(512) NULL |
Naming rule for simple replication tags. If NULL the naming rule specified in the SimpleReplicationNamingScheme system parameters is used. |
|
ServerDefaultSummaryReplicationNamingScheme |
nvarchar(512) NULL |
The default naming rule for summary replication tags. If NULL, the naming rule specified in the SummaryReplicationNamingScheme system parameter is used. |
|
TCPPort |
int NULL |
The TCP port to use to log in to the replication server. |
|
UserName |
nvarchar(255) NULL |
The user name for logging in to the replication server. (AuthenticateWithAAUser must be 0.) |
|
GroupAbbreviation |
nvarchar(32) NULL |
The abbreviation for the replication group. |
|
ReplicationGroupName |
nvarchar(255) NULL |
The unique identifier for the replication group. |
|
ReplicationScheduleKey |
int NULL |
The unique identifier for the schedule. |
|
ReplicationTypeKey |
tinyint NULL |
Can be 1, 2, or 3. (1 = Simple Replication, 2 = Analog Summary Replication, 3 = State Summary Replication.) |
|
GroupDefaultSummaryReplicationNamingScheme |
nvarchar(512) NULL |
The group default naming rule for summary replication tags. |
|
CompressionEnabled |
bit NULL |
0 = Compression off. 1 = Enable compression for the packets sent to the replication server. |
|
ConnectionDetails |
nvarchar(1024) NULL |
Internal use only. |