![]() |
Copyright © TIBCO Software Inc. All rights reserved. |
Default SQL Database Queue Tables (Test)Each message queue defined in the iql_queues table must be mapped to its own SQL database queue table.When the iProcess Engine is installed, the init2Ksql.sql script creates the default set of queue tables required by the system (see Default Message Queues and SQL Database Queue Tables).
If you subsequently decide to add additional message queues to your system, you must manually create the queue tables needed by those message queues. See Creating Additional SQL Database Queue Tables for more information about how to do this.Each sw_db_bgqueue_n (where n is 1 or 2) queue table holds messages intended for the background processes:TABLE sw_db_bgqueue_n (
rowid NUMERIC(15) identity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
When this value equals or exceeds the value of the IQL_RETRY_DELAY process attribute, the message is retried. When this value equals or exceeds the value of the IQL_RETRY_COUNT process attribute, the message is moved to the sw_db_deadqueue.
See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the IQL_RETRY_DELAY and IQL_RETRY_COUNT attributes.The following clustered index is defined for this table.
Each sw_db_bgqueue_n table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.
cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the IQL_RETRY_COUNT value.Each sw_db_wisqueue_n (where n is 1 or 2) queue table holds messages intended for the Work Item Server Mbox daemon process:TABLE sw_db_wisqueue_n (
rowid NUMERIC(15) identity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
When this value equals or exceeds the value of the IQL_RETRY_DELAY process attribute, the message is retried. When this value equals or exceeds the value of the IQL_RETRY_COUNT process attribute, the message is moved to the sw_db_deadqueue.
See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the IQL_RETRY_DELAY and IQL_RETRY_COUNT attributes.The following clustered index is defined for this table.
Each sw_db_wisqueue_n table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.
the WISMBD process dequeues a message from this table and either:cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the IQL_RETRY_COUNT value.Each sw_db_predictqueue_n (where n is 1 or 2) queue table holds messages intended for the background case prediction server processes:TABLE sw_db_predictqueue_n (
rowid NUMERIC(15) identity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
When this value equals or exceeds the value of the IQL_RETRY_DELAY process attribute, the message is retried. When this value equals or exceeds the value of the IQL_RETRY_COUNT process attribute, the message is moved to the sw_db_deadqueue.
See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the IQL_RETRY_DELAY and IQL_RETRY_COUNT attributes.The following clustered index is defined for this table.
Each sw_db_predictqueue_n table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.
cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the IQL_RETRY_COUNT value.The sw_db_deadqueue table holds failed messages from the sw_db_bgqueue_n, sw_db_wisqueue_n and sw_db_predictqueue_n tables.TABLE sw_db_deadqueue (
failed_by varchar(64) NOT NULL
rowid NUMERIC(15) iden tity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
Note: Messages in this table are not retried. The following clustered index is defined for this table.
The sw_db_deadqueue table contains one row for each message that has exceeded its IQL_RETRY_COUNT threshold value.
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.
![]() |
Copyright © TIBCO Software Inc. All rights reserved. |