The AMP Lock table has overflowed

Database
Enthusiast

The AMP Lock table has overflowed

Hi All,
I am using informatica to load data from MSSQL tables to Teradata.

This is the error that I am getting while loading data into a few table

WRITER_1_*_1> WRT_8229 Database errors occurred:
FnName: Execute -- [NCR][ODBC Teradata Driver][Teradata RDBMS] The AMP Lock table has overflowed.

What is an AMP LOCK TABLE and what causes an overflow.
Did any one come across this error either while using informatica or while using the load utilities?

I'd appreciate your help.

Thanks

1 REPLY
Enthusiast

Re: The AMP Lock table has overflowed

Found the cause:
Too many transactions running at the same time.