Frequently Asked Questions – Alarm Logging

Security Login Error occurs with Open or Create routines.
View the Database Security Login topic on how to setup security logins and access writes to create, open, and read and write to the database.
The database engine language is different than the Regional Language settings of the Data Logging and / Alarm Logging Service. Data Logging updates, Alarm Logging updates, trend history, and / alarm history is not working due to invalid date format.
Go to Configure-Options-History and Enable History Date Format. Examples: yyyy-MM-dd HH:mm:ss MM/dd/yyyy HH:mm:ss

Getting Started – Alarm Logging

To open a new window for Alarm Logging modification, select Configure-Alarm Logging.

Select a Windows Service to modify, the node with the green arrow is the current Service being modified. Refer to Selecting Service for more information on selecting an OAS Service.

In order to log alarms to a database you must first define the Tag Alarm Limits as described in Configure Tags of this Quick Start section.

For a complete list of all Alarm Logging properties refer to the OAS Configuration – Alarm Logging section in this help file.

Step 1

Getting Started-Tags 1Start the Configure OAS application if it is not already running.


Step 2

Select Configure-Alarm Logging.

Getting Started-Alarm Logging 1

Step 3

Select the Local OAS Service by selecting the Select button or the Local node in the service tree to the left.

Getting Started-Tags 3

Getting Started-Tags 4

Note: The Configure application can be used to connect to remote systems using the network node name or IP address of the remote node the OAS Service is running on.  Simply enter the IP Address or network node name of the remote OAS Service you wish to connect to and click on the Select key.

Step 4

Enter the Logging Group Name of Simulation in the field in the upper right.

Getting Started-Data Logging 2

Step 5

Check Logging Active in the Common Properties Tab.

Getting Started-Data Logging 3

Step 6

Select the Database Tab.

Getting Started-Data Logging 15

Step 7

Logging to SQL Server

Use the following configuration for SQL Server and SQL Server Express. The Database and Table will automatically be created for you.

Getting Started-Alarm Logging 2

The Server name may need to be adjusted from localhost to the proper Server name of the SQL Server engine you wish to log to. This Server name can be found when first bringing up the Connect dialog of the SQL Server Management Studio.

Also the login method can be with Windows Authentication or SQL Server mode. Contact your database administrator if you are unsure of what login type to use.

Getting Started-Data Logging 10

You can download a free version of SQL Server Express from

Logging to Microsoft Azure

Use the SQL Server Provider and view the following guide to setup Microsoft Azure:

Windows Azure Setup

Logging to Oracle

If you are using Oracle you must first create the database. All other steps are the same as SQL Server except the provider should be set to Oracle.  Oracle does not create the database.

If you do not have a TNSNAMES.ORA file or need to log to a remote database engine refer to the Frequently Asked Questions in this Data Logging topic.

Logging to mySQL

All steps are the same as using SQL Server except the provider should be set to mySQL.

Logging to PostgreSQL

All steps are the same as using SQL Server except the provider should be set to PostgreSQL.

Logging to Cassandra

All steps are the same as using SQL Server except the provider should be set to Cassandra.

Logging to MongoDB

All steps are the same as using SQL Server except the provider should be set to MongoDB.

Logging to Microsoft Access

Use the following configuration for Microsoft Access. The Database and Table will be automatically created for you.
When logging to MS Access 2007 or greater use the extension .accdb, use .mdb for the older versions of versions of Access.

Getting Started-Alarm Logging 3

Use the following configuration for CSV text logging:

Note: There is no historical replay to alarm windows with CSV logging.

Getting Started-Alarm Logging 4

Step 8

Select the Add button to add the Alarm Logging group.

Getting Started-Data Logging 13

Step 9

Select the Save button on the toolbar at the top.

Getting Started-Tags 19

Step 10

Save the file DemoAlarmLogging.AlarmLog in the directory C:\OPCSystemsDemo\.

Getting Started-Tags 20

You can specify for this configuration to load automatically when the Service starts using Configure-Options which is described also in this Training Guide.