Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# process_event_log

The `process_event_log` table logs all changes in the status of server process instances.

## Structure

The `process_event_log` table has the following structure:

    TABLE process_event_loglogical_machine_idINTEGERNOT NULL,logical_process_nameVARCHAR(10)NOT NULL,logical_process_instanceINTEGERNOT NULL,process_idINTEGERNOT NULL,process_statusINTEGERNOT NULL,process_status_commentVARCHAR(255)NULL,timestampDATETIMENOT NULL)

Column | Description
`logical_machine_id` | ID of the server where the process instance that this event applies to is running, as defined in the node_cluster table.
`logical_process_name` | Logical name of the process that this event applies to. Note: See "Administering iProcess Engine Server Process" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
`logical_process_ instance` | ID of the process instance that this event applies to, as defined in the process_config table.
`process_id` | Process ID (PID) of the process instance that this event applies to.
`process_status` | Status change event that occurs for the specified process instance. One of the following:
| • | `3000` - process instance started.
| • | `3001` - process instance stopping.
| • | `3002` - process instance stopped.
| • | `3003` - process instance died.
| • | `3004` - process instance paused.
| • | `3005` - process instance unpaused.
`process_status_comment` | Description of the `process_status` entry, as reported to the Process Sentinels by the process.
`timestamp` | Date and time that this event occurred.

## Primary Key

None.

## Triggers

None.

## Indexes

None.

## Table Activity

The `process_event_log` table contains one row for each status change event that has occurred to each instance of a server process.

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

A row is... | When...
added | a process starts, receives a shutdown command, or shuts down.
updated | never.
deleted | never. Note: Because rows are never deleted automatically, TIBCO recommend that you regularly monitor the size of this table and delete or archive rows manually if you need to.

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