Question:
I am trying to pull in records into BW. There are about 3.5 million records.
After loading data upto 2.5 million the job in R/3 is being cancelled automatically with a short dump.
The error is:
Database error text........: "ORA-01555: snapshot too old: rollback segment
number 14 with name "PRS_14" too small?"
The packet size is 20000. I tried by changing packet size to 10000 and even less.
Can anyone help me in solving this problem.
Thanks a lot
Answer:
Try to load the data in segments by restricting data load using fields selection in the InfoPackage. This will reduce the probability for this error to happen by making your data load size less that can be handled by the system and quicker to complete.
Regards,
_________________
Ali H. Alwan
Atos Origin Middle East
Saudi Arabia
Answer:
Is this error in R/3 or BW. I presume R/3. Snapshot too old happens when BW tries to read large volume of data from R/3 while lots of updates are happening in R/3. R/3 does not realise the BW read needs contents of the rollback segment and when it gets to the end of a segment it recycles it and overwrites data BW has yet to read.
There are some good OSS notes on use of the roll back segments. You will need to make the individual segments larger.