RR_4035: snapshot too old

[JDAEMS]

Dear,

When running a session, the session gets failed... sometimes after 1 hour, sometimes after 2 hours, sometimes after 3 hours.

The source table contains about 600.000 records. After a record is loaded into the target table, the source table gets updated as well to set a processed flag to 1.

Every time it is the same error message, which I don't know what I can do against it:

RR_4035 SQL Error [
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small

Database driver error...
Function Name : Fetch
SQL Stmt : SELECT STG_RATE_DWHI.CASEQNR, STG_RATE_DWHI.CAIDEN, STG_RATE_DWHI.CATYPE, STG_RATE_DWHI.CACENT, STG_RATE_DWHI.CAFSYR, STG_RATE_DWHI.CAFSMN, STG_RATE_DWHI.CAFDAT, STG_RATE_DWHI.CACDAT, STG_RATE_DWHI.CACUFR, STG_RATE_DWHI.CACUTO, STG_RATE_DWHI.CARATE, STG_RATE_DWHI.CAADTE, STG_RATE_DWHI.CAATME, STG_RATE_DWHI.CAPF01 FROM STG_RATE_DWHI
Oracle Fatal Error
Database driver error...
Function Name : Fetch
SQL Stmt : SELECT ...etcetera


Can anyone help me with this problem? It will be much appreciated.

Thank you in advance.

Kind regards
J.

 

[smirji]

Hi! J
It appears this is a DBA issue. The DBA has to look into this problem, and correct the Rollback segment size on your database.