Mitsubishi Electric GOT 1000 Series User manual

MES Interface Function Manual
for GT Works3
Series

A - 1
SAFETY PRECAUTIONS
(Always read these precautions before using this product.)
Before using the product, please read this manual and the relevant manuals introduced in this manual
carefully and pay full attention to safety to handle the product correctly.
The precautions given in this manual are concerned with only this product.
In this manual, the safety precautions are ranked as "WARNING" and "CAUTION".
Note that the CAUTION level may lead to serious consequences according to the circumstances.
Always follow the precautions of both levels as they are important for personal safety.
Please save this manual to make it accessible when required and always forward it to the end user.
[Design precautions]
WARNING
Before performing the test operation, read this manual carefully to understand the operation
procedure.
Incorrect output or malfunctions may cause an accident.
When the security of the GOT and relevant information need to be protected against illegal access
from an external device via the Internet, take measures at the user's discretion.
Failure to do so may cause the configured information to be read out illegally.
WARNING
CAUTION
Indicates that incorrect handling may cause hazardous conditions, resulting in
death or severe injury.
CAUTION Indicates that incorrect handling may cause hazardous conditions,
resulting in minor or moderate injury or property damage.

A - 2
CAUTIONS FOR USE
(1) GOTs that support the MES interface function
GT16 and GT15 only support the function.
By installing the option OS into a GOT from GT Designer3, the MES interface function can be used.
For applicable models, refer to the following:
2.2 Connection between GOT and Controllers
(2) Option function board that supports the MES interface function
For the option function board that supports the MES interface function, refer to the following:
2.3 Required Equipment, Software and Option OS
(3) Relational databases that support the MES interface function
For the relational databases that support the MES interface function, refer to the following:
2.4.2 Server computer (SNTP server computer)
(4) Connection type used for the MES interface function
To utilize the MES interface function, the Ethernet connection is used.
Install an Ethernet communication unit, and configure the Ethernet setting in Communication Settings of GT
Designer3.
For applicable Ethernet communication units, refer to the following:
2.3 Required Equipment, Software and Option OS
For the Ethernet connection, refer to the following.
GOT1000 Series Connection Manual (Mitsubishi Products) for GT Works3
Cautions on the system configuration

A - 3
SAFETY PRECAUTIONS .........................................................................................................................A - 1
CAUTIONS FOR USE ..............................................................................................................................A - 2
INTRODUCTION ......................................................................................................................................A - 3
CONTENTS ..............................................................................................................................................A - 3
MANUALS.................................................................................................................................................A - 7
QUICK REFERENCE ...............................................................................................................................A - 9
ABBREVIATIONS AND GENERIC TERMS ...........................................................................................A - 11
HOW TO READ THIS MANUAL .............................................................................................................A - 16
DEFINITIONS AND DESCRIPTIONS OF TERMS .................................................................................A - 17
1. OVERVIEW
1.1 Features........................................................................................................................................... 1 - 2
1.2 What is the MES Interface Function? .............................................................................................. 1 - 6
2. SYSTEM CONFIGURATION
2.1 System Configuration ...................................................................................................................... 2 - 1
2.1.1 Overall system configuration ................................................................................................ 2 - 1
2.1.2 System configuration when installing software used for the MES Interface Function .......... 2 - 2
2.2 Connection between GOT and Controllers...................................................................................... 2 - 3
2.2.1 Connection type used for the MES Interface Function ......................................................... 2 - 3
2.2.2 Precautions for inverter or servo amplifier connection ......................................................... 2 - 5
2.3 Required Equipment, Software and Option OS ............................................................................... 2 - 6
2.4 Operating Environment.................................................................................................................... 2 - 7
2.4.1 Configuration computer ........................................................................................................ 2 - 7
2.4.2 Server computer (SNTP server computer) ........................................................................... 2 - 7
2.5 Cautions on System Configuration ................................................................................................ 2 - 10
3. SPECIFICATIONS
3.1 Performance Specifications ............................................................................................................. 3 - 1
3.2 GOT Devices Available for the MES Interface Function.................................................................. 3 - 3
3.3 Function List and Setting Item List................................................................................................... 3 - 4
3.4 GOT Internal Device (GS) ............................................................................................................... 3 - 6
3.4.1 GOT internal device list ........................................................................................................ 3 - 6
3.4.2 MES Interface Function area................................................................................................3-6
INTRODUCTION
Thank you for purchasing the Mitsubishi Graphic Operation Terminal (GOT).
Before using the GOT, please read this manual carefully to understand the features and performance for
correct handling.
CONTENTS

A - 4
4. SETTINGS AND PROCEDURES BEFORE USE OF THE MES INTERFACE
FUNCTION
4.1 Settings and Procedures before Use of the MES Interface Function .............................................. 4 - 1
4.2 Installation and Uninstallation .......................................................................................................... 4 - 3
5. MES INTERFACE FUNCTION
5.1 DB Interface Function ...................................................................................................................... 5 - 1
5.1.1 DB interface function operation ............................................................................................5-1
5.1.2 Job execution procedure ...................................................................................................... 5 - 2
5.1.3 Tag function .......................................................................................................................... 5 - 3
5.1.4 Trigger monitoring function ................................................................................................... 5 - 4
5.1.5 Trigger buffering function...................................................................................................... 5 - 6
5.1.6 SQL text transmission (Communication action).................................................................... 5 - 9
5.1.7 Arithmetic processing function (Operation action) .............................................................. 5 - 10
5.1.8 Resource data send function (Resource data send action)................................................ 5 - 11
5.1.9 Program execution function ................................................................................................ 5 - 14
5.1.10 DB buffering function .......................................................................................................... 5 - 15
5.2 SNTP Time Synchronization Function...........................................................................................5-23
5.3 Precautions.................................................................................................................................... 5 - 24
6. MES INTERFACE FUNCTION SETTING
6.1 MES Interface Function Setting Screen........................................................................................... 6 - 1
6.2 Displaying the MES Interface Function Setting Screen ................................................................... 6 - 1
6.3 Screen Structure.............................................................................................................................. 6 - 2
6.3.1 Screen structure ................................................................................................................... 6 - 2
6.3.2 Operations using the Edit items tree..................................................................................... 6 - 3
6.4 Setting.............................................................................................................................................. 6 - 5
6.5 Device Tag Settings......................................................................................................................... 6 - 6
6.5.1 Setting items in Device tag settings...................................................................................... 6 - 7
6.5.2 Setting items in Array setting ................................................................................................ 6 - 9
6.5.3 Setting items in Component setting .................................................................................... 6 - 11
6.6 Server Service Settings ................................................................................................................. 6 - 17
6.6.1 Setting items in Server service settings.............................................................................. 6 - 18
6.7 Job Settings ................................................................................................................................... 6 - 21
6.7.1 Setting items in Job settings ............................................................................................... 6 - 22
6.7.2 Setting items in Trigger conditions...................................................................................... 6 - 25
6.7.3 Setting items in Program execution .................................................................................... 6 - 33
6.7.4 Setting items in DB Buffering..............................................................................................6-36
6.7.5 Notify errors (job cancellation) that occur during job execution .......................................... 6 - 36
6.7.6 One-shot execution............................................................................................................. 6 - 37
6.8 Job Settings - Actions .................................................................................................................... 6 - 38
6.8.1 Setting items in Communication action............................................................................... 6 - 42
6.8.2 Setting items in Operation action........................................................................................ 6 - 62
6.8.3 Setting items in Transmit resource action........................................................................... 6 - 65
6.9 Option Setting ................................................................................................................................ 6 - 78
6.9.1 Setting items in SNTP time synchronization setting ........................................................... 6 - 79

A - 5
6.9.2 Setting items in DB buffering settings................................................................................. 6 - 81
6.10 Diagnosis....................................................................................................................................... 6 - 85
6.10.1 Checking the MES Interface Function status (Status)........................................................ 6 - 86
6.10.2 Manipulating the MES Interface Function status (Operation)............................................. 6 - 87
6.10.3 Changing the job status (Change job status) ..................................................................... 6 - 88
6.10.4 Checking the connection of the previous job execution
(Connection result of previous job execution) .................................................................... 6 - 89
6.10.5 Manipulating DB buffering (DB buffering operation)........................................................... 6 - 90
6.10.6 Checking the trigger buffering (Trigger buffering status) .................................................... 6 - 91
6.11 Working Log................................................................................................................................... 6 - 92
6.11.1 MES Interface Execute Log................................................................................................ 6 - 93
6.11.2 Job Execute Log................................................................................................................. 6 - 94
6.12 Precautions.................................................................................................................................... 6 - 98
7. DB CONNECTION SERVICE AND SETTING TOOL
7.1 DB Connection Service Functions ................................................................................................... 7 - 1
7.2 Setting ODBC of Database.............................................................................................................. 7 - 3
7.3 Starting DB Connection Service Setting Tool ................................................................................ 7 - 11
7.4 Screen Structure of DB Connection Service Setting Tool ............................................................. 7 - 12
7.4.1 Screen structure ................................................................................................................. 7 - 12
7.4.2 Menu configuration ............................................................................................................. 7 - 12
7.5 Setting Items of DB Connection Service Setting Tool .................................................................. 7 - 13
7.6 Importing/Exporting Files .............................................................................................................. 7 - 17
7.7 Help ............................................................................................................................................... 7 - 18
7.8 Output Log Specifications.............................................................................................................. 7 - 19
7.8.1 Access log .......................................................................................................................... 7 - 20
7.8.2 SQL failure log .................................................................................................................. 7 - 21
8. TROUBLESHOOTING
8.1 Error Handling and Recovery Method ............................................................................................. 8 - 1
8.1.1 MES Interface Function setting ............................................................................................ 8 - 3
8.1.2 When using DB Connection Service Setting Tool ................................................................ 8 - 5
8.2 Error Code List................................................................................................................................. 8 - 6
8.2.1 Error log in the Working log .................................................................................................. 8 - 6
8.2.2 DB Connection Service ......................................................................................................8-10
APPENDICES
Appendix1 Usable Characters and ASCII Code Tables by Setting Items .............................................App - 1
Appendix.1.1 ASCII code table .........................................................................................................App - 1
Appendix.1.2 Characters applicable to item names, component names, variable names, etc. ........App - 2
Appendix.1.3 Characters applicable to character string constants, etc.............................................App - 3
Appendix.1.4 Characters applicable to field names, table names, etc..............................................App - 3
Appendix2 About Monitoring Interval Timeout.......................................................................................App - 4
Appendix3 Warning Messages in Windows Vista(R) ............................................................................App - 6
Appendix.3.1 Overview of warning messages ..................................................................................App - 6
Appendix.3.2 Methods for disabling warning messages ...................................................................App - 6
Appendix4 Tables for Used Terms ......................................................................................................App - 12

A - 6
Appendix5 Application Example of MES Interface Function................................................................App - 13
INDEX
REVISIONS

A - 7
MANUALS
The following table lists the manual relevant to this product.
Refer to each manual for any purpose.
Screen creation software manuals
Connection manuals
Extended and option function manuals
GT SoftGOT1000 manuals
Manual Name Packaging Manual Number
(Model code)
GT Works3 Version1 Installation Procedure Manual Enclosed in product -
GT Designer3 Version1 Screen Design Manual (Fundamentals) 1/2, 2/2 Stored in DVD-ROM SH-080866ENG
(1D7MB9)
GT Designer3 Version1 Screen Design Manual (Functions) 1/2, 2/2 Stored in DVD-ROM SH-080867ENG
(1D7MC1)
GT Simulator3 Version1 Operating Manual for GT Works3 Stored in DVD-ROM SH-080861ENG
(1D7MB1)
GT Converter2 Version3 Operating Manual for GT Works3 Stored in DVD-ROM SH-080862ENG
(1D7MB2)
Manual Name Packaging Manual Number
(Model code)
GOT1000 Series Connection Manual (Mitsubishi Products) for GT Works3 Stored in DVD-ROM SH-080868ENG
(1D7MC2)
GOT1000 Series Connection Manual (Non-Mitsubishi Products 1) for GT Works3 Stored in DVD-ROM SH-080869ENG
(1D7MC3)
GOT1000 Series Connection Manual (Non-Mitsubishi Products 2) for GT Works3 Stored in DVD-ROM SH-080870ENG
(1D7MC4)
GOT1000 Series Connection Manual (Microcomputer, MODBUS Products, Peripherals) for GT
Works3 Stored in DVD-ROM SH-080871ENG
(1D7MC5)
Manual Name Packaging Manual Number
(Model code)
GOT1000 Series Gateway Functions Manual for GT Works3 Stored in DVD-ROM SH-080858ENG
(1D7MA7)
GOT1000 Series MES Interface Function Manual for GT Works3 Stored in DVD-ROM SH-080859ENG
(1D7MA8)
GOT1000 Series User's Manual (Extended Functions, Option Functions) for GT Works3 Stored in DVD-ROM SH-080863ENG
(1D7MB3)
Manual Name Packaging Manual Number
(Model code)
GT SoftGOT1000 Version3 Operating Manual for GT Works3 Stored in DVD-ROM SH-080860ENG
(1D7MA9)

A - 8
GT16 manuals
GT15 manuals
GT14 manuals
GT12 manuals
GT11 manuals
GT10 manuals
Manual Name Packaging Manual Number
(Model code)
GT16 User's Manual (Hardware) Stored in DVD-ROM SH-080928ENG
(1D7MD3)
GT16 User's Manual (Basic Utility) Stored in DVD-ROM SH-080929ENG
(1D7MD4)
GT16 Handy GOT User's Manual Stored in DVD-ROM
JY997D41201
JY997D41202
(09R821)
Manual Name Packaging Manual Number
(Model code)
GT15 User's Manual Stored in DVD-ROM SH-080528ENG
(1D7M23)
Manual Name Packaging Manual Number
(Model code)
GT14 User's Manual Stored in DVD-ROM JY997D44801
(09R823)
Manual Name Packaging Manual Number
(Model code)
GT12 User's Manual Stored in DVD-ROM SH-080977ENG
(1D7ME1)
Manual Name Packaging Manual Number
(Model code)
GT11 User's Manual Stored in DVD-ROM JY997D17501
(09R815)
GT11 Handy GOT User's Manual Stored in DVD-ROM
JY997D20101
JY997D20102
(09R817)
Manual Name Packaging Manual Number
(Model code)
GT10 User's Manual Stored in DVD-ROM JY997D24701
(09R819)