Rockwell-automation FactoryTalk Report Expert User Guide Manual de usuario descargar pdf (Pagina 142)

Chapter 9 Administering Report Expert

142 Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014

Use this setting: To modify:

ColorBest setting changes into the color from the

ColorBeyond setting on the OEE% chart.

ThresholdLowNormal The limit of the OEE% value, after which the color from the

ColorLow setting changes into the color from the

ColorNormal setting on the OEE% chart.

ThresholdNormalBest The limit of the OEE% value, after which the color from the

ColorNormal setting changes into the color from the

ColorBest setting on the OEE% chart.

TransactionIsolationLevel The transaction isolation level to be used by DPE when

executing a set of SQL commands. Following are the

definitions of possible transaction isolation level values

supported by Report Expert:

Read Committed (0)

. Read only transactions that have not

been modified by other transactions and are committed.

Data can be changed by other transactions between

individual statements within the current transaction, but

the resulting data cannot be read again until such changes

are committed.

If you type 0 or leave this setting blank, this default isolation

level is used.

The behavior of Read Committed depends on the Read

Committed Snapshot database option set in Microsoft SQL

Server.

Read Uncommitted (1). Transactions running at the Read

Uncommitted isolation level do not use shared locks to

prevent other transactions from modifying data read by the

current transaction. This isolation level allows uncommitted

rows that have been modified to be read, therefore data can

be modified and rows can appear or disappear. To use the

Read Uncommitted isolation level, set the

TransactionIsolationLevel setting to 1. You may want to use

this option if a report times out due to uncommitted data

and therefore cannot display a subreport.

Snapshot (2). This isolation level specifies that data read

by any statement in the transaction will be consistent with

the data at the start of the transaction. Data modifications

made by other transactions after the start of the current

transaction are not visible in the current transaction. The

Snapshot isolation level does not prevent other transactions

1 2 ... 137 138 139 140 141 142 143 144 145 146 147 ... 181 182

Comentarios a estos manuales

Sin comentarios

Rockwell-automation FactoryTalk Report Expert User Guide Manual de usuario Pagina 142

Comentarios a estos manuales

Relacionado con productos y manuales para Equipo Rockwell-automation FactoryTalk Report Expert User Guide