Add Host Redistribution - Transaction Rolled back lock wait Timeout

[Former Member]

My Friends!
HANA on AWS
SUSE LINUX 11 sp3

HANA 97

Adding 4th host, during redistribution a very large table is failing.
Your expertise is advised..

The Last time I added hosts I had to Export the table, drop the table, distribute then import the table.. THe table is about 250GB partitioned into 3 parts..

Every time I try to export binary of table it has failed..

Need help!

Please and THank you!

Zachary

[Former Member]

More information..
I extended the lock wait time out value to 3 hours..

One of the data types on the field is a LOB-  insided this field is a very large JSON object from twitter.