Terminate a long running txn on the MDM Operational Server when a set timeout is reached at the Client.

When MDM txns are executed on the Operational Server (getParty for example), the calling Client stays connected until receiving a SUCCESS or FAILURE response from the server. Once the response is received, the connection is closed.  In the case where the SERVER reponse takes longer than the timeout of the calling Client the CLIENT drops the connection and retries the txn  In the background the txn code on the SERVER is still running until it completes or fails.  The CLIENT retries, causing txns to pile up on the SERVER.  It is currently not possible to terminate the txn at the SERVER once it has been started.  It is desirable that in this case, the timeout of the MDM txn is respected AND the txn on the SERVER is terminated immediately to

1. Allow a retry and potentially a SUCCESSFUL outcome

2. Prevent the SERVER from being overwhelmed with ultimately FAILURE txns (as the client has timedout and will try again).

There are several thousands cases like this per day.  Many are handled SUCCESSFULLY.  Occasionally, the client timeout issue occurs and the server is left to struggle.

The proposed solution should allow:

For example, there are times when the DB is busy with other work and one of these potential long running GETs or ADDs or UPDATES is executed by the client app through an API call.  If the timeout is reached, take the following actions.

1.     For a GET txn, terminate immediately AND allow the client to retry, this is 90% of the long running txns.  Potentially, when the client retries the DB is able to SUCCESSFULLY service the request.

2.     For an ADD / UPDATE or DELETE txn, terminate immediately AND release the DB to allow a later SUCCESSFUL retry.

The current experience is that during peak demands, these long running calls fail (7s timeout is standard across the calling applications) and are then subject to a retry at the client side, whilst the Server side is still busy with the timedout txn.