How to find out if the order is stuck in resequencer or not?

How to find out if the order is stuck in resequencer or not?

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.

For more such weblogic issues and resolution click here.

Latest Weblogic Interview Questions and Answers

How to Prevent the ‘WLS_DIAGNOSTICSxxxxxx.DAT’ file from Growing Too Large

ThreadDump and How to Analyse it?

AWK command in Linux with examples

Apache Proxy log Throws READ_ERROR_FROM_FILE

ORA-01555: snapshot too old: rollback segment number with name “” too small

Weblogic Issue-Caused By: weblogic.utils.ErrorCollectionException

Server subsystem failed. Reason: java.lang.NumberFormatException: null

Cloud Computing Interview Questions And Answers

Frequently Asked CSS Interview Questions And Answers

[UPDATED] Django Interview Questions And Answers