News CNCnetPDM About us Support  
         
  

DATABASE OUTPUT | CNCNETPDM MANUAL

For both, MS SQL-Server and Oracle databases CNCnetPDM writes data acquired from devices to table MTH_RAW_DATA and/or MTH_ONLINE_DATA.

Both tables have the following columns (field types are taken from MS SQL Server):

FIELD

DESCRIPTION

[GROUP_ID] [float] NULL

Used to tie together multiple items (status, part counter value, work order…) from a device acquired in a reading cycle. Prefixed with ServiceID, see chapter ‘CONFIGURE CNCNETPDM.INI’ for details. Example: 10000000159

[READING_TIME] [datetime] NOT NULL

Date and time when the data was read from the device e.g.
2016-10-12 11:01:07.000

[DEVICE_NUMBER] [smallint] NOT NULL

Number of the device from which data was received e.g. 1000

[TAG_CODE] [varchar](255) NOT NULL

Tag code for the item acquired from a device see also chapter ‘CONFIGURE CNCNETPDM.INI’ for details. For items Event, Counter, DowntimeReason, Order, Operation and Item the tag code is created by using entries as defined in CNCnetPDM.ini. For items acquired via sections 1-3 the tag codes are created according to the NAME definitions in the INI file for each device. This INI file is automatically generated by your device driver DLL.

 

Example:
Tag code STATUS ist taken from CNCnetPDM.ini. If a telegram that contains multiple values e.g. STATN|3|STATT|Manual| (status number = 3, status text = manual separated by a pipe character ‘|’) is read CNCnetPDM creates one record for every tag name (e.g. STATN) with its value (e.g. 3) in column [TAG_DATA].

[TAG_DATA] [varchar](255) NULL

Data value received from a device for a specific tag code. Examples:
TAG_CODE = STATN
TAG_DATA = 3

TAG_CODE = STATT
TAG_DATA = Manual

[CREATION_DATE] [datetime] NULL

Date and time when device data was received by CNCnetPDM e.g.
2017-04-23 11:20:57.000

[PROCESSING_FLAG] [tinyint] NOT NULL DEFAULT 1

This field is useful for further processing of data from MTH_RAW_DATA for example to update tables with aggregated / condensed values. CNCnetPDM sets the value in this field to 2. When you begin to process the data you can set the field to 1 to get a defined number of records that are processed (new records are continuously coming in from devices)

FIG 1: Database field description MTH_RAW_DATA and MTH_ONLINE_DATA TOP

The following figure shows output of data from CNCnetPDM into table MTH_RAW_DATA:

Database output (Raw data)

FIG 2:  Data received from CNCnetPDM in table MTH_RAW_DATA (MS SQL Server)

In the above example CNCnetPDM has received 8 items from device 1002 in a single telegram that contained TAG_CODE and TAG:DATA in a single line separated by a pipe character ‘|’ e.g. PRGCU|4|PRGMN|4712|…

Items collected in the same reading cycle get the same GROUP_ID value (1). READING_TIME (2) is the time when data was read from the device. DEVICE_NUMBER (3) is created according to the devices settings configured in CNCnetPDM.ini. TOP

If the telegram contains a single value TAG_CODE (4) is created according to the settings in CNCnetPDM.ini. In case of multiple values TAG_CODE is created based on the content of the telegram.

TAG_DATA (5) contains the data value returned by the device for the item. CREATION_DATE (6) is the time when the data was received by CNCnetPDM. PROCESSING_FLAG is automatically set to 2 (not shown).

Note: Please make sure that the columns in your database are set up as shown in the description above. Otherwise CNCnetPDM switches to ‘Offline Mode’ and writes all data to the offline-text-file specified for the service. In this case the reason for the issue can be found out by analyzing log file log_db_YYMMDD.txt in the log file folder of CNCnetPDM. TOP

Privacy notice

This website uses cookies. By continuing to use it you agree to our privacy policy. 

https://www.inventcom.net/support/cncnetpdm-manual/database-output
Support | CNCnetPDM Manual | Overview
CNCnetPDM Version 6.0.0.0 User Manual | Here you can find everything you need to... [read more]
Overview
Support | CNCnetPDM Manual | Setup
This section describes the steps to install CNCnetPDM. EXTRACT FILES Create a folder for CNCnetPDM on your PC or at a server. Due to Windows UAC please do... [read more]
Setup
Support | CNCnetPDM Manual | Foreground Program
This section describes the steps to start CNCnetPDM as a foreground program. After extracting the files it is possible and save to immediately start CNCnetPDM. If you like to... [read more]
Foreground Program
Support | CNCnetPDM Manual | Background Service
This section shows the steps to install and start CNCnetPDM as a background service. CNCnetPDM is able to and, in a production environment, usually runs as a windows background... [read more]
Background Service
Support | CNCnetPDM Manual | Instances
This section describes the steps to setup and run multiple instances of CNCnetPDM on a single PC. In case you would like or have to work with different parameters for specific... [read more]
Instances
Support | CNCnetPDM Manual | CNCnetPDM INI File
This section describes the steps to adjust CNCnetPDM via it's INI file according to your needs. CNCnetPDM.ini contains all information needed to control the functions of the... [read more]
CNCnetPDM INI File
Support | CNCnetPDM Manual | MTConnect Overview
The CNCnetPDM MTConnect Adapter enables you to access your machine controllers directly from within your applications or any MTConnect compatible program like an... [read more]
MTConnect Overview
Support | CNCnetPDM Manual | MTConnect Getting Started
Here you can find everything you need to know to get started with the CNCnetPDM MTConnect adapter. This section shows all necessary steps to setup CNCnetPDM, use the MTConnect... [read more]
MTConnect Getting Started
Support | CNCnetPDM Manual | MTConnect Standard Agent
This document describes setup of the MTConnect Standard Agent it’s usage and test with the CNCnetPDM MTConnect Adapter. Prerequisites As this example uses a simple... [read more]
MTConnect Standard Agent
Support | CNCnetPDM Manual | SQL Server Database Tables
This section describes the steps to setup an MS SQL Server database and required as well as optional tables for CNCnetPDM. Although not absolutely necessary for testing it is... [read more]
SQL Server Database Tables
Support | CNCnetPDM Manual | Oracle Database Tables
This section describes the steps to setup required and optional database tables for CNCnetPDM in case you're using an Oracle database. For an Oracle database the information... [read more]
Oracle Database Tables
Support | CNCnetPDM Manual | MySQL MariaDB Database Tables
This section describes the steps to setup required and optional database tables for CNCnetPDM in case you're using a MySQL or MariaDB (Version >= 5.5!)  database. For... [read more]
MySQL MariaDB Database Tables
Support | CNCnetPDM Manual | Database Connectivity
To connect to a database CNCnetPDM uses a Universal Data Link (.udl) file that contains information about your database. Connect to an MS SQL Server database... [read more]
Database Connectivity
Support | CNCnetPDM Manual | Licensing
When you start the program or service the first time without a license CNCnetPDM automatically creates a license number for your copy. Without a license number initially... [read more]
Licensing
Modified: 2018-12-05