Skip to Content
0
Former Member
Mar 21, 2014 at 07:17 PM

Error 131 Transaction rolled back by lock wait timeout

8076 Views

Hello all,

I was trying to run apriori, and then HANA writer in my database.

Apriori executes directly, and then I configure and try to execute HANA Writer. But it keeps executing for more than half an hour, and then gives the following error: Error 131 Transaction rolled back by lock wait timeout. Lock timeout occurs while waiting TABLE_LOCK of mode EXCLUSIVE.

Bimal suggested me to reduce the data to be analysed, so then I reduced it to a pretty small part and executed again.

It gave me the same error after more than 30 minutes waiting executing.

after having this error, I tried just execute apriori, but with a filter of 5 transactions and than it worked. After that I tried to visualize the results, and got the following error:

It means that my HANA memory is full?

I got the view from HANA:

Regards!

Error 131 Transaction rolled back by lock wait timeout

Attachments

1.png (96.4 kB)
2.png (153.8 kB)