Settings for transaction store

watt.sap.xtn.cts.txstore

Sets the path to the external file directory for the Shared Transaction Store (STS). The directory must exist and it must have write access, otherwise the transaction store will not be enabled. Default value is empty.

watt.sap.xtn.fileStore.threads

Sets the number of CPU threads used in the pub.sap.transaction:sweep service. The value is also used to list the content of the transaction store and to execute the pub.sap.transaction:list service. The value must be a positive number in the range of 1-6. Default value is 4.

watt.sap.xtn.fallback

Set to yes to let the adapter automatically use the local transaction store when the CTS setup is invalid or the CTS server is not available during adapter startup. Default value is no.

watt.sap.xtn.cacheFlushPeriod

Specifies how often Adapter for SAP will flush the unsaved changes in the transaction cache to the file system. The default is 2 seconds; the maximum allowed value is 100 seconds. If a transaction in the cache has been modified (for example: new state or new audit log), it will be persisted to the transaction store after "cacheFlushPeriod" has expired and no further modifications have happened. After that, the transaction remains in the cache until the "cacheTimeToLive" period has expired, or longer if it was modified again.

Important: For a Centralized Transaction Store, Adapter for SAP automatically limits the cache flush period to .2 seconds.

watt.sap.xtn.cacheTimeToLive

The transaction cache works both as a read and a write cache. After a transaction is read the first time, it is kept in the cache for the amount of time specified in cacheTimeToLive. The default is 50 seconds; the maximum allowed value is 500 seconds. If the transaction is not accessed during this time, it is removed from the cache after this period has ended. This keeps the cache from growing indefinitely.

Important: For a Centralized Transaction Store, Adapter for SAP automatically limits the cache time-to-live period to .2 seconds.

watt.sap.xtn.fastAsyncMode

Set to true to enable the synchronous write cache and set to false to disable the cache. This property works together with the watt.sap.xtn.cacheFlushPeriod and watt.sap.xtn.cacheTimeToLive. Setting this parameter to true forces the transaction manager to not persist each update of a transaction, but to keep the state changes in memory and persist it periodically.

Important: For a Centralized Transaction Store, you cannot set this parameter to true.

watt.sap.xtn.useSQL

Set to true to use MySQL database for transaction store and set to false to use file system for transaction store. Default is false.

watt.sap.xtn.sql_shared

Set to true if the MySQL transaction store is accessed by multiple Adapter for SAP instances. Default is true.

watt.sap.xtn.sql_compression

Set to true to compress the transaction payload data before storing in transaction store and decompress when retrieving from the transaction store. Default value is true.

Note: It is recommended to change the value to false when volume of the transaction payload is small and the MySQL instance runs local on the same host.