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