Time settings tab

You use the Time Settings tab to configure the settings that control how the interface handles loss of connectivity and how it processes data.

Query time settings

Scan (/SCAN=)

Specifies how frequently the interface scans the data source.

Cache time (/CACHETIME=)

Specifies how long completed events are retained in memory. Default is one day. Specify the maximum duration expected between events that need to be merged, plus any desired margin of safety. The value can be specified as whole day or fraction of a day.

For example, to release completed batches from memory after at least 7 days and 12 hours from current time, specify the following cache time setting:

CACHETIME=7.5 days

Abandoned batch timeout (/ABTO=)

The timeout has 2 functions:

1. In history recovery, if a batch starts less than the recovery start time minus the abandoned batch timeout it is not recovered. For example, if a batch is open in recovery start time, and the start time is June 1, 2024 and we have a 30-day abandoned batch time, and the batch you found is on May 1, 2024, it will not be recovered.

2. In real time mode, if a batch has not received a start or end time in the hierarchy - meaning in the top level of the event frame, or any of the children - and if the last updated time you get is less than the cache time minus the abandoned batch timeout, it will be considered abandoned. If July 1 is real time and cache time is one day, and our abandoned batch timeout is 30 days, and our last start time was April 29, it will be thrown from cache as abandoned.

The following graphic illustrates the timeout logic:

Maximum query time frame (/MAXQTF=)

To help manage workload and memory usage, defines the maximum time frame for queries. For example, if you specify 30 days and the interface queries for one year's worth of data, the interface issues 12 one-month queries rather than one (large) one-year query.

Maximum stop time (/MAXSTOPTIME=)

Specifies the maximum time allowed for the interface to properly shutdown. If the shutdown process takes longer than the specified time, the interface is forced to terminate immediately. The default value is 120 seconds.

Query Buffer Delay (/DELAYBUFFER=)

Specifies the amount of time (in minutes) subtracted from the current time when calculating the Next Query End Time. This configuration allows the system to catch recently closed batches that were missing from the latest database call.

The default value is two minutes, but you can configure the amount of time to a maximum of 10 minutes. To disable the configuration, set the /DELAYBUFFER to zero (0) in the INI file.

This configuration is used in both real-time and history recovery mode but only applies to interface configurations where the end time for data recovery (/ret) is not defined.

Use local time stamps to process incoming events (/TS)

Specifies whether timestamps from an SQL data source are interpreted as local time or GMT. By default, timestamps are interpreted as local time.

PI connection settings

PI connection timeout (/PICONNTO=)

Override the default PI Data server Connection TimeOut property.

PI data access timeout (/PIDATO=)

Override the default PI Data server Data Access TimeOut property.

Retry (/RETRY=)

Specifies how often the interface retries failed attempts to write data. The default is 60 seconds.

Retry timeout (/RETRYTO=)

Specifies how long the interface continues retrying an attempt to write data. To avoid data loss, set to 0 (default, no timeout).

SQL server connection settings

• SQL connection timeout (/PICONNTO=<seconds>)

  Override the default SQL Connection TimeOut property.

• SQL data access timeout (/PIDATO=<seconds>)

  Override the default SQL Data Access TimeOut property.