Skip to Content
0

Access plan calculation is getting failed for both CDPOS

Nov 16, 2016 at 04:07 PM

430

avatar image
Former Member

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.

2 Answers

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

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

Show 1 Share
10 |10000 characters needed characters left 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

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

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

Share
10 |10000 characters needed characters left characters exceeded