Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# eai_registry

The `eai_registry` table stores information about each iProcess server plug-in that is installed on this iProcess Engine. The background process reads this table to determine which iProcess server plug-ins to start.

## Structure

The `eai_registry` table has the following structure:

    TABLE eai_registry(
    	eai_type		VARCHAR(20)	NOT NULL,
    	logical_machine_id	INTEGER		NOT NULL,
    	release_version		VARCHAR(32)	NOT NULL,
    	plugin_library		VARCHAR(256)	NOT NULL,
    	init_params		VARCHAR(1024)	)

Column | Description
`eai_type` | Short name for the EAI Step type that this iProcess server plug-in supports. For example, one of the following:
| • | `EAIDB``` EAI Database
| • | `EAISCR``` EAI Script
| • | `EAIWEBSERVICES``` EAI Web Services
`logical_machine_id` | ID of the computer that this iProcess server plug-in is installed on, as defined in the node_cluster table. Note: If a node cluster architecture is in use, the iProcess server plug-in must be installed on each server in the cluster that is configured to run a background process.
`release_version` | Version number of this iProcess server plug-in (for example, i10.0-u(4.0)).
`plugin_library` | Pathname (on this `logical_machine_id`) where this EAI server plug-in is installed.
`init_params` | Startup parameters used by this iProcess server plug-in.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_eai_registry` | `eai_type logical_machine_id`

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_eai_registry` 1 This key enforces the DELETE CASCADE referential action. | `logical_machine_id` | node_cluster

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_eairegistry_fk` | `logical_machine_id`

## Table Activity

The `eai_registry` table contains one row for each iProcess server plug-in that is installed on each server in this iProcess Engine node.

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

A row is... | When...
added | an iProcess server plug-in is installed.
updated | an iProcess server plug-in is upgraded or amended.
deleted | an iProcess server plug-in is deleted.

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