Getting AMP step failure error

Database
Enthusiast

Getting AMP step failure error

Hello Experts,

I am new to Teradata, could you pls explain why do we get  "AMP step failure" error while executing BTQs through some of the job.

Temporary Fix: We reset the aborted job and resubmitted then completed successfully.

But wanted to know the permanent solution to fix this.

Thanks.


5 REPLIES
Enthusiast

Re: Getting AMP step failure error

sk ant29,

What do you mean by "we reset the aborted job"?

Can you provide the failed SQL?

Rglass

Teradata Employee

Re: Getting AMP step failure error

is it an express edition of TD ? (1 AMP)

Enthusiast

Re: Getting AMP step failure error

Thanks for the reply..

I may not able to provide you SQL query.

If we just rerun the same failed bteq without any modification in it,  thn its getting success.

When we run it second or third time we dont get that error again but might get same error with another bteq. 

"I mentioned "reset" word in my previous comment that means we do at scheduling app level not in Bteq query."

Enthusiast

Re: Getting AMP step failure error

Hi Experts,

Error :

COLLECT STATS DB_xref.TAB_ASSET_XREF;

 *** Failure 7487 AMP step failure: Please do not resubmit the last request.

                Statement# 1, Info =0 

 *** Total elapsed time was 3 minutes and 0 second.

Teradata Employee

Re: Getting AMP step failure error

Unfortunately you have encountered a software bug. Please have your Teradata DBA/admin folks raise an incident to Teradata to investigate and repair it.