Question & Answer
Question
When a BIRT report is launched in TRIRIGA on the Reports tab or elsewhere, a pop-up with a Progress Bar pops up and that pop-up has a Cancel button. 1. If I click Cancel , will that kill the SELECT statement that is running against the database on the database server? 2. Also, will clicking Cancel release the database connection that gets used when a BIRT report starts to run?
Answer
The answer to both aspects of the question is no in both respects. The thread will be consumed until the SELECT statement is complete. There is no messaging included in the log to the effect that the SELECT process has been orphaned due to the users interaction, the process simply continues to run until the result set is retrieved and then stops.
So effectively:
1. No, canceling a request will not kill the select statement
2. No, the thread remains unaware the request was canceled
3. When the results return, the thread will process them, and then hit the canceled thread. There may be a message in the log warning about an IO socket being disconnected, or some other exception dealing with the zombie connection.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg22003277