Official |[Flow] Transaction

Operation name

Transaction

Function overview

Performs a transaction.

Flows enclosed by the Transaction operation will start a new transaction. (The same behavior as REQUIRES_NEW)

= Remarks =

For more details on transactions, refer here.

Transaction configuration

Icon	Name	Description
	Start Transaction	The start of Transaction.
	End Transaction	The end of Transaction.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Icon-click menu

Icon	Item name	Description	Remarks
	Fold/Expand	Select + or - displayed on the icon. Show/hide icons between Start Transaction and End Transaction. When folded, only Start Transaction is displayed.

Icon

Item name

Description

Remarks

Fold/Expand

Select + or - displayed on the icon.

Show/hide icons between Start Transaction and End Transaction.

When folded, only Start Transaction is displayed.

Parallel Stream Processing

PSP isn't supported.

Specification limits

You can't set a timeout.
When you place the Raise Exception operation, the end operation, the break operation, or the continue operation between the Start Transaction icon and the End Transaction icon, script compilation fails.

Exception messages

None.

Notes

Properties window can't be opened.
Whether to roll back or commit the processing enclosed by the Transaction operation is determined based on the end status of the Transaction operation.

For example, even when an error occurs in a transaction, if the error is caught by the Monitor Exception operation in the transaction, the transaction ends successfully and the processing will be committed.

Operation example

Using the Transaction operation, create a script that rolls back the writing processing for the CSV file when an error occurs in the Call Script operation.

Create a script as follows.
Open the properties window of the Write CSV File operation and select Execute transaction processing in the Transaction tab.
Perform inappropriate settings in order to make an error occur in the Call Script operation.
Perform the mapping in Mapper as follows.
After running the script, you can confirm that the transaction is done correctly by referring to the CSV file contents and the execution history view log.

= Remarks =
To check whether a rollback is performed in the execution log, the log level must be FINFO or higher.

For settings for log levels, refer to Log levels.