Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# sw_subscription_list

The `sw_subscription_list` table stores the list of event subscription records currently defined on the system. Each event subscription record defines the event that is being subscribed to and the process instance that has subscribed to it.

The `sw_subscription_list` table is a persistent copy of the event daemon’s in-memory subscription list. If the event daemon fails for any reason, it rebuilds its subscription list from this table when it restarts.

## Structure

The `sw_subscription_list` table has the following structure:

    TABLE sw_subscription_list (
    event_topic_id			integer		NOT NULL,
    logical_machine_id		integer		NOT NULL,
    logical_process_name		varchar(10)	NOT NULL,
    logical_process_instance	integer		NOT NULL,
    notify_port_number		integer		NOT NULL,
    machine_name			varchar(256)	NOT NULL)

Column | Description
`event_topic_id` | ID of the iProcess event that has been subscribed to.
`logical_machine_id` | ID of the server where the subscribing process is running, as defined in the node_cluster table.
`logical_process_name` | Logical name of the process that has subscribed to this event. Note: See Administering iProcess Engine Server Processes in TIBCO iProcess Engine: Administrator's Guide for a list of logical process names.
`logical_process_ instance` | ID of the process instance that has subscribed to this event, as defined in the process_config table.
`notify_port_number` | Number of the RPC port that is used to notify the subscribing process when the event occurs.
`machine_name` | Physical name of the server where the subscribing process is running, as defined in the node_cluster table.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_sw_sub_list` | `event_topic_id logical_machine_id logical_process_name logical_process_instance`

## Foreign Keys

None.

## Indexes

None.

## Table Activity

The `sw_subscription_list` table contains one row for each event subscription currently defined on the system.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a process instance subscribes to an event.
updated | details of a subscribing process are changed. For example, if a process in a node cluster is moved to another server.
deleted | a process instance unsubscribes from an event.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine