While working on Informatica MDM jobs, I came across one issue. The issue is an ORA-01555: snapshot too old. This error message was reported while running the tokenization job. If you are also noticing a similar issue then this article will help. This article provides details about an error message and a solution to fix it.
java.sql.BatchUpdateException: ORA-01555: snapshot too old: rollback segment number 11 with name "_SYSSMU11_2399779032$" too small
SIP-16084: Error occurred while verifying the need to tokenize records. Return code 12801,
Error SQLException During VerifyNeedToStrip :ORA-12801: error signaled in parallel query server P000,
ORA-01555: snapshot too old: rollback segment number 30 with name "_SYSSMU30_2998435469$" too small.
Step 4: If the value is lower then increase the value to 4000 by executing the command below
ALTER SYSTEM SET UNDO_RETENTION = 4000;
Step 5: Increase Undo Tablespace to Auto Extended on.
Step 6: Restart the database servers with the clear cache
Step 7: Drop T$ table if present any in database
Step 8: Start the MDM servers with a clear cache.
This will fix the issue. I hope this is helpful. You can learn more about job tuning here -