UtilityFree

Transaction Manager

by Appian Corporation

Description

The Transaction Manager application provides a solution to handle transaction processing across multiple queues and priorities with typical queue management features such as throughput handling, parallel execution, batch processing. If you have work items to be processed, or need to manage your resource utilisation the Transaction Manager can help you.

Below are some use-case examples with details about these available as part of the documentation provided in the download package.

  • Maintain a continuous backlog of user tasks
  • Cancel a scheduled transaction
  • Schedule an item for future execution
  • Configure a recurring schedule
  • Priortise the order my transactions are processed
  • Limit the time period my transactions are processed
  • Retry X times before passing to a system administrator

Features

  • Multi-queue processing
  • Throughput and scaling of individual queues
  • Resource utilisation management
  • Parallel execution across process engines
  • Microbatch processing for high-throughput use cases

Release notes

  • Fix TM_GET_NEXT_TRANSACTIONS edge-case that caused the same transaction to be added to multiple micro-batches
Version history (5)

2.0.1

  • Patch to fix adding job type when micro batchsize is blank

2.0.0

  • Appian 24.1 as the minimum version
  • Major performance improvements. Tested with over 5m transactions. Main dashboard and stored procedure load < 1s
  • New: Microbatch feature for use cases that require massive throughput
  • New: Ability to disable auto context (process parameter) provisioning. For use cases that have large contexts that are complex to model or not required to be passed to the process. The relevant parts of the context can be retrieved in-process.
  • Exponential backoff for sleep, to reduce system load during low usage periods. This allows a smaller sleep time to be configured where low-latency is required
  • Removed dependency on Execute Stored Procedure plug-in. No longer relies on any plug-in
  • Fixed 1000 process model limit
  • Note: Oracle and SQL Server scripts will require updating (community contribution is welcome)

2.0

  • Appian 24.1 as the minimum version
  • New: Microbatch feature for use cases that require massive throughput
  • New: Ability to disable auto context (process parameter) provisioning. For use cases that have large contexts that are complex to model or not required to be passed to the process. The relevant parts of the context can be retrieved in-process.
  • Exponential backoff for sleep, to reduce system load during low usage periods. This allows a smaller sleep time to be configured where low-latency is required
  • Removed dependency on Execute Stored Procedure plug-in. No longer relies on any plug-in
  • Fixed 1000 process model limit
  • Tested with 5m rows in MariaDB
  • Note: Oracle and SQL Server scripts will require updating (community contribution is welcome)

1.6

  • Added support for Oracle.
  • Refreshed look-and-feel and improved usability.
  • Minimum Appian version increased to 21.1
  • Removed the bundled Pessimistic Locking app (now to be deployed separately)

1.4

Adding missing SQL scripts for version 1.4

Resources

  • Transaction Manager Documentation.pdf

    User Guide

    Download