IBM Support

Cancelling out of a BIRT runtime request does not cause any of the reporting process to stop

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.

[{"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"IBM TRIRIGA Application Platform Runtime Engine","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg22003277