Hi, I'm experiencing exactly same issue. I ran tdload from a file but it failed at a certain data point however it failed to remove a lock from the table. So now I cannot select or truncate the table. Running tdload again returns me an error
Got RDBMS Error 2652: Operation not allowed: mydb.mytable is being Loaded.
This is clearly an incorrect behavior. The table should have been unlocked in the first place. However how do I clean up the lock now?
When a job fails prematurely, the target table remains locked. This lock is enforced by the Teradata database.
However, the problem with the restart was a bug in our code and that has been fixed in 13.10 and so try downloading the latest 13.10 patch for TPT and that should fix this issue.
(The problem appears to have been fixed in efix patch #6, but it is always best to download the latest.)
Thanks a lot for the response. We do have 13.10 version.
Teradata Load Utility Version 13.10.00.04
What is the exact version of patch #6?
BTW, in order to solve this I dropped our table then it still failed and had to manually cleanup 3 tables _err, _log and _XXX (don't remember). And had to remove files from /var/opt/teradata/tbuild/checkpoint/ because it tried to resume a job while in fact the table is empty.