Basic Notifcation error handling | managing status flag = Y when DB is down

, ,
1

Hello

I have a basic notification which polls on staging table every 30 seconds hosted in EDM_WM_STG DB, with below settings & the WM_STATUS_FLAG is updated to P/G/E by the flow service during processing -

Record ID column : WM_STG_SEQ
Mark ID Column : WM_STATUS_FLAG
Exactly Once : True
Where clause : WM_STATUS_FLAG is null
order by : WM_STG_SEQ

Issue : Whenever the DB is not available there are multiple records stuck with WM_STATUS_FLAG = Y. Since the where clause is WM_STATUS_FLAG is null , these records are not picked.

Question : Is there any way i can handle this situation better instead of manually setting the Y records back to NULL after the DB is back.

Thanks in advance for the answers.

Regards
Shreyus

2

Who is setting the flag to Y is it by your program or automatically?

WM_STATUS_FLAG = Y

3

Hello

Status Y is not set manually, I think it’s set automatically by the notification as it picks the record and publishes the doc.

Regards
Shreyus

4

No, i am sure your stating table is being updated manually by the notification processing service.

5

the subsequent status after Y are done manually, but the status Y is done automatically by the notifications, isnt it?