Copyright © Cloud Software Group, Inc. All Rights Reserved

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, show_messages when used on an Oracle system will only list normal messages, 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

---

 

 

Copyright © Cloud Software Group, Inc. All Rights Reserved