Question
Standard Chartered Global Business Services Sdn. Bhd.
MY
Last activity: 20 Nov 2018 13:43 EST
Email processing during DB fluctuation
We are having deadlock situation happening in Prod where we are getting DB fluctuation, pega email listener is not able to write the opened email to DB.
Technically its stability issue in region still the objective is to make it as unread when the DB fluctuation is detected.
I have few work around to do email exception handling at service level and the desired expectation is once it received in email box, listener opens the email and if any DB exception is returned then the email should be considered for retry when the DB is available.
Note: during the exception I don’t have options to save somewhere making its as unread is good option to make it available for retry.
Please share your valuable thoughts and let me know if any other info need for issue
Pegasystems Inc.
FR
Hello,
This is a difficult situation to handle when the DB is suddenly kind of stopping like that. Unfortunately you won't be able to store anything at DB level.
Maybe you could try to save the eml file on a directory somewhere.
Standard Chartered Global Business Services Sdn. Bhd.
MY
Thanks MarcLasserre_GCS .. for the option.
Let me make it clear during DB commit failure. Is it possible to make the emails as unread or before reading the emails is it possible to check the DB availability?
The Best part in email listener and I like the option to send email during case creation failure. It should help the end user to resend the email if he gets failure response from system .
I can understand DB is back bone of any pega APP. Let me also try by improve the DB stability