All Forums Database
Sandeepyadav 52 posts Joined 09/13
05 Nov 2014
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 ?
 
 
 
 

Thanks, -Sandeep.
Raja_KT 1246 posts Joined 07/09
06 Nov 2014

How about  dbc.qrylog?

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Sandeepyadav 52 posts Joined 09/13
06 Nov 2014

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
 
 
 

Thanks, -Sandeep.

tomnolan 594 posts Joined 01/08
06 Nov 2014

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
 

Sandeepyadav 52 posts Joined 09/13
06 Nov 2014

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.
 

Thanks, -Sandeep.

tomnolan 594 posts Joined 01/08
07 Nov 2014

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.

monoranjan 6 posts Joined 09/13
09 Nov 2014

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. ?
 

Thanks,
Monoranjan

Raja_KT 1246 posts Joined 07/09
10 Nov 2014

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Sandeepyadav 52 posts Joined 09/13
14 Nov 2014

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.

Thanks, -Sandeep.

You must sign in to leave a comment.