FLOWCAL Transaction Queue

Queue Records Tab

Check all required record types to be published

History Period Time

Select the time period of the record types to be written to the file.

• All
• Fifteen Minutes
• Hourly (Default)
• Daily
• Weekly
• Monthly

GC Period Time

Select the time period of the GC record type to be written to the file.

• All
• Fifteen Minutes
• Hourly (Default)
• Daily
• Weekly
• Monthly

Record Span

This setting determines whether timestamps are left as provided by the flow computer or all records are converted to leading time stamps.

• Use Native Timestamp (Default)
• Convert to Leading Timestamp

Database Tab

Provider String

Used for the connection to the database. Entering this information is currently a manual process in ACM, but the Database Provider String Builder can be used. This can be found in: Start > Programs > AutoSol Communication Manager > Database Provider String Builder

Cursor Position

Select the appropriate Cursor Position per the database configuration requirement.

• Client-side. Some database configurations require a client-side cursor. SQL Server generally works well with a client-side cursor.
• Server-side (Default). Some database configurations require a server-side cursor. 

Strict floating point

Floating point numbers (numbers with a fractional part, like "1.25") use a specific format in the computer's memory. There are certain values that can't be represented meaningfully e.g.-'infinity' or 'negative zero'. Occasionally ACM will receive one of those values from a field device. Since those values can't be used in any logical fashion, databases frequently can't accept them. This option tells ACM what to do when it has one of those values.

• Leave as is (May cause database insert failure if value is de-normalized).
• Convert to zero.
• Insert null value (Default).

Ignore Database Constraint Errors

Default = Not selected. Ignore database constraint codes including ORA-00001, ORA-02290, ORA-02291, ORA-21614, and ORA-28117.