Home
Engineering
Powerful tools for easy or complex engineering tasks.
System Management
The System Management is the central administrative unit for WinCC OA Systems.
Database
SQLite®
Notes and Restrictions
Notes and restrictions that must be considered when using SQLite®.

Version Information
Release Notes, Update information, Certifications and Frequently Asked Questions.
Concepts
Your first step into modern and powerful process visualization.
Deployment
Topics, you need to know, before using WinCC OA.
Security
Go beyond the norm in cybersecurity.
Engineering
Powerful tools for easy or complex engineering tasks.
- Project Administration
  The chapter contains a description of the process monitor as well as the project administration.
- Graphics Editor (GEDI)
  Used for creating and editing panels, provides tools for creating and configuring graphic objects.
- System Management
  The System Management is the central administrative unit for WinCC OA Systems.
  - System management
  - Diagnostics
  - Reports
  - Database
    - Data backup in WinCC OA
    - Supported Database Combinations
      An overview over the possible database combinations within a WinCC OA project.
    - WCCOAtoolCreateDb
    - Estimation of the hard disk space
    - Update an ISO Project to SQLite Project
    - History DB
    - Archive/Export Alerts
    - ASCII Manager
      The ASCII Manager allows you to input and output and thus edit data points and data point types and to configure data points.
    - SQLite®/ RAIMA Online-Backup
    - Steps of the online DB backup process
    - Archiving and Compression
    - Data Point Groups
      The main purpose of grouping data points is to simplify selection of datapoints and datapoint elements.
    - PowerConfig Editor
    - RDB Archiving
    - RDB Compression
    - RDB Log
    - HDB/RAIMA - RDB Parallel
    - OLE DB Provider
      OLE DB is a Microsoft specification for accessing data on different computers. It is based on Microsoft's COM technology and is the successor to the older and limited ODBC technology.
    - NextGen Archiver (NGA)
    - SQLite®
      - SQLite®
      - SQLite Configuration
      - SQLite® Database Files
      - Automatic Migration of RAIMA → SQLite (+NGA)
      - Manual Migration of RAIMA → SQLite®
      - Notes and Restrictions
        Notes and restrictions that must be considered when using SQLite®.
  - Driver
  - Driver IEC
  - Driver OPC
  - Driver S7
  - SmartSCADA
  - Permission
  - Communication
  - Settings
- Wizard Framework
  Used for easy creation of wizards in a uniform layout style. The key elements "Navigation Bar" and "Bottom Bar" can be customized to fit the needs of the custom wizard.
- XML Panel Format
  The XML (Extensible Markup Language) panel format allows creating WinCC OA panels.
- Simple Symbols, basics
  The "Simple Symbols" functionality is used to simply assign corresponding symbols to data point types and increase the working comfort when working with different symbols.
- ScriptWizard
  Simple wizard for creating graphical user interfaces for users without prior programming knowledge.
- Panel topology/Group alert facility
  Tree structure for process panels with integrated group alert system
- Object-Oriented Panel References
  Reusable objects built with the GEDI tools. Insert them within an existing panel to provide a graphical element.
- Multilingual Projects
  WinCC OA is designed to provide both Native Language Support and Multi Language Support.
- Translator
  The WinCC OA Translator functionality supports you in creating and maintaining multilingual projects. It offers a convenient interface for translation of reusable terms.
- Layout management
  Layouts change the size and position of objects according to parameters previously defined in the GEDI.
- Generic Dialog Framework
  The Generic Dialog Framework is an easy way to generate your own dialogs by adjusting a set of prefabricated panels.
- Simple Configuration
  Simple configuration windows and panels support you in combining events (such as a mouse click) with different actions such as setting data point values, showing panels or changing attributes.
Data Management
Classify, structure and archive your data.
Business Logic / Control
Endless possibilities in data processing for your projects.
Data Visualization
User interfaces, Trends and Reports for every purpose and device.
Southbound Interfaces
The process connection to the actual machines/sensors.
Northbound Interfaces
Your portal to the cloud or supervising systems.
Web Connectivity / Network Interfaces
Data exchange, APIs and web technologies
User Management
All about authorization, authentication and login-customization.
Availability
How to get your system uptime to the maximum.
Reporting
Create state of the art project reports without limits.
Addons
Useful tools and enhancements for special demands.
Reference Tables
Detailed and extensive content for special project adaptation.
Videos & Tutorials
Explore the capabilities of WinCC OA with our carefully selected collection of video tutorials and guides.
WinCC OA Documentation
Basic information about terms and functions within the documentation.
Disclaimer
A brief clarification of liability exclusions or legal notices.

Notes and Restrictions

Notes and restrictions that must be considered when using SQLite®.

Important: The SQLite® database is an alternative to the existing RAIMA database and they cannot be used simultaneously within a project.

SQLite® can only be used in combination with NextGen Archiver (NGA).
NGA can be used in a RAIMA or SQLite® project. However, SQLite® can only be used with NGA and not with HDB / RDB Archiving.
You can switch from RAIMA to SQLite® but not back.
The maximum date that can be set and used for the SQLite® database is 9.4.2262.
The managers that require configurations (e.g. drivers) are not shut down when they attempt to connect to a data manager that is in mirroring mode. The managers wait until the mirroring mode has ended.

Note: Queries with SELECT ALL are now correctly returning an error as they are not supported in SQLite-NGA projects.

Using network mounted drive CIFS (Samba share) with SQLite

According to the official documentation, using SQLite over a network mounted file system is neither recommended nor tested. In particular, the synchronization and locking reliability of network file systems is questionable. The CIFS file system is not fully compatible with the SQLite locking mechanism. In WAL mode, most operations should work, but some operations on the DB require an exclusive lock, which is a problem in this case.

Workaround: When mounting a CIFS (Samba) network drive to access an SQLite database, it is necessary to connect the disk with the nobrl (No Byte-Range Locking) option. This can be done using the following command:

sudo mount -t cifs -o nobrl,username=z004cknf,password=***** //host.docker.internal/SharedF /home/winccoa/winccoaproj

Important: The nobrl option only hides the problem. The main issue is that SQLite officially doesn't support network file systems. In the worst case, the database can get corrupted.

Sources: