News CNCnetPDM About us Success Stories  
         
  

USER MANUAL

CNCnetPDM User manual

CNCnetPDM

Version 4.7.0.0 User Manual | Here you can find everything you need to install, setup and configure CNCnetPDM for your needs.

User Manual

Technical Support

Edition: 04/2017
Product: CNCnetPDM Ver. 4.8.0.0
Part N°: 00001400

Internet: support.inventcom.net
Email: support@inventcom.net

Inventcom | Theo-Prosel-Weg 1
DE 81243 Munich | Germany
Email: info@inventcom.net
Phone: ++49 [0] 89 121903-19
Fax: ++49 [0] 89 121903-21

 

This documentation only describes the functionality of the standard version. Extensions or changes made by a manufacturer of a controller, machine or software solution are documented by the respective manufacturer. Other functions not described in this documentation might be executable by CNCnetPDM. However, this does not imply an obligation to supply such functions with the program or when servicing. Further, for the sake of simplicity, this documentation does not contain all detailed information about all types of the product and cannot cover every conceivable case of installation, operation or maintenance.

Copyright© Inventcom, 2017

 

Download CNCnetPDM User Manual (PDF 733 KB)

CONTENTS

CNCnetPDM

FEATURES

CNCnetPDM is a standard program that allows you to connect devices from different manufacturers with your existing IT infrastructure without the need for additional hardware or modifications of the devices.

Functions

  • Connects highly diverse devices to all of your applications
  • Reads and writes data from or to those devices
  • Translates manufacturer specific protocols into standardized, comparable information
  • Outputs data in understandable form to your existent solutions from MES/ERP to IoT and Big Data and everything in between
  • Provides easy to use Open Source templates for building customized device drivers
  • Works with a single communication server, a single namespace and a single set of diagnostics

CNCnetPDM's proven high reliability and ease of use ensures the software can be installed quickly and operate flawlessly TOP

SPECIFICATIONS

GENERAL

 

Type of program

Foreground program or background-service

Number of devices

256 per program or background service - instance, multiple instances can run simultaneously on one server

Operation modes

Solicited messaging: Reads or writes data in adjustable intervals
Unsolicited messaging: Reads or writes data based on events

Extras

Attachable graphical interface (GUI) CNCnetControl for monitoring and configuration

DATA ACQUISITION:
DEVICE STATE

 

Off

Device is switched off

On

Device is switched on but not accessible (half-alive-state)

Run

Device is up and running

Manual

Device is in manual mode (e.g. setup)

Interrupted

Device is running but operation is interrupted

Faulted

Device is in error mode

DATA ACQUISITION:
QUANTITY

 

Cycles executed

Cumulative (sum of all cycles executed) or
incremental (sum of cycles executed since last reading cycle)

Number of Good-, Scrap- or Rework Pieces

Optional, if detectable by the device

DATA ACQUISITION:
WORK ORDER DATA

 

Work order

Number of the actual work order

Operation

Number of operation performed

Part

Part number

DATA ACQUISITION:
QUALITY AND PROCESS DATA

 

Actual

Values at the time of reading

Minimum - Maximum - Average

Minimal-, maximal- or average values since last reading cycle

SYSTEM REQUIREMENTS:
PC / SERVER

 

Operating system

All Microsoft Windows Operating Systems from XP to Server 2016 (32 and 64 Bit)

Required memory

Typically 50 MB RAM per CNCnetPDM server-instance (depends on number of devices)

Database support

Oracle 11g - 12c
MS SQL Server 2008 - 2016

Communication interface

Access to communication interface used by the device

SYSTEM REQUIREMENTS:
DEVICE

 

Communication interface

Any communication interface accessible by an external IT device for example:
Bluetooth, USB, Serial Interface, Ethernet or manufacturer specific network- or bus-systems*

 

*Optionally intermediate devices like Programmable-Logical-Controllers can be used

SETUP

This section describes all steps to install and run CNCnetPDM as a program or background service. TOP

EXTRACT FILES

Create a folder for CNCnetPDM on your PC or at a server. Due to Windows UAC it is recommended not to use the directories ‘Program Files’ or ‘Program Files (x86)’ as CNCnetPDM should be able to run as a service under the ‘Local System’ account without any user logged on. In the example below folder ‘D:\MES Plant 1 Manufacturing Cells A to F\’ (1) was used.

Download CNCnetPDM.zip (2). For a fresh install extract all content of the ZIP file into this directory. If you’re upgrading from a previous version stop the service and extract all content except CNCnetPDM.ini and connect.udl into the folder of the previous version, overwrite the old files. You will find the following files:

FILE NAME

DESCRIPTION

CNCnetPDM.exe

Main program

CNCnetPDM.ini

Configuration file

cncinterface.dll

Responsible for communication with devices

device.dll

Device specific functions

erpinterface.dll

Responsible for communication with your database

connect.udl

Contains database definitions

CNCnetControl.exe

Graphical user interface to interact with the service

ServiceDLL.dll

Contains functions used by all components

 

Extract files 

FIG 1:    Extract files from CNCnetPDM.zip

TOP

START CNCNETPDM AS PROGRAM

After extracting the files it is possible and save to immediately start CNCnetPDM. However, for best user experience it is recommended to set up database tables and database connectivity before doing so, see chapters ‘DATABASE TABLES’ and ‘DATABASE CONNECTIVITY’. Otherwise CNCnetPDM switches to ‘offline-mode’ and writes all data to its offline-text-file. It’s also recommended to make yourself familiar with the parameters used by CNCnetPDM, see chapter ‘CONFIGURE CNCNETPDM.INI’. The following instructions were made on a PC with database tables installed and connectivity set up.

Double click on CNCnetPDM opens a dialog:

Initial dialog window

FIG 2:    Initial dialog of CNCnetPDM

Initially in section Service server (1) is set to ‘Local System’ (this PC), no instance for CNCnetPDM is defined (2), state is ‘not installed’. The second section Thread allows to run CNCnetPDM as a user program under your user account instead of a background service. It is recommended to initially start CNCnetPDM in this mode. If you click on ‘Start Thread’ CNCnetPDM performs some actions on your PC:

Subfolder ‘log’ is created under the folder where you extracted the program. It contains the log files written by CNCnetPDM. Folder name and location can be adjusted in CNCnetPDM.ini. With one device the following files are written (YYMMDD = actual year, month and day):

FILE NAME

DESCRIPTION

log_1000_YYMMDD.txt

Device specific messages, one per device, device number is taken from CNCnetPDM.ini

log_admin_YYMMDD.txt

Messages from administration service e.g. high water mark reached

log_db_YYMMDD.txt

Database related messages, e.g. connection succeeded, failed, insert errors

log_file_YYMMDD.txt

Messages about writing data to offline-text-files if database goes down

log_master_YYMMDD.txt

Messages from the main service about devices, instance, license and threads started by CNCnetPDM

log_readfile_YYMMDD.txt

Messages about offline-text-files written to the database

 

Subfolder ‘offline’ is created. In case your database cannot be reached or goes down data from devices is written into offline-text-files created by CNCnetPDM in this folder. Location and name of offline-text-files can be configured in CNCnetPDM.ini. Data from offline-text-files can be written to the database after database connectivity is established or the database is up again. Initially the file is named offline + number of offline file written.txt.

In configuration file CNCnetPDM.ini 4 entries are automatically added:

In section [GENERAL] License = license number is created. Initially this is a demo license. The only limitation of this license type is that CNCnetPDM automatically stops after 3 hours. Restarting the program or service again enables 3 hours of operation. See section LICENSING for more details.

Section [Connect] gets an additional entry UDL_DATEI which points to the .udl file connect.udl that contains information about your database connection. You can create different .udl files with different names for different databases. Please make sure that only one of them is active at a time. Inactive .udl files can be commented out by a prefixed semicolon ‘;’.

In section [Offline] entry FILENAME is created. This entry points to the folder and file name that should be used for offline-text-files. You can change that according to your needs. Please make sure that you always specify folder + file name in this case.

After starting CNCnetPDM as a program field State shows ‘Running’ and the ‘Stop Thread’ button becomes active. Clicking on ‘Stop Thread’ stops the program. In this state you could modify CNCnetPDM.ini and start the program again by clicking ‘Start Thread’. Clicking on button ‘Close’ also stops the program and closes the dialog. TOP

INSTALL AND START SERVICE

CNCnetPDM is able to and, in a production environment, usually runs as a windows background service. To install and start the service proceed as follows.

If you simply double click CNCnetPDM.exe and click on button ‘Install’ in section ‘Service’ an additional dialog with various service parameters opens. However, if you click on ok on most recent MS Windows Operating Systems you most likely will see a popup window with an ‘Access is denied’ message. This is because your user account does not have the appropriate rights to install a background service.

If you open CNCnetPDM.exe with elevated privileges (e.g. by right click + ‘Run as Administrator’) you are able to perform the necessary steps. Clicking on button ‘Install’ opens the following dialog:

Install dialog

FIG 3:    Service install dialog of CNCnetPDM

Service name is CNCnetPDM (1), no instance is defined (for details see chapter ‘WORKING WITH INSTANCES’). By clicking the button right of field file name (2) you could select and use a different file name and folder for the service, usually not necessary. Checking Automatic startup (3) causes the service to automatically start when the PC is turned on which should be checked in a production environment. If checked you can select a service that has to be started before CNCnetPDM starts (e.g. your database). Interactive only has to be checked when the service has to receive and send Windows Messages (e.g. DDE), usually this is not necessary.

Section ‘Service Account’ contains information about the user account the service runs under. If nothing is entered here the service runs under the ‘Local System’ account which is default for most Windows background services. Enter information here only if you’d like to run the service under a different account. Please note that this account has to have the appropriate permissions to run a service. Usually no data should be entered here.

Clicking on button Ok installs CNCnetPDM as a background service on your PC and the install dialog is closed. Now button ‘Start’ in section ‘Service’ of the main dialog gets active. Clicking on this button starts the background service. You can verify that by opening services (command line: services.msc) on your PC:

Installed background service (SCM)

FIG 4:    Installed Windows Background Service CNCnetPDM

By clicking on buttons ‘Stop’ or ‘Uninstall’ in the main dialog of CNCnetPDM you can stop or uninstall the service. TOP

WORKING WITH INSTANCES

In case you would like or have to work with different parameters for specific devices or groups of them you can use instances of the program or background service to do so. An instance basically is an own working environment for CNCnetPDM, you can run multiple instances of CNCnetPDM at the same time. To set up an instance for CNCnetPDM proceed as follows:

In the main dialog of CNCnetPDM click on the button (1) right of ‘Instance’ in section ‘Service’, a new dialog opens. Enter the name of the instance of the program (2), do not use whitespace characters. Doing so would cut off the instance name after the first whitespace character.

Setup of an instance
FIG 5:    Setup of a CNCnetPDM program or service instance

Clicking on button Ok closes the secondary dialog, the name of the instance is shown right of ‘Instance’ in section ‘Service’. If you now click on ‘Start Thread’ or ‘Install’ the following happens:

CNCnetPDM copies configuration file CNCnetPDM.ini to CNCnetFANUCNORTH.ini and if you use CNCnetPDM as a program starts instance FANUCNORTH. In addition shortcut ‘CNCnetPDM FANUCNORTH’ is created that enables you to use the instance without entering the name again.

You can configure the all parameters of the instance by editing the respective configuration file of the instance, in this example CNCnetPDMFANUCNORTH.ini. After editing the file and stopping and starting the program or service again the altered parameters are used by the instance.

An instance of CNCnetPDM installed as background service shows up as service CNCnetPDM.INSTANCENAME (e.g. CNCnetPDM.FANUCNORTH) in the service control manager = (Run… + services.msc)

Note: Please do NOT run CNCnetPDM as a foreground program and/or instance and non-instantiated service with the same .ini file content at the same as this leads to unpredictable results.

Information about the instance can also be found in file log_master_YYMMDD.txt in the log directory of CNCnetPDM.

To uninstall an instance when using CNCnetPDM as a program simply stop the program and delete the additional .ini file and the shortcut. In case you run an instance of CNCnetPDM as a service first click on ‘Uninstall’ in section ‘Service’ of the main dialog before removing the additional .ini file and shortcut. TOP

CONFIGURE CNCNETPDM.INI

CNCnetPDM.ini contains all information needed to control the functions of the service and to find and configure devices connected and controlled by the service. Although it is save and possible to start CNCnetPDM without any modifications to this file it is recommended to know the parameters and adjust them according to your needs. CNCnetPDM.ini contains the following sections and parameters:

Section [GENERAL] contains global parameters used by CNCnetPDM.

License = Your license number
Automatically created when you start CNCnetPDM the first time. Initially this is a demo license. The only limitation of this license type is that CNCnetPDM automatically stops after 3 hours. Restarting the program or service again enables 3 hours of operation. See section LICENSING for more details.

ServiceID = 1 - Possible values 1 - 9
If a device sends more than one item to CNCnetPDM in a reading cycle (for example Status, Counter, Work-Order, Quality and Feeder data) these records get the same Group_ID that enables to keep those records together. If you run more than one instance of the service on the same PC you can define a unique ServiceID for every instance so that Group_ID is always unique. If you just run one instance of the service there’s no need to change ServiceID.

IncrementCounters = 1
1 = Send difference between the previously and actually received part counter value.
0 = Send part counter value unmodified.

LimitCounters = 0
Only active when IncrementCounters is set to 1. Limit the possible amount of produced parts between previous and actual reading cycle. 0 = no limit.

ReplaceCounters = 20
Only active when IncrementCounters is set to 1 and LimitCounters not 0. If above the limit replace part counter value with this value.

Simulation = 0
Can either be 0 (no simulation) or 1. If set to 1 the service generates random values with a chance to be productive around 50% of the time for every defined device, good for testing if you do not have any device connected.

UseDNS = 1
1 = Identify devices by their DNS Hostname
0 = Use IP-Address of the device
If you can reach your devices by sending command ping DNSHOSTNAME (e.g. FANUC1) you can set the value to 1, otherwise 0 should be used.

AcquisitionMethod = 1
Method that should be used for data acquisition 1 = solicited 2 = unsolicited messaging
When solicited messaging is used the device is queried for data by the service, otherwise the device actively has to send data to the service. Please set this value to 1 if you do not use a device driver that is able to actively send data.

PollInterval = 30
Interval (seconds) for reading data from devices if solicited messaging is used. Please do not use too short values as this produces a large amount of data, recommended values are 20 to 120.

CollectCounters = 1
CollectQuality = 1
CollectFeeder = 1
CollectOrders = 1
Determination what should be acquired, value can either be 0 (no acquisition) or 1.
Device Status is always collected. Device Status and Counters are numeric values, all other items are alphanumeric.

Note: When CollectOrders is set to 1 CNCnetPDM may also output details about controller mode, NC program, spindle speed, feed rate and so on. If CollectFeeder is set to 1 CNCnetPDM may output axis data also. This depends on the  device driver DLL (e.g. device.dll or fanucext.dll) used for a specific device.

Section [RS232] (naming due to historic reasons) contains information about devices connected to CNCnetPDM.

For every device one line with a sequential number + ‘=’ and exactly 16 items is used. Of course it would have been possible to create an own section or .ini file for every connected device however, the benefits of this technique are that you just have to copy one line and adjust the parameters needed to add a new device and the size of the .ini file still stays small, even with 50 devices. All items have to be separated by semicolons ‘;’.

Note: In case there’s an error in a device configuration line CNCnetPDM continues to work but automatically uses default values which may not point to the desired device!

ITEM

DESCRIPTION

Sequential Nr. =

One number per line

Device Nr.

Device number 4-digits, use a unique number for every device

Baud

RS232 only, use default value (19200) for other devices

Data-bits

RS232 only, use default value (8) for other devices

Parity

RS232 only, use default value (N) for other devices

Stop-bits

RS232 only, use default value (19200) for other devices

Device name

Name of the device, use an own name for every device

IP-Address

IP-Address of device, enter 127.0.0.1 if server and device are on the same PC (e.g. Fanuc HSSB, Sinumerik DDE, PC with RS232 devices)

Port

TCP/UDP port for querying data from device (e.g. FANUC FOCAS 8193), enter 0 if not used

Method

If device.dll provides multiple methods to query data enter it here, otherwise use 0

DNS-Name

DNS Hostname of device, use ‘none’ if devices are found by IP-Address

Mitsubishi Nr.

Number of device specified by manufacturer specific device.dll (e.g. Mitsubishi), otherwise enter 0

PLC addr.

PLC address of part counter value if the Programmable Logic Controller (PLC) of the device is queried (default 0)

Log-file share

Log-file service only, name of the shared folder at the device (default none)

Log-file name

Log-file service only, name of the log file at the device (default none)

Log-file version

Log-file service only, version of the log file written by the device if more than one (default none)

DLL name

Name of the device driver to be used to query the device (default device.dll)


Initially CNCnetPDM ships with one device defined:

1 = 1000;19200;8;N;1;TEST #1;127.0.0.1;0;0;localhost;0;0;none;none;0;device.dll

The sequential number of the device is 1, device number is 1000, RS232 is not used (default values for 4 items), name of the device is ‘TEST #1’, IP-Address of the device is 127.0.0.1 (same IP-Address as the PC with the service), port and method are not used (0), DNS Hostname is localhost (DNS Hostname of the PC with the service), manufacturer device number and PLC address are not used (both 0), log-file share and name are not used (both ‘none’), log-file version is not used (set to 0), device driver used by the device is device.dll (default).

To add a secondary device on PC with IP-Address 192.168.1.10 and DNS-Hostname ‘PC2’ you could copy the line and modify its content as follows:

2 = 1001;19200;8;N;1;TEST #2;192.168.1.10;0;0;PC2;0;0;none;none;0;device.dll

Now CNCnetPDM would try to contact PC2 via its DNS-Hostname (if UseDNS is set to 1) or its IP-Address and report random values for the defined items if the device can be reached, otherwise CNCnetPDM would just report state (0) - disconnected.

Section [Protokoll] - German for protocol - defines the depth and date format of writing log-files

LEVEL = 0
Logs only errors and startup messages, depth can be controlled via GUI, leave at 0.

MODUS = 12
Format of date extension appended to log files (e.g. log_db_161006.txt = YYMMDD), leave at 12.

Section [Connect] contains information about the database used by CNCnetPDM

UDL_DATEI = Path and name of connect.udl file
Automatically created when CNCnetPDM starts the first time. Points to the path and name of file connect.udl that contains information about your database connection. You can create different .udl files with different names for different databases. Please make sure that only one of them is active at a time. Inactive .udl files can be commented out by a prefixed semicolon ‘;’.

DB_TYPE = 1
Type of Database to be used 1 = SQL Server 2 = ORACLE

ReconnectAfter = 30
Try to reconnect to database after number of seconds if database goes down. Value depends on how long the usual downtime for your database is.

Section [Offline] contains information about writing data to a text-file that can be processed afterwards in case your database goes down.

FILENAME = Path + name of offline-text-file
Automatically created when CNCnetPDM starts the first time. This entry points to the folder and file name that should be used for offline-text-files. You can change that according to your needs. Please make sure that you always specify folder + file name in this case.

TIMEOUT = 500
Milliseconds CNCnetPDM should wait before writing to the text-file instead of the database, leave at 500.

NR = 2962
Number appended to the offline text-file. The number is increased by 1 for every new offline text-file written. Can be changed to 0.

SIZE = 1
The maximum size of offline files can be adjusted by this entry. If not present it is automatically created with value 1 (= 1 MB). If this limit is reached CNCnetPDM creates a new offline file.

Section [ERP] - contains information about when, what and how to write records to the database

Changeddataonly = 0
If this entry is set to 0 (default) all item values are output on every reading cycle. If set to 1 all items values are output on the first reading cycle, subsequent readings only output item values that have changed since last reading.

CollectInShift = 0
If set to 1 device-data is only collected within an active shift for the device, requires table MTH_EQP_SHIFT_AVAIL_V, see chapter ‘DATABASE TABLES’ for details.

Writeworkorder = 0
If set to 1 current work order, operation and part number for the device are read from table MTH_USER_CONTEXT, see chapter ‘DATABASE TABLES’ for details.

Writedowntime = 1
If set to 1 CNCnetPDM creates an additional record with the reason for the downtime of a device. In case the status of the device is different to 2 (running) the following reasons are written by CNCnetPDM:
Switched off: PWD
Powered on but no data can be queried (half-alive-state): PWU
Device in manual mode: MAN
Automatic operation interrupted: INT
Faulted: ERR

Default tag names are:

Event = STATUS
Counter = COMP_QTY
Quality = COMP_QLT
Message = COMP_MSG
Order = ORDER
Operation = OPERATION
Item = ITEM_A
Feeder = FEED_QTY

Basic tag codes for different items sent by the devices, alphanumeric. Change that according to your needs.

DownTimeReason = DOWN
IdleTimeReason = IDLE
ScrapReason = SCRAP
ScrapQuantity = SCRAP_QTY
ReworkQuantity = REW_QTY
OutputQuantity = OUT_QTY

Extended tag codes for data from devices. DownTimeReason is the tag code for the downtime reason record if Writedowntime is set to one, all other tag codes are only used by customized versions of CNCnetPDM (e.g. Oracle MOC).

Section [MAPSTATES] - contains information about writing different numbers for status data from devices. Needed in case the solution that uses acquired data expects other values than the default ones.

Note: Please do NOT change Running = 2 to a different number or use number 2 for a different state.

Default values are: Off=0, On=1, Running=2, Manual=3, Interrupted=4, Faulted = 5
Faulted = 5
Interrupted = 4
Manual = 3
Running = 2
On = 1
Off = 0

Section [Hochwasser] (German for high water) - contains information about when to switch to error mode.

VERBUCHUNG = 80
(Processing) If more than this number of messages is waiting to be written to one of the components of CNCnetPDM (e.g. the database) CNCnetPDM switches to error mode, in case of the database writing is stopped and data is written to the offline-text-file. On lower deviation of this value CNCnetPDM automatically switches back to online processing. This is very useful if a database occasionally slows down due to high traffic.

VERWALTUNG = 60

(Administration) If more than this number of messages is waiting to be processed by CNCnetPDM (input data) CNCnetPDM waits until the data can be processed. TOP

DATABASE TABLES

Although not absolutely necessary for testing it is recommended to setup database tables and database connectivity before starting CNCnetPDM the first time. Without a database CNCnetPDM writes all collected data into a text file in subfolder \offline of the program directory.

SQL SERVER

For storing all data collected from devices CNCnetPDM uses table MTH_RAW_DATA. You can create it manually by using the following code or use file MTH_RAW_DATA_SQLSERVER.sql from this zip archive. In this description tables in database MDA are used.

/****** Object:  Table [dbo].[MTH_RAW_DATA] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MTH_RAW_DATA]
(
	[GROUP_ID] [float] NULL,
	[READING_TIME] [datetime] NOT NULL,
	[DEVICE_NUMBER] [smallint] NOT NULL,
	[TAG_CODE] [varchar](255) NOT NULL,
	[TAG_DATA] [varchar](255) NULL,
	[CREATION_DATE] [datetime] NULL,
	[PROCESSING_FLAG] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[MTH_RAW_DATA] ADD  CONSTRAINT [DF_MTH_RAW_DATA_PROCESSING_FLAG]  DEFAULT ((1)) FOR [PROCESSING_FLAG]
GO
FIG 6:    Setup script (SQL Server) for database table MTH_RAW_DATA

 OPTIONAL: CNCnetPDM is able to use work-order, operation and part-number collected by a separate solution for Operational Data Acquisition. In this case CNCnetPDM looks up this information after every reading cycle and inserts 3 additional records for the current work-order, operation and part-number. If you plan to use in CNCnetPDM with you also need table MTH_USER_CONTEXT. You can create it by using the following code or file MTH_USER_CONTEXT_SQLSERVER.sql from this zip archive.

/****** Object:  Table [dbo].[MTH_USER_CONTEXT] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MTH_USER_CONTEXT](
	[USER_CONTEXT_PK_KEY] [numeric](5, 0) IDENTITY(1,1) NOT NULL,
	[SCAN_TIME] [varchar](255) NOT NULL,
	[EQUIPMENT_FK] [varchar](255) NOT NULL,
	[WORKORDER_FK] [varchar](255) NOT NULL,
	[SEGMENT_FK] [varchar](255) NOT NULL,
	[ITEM_FK] [varchar](255) NOT NULL,
 CONSTRAINT [PK_MTH_USER_CONTEXT] PRIMARY KEY CLUSTERED 
(
	[USER_CONTEXT_PK_KEY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
FIG 7:    Setup script (SQL SERVER) for database table MTH_USER_CONTEXT

If you’re using an external program for Operational Data Acquisition the table should contain one row for every device with the 4 digit device number in column EQUIPMENT_FK, SCAN_TIME is optional. The solution has to update WORKORDER_FK (work order), SEGMENT_FK (operation) and ITEM_FK (part number) with data about the current activity of the device.

OPTIONAL: If your devices are switched on all the time but you only want to acquire data within active shifts only you need an additional view named MTH_EQP_SHIFT_AVAIL_V that just returns the 4 digit device number in case there is an active shift for the device at the moment. If nothing is returned CNCnetPDM assumes that there is no active shift. For testing you can also create a table MTH_EQP_SHIFT_AVAIL_V that just contains column EQUIPMENT_FK. To build the table you can use the following code or file MTH_EQP_SHIFT_AVAIL_V_SQLSERVER.sql from this zip archive.

/****** Object:  Table [dbo].[MTH_EQP_SHIFT_AVAIL_V] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MTH_EQP_SHIFT_AVAIL_V](
	[EQUIPMENT_FK] [numeric](5, 0) NOT NULL
) ON [PRIMARY]
GO
FIG 8:    Setup script (SQL SERVER) for database table MTH_EQP_SHIFT_AVAIL_V

For testing you can insert the 4 digit device number into field EQUIPMENT_FK and adjust the .ini file for CNCnetPDM to only collect data within a shift. In a production environment MTH_EQP_SHIFT_AVAIL_V should be a view that looks up if there’s an active shift for the equipment in a shift table and, if yes, returns the 4 digit device number. TOP

ORACLE

For Oracle, MySQL or MariaDB databases the information above applies also but the scripts to create the tables look slightly different. The following code can be used to create MTH_RAW_DATA alternatively you can use MTH_RAW_DATA_ORACLE.sql from this zip archive. Here user is MTH and tablespace is USERS, please change that according to your needs.


 CREATE TABLE "MTH"."MTH_RAW_DATA" 
   (	"GROUP_ID" NUMBER, 
	"READING_TIME" DATE NOT NULL ENABLE, 
	"DEVICE_NUMBER" NUMBER NOT NULL ENABLE,
	"TAG_CODE" VARCHAR2(255 BYTE) NOT NULL ENABLE, 
	"TAG_DATA" VARCHAR2(255 BYTE), 
	"CREATION_DATE" DATE, 
	"PROCESSING_FLAG" NUMBER DEFAULT 2 NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
   COMMENT ON COLUMN "MTH"."MTH_RAW_DATA"."GROUP_ID" IS 'Tag context group identifier';
   COMMENT ON COLUMN "MTH"."MTH_RAW_DATA"."READING_TIME" IS 'Reading time for the tag data';
   COMMENT ON COLUMN "MTH"."MTH_RAW_DATA"."DEVICE_NUMBER" IS 'Device number sending tag data';
   COMMENT ON COLUMN "MTH"."MTH_RAW_DATA"."TAG_CODE" IS 'Tag code';
   COMMENT ON COLUMN "MTH"."MTH_RAW_DATA"."TAG_DATA" IS 'Tag data';
   COMMENT ON COLUMN "MTH"."MTH_RAW_DATA"."CREATION_DATE" IS 'Creation time';
   COMMENT ON TABLE "MTH"."MTH_RAW_DATA"  IS 'This table contains the unprocessed tag data collected from devices'; 
FIG 9:    Setup script (ORACLE) for database table MTH_RAW_DATA

For table MTH_USER_CONTEXT you can use the following code or alternatively MTH_USER_CONTEXT_ORACLE.sql from this zip archive. Here again user is MTH and tablespace is USERS, please change that if needed.

  CREATE TABLE "MTH"."MTH_USER_CONTEXT" 
   (	"USER_CONTEXT_PK_KEY" NUMBER NOT NULL ENABLE, 
	"SCAN_TIME" VARCHAR2(255 BYTE) NOT NULL ENABLE, 
	"EQUIPMENT_FK" VARCHAR2(255 BYTE) NOT NULL ENABLE, 
	"WORKORDER_FK" VARCHAR2(255 BYTE) NOT NULL ENABLE, 
	"SEGMENT_FK" VARCHAR2(255 BYTE) NOT NULL ENABLE, 
	"ITEM_FK" VARCHAR2(255 BYTE) NOT NULL ENABLE, 
	"EQUIP_DOWN_REASON" VARCHAR2(255 BYTE), 
	"SYSTEM" VARCHAR2(20 BYTE), 
	 CONSTRAINT "MTH_USER_CONTEXT_PK" PRIMARY KEY ("USER_CONTEXT_PK_KEY")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
FIG 10:  Setup script (ORACLE) for database table MTH_USER_CONTEXT

To only acquire data within an active shift for a device you can use the following code or alternatively file MTH_EQP_SHIFT_AVAIL_V_ORACLE.SQL from this zip archive.

  CREATE TABLE "MTH"."MTH_EQP_SHIFT_AVAIL_V" 
   (	"EQUIPMENT_FK" VARCHAR2(255 BYTE) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
FIG 11:  Setup script (ORACLE) for database table MTH_EQP_SHIFT_AVAIL_V

For testing you can insert the 4 digit device number into field EQUIPMENT_FK and adjust the .ini file for CNCnetPDM to only collect data within a shift. In a production environment MTH_EQP_SHIFT_AVAIL_V should be a view that looks up if there’s an active shift for the equipment in a shift table and, if yes, returns the 4 digit device number. TOP

DATABASE CONNECTIVITY

To connect to a database CNCnetPDM uses a Universal Data Link (.udl) file that contains information about your database. CNCnetPDM.zip initially ships with file connect.udl which contains the following information:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Persist Security Info=False; Data Source=(local)

This means that CNCnetPDM assumes that you’re using MS SQL SERVER (Provider=SQLOLEDB.1), Username and password should not be stored (Persist Security Info=False) and your database is at the local PC (Data Source=(local)). To change that, proceed as follows. The procedures for MS SQL SERVER and ORACLE are slightly different. TOP

MS SQL SERVER

Double click on file connect.udl, click on tab ‘Provider’ (1), select the provider you want to use to connect to your database (2).

Select database provider

FIG 12:  Select provider for database connection (UDL file)

Click on tab ‘Connection’ (3), enter information that describes your database. Under ‘Select or enter a server name’ (4) enter or select the database you’re using. If you use an instance simply append \INSTANCENAME to the server name.

Enter database connection parameters

FIG 13:  Setup database connection information (UDL file)

Under ‘Enter information to log on to the server’ (5) select either ‘Use Windows NT Integrated security’ or ‘Use a specific user name and password’. If you plan to use CNCnetPDM as a background service it is highly recommended that you use the second option as the service normally is executed under the ‘local system’ account and should be able to run without any user logged on. In this case please also check ‘Allow saving password’ (6). Finally select the database on the server that contains the required tables (7), here MDA. Clicking on button ‘Test Connection’ should return ‘Test connection succeeded’. Click OK, you’re done. TOP

ORACLE

Oracle has 2 different types of database clients, one for 64 and one for 32 bit Operating Systems (OS). Because CNCnetPDM is a 32 bit program please install the 32 bit version of the client tools even if you’re working with a 64 bit OS. To configure the database connection for CNCnetPDM on a PC with 64 bit OS proceed as follows, do NOT double click the .udl file.

  1. Open a 32 bit command line: %SystemRoot%\syswow64\cmd.exe
  2. Navigate to the directory where CNCnetPDM is installed: cd DIRECTORYNAME
  3. Type in the name of the .udl file: connect.udl

A dialog opens, click on tab ‘Provider’ (1), select the provider you’re going to use for your database connection (2).

Select database provider (Oracle)

FIG 14:  Select provider for database connection (UDL file)

Next, click on tab ‘Connection’ (3) to enter information required to access your database.

Enter database connection parameters (Oracle)

FIG 15:  Setup database connection information (UDL file)

Under ‘Enter the data source and/or location of the data’ (4) enter the Data Source name of the database you’re using, here TNS name ORCL2 is used. Tip: You can also use a so called ‘TNS less’ connection. In this case please enter data similar to the following into this field:

(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IPOFHOST)(PORT=PORTOFSERVICE)))(CONNECT_DATA=(SID=SERVICEID)(SERVER=DEDICATED)))

IPOFHOST = IP Address of the PC with the database
PORTOFSERVICE = Port of the service, typical 1521
SERVICEID = ID of the service, e.g. VIS

Under ‘Enter information to log on to the server’ (5) enter the username and password into the appropriate fields. If you plan to use CNCnetPDM as a background service it is highly recommended that you check ‘Allow saving password’ (6) as the service normally is executed under the ‘local system’ account and should be able to run without any user logged on. Click on tab ‘All’ and make sure that ‘Persist security Info’ is set to ‘True’. Clicking on button ‘Test Connection’ in tab ‘Connection’ should return ‘Test connection succeeded’. Click OK, you’re done. TOP

DATABASE OUTPUT

For both, MS SQL-Server and Oracle databases CNCnetPDM writes data acquired from devices to table MTH_RAW_DATA. The table has 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 chapter ‘CONFIGURE CNCNETPDM.INI’ for details. The specified tag code gets prefixed with the 4 digit device number. Example:
1000.STATUS. 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 received from a device for a specific item. Status and part counter values are numeric, all other items are alphanumeric. 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)

 

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

Database output (Raw data)

FIG 16:  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.

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 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

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 this is a demo license.
The ONLY limitation of this license type is that CNCnetPDM automatically stops after 3 hours. Restarting the program or service again enables 3 hours of operation.

Information about your license is stored in file log_master_YYMMDD.txt in the log directory of CNCnetPDM. In addition entry License = Your license number is created in section [GENERAL] of configuration file CNCnetPDM.ini

There are 3 possible licensing options for CNCnetPDM:

LICENSE TYPE

DESCRIPTION

Demo License
(Default)

Unlimited number of devices. Automatically stops after 3 hours of operation, restarting the program or service again enables 3 hours of operation

Device License

Limited to a specific number of devices per server, no time limitation

Server License

Unlimited number of devices on a single server, no time limitation

 

In addition time-limited versions of license types Device or Server are available. To purchase a license or get a time-limited license for testing please contact our sales and support department.

You have two possible options to obtain an updated license:

  1. Copy your current license number (40 characters) from log-file log_master_YYMMDD.txt or from CNCnetPDM.ini and send it by email to the sales and support department.
  2. Double click on CNCnetControl.exe with your service running. Click on Button ‘View / Edit’ under ‘License’, an additional dialog opens:

Licensing dialog (CNCnetControl)

FIG 17:  CNCnetPDM license dialog (CNCnetControl)

On top (1) you see details about your current license, a demo license always shows up as ‘expired’. If you click on the button right of field ‘Current License Number’ your license number is copied to the clipboard. Paste it into an email and send it to our sales and support department.

To register a new license received from inventcom you also have two options.

  1. Exchange your current license number in file CNCnetPDM.ini with the one received from inventcom, restart the program or service.
  2. Double click on CNCnetControl.exe with your service running. Click on Button ‘View / Edit’ under ‘License’. Copy the license number from the email received from inventcom to the clipboard.
  3. Click on the button (3) right of field ‘New License Number’, this pastes the new license number into the appropriate field. If you entered a valid license number button OK gets activated. Clicking on OK immediately registers the license, no restart of the program or service is required! In case everything worked well the information in the top area (1) of the license dialog changes accordingly.

IMPORTANT NOTES ABOUT LICENSING:

In case you enter an invalid license number or copy your program to another PC CNCnetPDM automatically creates a new demo license on next startup of the program or service. If you have a valid license for CNCnetPDM please contact sales and support before changing PCs! TOP

CNCNETCONTROL

OVERVIEW

CNCnetControl is a Graphical User Interface (GUI) to monitor and configure CNCnetPDM running on a local or remote PC. Double clicking CNCnetControl.exe opens up a dialog with several areas and buttons:

CNCnetControl main dialog

FIG 18:  Graphical user interface CNCnetControl for CNCnetPDM
  • In the lower left pane (1) you can see all devices connected to the selected instance, program or service of CNCnetPDM. Clicking on one of the devices only shows data for the selected device in the right window. Clicking on ‘Show all’ again shows data from all devices.
  • In the right lower pane (2) you see all incoming data from connected devices.
  • Button ‘Manage’ (3) in section ‘Service’ enables you to start and stop a CNCnetPDM background service on a local or remote PC. With button ‘Connect’ (4) you can connect to a CNCnetPDM program or service on a remote or local PC.
  • Clicking on button ‘Set Flag’ (5) in section ‘Protocol’ enables you to set the depth of logging for the selected instance of CNCnetPDM.
  • Button ‘View / Edit’ (6) in section ‘License’ enables to read or update licensing information, see chapter ‘LICENSING’ for details.
  • Button ‘Open’ (7) under section ‘Database’ allows to open a previously manually closed database connection. Button ‘Close’ (8) manually closes the current database connection, all data is written to the offline-text-file specified for CNCnetPDM. Button ‘Process’ (9) allows you to write data previously written to an offline-text-file to your database.
  • Button ‘Open’ (10) in section ‘Device’ enables to open a previously manually closed device. With button ‘Close’ you can manually stop data acquisition from a selected device. (device shows up as ‘switched off’ then). Both buttons only get active if you select a device by clicking on it in the left window. TOP

DEVICE STATES

The icons and status text for configured devices changes according to their state:

Device states in CNCnetControl

FIG 19:  Device states in CNCnetControl
  • Green icon, device is connected, status shows ‘Connected’
  • Red icon, device is disconnected or unreachable, status shows ‘Disconnected’
  • Yellow icon, device is manually switched off, status shows ‘Switched Off’
  • Blue icon, device is currently communicating with CNCnetPDM. Status shows ‘Communicate’ TOP

DEVICE DATA

According to the items selected for data acquisition in CNCnetPDM.ini the right lower pane shows incoming data (1) from the devices. If all collectable items are selected output may look as follows. In general the format for device output is Device number 4-digits, date and time, event type, data and group id. Group id is always identical for multiple items acquired in one cycle.

Device data in CNCnetControl

FIG 20:  Monitoring of device data in CNCnetControl
  • 1000 10/11/2016 05:50:02 PM E 5 10000000195
    (E) = Device state (numeric): 0 = disconnected, 1 = connected but not sending data (half alive), 2 = running, 3 = in manual mode, 4 = operation interrupted, 5 = faulted
  • 1000 10/11/2016 05:50:02 PM Z 0 10000000195
    (Z) = Part counter value (numeric), either difference to the last value read or value sent by the device.
  • 1000 10/11/2016 05:50:02 PM A -387.28 1849.12 3374.43 6158.94 9542.22  10000000195
    In case a single value is received (A) = Quality data (alphanumeric), quality or process data. If multiple values delimited with pipe symbols are received CNCnetPDM automatically creates a record for every TAG_CODE and TAG_DATA pair.
  • 1000 10/11/2016 05:50:02 PM O 477130 10000000195
    (O) = Data related to work order (alphanumeric), data about work order operation part number a.s.o., can be used for other data like process or quality also. If multiple values delimited by a pipe symbol ‘|’ are found CNCnetPDM creates multiple records.
  • 1000 10/11/2016 05:50:02 PM F -387 1849 3374 6159  10000000195
    (F) = Data from feeding device (alphanumeric), data send by bar feeder or other attached devices, can be used for other data like process or quality data also. TOP

CLOSE - OPEN DEVICE

Clicking (1) on one of the devices in the left window enables the buttons in section ‘Device’. Instead of ‘Device’ the number and name of the selected device is shows as section title (2).

Close / open devices in CNCnetControl

FIG 21:  Close / open devices in CNCnetControl

Clicking on ‘Close’ (3) manually closes the device connection, the icon color changes to yellow, the status changes to ‘Switched Off’. In this state no attempts are made to receive data from this device.

Clicking on ‘Open’ (4) again opens a previously manually closed device connection, the icon color changes to green or red according to the state of the device, the status changes to ‘Disconnected’ or ‘Connected’. Data reception is again activated from this device. TOP

CONNECT TO SERVICE

Clicking on button ‘Connect’ in section ‘Service’ enables you to connect CNCnetControl to a CNCnetPDM program or service on a remote or the local PC. A new dialog window opens:

CNCnetControl select server / instance

FIG 22:  Connect to an instance of CNCnetPDM on a remote server

You can enter the DNS-Hostname or IP-Address of a remote PC (1) under ‘Enter the Servers Name’. If you do not enter anything CNCnetControl assumes that you try to connect to CNCnetPDM on the local PC.

Under ‘Enter an instance for the service’ you can enter an instance of the service (2) if you are working with instances of CNCnetPDM, see chapter ‘WORKING WITH INSTANCES’ for details. If you enter nothing CNCnetControl assumes that you do not work with an instance.

Note: This dialog also automatically opens if you open CNCnetControl on your PC without CNCnetPDM running on the local PC.

After clicking on OK CNCnetControl tries to connect to the specified CNCnetPDM program or service. If successful the title bar of CNCnetControl changes according to the information entered. If the specified PC or service cannot be reached you see a dialog with an error message.

If you connect to an instance or service of CNCnetPDM CNCnetControl also automatically creates a shortcut in the program folder. The shortcut is named ‘CNCnetControl REMOTEHOST INSTANCE’ or ‘CNCnetControl INSTANCE’ if no host was entered or ‘CNCnetControl REMOTEHOST’ if no instance was entered. Clicking the shortcut automatically connects to the specified instance of CNCnetPDM on your local or a remote PC. TOP

MANAGE SERVICE

Clicking on button ‘Manage’ in section ‘Service’ also opens a dialog window that enables you to select a PC and/or an instance of CNCnetPDM, see chapter ‘CONNECT TO SERVICE’ for details. If the connection succeeds a dialog opens that allows you to see the current state (1) of the selected service.

Manage service (CNCnetControl)

FIG 23:  Manage CNCnetPDM background service in CNCnetControl

Clicking on button ‘Stop’ stops the selected service. By clicking on button ‘Start’ you can start the service again.

Notes:
Button ‘Manage’ only connects to CNCnetPDM running as a background service.
If you see a popup window with an error message e.g. ‘Access is denied’ please run CNCnetControl with elevated privileges f.i. ‘Run as Administrator’. TOP

ADJUST PROTOCOL LEVEL

For debugging purposes (only!) it can be useful to increase the level of writing information about program activities to the log file directory. Clicking on button ‘Set Flag’ in Section ‘Protocol’ opens a dialog that allows you to control the depth of logging for selected areas:

CNCnetControl set protocol level

FIG 24:  Adjust level of logging in CNCnetControl

If you click on one of the items the icon under ‘Bit’ changes from 0 to 1 or 1 to 0. Clicking on button OK sets the log level according to the selected items. Please note that with any of the bits set to 1 the amount of data written to the log file folder heavily increases. As mentioned before this should be used for debugging purposes only. Switch bits set to 1 back to 0 after you’re done with debugging! TOP

VIEW - EDIT LICENSE INFORMATION

If you click on button ‘View / Edit’ in section ‘License’ you can view your currently installed license and update your license, see chapter ‘LICENSING’ for details. TOP

CLOSE - OPEN DATABASE CONNECTION

If the currently selected program, service or instance of CNCnetPDM is connected to a database you see an animated green traffic light icon in section ‘Database’ followed by the text ‘Connection to database succeeded’ (1). In this case button ‘Close’ (2) gets activated.

Close / open database connection (CNCnetControl)

FIG 25:  Close / open database connection in CNCnetControl

If you click on button ‘Close’ CNCnetPDM closes the connection to your database and writes all acquired data to the offline-text-file specified in CNCnetPDM.ini. The icon changes to yellow followed by text ‘Set offline’. This feature is very useful for scheduled database management tasks that require database downtime.

If the database connection is closed button ‘Open’ gets activated. Clicking on this button again tries to establish a connection to your database. If successful the icon again changes to green.

If CNCnet PDM cannot establish a connection to your database the color of the icon changes to red followed by an error message. CNCnetPDM then tries to automatically reconnect to your database after the number of seconds specified in CNCnetPDM.ini, section [Connect] -> ReconnectAfter = number of seconds

In case your database is up again you can send the data previously written to the offline-text-file to your database by clicking on button ‘Process’. A dialog opens and shows which offline-text-file is written to the database. TOP

Support | CNCnetPDM | Release Notes
Release Notes tell you what’s new in CNCnetPDM. As always, we welcome your feedback .... [read more]
Release Notes
Support | CNCnetPDM | Overview
Welcome to CNCnetPDM online support! Below you can find everything you need to install, setup, configure and troubleshoot CNCnetPDM. For device-specific support topics please... [read more]
Overview
Support | CNCnetPDM | Quick Start Guide
Version 4.9.0.1 If you don’t want to go through all the steps described in the user manual and you know what you’re doing simply follow the steps below to... [read more]
Quick Start Guide
Support | CNCnetPDM | Device Port Scanner
In case you're going to connect to a remote device with an Ethernet network connection that uses a specific TCP-Port for communication you can use the utility CNCScan.exe to... [read more]
Device Port Scanner
Support | CNCnetPDM | Device Driver Tester
This utility program allows you to easily test and adjust the output of all available device drivers without the need to setup a device in CNCnetPDM. It also enables to verify... [read more]
Device Driver Tester
Support | CNCnetPDM | Changes in Version 4.8.0.0
Compared to version 4.7.0.0 this version includes some major changes. DATABASE TABLES The structure of database table MTH_RAW_DATA that now receives all raw data from devices has... [read more]
Changes in Version 4.8.0.0
Modified: 2017-04-24