Transaction aborted by Administrator or operation staff

Database
Teradata Employee

Transaction aborted by Administrator or operation staff

Hi All,

A query was aborted but we are not able to find that this query is aborted by Administrator or operation staff .

Is there any way to find that who aborted this query. ? Administrator or operation staff ?

8 REPLIES

Re: Transaction aborted by Administrator or operation staff

How about  dbc.qrylog?

Teradata Employee

Re: Transaction aborted by Administrator or operation staff

Hi Raja,

We get data like "The transaction was aborted by the user" only. Is there any way to find the username who has aborted it.? admin or operation staff

Teradata Employee

Re: Transaction aborted by Administrator or operation staff

Error 3110 "The transaction was aborted by the user" means the end-user or the client application aborted the transaction, not an administrator.

This can occur in a variety of ways, depending on the client product or client application.

  • The user can press Ctrl+C in a command-line program.
  • The Statement.cancel method can be used in a Java application.
  • A timeout can be specified with the Statement.setQueryTimeout method in a Java application, and an executing query can exceed the timeout.

The Teradata JDBC Driver FAQ includes more details about this topic.

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/faq.html#q12

Teradata Employee

Re: Transaction aborted by Administrator or operation staff

Thanks Tomnolan.

Can we get information of the user who has aborted it?

Lets say, Sysdba abort a query then may i get information about sysdba related to the aborting this query. Any information like clientid etc.

Teradata Employee

Re: Transaction aborted by Administrator or operation staff

Error 3110 means that the user aborted their own query, that they were running. It does not mean that a user aborted some other user's query.

DBQL records the username of the user who executed the query. That is also the username of the user who aborted the query when a Error 3110 is reported.

Re: Transaction aborted by Administrator or operation staff

Hi All,

If Sysdba abort a user query then can we get information of sysdba regarding this query abortion with different error code in DBQL. ?

Re: Transaction aborted by Administrator or operation staff

On Sandeep's question:

It is my curiosity if we can see in viewpoint or if there is a session id, connected with Linux/unix process id.....

Teradata Employee

Re: Transaction aborted by Administrator or operation staff

Raja,

if you are talking about rewind option to go back and check, then there is nothing such information except it state i.e. abort.