Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# sw_db_predictqueue_n

Each `sw_db_predictqueue_``n` (where `n` is `1` or `2`) queue table holds messages intended for the background case prediction server processes:

| • | iProcess processes (for example, WIS, DLMGR or RPC_POOL) enqueue messages to the table.

| • | The background case prediction server processes (BGPREDICT) dequeue and process messages from the table.

## Structure

The `sw_db_predictqueue_``n` table has the following structure:

    TABLE sw_db_predictqueue_n (
    	rowid		numeric(15)			NOT NULL
    GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 50),
    	last_failed	numeric(10)			,
    	failure_count	integer				NOT NULL,
    	msg_id		varchar(16) FOR BIT DATA 	NOT NULL,
    	msg_hdr		varchar(500)			,
    	msg_data	varchar(1000)			NOT NULL
    	priority	integer				NOT NULL)

Column | Description
`rowid` | Identifier of the row in the table for this message.
`last_failed` | Number of seconds since January 1st, 1970, when this message last failed to be processed. When this value equals or exceeds the value of the `IQL_RETRY_DELAY` process attribute, the message is retried.
`failure_count` | Number of times that this message has failed to be processed. When this value equals or exceeds the value of the `IQL_RETRY_COUNT` process attribute, the message is moved to the sw_db_deadqueue.
`msg_id` | Unique identifier of this message.
`msg_hdr` | Header data associated with this message.
`msg_data` | Message data.
`priority` | Message queue priority. The lower this value is, the higher the message queue priority is. The default value is 50.

Note | See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the `IQL_RETRY_DELAY` and `IQL_RETRY_COUNT` attributes.

## Primary Key

No primary key is defined for this table.

## Indexes

The following index is defined for this table.

Index Name | Indexed Column(s)
`idx_predictq_`n``1 | `row_id`

## Table Activity

Each `sw_db_predictqueue_n` table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.

A row is... | When...
added | an iProcess process enqueues a message to this table.
updated | a BGPREDICT process dequeues a message from this table but cannot successfully process it (but the message has not exceeded the `IQL_RETRY_COUNT` value).
deleted | a BGPREDICT process dequeues a message from this table and either: successfully processes it. cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the `IQL_RETRY_COUNT` value.

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