How to find out if the order is stuck in resequencer or not?
Please find below steps to find out if the order is stuck in resequencer or not?
Step 1: Find out the common id. For this we need an account number used for order journey. Here I am taking an example of telecom order journey which uses Siebel account number are stored it in AIA_XREF schema of FMW.
select * from xref_cp_accountid where sebl_vfaccountnumber = ‘<<account_number>>’
note down the group id.
Step 2: Here group id is equal to common id. Use below command to know the status of messages.
select creation_date,group_id,component_dn,status, container_id from mediator_resequencer_message where group_id='<<GROUP_ID>>’ order by creation_date desc
if status is equal to 0 and 3 then it is stuck in resequencer.