Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

SearchMessageSyncRequest

  • Last UpdatedMar 10, 2025
  • 1 minute read

Contains one row for each search message synchronization request. (This is used exclusively for tiered historian installations.)

Note: This table is for internal use only. Do not edit this table.

Column

Data Type

Description

(PK)
Id

int, NOT NULL

The unique numerical identifier for a search message synchronization request.

JobId

nvarchar(255), NOT NULL

The unique numerical identifier for a search message synchronization job.

Indexing
Message

nvarchar(MAX), NOT NULL

Details from the JSON file used for search indexing to make the associated content searchable. This is an example:

{"_messageid":"test_636571577850365608","_tenantid":"","_body":[{"_keywords":[],"_fields":[{"ContentName":"test","_analyzers":"nGram"}],"_id":"afwwGwD30FUMl9UpE

DocumentType

nvarchar(50), NOT NULL

Specifies the type of index document; for example SavedContent or Tag.

DeQueue
Count

smallint, NULL

The number of times this message has been dequeued.

JobSubmisionTimeUtc

datetime2(7), NOT NULL

The time the job was submitted in UTC time.

LastModified
TimeUtc

datetime2(7), NULL

The time the job was last modified in UTC time.

Status

smallint, NULL

The status of the search message synchronization job.

Related Links
TitleResults for “How to create a CRG?”Also Available in