We are experiencing some sort of Oracle time out while using TPT, and extracting data from Oracle and load to TD.
The same job runs okay for a smaller dataset however it fails every now and then for huge data.
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
MSG='[TPT][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 700 with name "_SYSSMU700_xxxxxxxxxx$" too small'
Is this due to the fact that Oracle Commit is not happening sooner? If so is there a way to force TPT to perform Commit and let Oracle know about active session while reading and not pretending to be idle?
I looked on the TPT commit however I am not able to see any parameter that I can force to change the session to do frequent commit.