on 11-16-2016 4:07 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.