beautypg.com

Rockwell Automation FactoryTalk Transaction Manager User Guide User Manual

Page 103

background image

7

Creating Transactions

103

Transaction Type: Transaction

Storage Method:

Lost Connection with
Enterprise Connector:

Lost Connection with
Enterprise System:

Unidirectional

Cached transaction
files

Cache files are applied
when the connection is
restored.

One cache file can be converted
to an .sql file and returns
Database Failed. Remaining
cache files are processed when
connection is restored.(1)

Unidirectional

Real time thread

Transaction fails and
transaction data is lost.

Transaction returns Database
Failed, transaction data is
written to an .sql file.(2)

Bidirectional

Real time thread

Transaction fails and
transaction data is lost.

Transaction returns Database
Failed, transaction data is
written to an .sql file.(2)

Transaction Result
Binding

Cached transaction
files

Transaction data is written
to a cache file. The
transaction returns a
successful result to the
controller. The cache files
are processed when the
connection is restored.

Transaction returns a successful
result. One cache file can be
converted to an .sql file and
returns Database Failed.
Remaining cache files are
processed when the connection
is restored.(1)

Transaction Result
Binding

Real time thread

Transaction fails and
transaction data is lost. The
failure is sent to the
controller.

Transaction returns Database
Failed, transaction data is
written to an .sql file.(2)

(1) If multiple database connections are defined in the configuration, then the cache files continue
processing. All data for the failed connection is written to an .sql file.

(2) Data is stored in separate .sql files depending on whether the Real Time option or the Transaction Cache
Files option was used on the Transaction Definition dialog box. This allows you to recover this data.

For more information on enterprise connector error handling, see chapter
Defining Data Objects (page 87).