Skip to Content
avatar image
Former Member

Access plan calculation is getting failed for both CDPOS

Dear Colleagues,

We have issues with the CDPOS table replication in our SLT system.

Below is the environment details.

Source system is : ECC on HANA

SLT :

Destination : Native HANA

CDPOS:

When we tried to perform replication from source to destination, SLT has triggered the one access plan calculation job on both SLT and source system, within seconds the job which is running on source system got failed with the below dump:

####################################

SQL error "SQL code: 129" occurred while accessing table "CDPOS".

Database error text: "SQL message: transaction rolled back by an internal error: exception 10001001: Search result size limit exceeded: 6589781184#"

######################################

I have tried to split the access plan calculation by using the table IUUC_PRECALC_OBJ with the 028650000 of records and tried to execute the access plan from /nMwbmon, triggered jobs are getting finished with 0 seconds and table is going to error status.

In my LTRS below settings are on for this table:

No.of parallel jobs : 4

Reading type for initial load is 4 since this is cluster table.

In source system we have 6,594,916,956.

Could you please help us to proceed further on this.

Regards,

Rajesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 06 at 07:08 AM

    Hi Rajesh,

    Did you manage to resolve this? I have run into the same issue with table KONV in my source system which has 4.5Billion Records.


    Regards,

    Jacques

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Hi Jacques,

      Try to remove the entry of KONV from table IUUC_PRECALC_OBJ in SLT and start the Intial load/Replication again.

      regards,

      Sandeep nelly

  • avatar image
    Former Member
    Mar 24 at 02:05 AM

    Hi Rajesh,

    I was able to resolve similar issue but remove the entry of KONV from table IUUC_PRECALC_OBJ in SLT .

    Hope this will resolve your issue too.

    Regards,

    Sandeep Nelly

    Add comment
    10|10000 characters needed characters exceeded