Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# sw_db_deadqueue

The `sw_db_deadqueue` table holds failed messages from the sw_db_bgqueue_n, sw_db_wisqueue_n and sw_db_predictqueue_n tables.

## Structure

The `sw_db_deadqueue` table has the following structure:

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

Column | Description
`failed_by` | Identifies the queue table that this message originates from. One of the following processes: BG (for a message from a sw_db_bgqueue_n table). WIS (for a message from a sw_db_wisqueue_n table). BGPREDICT (for a message from a sw_db_predictqueue_n table).
`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.
`failure_count` | Number of times that this message has failed to be processed. Note: Messages in this table are not retried.
`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.

## 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_deadqueue` 1 | `row_id`

## Table Activity

The `sw_db_deadqueue` table contains one row for each message that has exceeded its `IQL_RETRY_COUNT` threshold value.

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

A row is... | When...
added | a message is moved to this table from a sw_db_bgqueue_n, sw_db_wisqueue_n or sw_db_predictqueue_n table, because it has exceeded the `IQL_RETRY_COUNT` value.
updated | never.
deleted | never.

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