Amp lock table overflow.

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Amp lock table overflow.

Rate Topic

Display Mode

Topic Options

Author

Message

feroz_shaik

Posted 5/17/2006 12:02:17 PM

Supreme Being

Group: Forum Members
Last Login: 10/7/2008 12:54:51 PM
Posts: 116, Visits: 20

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

Feroz Shaik

Post #4187

feroz_shaik

Posted 5/17/2006 12:18:59 PM

Supreme Being

Group: Forum Members
Last Login: 10/7/2008 12:54:51 PM
Posts: 116, Visits: 20

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

Feroz Shaik

Post #4190

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:21am