BTEQ failing with 3110 :: Transaction aborted by the user

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.

BTEQ failing with 3110 :: Transaction aborted by the user

Hi All, I am running a BTEQ query in TD2650 appliance and the query strangely fails with 3110 error code even though no user aborts the process. When I run the same query in SQLA, it runs fine. Can you please provide any insight. 

2 REPLIES
Enthusiast

Re: BTEQ failing with 3110 :: Transaction aborted by the user

looks like your sql is cancled by the DBA a its hampetring the system

Highlighted
Teradata Employee

Re: BTEQ failing with 3110 :: Transaction aborted by the user

3110 indicates that the client (i.e. BTEQ itself) requested the abort - not a DBA or TASM. Double-check your script.

For example, did you do a BT with no ET before logoff?