Skip to Content

Transfer of 250K rows to Google Cloud SQL fails

Dec 13, 2016 at 10:07 PM


avatar image
Former Member


I am using DS 4.2 SP5 and trying to transfer from on premise 250K row Oracle table to MySQL table on Google Cloud using 10 to 50 bulk loaders.

Every time, a child process fails and I get memory error message half way though the transfer around 100K rows transferred. After first fail, retrying gets is to fail on the same count again and again.

Memory monitoring indicates that there is no problem during the job execution (only 5 Gbs are used out of available 30 GBs).

Anyone have similar experiences and working with cloud databases on Google or AWS?

It seems like BODS was not just build/designed to work with non-SAP cloud platforms well.

capture.png (52.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers