cancel
Showing results for 
Search instead for 
Did you mean: 

Access plan calculation is getting failed for both CDPOS

rajesh_gollapudi
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

SandeepNelly
Explorer
0 Kudos

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

jacques_vandenberg2
Discoverer
0 Kudos

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

SandeepNelly
Explorer
0 Kudos
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