Replication of CDPOS table failing

[Former Member]

Hi ,

We are trying to replicate CDPOS table from ECC to Hana.

During the initial load , the following happens.

It is getting failed with the following error "ORA-01555:snapshot too old:rollback segment number 28 with name "_SYSSMU28_1094773238$" too small". This error occurs in the ECC system.

I have tried many times but it fails after running for more than 20 hours .

Please help.

Thanks,

Rajiv

[Former Member · Accepted solution]

Hi Rajiv,

Did you get any solution for this?

We also facing same issue.

Best Regards,

Krishna.

[Former Member · Accepted solution]

yes it was solved by

increasing number of /initial/ calculation jobs and edting the following tables

UUC_PRECALC_OBJ-NUMREC

           IUUC_PERF_OPTION-PARALL_JOBS

Regards,

Rajiv

[candy_zhan]

Hi Rajiv,

ORA-01555 is a typical ORACLE error than SLT. Note 185822 introduces the possible causes if you are interested.

The fast way to solve this issue is to increase the undo tablespace in the ECC. You can ask your ORACLE DBA to help increase the UNDO tablespace temporarily.

Best regards,

Candy