Job cancelled in source system
I am having trouble loading data from CRM to BW.
I have a generic datasource loading the table CRMD_PARTNER. Because this is a large table I have narrowed it down to Partner Function '9'. This decreases the number of records by 2/3rd of the total table size.
When loading it keeps cancelling my job after loading about 8 million records.
The shortdump is a DBIF_RSQL_SQL_ERROR in which is states:
To prevent the exception, note the following:
Database error text........: "ORA-01555: snapshot too old: rollback segment
number 1 with name "_SYSSMU1$" too small"
Internal call code.........: "[RSQL/FTCH/CRMD_PARTNER ]"
Please check the entries in the system log (Transaction SM21).
The weard thing is that I also load table CRMD_LINK which contains the same amount of records but this goes through easily and MUCH faster.
My question is:
How to prevent the job from cancelling?
How to improve the loadtime in which this datasource extracts the table CRMD_PARTNER?