Clarity

  • 1.  Jasper schedule failed

    Posted Oct 15, 2018 04:17 PM

    A Jasper schedule failed saying Error executing SQL statement followed by this Strange Issue "Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 17 with name "_SYSSMU17_3827677235$" too small"

     

    Please advice why this ORA-01555 snapshot too old error occurs. This is first time i have faced this.



  • 2.  Re: Jasper schedule failed

    Broadcom Employee
    Posted Oct 16, 2018 02:06 AM

    Hi Santosh,

     

    Snapshot issues are common occurrence when your report query takes lot of time to execute. 

     

    Please refer the below link for more details.

     

    ORA-01555 Snapshot Too Old