Siebel Store-and-Forward Messaging Guide for Mobile Web Client > Administration of Siebel Store-and-Forward Messaging >

Inspecting and Clearing Store-and-Forward Messaging Queues


The sfmutil.exe utility lets you perform the following actions on problematic Store-and-Forward Messaging queues for Mobile Web Clients:

  • Gather information about the first message in a queue
  • Save the first message in a queue to a file
  • Remove the first message from a queue
  • Remove all messages from a queue

This topic describes how to perform each of these actions. For more information about the sfmutil.exe utility, see About Inspecting and Clearing Store-and-Forward Messaging Queues.

The following procedure describes how to use sfmutil.exe to gather information about the first message in a problematic queue.

To gather information about the first message in a problematic queue

  1. On the Siebel Server where the queue resides, navigate to the siebsrvr\bin directory.
  2. From the Windows Start menu, choose Start > Run, then enter cmd.exe and click OK to open a command window.
  3. In the command window, enter the following command:

    sfmutil /u sadmin_userID /p password /s ODBC_data_source /D table_owner /c app_cfg_file /l language_code /N mobile_web_client /M Y /Q queue_name /X subsystem_name

    Sfmutil displays the message type and ID number on screen.

The following procedure describes how to use sfmutil.exe to save a copy of the first message in a problematic queue to a file. In some circumstances, a Support representative may ask you for this file as part of the effort to resolve a problem.

To save the first message in a problematic queue to a file

  1. On the Siebel Server where the queue resides, navigate to the siebsrvr\bin directory.
  2. From the Windows Start menu, choose Start > Run, then enter cmd.exe and click OK to open a command window.
  3. In the command window, enter the following command:

    sfmutil /u sadmin_userID /p password /s ODBC_data_source /D table_owner /c app_cfg_file /l language_code /N mobile_web_client /A file_name /Q queue_name /X subsystem_name

    Sfmutil writes a copy of the message to the file that you specify with the /A argument. The /A argument does not affect the contents of the queue.

The following procedure describes how to use sfmutil.exe to remove the first message from a problematic queue.

To remove the first message from a problematic queue

  1. On the Siebel Server where the queue resides, navigate to the siebsrvr\bin directory.
  2. From the Windows Start menu, choose Start > Run, then enter cmd.exe and click OK to open a command window.
  3. In the command window, enter the following command:

    sfmutil /u sadmin_userID /p password /s ODBC_data_source /D table_owner /c app_cfg_file /l language_code /N mobile_web_client /R Y /Q queue_name /X subsystem_name

    The message is moved from InboundRTSQ to InboundRTSQ.MWC_name, where MWC_name is the name of the Mobile Web Client associated with the message. Then the message is deleted from the InboundRTSQ.MWC_name queue.

NOTE:  If you combine the use of /A and /R arguments, sfmutil saves a copy of the first message in the queue before deleting that message from the queue.

The following procedure describes how to use sfmutil.exe to remove all messages from a problematic queue.

CAUTION:  When you remove all messages from a queue, the messages are discarded and they cannot be recovered.

To remove all messages from a problematic queue

  1. On the Siebel Server where the queue resides, navigate to the siebsrvr\bin directory.
  2. From the Windows Start menu, choose Start > Run, then enter cmd.exe and click OK to open a command window.
  3. In the command window, enter the following command:

    sfmutil /u sadmin_userID /p password /s ODBC_data_source /D table_owner /c app_cfg_file /l language_code /N mobile_web_client /Z Y /Q queue_name /X subsystem_name

    Sfmutil removes all messages from the queue and discards them permanently.

Siebel Store-and-Forward Messaging Guide for Mobile Web Client Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.