MessageHandler table - SuperOffice

MessageHandler Table (241)

Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale

Fields

Name	Description	Type	Nullable
MessageHandler_id	Primary key	PK	No
uniqueIdentifier	GUID identifying the handler, generated by the handler when it starts	String(39)	No
machine	Machine the handler is running on	String(254)	No
port	UDP port this handler is listening on	UInt	No
processIdLow	Low word of process id of the message handler process	UInt	No
processIdHigh	High word of process id of the message handler process	UInt	No
role	1 = request, 2 = respond, 4 = route (bitmapped flags)	Int	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	’heartbeat’ that is updated once a minute by the batch task process	UtcDateTime	No
updated_associate_id	’heartbeat’ that is updated once a minute by the batch task process	FK associate	No
updatedCount	’heartbeat’ that is updated once a minute by the batch task process	UShort	No

Indexes

Fields	Types	Description
uniqueIdentifier	String(39)	Unique
machine	String(254)	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Execute Event Handlers Event Handlers Exists Event Handler Exists Enum EventHandlerType EventHandler Ask another request handler for help

⌘I