Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# process_attributes

The `process_attributes` table stores process attribute definitions, which provide configuration information for iProcess Engine server processes.

## Structure

The `process_attributes` table is structured as follows:

    TABLE process_attributes (logical_machine_idINTEGERNOT NULL,logical_process_nameVARCHAR(10)NOT NULL,logical_process_instanceINTEGERNOT NULL,attribute_nameVARCHAR(50)NOT NULL,attribute_valueVARCHAR(1024)NOT NULL,attribute_typeVARCHAR(2)NOT NULL)

Column | Description
`logical_machine_id` | ID of the server where the process instance that this attribute applies to is running, as defined in the node_cluster table. A value of `0` means that this attribute applies to all servers that are part of this node.
`logical_process_name` | Logical name of the process that this attribute applies to. A value of `ALL` means that this attribute applies to all processes on the indicated server. 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 this attribute applies to, as defined in the process_config table. A value of `0` means that this attribute applies to all instances of the indicated process.
`attribute_name` | Name of this process attribute. Note: See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for a list of the available process attributes.
`attribute_values` | Value of this process attribute. Note: See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for a list of the valid values for each process attributes.
`attribute_type` | Type of this process attribute: either `I` (Integer), `C` (Character) or `S` (String). Note: All `attribute_values` are stored as strings in this table. This value determines how the value is returned to the `SWDIR``\bin\swadm` interface.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_process_attributes` | `logical_machine_id logical_process_name logical_process_instance attribute_name`

## Foreign Keys

None.

## Indexes

None.

## Table Activity

The `process_attribute` table contains one row for each unique definition of a process attribute on the system.

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

A row is... | When...
added | a new process attribute definition is added, either at installation or by using the `SWDIR``\util\swadm` utility.
updated | a process attribute definition is updated, using the `SWDIR``\util\swadm` utility.
deleted | a process attribute definition is deleted, using the `SWDIR``\util\swadm` utility.

Note | This table can contain orphan rows in which data can exist that does not apply to any process currently being used.

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