All Forums UDA
17 May 2006
Amp lock table overflow.

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 tableWRITER_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

17 May 2006

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

You must sign in to leave a comment.