Problem with our deliveries : ORA-210000 Oracle error: ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-22924: snapshot too old | Community
Skip to main content
O
Ofattah
Level 2
March 17, 2022
Question

Problem with our deliveries : ORA-210000 Oracle error: ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-22924: snapshot too old

  • March 17, 2022
  • 1 reply
  • 1266 views

Hello everyone,

 

I hope you can help us with the recurrent problem we have been facing for two weeks now.

 

5 of our  workflows can't complete the analysis of the recurrent deliveries and we have to restart them each time after the error below, please note that the deliveries are sent after the restart (sometimes we need to restart the workflows 2 or 3 times for the deliveries to be sent)

 

Please note that the volume of the target is low (from 4 to 3000 emails each day) and that the "tablespace undo" has already been modified to 300mb and everything seems ok database-wise.

 

Thank you in advance

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
March 18, 2022

Hello Ofattah,

 

Since these are all Oracle errors I would recommend doing a web search on the errors themselves. I just ran a search for each error and found several articles noting the possible causes and fixes. As I don't have access to your database and cannot confirm the exact solution, I will let you search and review the articles.

 

Regards,

Craig

    O
    OfattahAuthor
    Level 2
    March 22, 2022

    Hello @craig_thonis 

     

    Thank you for your response.

    The error was caused by the "contact date" we implemented in the native scheduler of our recurring deliveries because we wanted to take into consideration the pressure rules.

    This is how the contact date was implemented 

    When we disabled the scheduler ( we opted for "No scheduling..."), there was no problem and all the emails went through.

    Do you have an idea how we can resolve this, please? Because we still need the pressure rules to be taken into account.

     

     

    Thanks 

    Best regards

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    March 30, 2022

    Hi @craig_thonis,

    Could you please help @ofattah further with their query? 

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...