Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Many thanks!


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question