Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Show Messages in a Queue

To display a summary list of all the iProcess messages that are currently in a queue, use the following command:

`swadm show_messages` `queue_id``|ALL [EXP] [``-x``]`

where:

| • | `queue_id` is the unique identifier of the queue you want to view messages for. You can find a queue’s identifier using the `show_queues` command. Enter ALL to show the messages in all queues.

| • | `EXP` is an optional parameter used with Oracle databases only. Use it to show all the Oracle exception messages. If this parameter is not specified, when show_messages is used on an Oracle system, it will list only normal messages. But, with other types of database, it will show all the messages.

| • | `-x` is an optional parameter that changes the format in which messages are displayed. If this parameter is specified, one message is displayed per line and fields in the message are separated by '|' characters.

The following example (for Windows/SQL Server) lists all the messages in the DEADQUEUE queue. (The `show_queues` command is used first to identify the `DEADQUEUE`’s `queue_id`, which is `5`.) In this case the DEADQUEUE contains just a single RELEASE instruction that has failed to be processed.

`swadm_show_queues`
Queue ID | Queue Name | Queue Type | Queue Desc
1 | BGMBOX1 | Local | 0003:swpro.sw_db_bgqueue_1
2 | BGMBOX2 | Local | 0003:swpro.sw_db_bgqueue_2
3 | WISMBOX1 | Local | 0003:swpro.sw_db_wisqueue_1
4 | WISMBOX2 | Local | 0003:swpro.sw_db_wisqueue_2
5 | DEADQUEUE | Local | 0003:swpro.sw_db_deadqueue
`swadm show_messages 5`
Queue ID | 5 Message ID: Instruction: Addressee: Procedure: Step Name: Case Number: Req ID: Failed Count: Failed By: | 291E84BA-A898-4D6A-A812-A76BE108B21D RELEASE pro TESTBW2 STEP1 1253 2504 0 BG

The following command displays the same messages in the alternative format:

`swadm show_messages 5 -x` | 5|291E84BA-A898-4D6A-A812-A76BE108B21D|RELEASE|pro|TESTBW2|STEP1|1253|2504|0|BG

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

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.