ORA-01555: snapshot too old: rollback segment number N with name "X" too small

[LAR1985]

Hello community,

We are experiencing the following issue: occasionally, when running workflows, we get the following error in some deliveries "ORA-210000 Oracle error: ORA-01555: snapshot too old: rollback segment number N with name "X" too small". These are isolated errors that do not happen always in the same workflows and always work when re-run. What could be causing this?

Thanks

[Rch_ · Accepted solution]

Hi @LAR1985,

This error usually happens when a workflow is running a query that takes a long time, and the database can’t keep up with all the changes happening at the same time. Because of that, some data it needs gets cleaned up too soon.

Since it only happens sometimes and works when you try again, it’s likely due to the database being busy or having limited space for temporary data.

A few things that can help:

• Ask your DBA to give more space for undo data and keep it longer.

• Try running big workflows during quieter times.

• Break big workflows into smaller parts if you can.

• Look at how complex your queries are and try to simplify them.

Hope that helps! Feel free to ask if you want tips on checking your workflows.

Thanks,