Skip to Content
0

Access plan calculation is getting failed for both CDPOS

Nov 16, 2016 at 04:07 PM

205

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers