I also came across the same error today. Could find the details about this error in TD Error Messages pdf (1096) for v13.10. Pasting it here.
I am having the same issue. Using .NET to insert one million rows into teradata - errors out as follows:
Every single row Insert needs a RowHash-lock.
If there's one million rows inserted within a single transaction this will result in one million RowHash-locks.
So either don't do it within a single transaction or simply submit a LOCK TABLE tab FOR WRITE at the begin of the transaction.
Write lock on table does not allow Hash Lock ? By default insert table has write lock and select table read lock.
please elaborate how placing write lock on source table help in this issue.Please correct me if i am wrong.