oscpmqueue

Queue table for content and processing messages (CP). Holds the pending jobs for external service instances (full-text indexer, rendition cache, page-count service, …​).

Usage and lifecycle of the messages are described under Capture and Processing Messages (CP); reads and writes happen exclusively through the std.CPMessage jobs of the Standard Engine.

1. Columns

Name Type Length Description

messageguid

nvarchar

32

Unique message ID (hex GUID, no separators). Primary key of the table and reference value for std.DispatchCPMessage.

queuename

nvarchar

128

Logical queue name (e.g. FULLTEXTIDX, FULLTEXTDOC, RENDITION). Determines which service instance picks up the message.

osid

int

ID of the DMS object the job refers to.

ostype

int

Numeric object type ID.

created

datetime

Creation timestamp of the message. Used to determine pickup order — the message with the most recent created value is delivered first.

lock_service

nvarchar

128

ServiceName of the service instance currently holding the reservation. NULL = unreserved (free for pickup). Set on pickup and cleared again by std.DispatchCPMessage (removes the message) or by std.ResetServiceCPMessages (releases the reservation).

checkguid

nvarchar

32

Verification GUID, randomly generated on pickup and stored together with lock_service. Allows the server to detect competing reservation attempts from two service instances (optimistic locking).