+14Execution error: ERROR: Join [("27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".USR02 x "27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".CDHDR)
using USR02_v1_b0 and previous join (PATH ID: 7)] inner partition did not fit in memory; value [100,BATCH]
Hi Kaveri,
Can I get more insight about the Transformation error? As I understand from Error, it is SAP ( CDHDR) table data. How many Values are you trying to move at a time ?
BR/VM
+14I believe it has huge data set , i am unable to check the count as well as its laoding from long time.
Details of activity:- 7 activity based upon cdhdr and cdpos
It has inner joins of vbak/vbap/vbep/cdpos/cdhdr and left join of usr02. How best i can optimise this.
I tried creating separate transformation of each activity but i get the same result.
Pls enable Debug mode, it will help you for further analysis.
Assume you have chosen the Option Right (standard) and reduce the Batch size to 50% for trail.
Hope it helps..Attached Screenshot.
Br/VM
+14Thanks but i am facing an issue with transformation not extraction . extraction has loaded successfully.
+14It is Add Activity: Changes Schedule Line main one which is giving an issue
To test i have splitted same activity in 5 transformation w.rt activity and running , thinking it might help.
But yes please check Add Activity: Changes Schedule Line and help me how best i can optimise this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
