Page 1 Series MES Interface Function Manual for GT Works3...
Page 3: Safety Precautions
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"...
Page 4: Cautions For Use
CAUTIONS FOR USE Cautions on the system configuration (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...
Page 5: Table Of Contents
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 SAFETY PRECAUTIONS .........................A - 1 CAUTIONS FOR USE ..........................A - 2 INTRODUCTION ............................A - 3 CONTENTS ..............................A - 3 MANUALS..............................A - 7...
Page 6 4. SETTINGS AND PROCEDURES BEFORE USE OF THE MES INTERFACE FUNCTION Settings and Procedures before Use of the MES Interface Function ..........4 - 1 Installation and Uninstallation ......................4 - 3 5. MES INTERFACE FUNCTION DB Interface Function ........................5 - 1 5.1.1 DB interface function operation ....................
Page 7 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) ..............
Page 8 Appendix5 Application Example of MES Interface Function..............App - 13 INDEX REVISIONS A - 6...
Page 9: Manuals
MANUALS The following table lists the manual relevant to this product. Refer to each manual for any purpose.  Screen creation software manuals Manual Number Manual Name Packaging (Model code) GT Works3 Version1 Installation Procedure Manual Enclosed in product SH-080866ENG GT Designer3 Version1 Screen Design Manual (Fundamentals) 1/2, 2/2 Stored in DVD-ROM (1D7MB9)
Page 10  GT16 manuals Manual Number Manual Name Packaging (Model code) SH-080928ENG GT16 User's Manual (Hardware) Stored in DVD-ROM (1D7MD3) SH-080929ENG GT16 User's Manual (Basic Utility) Stored in DVD-ROM (1D7MD4) JY997D41201 GT16 Handy GOT User's Manual Stored in DVD-ROM JY997D41202 (09R821) ...
Page 11: Quick Reference
QUICK REFERENCE  Creating a project Obtaining the specifications and operation methods of GT Designer3 Setting available functions on GT Designer3 GT Designer3 Version1 Screen Design Manual (Fundamentals) 1/2, 2/2 Creating a screen displayed on the GOT Obtaining useful functions to increase efficiency of drawing Setting details for figures and objects GT Designer3 Version1 Screen Design Manual (Functions) Setting functions for the data collection or trigger action...
Page 12  Others Obtaining specifications (including part names, external dimensions, and • GT16 User's Manual (Hardware) options) of each GOT • GT16 Handy GOT User's Manual • GT15 User's Manual • GT14 User's Manual • GT12 User's Manual • GT11 User's Manual Installing the GOT •...
Page 13: Abbreviations And Generic Terms
ABBREVIATIONS AND GENERIC TERMS  Abbreviations and generic terms Description GT1695 GT1695M-X Abbreviation of GT1695M-XTBA, GT1695M-XTBD GT1685 GT1685M-S Abbreviation of GT1685M-STBA, GT1685M-STBD GT1675M-S Abbreviation of GT1675M-STBA, GT1675M-STBD GT1675 GT1675M-V Abbreviation of GT1675M-VTBA, GT1675M-VTBD GT1675-VN Abbreviation of GT1675-VNBA, GT1675-VNBD GT1672 GT1672-VN Abbreviation of GT1672-VNBA, GT1672-VNBD GT1665M-S Abbreviation of GT1665M-STBA, GT1665M-STBD...
Page 14 Abbreviations and generic terms Description GT16 Handy GT1665HS-V Abbreviation of GT1665HS-VTBD Handy GOT1000 GT11 GT1155HS-Q Abbreviation of GT1155HS-QSBD Series Handy GT1150HS-Q Abbreviation of GT1150HS-QLBD GT SoftGOT1000 Abbreviation of GT SoftGOT1000 GOT900 Series Abbreviation of GOT-A900 series, GOT-F900 series GOT800 Series Abbreviation of GOT-800 series ...
Page 15  Option Abbreviations and generic terms Description GT05-MEM-16MC, GT05-MEM-32MC, GT05-MEM-64MC, GT05-MEM-128MC, CF card GT05-MEM-256MC, GT05-MEM-512MC, GT05-MEM-1GC, GT05-MEM-2GC, Memory card GT05-MEM-4GC, GT05-MEM-8GC, GT05-MEM-16GC SD card L1MEM-2GBSD, L1MEM-4GBSD Memory card adaptor GT05-MEM-ADPC GT16-MESB, GT15-FNB, GT15-QFNB, GT15-QFNB16M, Option function board GT15-QFNB32M, GT15-QFNB48M, GT11-50FNB, GT15-MESB48M Battery GT15-BAT, GT11-50BAT GT16-90PSCB, GT16-90PSGB, GT16-90PSCW, GT16-90PSGW,...
Page 16  Software Abbreviations and generic terms Description GT Works3 Abbreviation of the SW DND-GTWK3-E and SW DND-GTWK3-EA GT Designer3 Abbreviation of screen drawing software GT Designer3 for GOT1000 series GT Simulator3 Abbreviation of screen simulator GT Simulator3 for GOT1000/GOT900 series GT SoftGOT1000 Abbreviation of monitoring software GT SoftGOT1000 GT Converter2...
Page 17 Abbreviation of Allen-Bradley products manufactured by Rockwell Automation, Inc. Abbreviation of GE Intelligent Platforms LS IS Abbreviation of LS Industrial Systems Co., Ltd. MITSUBISHI INDIA Mitsubishi Electric India Pvt. Ltd. SCHNEIDER Abbreviation of Schneider Electric SA SICK Abbreviation of SICK AG...
Page 18: How To Read This Manual
HOW TO READ THIS MANUAL The following symbols are used in this manual. Display reference ahead Display of chapter finding Referring ahead and the The chapter on the page which is the reference manual have opening in the index at the right of the been described by the page is understood at one view.
Page 19: Definitions And Descriptions Of Terms
DEFINITIONS AND DESCRIPTIONS OF TERMS The following table shows the definitions and descriptions of the terms used in this manual. Term Description   Tag for Wonderware Historian Name for data unit in the database Wonderware Historian. Abbreviation for Manufacturing Execution System The system that controls and monitors the plant status in real time to optimize production activities This enables speed-up of the responses to production plans and status changes and efficient production operation, optimizing the production activities.
Page 20 Term Description Standard time zone for each region of the world Each nation uses the time difference (within 12 hours) from the time at the Greenwich Observatory in the United Kingdom (GMT) as the standard time. The region using the same time difference is called a Time zone time zone.
Page 21: Overview
OVERVIEW The MES interface function allows SQL text transmission from a GOT to a database in the server computer connected via the Ethernet, enabling writing GOT's device values to the database and reading database values to set them to GOT's devices. This direct communication with the server computer eliminates the need for gateway equipment, realizing reduction in the maintenance cost and improvement in reliability.
Page 22: Features
1.1 Features This section explains the features of the MES interface function. (1) Simple setting enables connection to the information system without programming. Access to information system databases can be realized simply by making the necessary settings with the setting tool. Since there is no need to create programs for generating SQL texts, the engineering costs for system construction and the work period can be reduced.
Page 23 (2) Important data can be protected. (a) Buffering of send data (SQL text) during a communication error When an error occurs during communications with a database, the SQL texts failed to be sent can be buffered in the GOT. After recovery, the buffered SQL texts are automatically sent to the database. (Manual operation is also possible.) Disconnected Database...
Page 24 (b) Obtaining logs in the event of access errors After connection to a database, if a communication error occurs, the error details can be recorded as a log on the database side. Analyzing the log is useful for data protection and error analysis. Database DB connection service Access...
Page 25 (5) Various controller information can be stored and changed in the database. Controllers can be connected in a variety of topologies and their information can be stored into a database via GOT devices. Also, data read out from the database can be set to controllers as parameters via GOT devices. Inverter <MES interface function>...
Page 26: What Is The Mes Interface Function
1.2 What is the MES Interface Function? The items listed below are used with the MES interface function. For equipment required for the MES interface function, refer to the following: 2.3 Required Equipment, Software and Option OS Reference Item Description section Option OS (MES Interface) The option OS that runs on a GOT to realize the MES interface function.
Page 27: System Configuration
SYSTEM CONFIGURATION This chapter explains the system configuration available for the MES interface function. 2.1 System Configuration 2.1.1 Overall system configuration This section shows the overall system configuration when using the MES interface function. Oracle , SQL Server Database (Third party product) SNTP server computer* 1 Server computer DB Connection Service...
Page 28: System Configuration When Installing Software Used For The Mes Interface Function
2.1.2 System configuration when installing software used for the MES Interface Function The following shows system configuration when installing software used for the MES interface function. (1) When installing the DB Connection Service and DB Connection Service Setting Tool on a server computer Sever computer GT Works3...
Page 29: Connection Between Got And Controllers
2.2 Connection between GOT and Controllers 2.2.1 Connection type used for the MES Interface Function The following table shows the GOT supporting the MES interface function and availability in each connection type. For system configuration when using the MES interface function, refer to the following manual: GOT1000 Series Connection Manual for GT Works3 and a controller used : Applicable : Partly restricted...
Page 30 POINT POINT POINT Connection type examples for the case where the MES interface function cannot be used (Example 1) When using GT11 Because the Ethernet communication unit is not mountable, the MES interface function cannot be used. GT11 Ethernet communication unit (Example 2) When using GT15 Since the CC-Link communication unit (GT15-75J61BR13-Z) is not mountable concurrently together with the...
Page 31: Precautions For Inverter Or Servo Amplifier Connection
2.2.2 Precautions for inverter or servo amplifier connection In the inverter or servo amplifier connection, the status observation function or the script function must be used for device assignment. For the status observation function and the script function, refer to the following manual. GT Designer3 Version1 Screen Design Manual (Functions) The following are device assignment examples.
Page 32: Required Equipment, Software And Option Os
2.3 Required Equipment, Software and Option OS (1) Required equipment and software The following table lists the equipment and software required for use of the MES interface function. (a) GT16 Application Required equipment/software Module name Executing the MES interface function on the GOT Option function board GT16-MESB Connecting the GOT to Ethernet...
Page 33: Operating Environment
2.4 Operating Environment 2.4.1 Configuration computer The operating environment for the configuration computer is identical to those for GT Designer3. For the operating environment for GT Designer3, refer to the following manual. GT Designer3 Version1 Screen Design Manual (Fundamentals) 2.4.2 Server computer (SNTP server computer) This section explains the operating environment for the server computer.
Page 34 Item Description When using the DB interface function: Relational database (any of the following)  • Oracle  • Oracle  • Oracle  • Oracle  • Oracle   *2*6*7 • Microsoft SQL Server 2012   *2*6*7 •...
Page 35 Performance required for personal computer and operating system to be used Performance required for personal computer Operating system Required memory   Microsoft Windows XP Professional   Intel Pentium /Celeron series CPU 512 MB or more with clock speed of at least 300 MHz ...
Page 36 POINT POINT POINT How to set security authentication mode (SQL Server and Windows)     (1) For Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008, Microsoft  SQL Server 2005 and Microsoft SQL Server 2000. Set the security authentication mode in the SQL Server Properties (Configure) screen.
Page 37: Cautions On System Configuration
2.1 Cautions on System Configuration (1) 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) (2) Notes when CF card is used Insert the memory card into the A drive of the GOT.
Page 38 The CF card cannot be used in B drive. 2 - 12 2.1 Cautions on System Configuration...
Page 39: Specifications
SPECIFICATIONS This chapter explains the performance specifications, functions and devices of the MES interface function. 3.1 Performance Specifications The following are the performance specifications of the MES interface function. 3 - 1 3.1 Performance Specifications...
Page 40 Reference Item Specifications section No. of connected databases Up to 8 databases/project  • Oracle  • Oracle  • Oracle  • Oracle  • Oracle  • Microsoft SQL Server 2012  • Microsoft SQL Server 2008 R2 ...
Page 41 Reference Item Specifications section No. of tags Up to 64 tags/project Up to 256 tag components/tag No. of tag components Up to 4096 tag components/project 5 types (Signed single-precision integer type (16 bits), signed double-precision Device tag Data type integer type (32 bits), single-precision floating point type (32 bits), bit type, character string type) 6.5.3 Character string length...
Page 42: Got Devices Available For The Mes Interface Function
3.2 GOT Devices Available for the MES Interface Function The following are GOT devices that can be set in the Device tag settings of the MES interface function. Type Description Available setting range Bit register inside the GOT GOT bit register GB64 to GB65535 Can be used as a bit device.
Page 43: Function List And Setting Item List
3.3 Function List and Setting Item List This section provides the lists of the functions and setting items that can be set for the MES interface function. (1) MES interface function list Reference Function Description section DB interface function Executes communication with the database in units of jobs. Collects data in the internal devices or gateway devices of the GOT on the network in units of tags.
Page 44 (2) List of the MES interface setting items Reference Function Description section Device tag settings Configure the settings for the tag function. Configure this setting when writing multiple records extracted from a database to the same tag Array setting 6.5.2 component.
Page 45: Got Internal Device (Gs)
3.4 GOT Internal Device (GS) 3.4.1 GOT internal device list The list of the GOT internal devices (GS) used for the MES interface module is shown below. POINT POINT POINT (1) For details of any other GOT internal devices (GS) than the shown areas used for the MES interface function, refer to the following manual.
Page 46 (2) SNTP time query result (GS266 to GS272) When the "Synchronize using SNTP" box is checked in in the Option setting, the time information obtained from the SNTP server is stored. Name Description Setting side SNTP time query result (Year) The four-digit year data is stored.
Page 47: Settings And Procedures Before Use Of The Mes Interface
SETTINGS AND PROCEDURES BEFORE USE OF THE MES INTERFACE FUNCTION This chapter explains the procedures and settings to be done before use of the MES interface function. 4.1 Settings and Procedures before Use of the MES Interface Function The flowcharts for use of the MES interface function are shown here. POINT POINT POINT...
Page 48 Be sure to make the settings to use the DB interface function. 5.1 DB Interface Function Make the settings when using the program execution function. 5.1.9 Program execution function Make the settings when using the time on the SNTP server computer with the SNTP time synchronization function. 5.2 SNTP Time Synchronization Function Restart the personal computer after installing the relational database.
Page 49: Installation And Uninstallation
4.2 Installation and Uninstallation For how to install and uninstall each execution software for the MES interface function on the operating environment, refer to the following manual. GT Works3 Version1 Installation Procedure Manual 4 - 3 4.2 Installation and Uninstallation...
Page 50 4 - 4 4.2 Installation and Uninstallation...
Page 51: Mes Interface Function
MES INTERFACE FUNCTION The MES interface function can be used on the GOT by installing the option OS (MES Interface). This chapter describes the MES interface function. POINT POINT POINT The MES interface function settings are configured on the MES interface function setting screen of GT Designer3. 6.
Page 52: Job Execution Procedure
5.1.2 Job execution procedure The following is the job execution procedure. Start Stopped Is the GOT working? No job is executed during the stop. Working Activate the GOT. • 6.10.1 Checking the MES Interface Function status (Status) • 6.10.2 Manipulating the MES Interface Function status (Operation) Disabled Is the job enabled?
Page 53: Tag Function
(From the previous page) Executed in order Actions are executed. Up to 10 actions can set for a job, and they are executed in order. • 5.1.6 SQL text transmission (Communication action) • 5.1.7 Arithmetic processing function (Operation action) • 5.1.8 Resource data send function (Resource data send action) •...
Page 54: Trigger Monitoring Function
5.1.4 Trigger monitoring function The trigger monitoring function monitors values such as the time and tag values and, when the trigger condition changes from false to true (when the condition is met), starts a job. The following setting options are available as conditions for start. •...
Page 55 POINT POINT POINT In [Value monitoring startup], tag component values used for triggering monitoring and those used in the activated job are collected at different timings without synchronization. Tag 1 Sampling cycle: 1s Component name Value Component A Sampling time 10:08:30 Component B Tag 2 Sampling cycle: 60s Component name...
Page 56: Trigger Buffering Function
5.1.5 Trigger buffering function When too many trigger conditions (data transmission conditions) are met simultaneously, the trigger buffering function allows the system to buffer the data and time trigger conditions are met to the user area of the GOT. The action (operation and transmission of the data) for the buffered data is executed later.
Page 57 (b) When busy (Interval that trigger conditions are met is shorter than processing time of action) • Tag data and time that conditions are met are stored to the trigger buffer every time the conditions are met. • If an action cannot complete before another condition is met, up to 128 trigger data can be stored. [GOT] [When busy] Data...
Page 58 (2) Maximum times of trigger buffering (a) The trigger buffering function allows up to 128 trigger data (tag data and time) to be stored simultaneously. A job can be stored for unlimited number of times. (b) Check status of the trigger buffering in the following. Number of jobs in the trigger buffer (GS670) [MES Interface] - [Diagnostics] tab ( 6.10.6 Checking the trigger buffering (Trigger buffering status))
Page 59: Sql Text Transmission (Communication Action)
5.1.6 SQL text transmission (Communication action) The SQL text transmission function allows automatic creation of SQL texts, enabling communications with the database. The following three types of commands can be selected for the SQL text. • Select/MultiSelect • Update • Insert For the SQL text transmission setting, refer to the following: 6.8.1 Setting items in Communication action (1) Select/MultiSelect...
Page 60: Arithmetic Processing Function (Operation Action)
5.1.7 Arithmetic processing function (Operation action) The arithmetic processing function performs operations for tag component values. In this function, up to 20 dyadic operations can be processed per operation action. By storing an operation result in the temporary variable area, complicated operations are also executable. For the arithmetic processing function setting, refer to the following: 6.8.2 Setting items in Operation action An operand is selectable from...
Page 61: Resource Data Send Function (Resource Data Send Action)
5.1.8 Resource data send function (Resource data send action) The resource data send function allows the GOT to send resource data collected in a GOT buffering area and a CF card to a database. Device values for controllers, alarm data for the GOT, and others can be stored to the database without any communication programs.
Page 62 (b) Resource data to be sent 1) Settings on the resource data send action for the collected resource data The GOT sends the resource data before and after turning on the GOT. Specifying the number of resource data and the time of collecting the data or others are available. This setting allows the GOT to send resource data when the loads on the GOT and controllers are lower.
Page 63 2) Sending one resource data at the multiple resource data send actions When one resource data is sent at the multiple resource data send actions, the resource data is sent and stored to the database for each action. [Resource data] Data collected before turning on GOT Turning on GOT...
Page 64: Program Execution Function
5.1.9 Program execution function The program execution function is used for executing programs in the application server computer before execution of the first action and after execution of the last one in a job. For the program execution function setting, refer to the following: 6.7.3 Setting items in Program execution Programs that can be executed from [Command line] are applicable.
Page 65: Db Buffering Function
5.1.10 DB buffering function (1) DB buffering function The DB buffering function temporarily stores SQL texts into a CF card when they cannot be sent due to network disconnection or failure of the database server computer. After recovery, the buffered SQL texts are automatically sent to the database. (Manual operation is also possible.) Disconnected Database...
Page 66 (2) Factors for starting DB buffering The DB buffering is conducted when SQL texts cannot be sent to the database by the following factors: • Network disconnection • Failure of the database server computer • Failure of the database software POINT POINT POINT...
Page 67 (5) DB buffering operation (a) When no data are currently stored in the DB buffer Start Job execution starts when trigger conditions are met. 5.1.2 Job execution procedure Sent Were the SQL texts sent to the database? Sent to the database without being stored in the DB buffer.
Page 68 (b) When some data are currently stored in the DB buffer Start Job execution starts when trigger conditions are met. Section 5.1.2 Job execution procedure Is "Manual resend" selected for the job? Section 6.7.4 Setting items in DB Buffering Sent Were the SQL texts sent to the database? (c) Automatically resending data...
Page 69 (c) Automatically resending data after recovery Start Execution of the job with Auto resend setting is started. The job with Auto resend setting is sent to the database without being buffered. In the order of storing the jobs data in the DB buffer, the accumulated data of the jobs with Auto resend setting are sent again.
Page 70 (d) Manually resending data Start Execute manual resend of the DB buffer data. After line recovery, retry the manual resend of DB buffer Request for resend on [MES interface setting] - [Diagnosis] data. Request for resend on [Resend DB buffer request] of the specified tag component •...
Page 71 POINT POINT POINT If any of the jobs for which manual resend is selected exists in the DB buffer, it remains there after recovery until manual resend is executed. (6) Clearing the DB buffer The DB buffer is cleared by the following: •...
Page 72 (b) When manual resend is selected for the job If SQL texts cannot be sent to the database due to network disconnection or failure of the database server computer or database software, the system starts DB buffering after detection of a timeout. After started, DB buffering is performed without checking whether SQL texts can be sent to the database or not for each job activation.
Page 73: Sntp Time Synchronization Function
5.2 SNTP Time Synchronization Function The SNTP time synchronization function allows the time on the GOT to be synchronized with the time on the SNTP server computer on the network. Time information is utilized for job start conditions or in send data to the database. For the SNTP time synchronization function setting, refer to the following.
Page 74: Precautions
5.3 Precautions (1) Operation behavior of jobs (a) When a trigger condition for a job is met again during execution of the job 1) Jobs for which [Trigger buffering] is disabled A new job is not executed during execution of the previous job. (Example) When a trigger condition for a job is met again during execution of the job set to [Value monitoring startup]...
Page 75 (c) When actions are set for a job When actions are set for a job, if a communication error occurs, a timeout time will be generated. In the case of multiple action settings, timeout time is generated for each action. For the timeout time, refer to the following.
Page 76 (2) When an error occurs in job execution (a) The job execution is canceled when the error cause is the following: • Failure in device data writing due to network disconnection within the PLC system • Failure in device data writing, or operation error •...
Page 77: Mes Interface Function Setting
MES INTERFACE FUNCTION SETTING This chapter explains the setting of the MES interface function. 6.1 MES Interface Function Setting Screen The MES interface function setting screen is a screen for configuring various settings required for the MES interface function. In addition, the operation status of the MES interface function and the working log can be checked, and other operations such as stop/restart of the MES interface function can be also performed.
Page 78: Screen Structure
6.3 Screen Structure This section explains the structure of the MES interface function setting screen. 6.3.1 Screen structure Title bar Edit items tree 6.3.2 Operations using the Edit items tree Detailed setting edit screen POINT POINT POINT (1) Display on the title bar On the title bar, the status of connection to the GOT is displayed.
Page 79: Operations Using The Edit Items Tree
6.3.2 Operations using the Edit items tree The Edit items tree shows overall MES interface function settings in a tree. This section explains the operations using the Edit items tree. Project root Item Setting type (1) Selecting an item When double-clicking the project root or each setting type, some items are displayed. Selecting one of the items displays the corresponding edit screen on the detailed setting edit screen area.
Page 80 (4) Replicating an item Select an item to be copied, right-click it to display the menu. Selecting [Copy & Paste] replicates the item. When the item is added properly, it is automatically selected and the edit screen is switched to the one for the added item.
Page 81: Setting
6.4 Setting Configure the settings for the MES interface function. Click the "Setting" tab. The "Setting" sheet is displayed on the detailed setting edit screen. For each of the setting items, refer to the section shown below. Reference Item Description section Device tag settings Configure the settings for the tag function.
Page 82: Device Tag Settings
6.5 Device Tag Settings Configure the settings for the tag function. For the tag function, refer to the following: 5.1.3 Tag function Configured tags are used in [Job settings], etc. Double-clicking [Device tag settings] in the Edit items tree displays relevant items. Selecting one of the items displays the corresponding edit screen on the detailed setting edit screen area.
Page 83: Setting Items In Device Tag Settings
6.5.1 Setting items in Device tag settings Up to 64 items can be set in [Device tag settings] within one project. Item Description Device tag name Enter a device tag name. (Up to 16 characters) Set whether to periodically sample the tag or not. Sampling setting Set a sampling interval to sample the tag.
Page 84 POINT POINT POINT (1) The GOT becomes less busy if [Do not sample] is selected for the following tags. • Tags only for writing • Tags for sampling device values with the handshake operation. For the handshake operation, refer to the following: 6.7.2 (8) Handshake operation (2) When [Do not sample] is selected, the setting items for reading tags cannot be selected for the tag.
Page 85: Setting Items In Array Setting
6.5.2 Setting items in Array setting An array is a data format, in which the specified number of data of the same data type are arranged sequentially. The Array setting is set when writing multiple records extracted from a database to the same tag component. Either of the following can be selected for device assignment to each tag component.
Page 86 (b) Block Devices of all tag components are arranged as a block. The size of the block can be changed in [array block size]. For [array block size], refer to the following. 6.5.3 Setting items in Component setting Usually, the block size need not be changed because it is automatically adjusted to avoid device duplication.
Page 87: Setting Items In Component Setting
6.5.3 Setting items in Component setting Configure the settings for assigning GOT devices to tags. Up to 256 components can be set for one tag. Up to 4096 components can be set for one project. (Adding a component) • Set required items in [Component setting input], and click the button.
Page 88 Item Description Component name Enter a component name. (Up to 16 characters) Head device Set device name. Component Data type Select the data type of the sampling data. setting input Character string length Set a character string length when [String] is selected for [Data type].(1 to 32 characters) Perform statistical Set whether to perform statistical processing or not.
Page 89 (1) Component name (Up to 16 characters) Enter a component name. For characters that can be used for component names, refer to the following: Appendix.1.2 Characters applicable to item names, component names, variable names, etc. (2) Device • Set a device type and an actual device number. •...
Page 90 (5) Perform statistical processing (a) Set whether to perform statistical processing or not. Up to 64 components that have [Perform statistical processing] setting can be set in all projects. (Check [No. of statistical processings in project] on the status bar.) When the [Perform statistical processing] box is checked, statistical processing is performed for tag component values.
Page 91 2) No. of samples (2 to 20) Specify the number of samples when [Moving average], [Moving maximum], or [Moving minimum] is selected. (Moving average when [No. of samples] is 4) Device value Sampling interval 10) 11) Tag component value Moving average Time (seconds) <Change in tag component values>...
Page 92 (7) Array block size When [block] is selected in [Array setting], [array block size] setting is available. Usually, the block size need not be changed because the it is automatically adjusted to avoid duplication of components. Change [array block size] when: •...
Page 93: Server Service Settings
6.6 Server Service Settings Configure the settings for the access to a server computer. The set server service name is used in [Job setting]. Double-clicking [Server Service setting] in the Edit items tree displays relevant items. Selecting one of the items displays the corresponding edit screen on the detailed setting edit screen area. Make the setting referring to the following descriptions.
Page 94: Setting Items In Server Service Settings
6.6.1 Setting items in Server service settings Up to 8 items can be set in [Server service settings] within one project. Item Description Sever service name Enter a server service name. (Up to 16 characters) Server type Select the server type of the server computer to be accessed. IP address Enter a decimal IP address of the server computer where DB Connection Service is installed.
Page 95 (1) Server service name (Up to 16 characters) Enter a server service name. The set server service name is used in [Job setting]. For characters that can be used for server service names, refer to the following: Appendix.1.2 Characters applicable to item names, component names, variable names, etc. Note that using the name same as the one of the device tags set in [Device tag settings] is not allowed.
Page 96 (7) Access error notification setting (a) [Notify the access error status.] Set whether to enable or disable notification of the access error status. If the [Notify the access error status.] box is checked, an error occurred in access to the server computer is reported to a tag component.
Page 97: Job Settings
6.7 Job Settings Configure the settings for the DB interface function. For the DB interface function, refer to the following: 5.1 DB Interface Function Double-clicking [Job settings] in the Edit items tree displays relevant items. Selecting one of the items displays the corresponding edit screen on the detailed setting edit screen area. Make the setting referring to the following descriptions.
Page 98: Setting Items In Job Settings
6.7.1 Setting items in Job settings Up to 64 items can be set in [Job settings] within one project. For job operations, refer to the following: 5.3 Precautions Item Description Job name Enter a job name. (Up to 16 characters) GOT Initializing Set whether to enable the job at startup of the GOT or not.
Page 99 (1) Job name (Up to 16 characters) Enter a job name. For characters that can be used for job names, refer to the following: Appendix.1.2 Characters applicable to item names, component names, variable names, etc. (2) GOT Initializing (a) Set whether to enable the job at startup of the GOT or not. If the [GOT Initializing] box is not checked, the job is disabled at startup of the GOT.
Page 100 (5) Test mode (a) Set whether to operate the job in test mode or not. Up to 4 jobs can be set to [Test mode]. When the [Test mode] box is checked, the test mode is activated, and execution details of the job can be confirmed before operation.
Page 101: Setting Items In Trigger Conditions
6.7.2 Setting items in Trigger conditions Configure the settings for startup conditions of the job. The job is activated when the trigger condition value is changed from false to true. At the time of power-up, at restart of the MES interface function, or at the end of one-shot execution, all the conditions are initialized to false, and the job is started up when the initial condition is true.
Page 102 (1) Combination (a) Selects a combination of [Trigger 1] and [Trigger 2]. • OR (When either of them is true, the result is true.) • AND (When both of them are true, the result is true.) When the combination result of [Trigger 1] and [Trigger 2] is changed from false to true, the job is activated. (b) The following shows the timings at which the combination result of [Trigger 1] and [Trigger 2] is changed from false to true.
Page 103 (2) Trigger 1, Trigger 2 Select items for [Trigger 1] and [Trigger 2], referring to this section (3) and subsequent descriptions. Item Description Trigger 1 Trigger 2 No trigger conditions Disable This section (3) Disable When the specified date, time and day of the week match the actual date, time and day of the week, the condition changes from Time specification startup false to true, resulting in job startup.
Page 104 (4) Time specification startup (a) When the specified date, time and day of the week match the actual date, time and day of the week, the condition changes from false to true, resulting in job startup. (b) When [Time specification startup] is selected, the date, time, and day of the week must be set. 1) Year, Month, Day, Hour, and Minute Directly enter the date and time.
Page 105 (5) Specified time period startup (a) The condition is alternated between true and false in the specified cycles (unit: seconds), and when it changes from false to true, the job is activated. (b) When [Specified time period startup] is selected, set the cycle. (Range: 1 to 32767 seconds) (Example) The following shows that the job is activated at 60-second intervals for an hour from 12:00 to 13:00 every...
Page 106 (b) When [Value monitoring startup] is selected, specify conditions for comparison. 1) Tag, Component Select a tag component to be compared with. Tags that have a tag component with [Array setting] cannot be selected. 2) Condition Select a condition for comparison. Item Description The tag component value is equal to the condition value.
Page 107 (Example) To activate the job repeatedly while the condition of [Value monitoring startup] is met, Make settings as follows: Item Description Combination AND (When both of them are true, the result is true.) Trigger 1, Trigger 2 [Value monitoring startup], [Specified time period startup] As the condition alternates between true and false as shown below, job startup can be repeated while the [Value monitoring startup] condition is met.
Page 108 (8) Handshake operation (a) The job is activated when [Handshake startup] of the GOT turns ON. Upon completion of the job execution, [Completion notification] of the GOT turns ON. [Handshake operation] is a startup method by which completion of job execution can be notified to a GOT. Sampling interval Handshake operation started [Handshake startup]...
Page 109: Setting Items In Program Execution
6.7.3 Setting items in Program execution Configure the settings for the program execution function. For the program execution function, refer to the following: 5.1.9 Program execution function Click the button of [Before actions] or [After actions]. Setting • Before actions: Set a program to be performed before execution of the first action of the job.
Page 110 Item Description Execute program before (after) action Set whether or not to enable program execution before or after execution of actions. Program execution destination Select an application server to be accessed. Enter a command line for the program that is executed on the application server computer. (Up to Command line 127 characters) Check return value...
Page 111 (4) Check return value (a) Set whether to check the return value or not. When the [Check return value] box is checked, the return value (End code) of the executed program is checked. If no return value is returned within the [DB access timeout] time set in DB Connection Service Setting Tool, a timeout error is detected and the job execution is canceled.
Page 112: Setting Items In Db Buffering
6.7.4 Setting items in DB Buffering Set whether to utilize the DB buffering function or not. For the DB buffering function, refer to the following: 5.1.10 DB buffering function Item Description Enable DB buffering Set whether to enable the DB buffering or not. Set whether or not to automatically resend data after recovery.
Page 113: One-Shot Execution
6.7.6 One-shot execution Execute a job as a one-shot task. Doing so allows the user to check the execution result of the currently editing [Job setting]. (1) Procedure for one-shot execution POINT POINT POINT • In [One-shot execution], settings of [Startup logging] and [DB Buffering] are not executed. •...
Page 114: Job Settings - Actions
6.8 Job Settings - Actions The following shows types of actions. Up to 10 actions can be set for one job. • [Communication action] For communicating the GOT with a database • [Operation action] For operating tag component values • [Transmit resource action] For sending the resource data to the database (Adding an action) •...
Page 115 (Copying an action of another job within the project) Select [Replicate actions of other jobs] in the list box next to the button, and click the button. The [Replicate actions] dialog box is displayed. By repeating the following steps , set copy targets in [Selected Actions to replicate]. From [Source Jobs], select a job that includes a desired action.
Page 116 Item Description Type The types of the existing actions are displayed. Summary Details of the existing actions are displayed. Selecting an action in [Action list] and clicking the button reverses the order between the selected one and the one immediately above it. button button cannot be clicked on the first action.
Page 117 (2) Summary Details of the existing actions are displayed. (a) In the case of [Communication action] Item Description [Database: Table name]{DB-tag link setting No.1}...{DB-tag link setting No.n} Display format • Select: {DB-tag link setting} = {Field name -> Tag component/Constant value} •...
Page 118: Setting Items In Communication Action
6.8.1 Setting items in Communication action Configure the settings for communications with a database. Performing the operation for adding or modifying an action displays the [Communication action] dialog box. Make the setting referring to the following descriptions. Clicking the button after setting adds or modifies the action. For the operation for adding or modifying an action, refer to the following: 6.8 Job Settings - Actions Item...
Page 119 Item Description Generated SQL text Displays SQL text that is generated in the currently editing [Communication action]. No. of fields in project Displays the total number of fields in the project. Tag component data length in job Displays the total data length of the tag components in the job. Selecting a row and clicking the button reverses the order between the selected row and the one immediately above it.
Page 120 (a) When [Select] is selected for [Action type] [Select] substitutes a field value of the record, whose conditions are met, for a substitute value (tag component value/variable). Set conditions of the record to be selected in [Select/Update conditions]. This section (5) Select/Update conditions Conditions for sorting the selected records are set in [Select sort settings].
Page 121 (b) When [Update] is selected for [Action type] [Update] substitutes a substitute value (tag component value/variable) for a field value of the record whose conditions are met. Set conditions of the record to be updated in [Select/Update conditions]. This section (5) Select/Update conditions 1) Field name (1 to 32 characters) Set a field name for the field value to be updated.
Page 122 (c) When [Insert] is selected for [Action type] [Insert] generates a new record, and inserts an insert value (tag component value/constant value/variable) into a field of the generated record. 1) Field name (1 to 32 characters) Set a field name for the field value to be inserted. For characters that can be used for field names, refer to the following: Appendix.1.4 Characters applicable to field names, table names, etc.
Page 123  4) When the database is Wonderware Historian, the following is inserted as one record to the database by executing [Communication action]. • Date and time when a communication action is executed • Tag name set for [Field name] • Tag component value or constant value set for [Component] When multiple fields are set, the number of records to be inserted is equivalent to that of fields.
Page 124 POINT POINT POINT When [MultiSelect] is used in a job, the total of [Tag component data length in job] must be 45000 words or less. [Tag component data length in job] represents a total length of the tag component data set for the following: •...
Page 125 Database: DB1, Table name: RECIPEDATA RECIPE_A RECIPE_B RECIPE_C Work_No Select-sorted Matched Selected Selected (Ascending) (RECIPE_C=1) Tag component Process1.Work_No[1] Process1.RECIPE_A[1] Process1.RECIPE_B[1] Process1.RECIPE_C[1] Process1.Work_No[2] Process1.RECIPE_A[2] Process1.RECIPE_B[2] Process1.RECIPE_C[2] Process1.Work_No[3] Process1.RECIPE_A[3] Process1.RECIPE_B[3] Process1.RECIPE_C[3] 6 - 49 6.8 Job Settings - Actions...
Page 126 (e) About tag components Tag component values can be used as substitute/insert values for [Select], [Update], [Insert] or [MultiSelect], or as condition values of [Select/Update conditions]. The following table lists data types of tag components and those of assignable fields. If the data type of a tag component does not match the one of its substitution target field, an error occurs, resulting in cancellation of job execution.
Page 127 About constants Constants can be used as substitute/insert values for [Update] or [Insert], or as condition values of [Select/ Update conditions]. The following table lists constant types and the data types of assignable fields. If the type of a constant does not match the data type of its substitution target field, an error occurs, resulting in cancellation of job execution.
Page 128 (g) About variables Variables can be used as substitute/insert values for [Select], [Update] or [Insert], or as condition values of [Select/Update conditions]. The following table lists data types of variables and those of assignable fields. If the type of a variable does not match the data type of its substitution target field, an error occurs, resulting in cancellation of job execution.
Page 129 (5) Select/Update conditions When [Select], [Update] or [MultiSelect] is selected for [Action type], set conditions for the records to be selected, updated or multi-selected. When a field value of a record matches a condition value, the record is selected or updated. Up to 8 rows can be set for one communication action in [Select/Update conditions].
Page 130 (e) Component Select or directly enter a component/constant value that is used as a condition for comparison. If [Variable] is selected for [Tag], select or directly enter a variable. POINT POINT POINT For tag components, constants or variables, refer to the following: This section (4) (e) About tag components •...
Page 131 (b) Order Set the order of sorting the selected records. Item Description Ascending order Sorts the records so that the specified fields are arranged in ascending order. Descending order Sorts the records so that the specified fields are arranged in descending order. Database (before sorting) ORDER_NO PRODUCT_CODE...
Page 132 (7) Exception processing setting A click on the button displays the [Exception process setting] dialog box. Exception process setting (Example) When [Select] is selected for [Action type] (a) Exception processing: No applicable record When [Select], [Update] or [MultiSelect] is selected for [Action type], set processing for the case where there is no record to be selected, updated or multi-selected.
Page 133 POINT POINT POINT (1) When a job is forcibly terminated, an error occurred during job execution (job cancellation) is not notified. 6.7.5 Notify errors (job cancellation) that occur during job execution (2) If [Enable DB buffering] is selected for a job, its exception processing setting is disabled. 6.7.4 Setting items in DB Buffering (b) Exception processing: Multiple applicable records When [Select] or [Update] is selected for [Action type], set processing for the case where there are multiple...
Page 134 POINT POINT POINT (1) When a job is forcibly terminated, an error occurred during job execution (job cancellation) is not notified. 6.7.5 Notify errors (job cancellation) that occur during job execution (2) If [Enable DB buffering] is selected for a job, its exception processing setting is disabled. 6.7.4 Setting items in DB Buffering (c) Exception processing: Applicable records overflow When [MultiSelect] is selected for [Action type], set processing for the case where the number of records to...
Page 135 2) Send notification of this exception If the [Send notification of this exception] checkbox is checked, a value is assigned to the specified tag component when the number of records selected by [Select/Update conditions] is greater than the number of arrays set in [Array setting]. [Array setting] is less than the number of records selected by [Select/Update conditions].
Page 136 (8) Multi select setting A click on the Multi select setting button displays the [Multi select setting] dialog box. Complete the setting, referring to the following explanation. (a) Specify the maximum number of acquiring records If the [Specify the maximum number of acquiring records] checkbox is checked, records of up to the specified number are acquired.
Page 137 (c) Clear the unused tag components by zero When the [Clear the unused tag components by zero] checkbox is checked, if the specified number of arrays of the tag component is less than the number of actually acquired records, zeros are assigned to other array areas.
Page 138: Setting Items In Operation Action
6.8.2 Setting items in Operation action Configure the settings for operation of tag component values. Up to 20 dyadic operations can be set for one operation action. Performing the operation for adding or modifying an action displays the [Operation action] dialog box. Make the setting referring to the following descriptions.
Page 139 (1) About constants Constants can be used for [Operation tag] - [Component] and not for [Operator]. The following shows the constant types and values that can be entered in the [Component] column. Constant type Values that can be entered in [Component] Up to 16 characters [Number] •...
Page 140 (3) Setting example of [Operation action] The following is a case in which correction power is calculated using a correction voltage and it is assigned to a tag component (Process 1.Correction power). The tag component value (Process 1.Correction power) obtained from the following [Operation action] is: (Process 1.Voltage 100 + 50) Currrent...
Page 141: Setting Items In Transmit Resource Action
6.8.3 Setting items in Transmit resource action Configure the settings for sending the resource data collected in a GOT to a database. POINT POINT POINT Before setting [Transmit resource action], configure the settings to collect the resource data (the logging setting, the advanced user alarm observation, the advanced system alarm observation, and the operation log setting).
Page 142 (1) Action type Select an action type. The selectable action type is the insert only. Item Description Insert Generates a new record, and assigns a value (resource data) into a field. (2) Database Select a database to be accessed. (3) Table name (1 to 32 characters) Set a table name of the database to be accessed.
Page 143 (5) Field name setting Set the assignments between the resource data to be sent and the field values for the database. The resource data types vary according to [Resource type]. (Example) Screen for settings of sending logging data Item Description 1) First row (comment) A field name for sending a comment to the database can be set.
Page 144 The following shows the resource data to be sent and the types of the data. (a) When selecting [Logging] for [Resource type] Insert data Data type Logging time Date Numeric type (Integer, floating point) LoggingDevice (1 to 250) The numbers of 1 to 250 correspond to the rows set for the number of the block number in the logging setting. (b) When selecting [Advanced user alarm] for [Resource type] Insert data Data type...
Page 145 POINT POINT POINT Up to 512 of one-byte and two-byte characters can be set in a comment for the advanced user alarm. Set the length of character string on the database more than that for the comment. (c) When selecting [Advanced system alarm] for [Resource type] Insert data Data type Alarm time...
Page 146 (d) When selecting [Operation Log] for [Resource type] Data type Insert data Logging time(DATE) Date Log No.(NO) Numeric type (Integer) Screen No.(SCRN_NO) Character string Action type(ACT_ABBR) Character string Action type(ACTION) Character string Object name(OPNAME) Character string Operation level(OPERATOR) Character string Operation level(OPE_ID) Numeric type (Integer) User ID(USER_ID)
Page 147 (e) Data types The following table shows the data types of resource data and the data types of data to be sent in the field. When the data type of the resource data does not match that of data to be sent in the field, an error occurs, resulting in the cancellation of the job execution.
Page 148 (7) Operation log file The GOT displays the operation log file when [Operation log] is selected for [Resource type] only. Clicking the button displays the stored location for the operation log file. Set operation log file name The GOT can send the displayed operation log file to the database. Inputting the data directly to [Drive Name], [Folder Name], and [File Name] are not available.
Page 149 *1 Resource data to be sent after changing the GOT time and date When changing the GOT time, the resource data to be sent may differ from the resource data to be sent without changing the GOT time. The following shows the resource data to be sent after changing the GOT time and date. (1) Logging data (a) Executing the next action before the time of the last action Example 1) Changing the time from 11:40 to 11:10, and executing the next action at 11:20...
Page 150 (2) Advanced user alarm data/advanced system alarm data (a) Executing the next action before the time of the last action (The GOT does not send all the data collected after the last acton.) Example 1) Changing the time from 11:40 to 11:00, and executing the next action at 11:20 : Time specified (300 seconds) GOT time Sending resource data...
Page 151 Example 2) Changing the time from 0:40 to 0:10 on the same day, and executing the next action at 0:20 : Days specified (1 day) GOT time Sending resource data <Resource data to be sent for the last action> Changing date (last action) A:Data collected for the specified day (1 day) 0:30...
Page 152 POINT POINT POINT (1) The GOT sends the resource data only one time, regardless of the settings for [Range of data]. The GOT does not send the sent data to the database. The GOT may send the sent data when restarting the GOT for downloading the project data and others. 6.12 Precautions (2) When an action fails due to the communication error between the GOT and the server computer or others, the GOT sends the failed action data at the next action.
Page 153 (9) Generated SQL text The SQL (INSERT) text generated by the currently editing data for [Transmit resource action] is displayed. The SQL text shows the display type for the resource data, the character string, and the date. The GOT does not send the resource data without setting the field name for [Field name setting]. The data with no field name are not included in the SQL text.
Page 154: Option Setting
6.9 Option Setting Configure the SNTP time synchronization setting and the DB buffering function setting. Click [Option setting] in the Edit items tree. The "option setting" area is displayed on the detailed setting edit screen. Make the setting referring to the following descriptions. 6 - 78 6.9 Option Setting...
Page 155: Setting Items In Sntp Time Synchronization Setting
6.9.1 Setting items in SNTP time synchronization setting Configure the settings for the SNTP time synchronization function. Time is obtained from the SNTP server computer on the network and used on the GOT. POINT POINT POINT To synchronize the time between the GOT and other devices on the network, using the time on the SNTP server computer is recommended.
Page 156 (2) When time information is not obtainable from the SNTP server computer When the GOT cannot obtain time information from the SNTP server computer due to failure of the network or time synchronization server, it behaves as follows: (a) When time information is not obtained at the time of powering ON the GOT from OFF, or resetting the GOT 1) Time synchronization is not performed.
Page 157: Setting Items In Db Buffering Settings
6.9.2 Setting items in DB buffering settings Configure the settings for the DB buffering function. For the DB buffering function, refer to the following: 5.1.10 DB buffering function (1) DB buffering capacity (Range: 16MB to 512MB, Default: 64MB) Set the capacity used for DB buffering out of the entire CF card capacity within the following range. Maximum capacity = CF card capacity - 32M bytes (2) DB buffering status (a) Select a tag component into whose device whether data are currently accumulated in the DB buffer or not...
Page 158 (4) Resend DB buffer request (a) Select a tag component used to request for resend processing of the DB buffer. Tags that have a tag component with [Array setting] cannot be selected. (b) The following explains the operation of the resend processing using [Resend DB buffer request]. Data type of tag component Description The resend processing of the DB buffer is performed when the specified tag component is ON.
Page 159 (5) Clear DB buffer request (a) Select a tag component used to request for clear processing of the DB buffer. Tags that have a tag component with [Array setting] cannot be selected. (b) The following explains the operation of the clear processing using [Clear DB buffer request]. Data type of tag component Description The clear processing of the DB buffer is performed when the specified tag component is ON.
Page 160 (7) DB buffer utilization (a) Select a tag component into whose device the utilization of the DB buffer area (unit: %) is stored. Tags that have a tag component with [Array setting] cannot be selected. (b) Data are stored as follows depending on the data type. Data type of tag component Description OFF : Not accumulated...
Page 161: Diagnosis
6.10 Diagnosis Perform the remote diagnosis for the MES interface function. Click the [Diagnosis] tab. The [Diagnosis] sheet is displayed. Operate it referring to the following descriptions. 6 - 85 6.10 Diagnosis...
Page 162: Checking The Mes Interface Function Status (Status)
6.10.1 Checking the MES Interface Function status (Status) The operation status of the MES interface function can be checked. The following explains the display of [Status]. The display of [Status] is updated every 3 seconds. Display Description Running The MES interface function is working normally. The MES interface function is stopped.
Page 163: Manipulating The Mes Interface Function Status (Operation)
6.10.2 Manipulating the MES Interface Function status (Operation) The operation status of the MES interface function can be manipulated. (1) Stop Selecting the [Stop] radio button and clicking the button stops the operation of the MES interface Execute function. POINT POINT POINT If a job is in execution, the MES interface function will stop upon completion of the job.
Page 164: Changing The Job Status (Change Job Status)
6.10.3 Changing the job status (Change job status) The job status can be changed. POINT POINT POINT The job status changed by this operation returns to the status set in [Job settings] by powering OFF and ON or resetting the GOT. From [Job list], select the job whose status is to be changed.
Page 165: Checking The Connection Of The Previous Job Execution (Connection Result Of Previous Job Execution)
The startup log can be confirmed in [Job Execute Log] on the [Working log] tab. 6.11.2 Job Execute Log [Enable detailed logging] is selectable only when [Test mode] is selected in [Job settings]. 6.7.1 (5) Test mode When [Enable detailed logging] is checked, [Enable startup logging] is also selected. The detailed log can be confirmed in [Job Execute Log] on the [Working log] tab.
Page 166: Manipulating Db Buffering (Db Buffering Operation)
6.10.5 Manipulating DB buffering (DB buffering operation) Operate the DB buffering. For the DB buffering function, refer to the following: 5.1.10 DB buffering function (1) Number of bufferings and Buffer utilization This section explains checking the number of data buffered, the current buffer utilizations, and the highest buffer utilizations of the DB buffering function.
Page 167: Checking The Trigger Buffering (Trigger Buffering Status)
6.10.6 Checking the trigger buffering (Trigger buffering status) This section explains checking the number of data buffered, the current buffer utilizations, and the highest buffer utilizations of the trigger buffering function. For the trigger buffering function, refer to the following: 5.1.5 Trigger buffering function Description Display...
Page 168: Working Log
6.11 Working Log The operation log of the MES interface function can be checked. In [Working log], the MES interface Execute Log and the Job Execute Log of the GOT can be checked. Click the [Working log] tab. The [Working log] sheet is displayed. Click the button.
Page 169: Mes Interface Execute Log
6.11.1 MES Interface Execute Log (1) The MES interface function execution log is displayed. Data displayed in the MES Interface Execute Log are shown below. Item Description Date Displays the date and time on which an error occurred. Displays an error code of the error occurred. For error codes, refer to the following: Error code 8.1 Error Handling and Recovery Method...
Page 170: Job Execute Log
6.11.2 Job Execute Log This area displays event log data of the jobs whose executions have been completed. There are two kinds of Job Execute Log data: [Startup log] and [Detailed log], by which the job startup history and job execution details can be checked respectively.
Page 171 (2) Detailed log Detailed log data of the jobs, each of which has [Test mode] setting in [Job settings], are displayed. 6.7.1 (5) Test mode POINT POINT POINT Do not remove the CF card from the GOT during detailed log output. Selecting a job of icon and clicking the button displays the [View details] dialog...
Page 172 In the case of Communication action Display Description Displays data of [Action type], [Database], and [Table name], which were set in Type, Database, Table name [Communication action]. Displays the number of records specified for [Specify the maximum number of Request record No. acquiring records] in the Multi select setting screen for the communication action.
Page 173 In the case of Transmit resource action Display Description Displays data of [Action type], [Database], and [Table name], which were set in Type, Database, Table name [Communication action]. Displays the execution result of the SQL text. • When succeeded Execution result [Success] is displayed.
Page 174: Precautions
6.12 Precautions Precautions for the MES interface function setting are described below. (1) When adding, editing or deleting a MES interface setting Adding a new MES interface setting, or editing or deleting an existing one is performed on the MES interface function setting screen.
Page 175 (b) Operation of numerical values There are two kinds of numerical values: Integer type and Floating-point type. • Integer type : Represents the bit type, single-precision type, and double-precision type of tag components. • Floating-point type : Represents the floating-point type of tag components. The following table lists operation items and types of the results.
Page 176 (b) Conditions for sending the sent resource data When restarting the GOT, the GOT may send the sent data. Multiple records are created in the database when the GOT sends the sent data. The following shows conditions for sending the sent resource data. Resource type Condition Logging...
Page 177: Db Connection Service And Setting Tool
DB CONNECTION SERVICE AND SETTING TOOL This chapter explains DB Connection Service and DB Connection Service Setting Tool. 7.1 DB Connection Service Functions Installing DB Connection Service on the server computer allows to use the MES interface function of the GOT. The following shows the functions of the DB Connection Service.
Page 178 (2) Program execution function The program execution function executes a program on an application server computer upon request from the GOT. The following shows operation on the application server computer. Application server computer Program DB Connection MES interface Service function When accessed Access...
Page 179: Setting Odbc Of Database
7.2 Setting ODBC of Database When using DB Connection Service on a database server computer, the ODBC setting for the database used must be done beforehand. For the ODBC setting, refer to the following. Manuals and online help for the database software and operating system (OS) used ...
Page 180 (From the previous page) Double-clicking [Administrative Tools] displays the [Administrative Tools] dialog box. Double-clicking [Data Sources (ODBC)] displays the [ODBC Data Source Administrator] dialog box. Select the [System DSN] tab, and click the button. The [Create New Data Source] dialog box is displayed.
Page 181 (From the previous page) Enter the user name and password, then click the button. If the connection is normal, the confirmation dialog box appears. Click the button in the [Oracle ODBC Driver Configuration] dialog box. Click the button in the [ODBC Data Source Administrator] dialog box.
Page 182    (2) For Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008,    Microsoft SQL Server 2005, Microsoft SQL Server 2000, MSDE 2000 and Wonderware Historian    (The following shows a setting example using Microsoft SQL Server 2000 with Microsoft Windows Professional Operating System.)
Page 183 (From the previous page) The [Create New Data Source] dialog box is displayed, then select [SQL Server]. The [Create a New Data Source to SQL Server] dialog box is displayed, then set the following. • [Data source name]:SAMPLEDS • [Server name]: SAMPLESRV Select the [With SQL Server authentication using a login ID and password entered by the user.] radio button, then enter [Login ID] and...
Page 184 (From the previous page) In the [ODBC Microsoft SQL Server Setup] dialog box, click the [Test Data Source] button to check that the connection is normal. Click the button in the [SQL Server ODBC Data Source Test] dialog box. Click the button in the [ODBC Microsoft SQL Server Setup] dialog box.
Page 185   (3) For Microsoft Access 2013/2010/2007/2003/2000    (The following shows a setting example using Microsoft Access 2003 with Microsoft Windows Professional Operating System.) Set the following conditions. • Data source name : SAMPLEDS • Database name : C \ mes \ sampledb.mdb Data source name can be set as desired.
Page 186 (From the previous page) The [Create New Data Source] dialog box is displayed, then select [Microsoft Access Driver(*.mdb)].   For Microsoft Access 2007/2010 Select "Microsoft Access Driver(*.mdb. *accdb)". The [ODBC Microsoft Access Setup] dialog box is displayed. Set the following and click the [Database] selection button.
Page 187: Starting Db Connection Service Setting Tool
7.3 Starting DB Connection Service Setting Tool POINT POINT POINT Only one DB Connection Service Setting Tool can be activated.      When Windows 8.1, Windows 8, Windows 7, or Windows Vista is used Select [Start] → [All Programs] → [MELSOFT Application] → [MES Interface] → [DB connection service setting tool].
Page 188: Screen Structure Of Db Connection Service Setting Tool
Reference Item Description section Product information Displays product information of the DB Connection Service Setting Tool. Connect to MELFANSweb Connects to the Mitsubishi Electric Factory Automation Global Website. 7 - 12 7.4 Screen Structure of DB Connection Service Setting Tool...
Page 189: Setting Items Of Db Connection Service Setting Tool
7.5 Setting Items of DB Connection Service Setting Tool The following shows how to change the DB Connection Service settings. Set the following items and click the button. Reflect settings After updating the settings, check for an error by selecting [Administrative Tools] - [Event Viewer] in Windows . 8.1 (2) Error checking procedure POINT POINT...
Page 190 (2) DB access timeout (required) (Range: 1 to 3600; Default: 30) Set a DB access timeout time (Unit: seconds) for writing/reading a database value from the GOT to the server computer, or for the case where no response is returned after request for program execution. When a timeout occurs, the connection with the GOT is disconnected and job execution is canceled.
Page 191 (Example) Specifying IP addresses in a batch If [192.168.0.64] is set for [IP address] and [26] for [Mask bit length], the IP addresses set for connection permission are [192.168.0.64] to [192.168.0.127], as the logical product is [192.168.0.64]. IP address permitted to connect 0 0 0 0 0 0 1 0...
Page 192 (Example) When [Output destination] is set as [dbConnector.log] and [Access capacity] as [1MB 3 files] Capacity over dbConnector.log dbConnector.log Files within the dbConnector.log.001 dbConnector.log.001 specified number of files dbConnector.log.002 dbConnector.log.002 When [dbConnector.log] exceeds 1M byte, it is renamed as [dbConnector.log.001]. A new [dbConnector.log] is created and logging resumes.
Page 193: Importing/Exporting Files
Importing/Exporting Files Import/export files. (1) Import An existing file can be imported. Select [File] [Import] from the menu. The [Open] dialog box is displayed. Set the following items, then click the button. Open Item Description Look in Select the location where the file is stored. File name Specify the name of the file to be imported.
Page 194: Help
7.7 Help The product information of the DB Connection Service Setting Tool and the Connect to Mitsubishi Electric Factory Automation Global Website screen can be displayed. (1) Product information Select [Help] [Product information] from the menu. The [Product information] dialog box of the DB Connection Service Setting Tool is displayed.
Page 195: Output Log Specifications
7.8 Output Log Specifications The following shows the output log format for the access log and SQL failure log given in Section 7.8.1 and later. [Date] [Error code] message Line feed Item Description First line 1st to 4th bytes from the line Year Four-digit integer for year (Numbers) head...
Page 196: Access Log
7.8.1 Access log The following explains the access log contents. (1) Service start/end (a) Start Item Description Output log format [Date] [Error code] Service Start Example 2005/07/01 12:00:00.000 0x00000000 Service Start (b) End Item Description Output log format [Date] [Error code] Service Stop Example 2005/07/01 12:00:00.000 0x00000000 Service Stop (2) Connection/disconnection from the GOT...
Page 197: Sql Failure Log
(c) INSERT Item Description Output log format [Date] [Error code] SID [Session ID]:SQL<[SQL text]>:[Processing result ]([No. of inserted records]) Example 2005/07/01 12:00:00.000 0x00000000 SID 0:SQL<INSERT INTO TABLE ( COL ) VALUES ('') ;>:Success(1) When succeeded: Success ([No. of inserted records]), when failed: Failed (Line feed) Database message (d) COMMIT Item Description...
Page 198 7 - 22 7.8 Output Log Specifications...
Page 199: Troubleshooting
TROUBLESHOOTING 8.1 Error Handling and Recovery Method This section describes how to check an error output when using the MES interface function. (1) Error checking and restoration The following lists the points to be checked when an error occurred, and corresponding recovery methods. Error type Check point Recovery method...
Page 200 (2) Error checking procedure For error codes, refer to the following: 8.2 Error Code List Item Checking procedure MES interface function Shows how to check an error occurred in execution of the MES interface function. execution error • For the system alarm checking procedure, refer to the following manual. System alarm checking procedure GT Designer3 Version1 Screen Design Manual (Functions)
Page 201: Mes Interface Function Setting
8.1.1 MES Interface Function setting This section explains troubleshooting information on the setting of the MES interface function. (1) Common to all settings Symptom Checked item Corrective action • Check that no other GT Designer3 is running and communicating on the same personal Is the GOT communicating with another GT computer.
Page 202 (3) [Job settings] ( 6.7 Job Settings) Symptom Checked item Corrective action • Do not use Select actions in the job where DB buffering is enabled. Unable to set [DB buffering setting]. Is there any Select action set for the job? •...
Page 203: When Using Db Connection Service Setting Tool
8.1.2 When using DB Connection Service Setting Tool This section explains troubleshooting information on the setting of DB Connection Service Setting Tool. 7. DB CONNECTION SERVICE AND SETTING TOOL Symptom Checked item Corrective action • Terminate the already started DB Connection Unable to start DB Connection Service Setting Has DB Connection Service Setting Tool been Service Setting Tool.
Page 204: Error Code List
8.2 Error Code List The error code list is shown below. For the error output checking method, refer to the following. 8.1 Error Handling and Recovery Method 8.2.1 Error log in the Working log Error code Error description and cause Corrective action •...
Page 205 Error code Error description and cause Corrective action • The DB buffer file is invalid. 0x41140087 DB buffer file error • The CF card may be corrupted. • Replace the CF card. • Data stored in the DB buffer are invalid. 0x41140089 DB buffer content error •...
Page 206 Error code Error description and cause Corrective action • The maximum number of obtained records is invalid. 0x411400E8 Invalid max number of select record. • Set the tag component value specified as the maximum number of records 1 or more. •...
Page 207 Error code Error description and cause Corrective action • An Ethernet communication error has occurred. • Check the Ethernet connection. 0x41151110 Message reception error • Check if [Server Service setting] are correct. 6.6 Server Service Settings • Check if the ODBC setting is correct. 7.2 Setting ODBC of Database •...
Page 208: Db Connection Service
8.2.2 DB Connection Service  The DB Connection Service outputs errors to the Windows Event Log, access log, and SQL failure log.   For Windows Vista , DB Connection Service Client also outputs errors to Windows Event Log.  (1) Event log of Windows (a) Event log output warning list of DB Connection Service (Source name: DBConnector) Warning event ID...
Page 209 Error event ID Error description and cause Corrective action The server port No. setting is not correct. The server port No. setting is out of range. The timeout time setting is not correct. The timeout time setting is out of range. There are too many connection-permitted IP address settings.
Page 210 Error event ID Error description and cause Corrective action • If no directory exists for storing the access log file, create it. • When the attribute of the access log file is set to read- only, cancel the setting. • If read/write is disabled for the access log file, enable it The access log file could not be opened.
Page 211 Error event ID Error description and cause Corrective action • When the disk space is full, ensure a free disk space. • When the SQL failure log file has been open in another The log could not be written to the SQL failure log file. application, terminate the application.
Page 212 (2) Access log of DB Connection Service Error code Error description and cause Corrective action (Service Not Start.) 0x20100001 Failed to start the service due to insufficient memory. • Terminate any unnecessary applications. • Add more memory to the personal computer. (Service Not Start.) 0x20100002 Failed to start the service due to insufficient resources.
Page 213 Error code Error description and cause Corrective action (SID [Session ID]: Response Transmit Error: [IP address]) 0x20310010 Failed to transmit a response due to disconnection. (SID [Session ID]: Response Transmit Error: [IP address]) 0x20310011 Timed out during response transmission. • Check if it is connected to the network. •...
Page 214 Error code Error description and cause Corrective action (SID [Session ID]: SQL<...>: Failed) (SID [Session ID]: COMMIT: Failed) (SID [Session ID]: ROLLBACK: Failed) 0x20600010 (SID [Session ID]: GetNext: Failed) (SID [Session ID]: Reset: Failed) Invalid SQL execution request • Check the source IP address setting. (SID [Session ID]: SQL<...>: Failed) •...
Page 215 Error code Error description and cause Corrective action • In [MES interface setting], set correct user name and password for the application server setting. 6.6 Server Service Settings • Check if the user account is invalid or not by  (ProgramExec: [IP address]: <...>: Failed) Administrative Tools of Windows 0x20700020...
Page 216 (3) SQL failure log of DB Connection Service Error code Error description and cause Corrective action 0x20600001 Failed in SQL execution due to insufficient memory. • Terminate any unnecessary applications. • Add more memory to the personal computer. 0x20600002 Failed in SQL execution due to insufficient resources. DB Connection Service does not support the SQL •...
Page 217: Appendices
APPENDICES Appendix1 Usable Characters and ASCII Code Tables by Setting Items Appendix.1.1 ASCII code table (SP) & ‘ < > App - 1...
Page 218: Appendix.1.2 Characters Applicable To Item Names, Component Names, Variable Names, Etc
Appendix.1.2 Characters applicable to item names, component names, variable names, etc. (1) ASCII characters The shaded characters can be used. (However, neither a number nor an underscore ( _ ) can be used as the first character.) (SP) & Åe <...
Page 219: Appendix.1.3 Characters Applicable To Character String Constants, Etc
Appendix.1.3 Characters applicable to character string constants, etc. The shaded characters can be used. (SP) & ‘ < > Appendix.1.4 Characters applicable to field names, table names, etc. The shaded characters can be used. (However, a number cannot be used as the first character.) (SP) &...
Page 220: Appendix2 About Monitoring Interval Timeout
Appendix2 About Monitoring Interval Timeout Depending on the number of set jobs or the trigger condition setting, the monitoring interval timeout may be generated in the MES interface function. This section explains monitoring interval timeout. POINT POINT POINT Although up to 64 jobs can be registered and trigger conditions can be set to each of them, some adjustment in trigger condition settings is required depending on the number of the jobs.
Page 221 (Example 2) When the time for trigger detection is longer than the monitoring interval Since processing for trigger detection cannot be completed within each monitoring interval, monitoring interval timeout occurs. The processing for trigger detection is performed at the next timing after the monitoring interval. Monitoring interval Detecting trigger...
Page 222: Appendix3 Warning Messages In Windows Vista(R)
Appendix3 Warning Messages in Windows Vista(R) Appendix.3.1 Overview of warning messages  In Windows Vista , a User Account Control feature has been added. When installing/uninstalling GT Works3, or starting [DB Connection Service Setting Tool], a warning message is displayed. Appendix.3.2 Methods for disabling warning messages POINT...
Page 223 (From the previous page) Select [User Accounts]. Select [User Accounts]. Select [Turn User Account Control on or off]. When User Account Control is enabled in  Windows Vista , the following screen appears. Click the button. Continue (To the next page) App - 7...
Page 224 (From the previous page) Deselect [Turn on User Account Control (UAC) to make your computer more secure]. (End) App - 8...
Page 225 (2) Method for permitting programs without any warning message The following shows a procedure for permitting programs without any warning message. Select [Start] - [Control Panel]. Select [Classic View]. Select [Administrative Tools]. (To the next page) App - 9...
Page 226 (From the previous page) Select [Local Security Policy]. When User Account Control is enabled in  Windows Vista , the following screen appears. Click the button. Continue Select [Local Policies]. Select [Security Options]. (To the next page) App - 10...
Page 227 (From the previous page) Select [User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode, Prompt for consent]. Select [Elevate without prompting] on the [Local Security Setting] tab, and click the button. (End) App - 11...
Page 228: Appendix4 Tables For Used Terms
Appendix4 Tables for Used Terms In GT Designer3, some different terms are used for the same meaning on the MES interface function setting screen and other setting screens. They are listed in the tables shown below. (1) In the case of Device tag settings MES interface function setting Others Signed Decimal (Data length: 16 bits)
Page 229 Appendix5 Application Example of MES Interface Function The following is an example of the system where the MES interface function is used. Example) A system where manufacturing information is collected in a GOT and managed in a database In the company-wide integrated system in which parts acceptance, manufacturing processing, assembly, shipment, and inventory control are managed, information of the actual performance is managed in a database using the MES interface function.
Page 230 (1) Setup on the server computer (database) The actual performance for every 5 seconds, and fraction defective and operation rate for every hour are managed using the database. (a) Table setting • Table name: PROCESS • Field: Name Data type Size Scale NULL...
Page 231 (d) MES interface setting • Device tag settings Device tag name Sampling cycle Component name Data type Device Operation time Single word GD540 Accumulated down time Single word GD542 Performance Single word GD544 Normal sampling 5 seconds Rejected Single word GD546 Fraction defective Real number...
Page 232 App - 16...
Page 233 INDEX Access log ..........7-2,7-15,7-20 Job ..........A-17,5-1,6-21,6-38 Job cancellation ........... 6-36 Account..............A-17 Action............A-17,6-38 Application server computer ........ A-17 Arithmetic processing function MES ..............A-17 (Operation action)........5-10,6-62 MES interface function setting ....... 6-1 Monitoring interval timeout......3-7,App-4 String ..............6-13 COMMIT ..............
Page 234 Update ............. 6-45 Statistical processing ........... 6-14 Tag component (Component)......A-18 Tag for Wonderware Historian......A-17 Tag function ..........3-4,5-3,6-6 Test mode............6-24 Time zone ............A-18,6-79 Transaction ............A-18 Trigger buffering ..........A-18 Function ............3-4,5-6 Settings ............6-25 Trigger conditions ........A-18,6-25 Trigger monitoring function ......
Page 235 This manual confers no industrial property rights or any rights of any other kind, nor does it confer any patent licenses. Mitsubishi Electric Corporation cannot be held responsible for any problems involving industrial property rights which may occur as a result of using the contents noted in this manual.
Page 236 GOT is a registered trademark of Mitsubishi Electric Corporation. Microsoft, Windows, Windows NT, Windows Server, Windows Vista, Windows 7 are registered trademarks or trademarks of Microsoft Corporation in the United States and other countries. Adobe and Adobe Reader are registered trademarks of Adobe Systems Incorporated.
Page 238 Series MES Interface Function Manual for GT Works3 SW1-GTD3-O(MES)-E MODEL MODEL 1D7MA8 CODE SH(NA)-080859ENG-L(1410)MEE HEAD OFFICE : TOKYO BUILDING, 2-7-3 MARUNOUCHI, CHIYODA-KU, TOKYO 100-8310, JAPAN NAGOYA WORKS : 1-14 , YADA-MINAMI 5-CHOME , HIGASHI-KU, NAGOYA , JAPAN When exported from Japan, this manual does not require application to the Ministry of Economy, Trade and Industry for service transaction permission.

Mitsubishi Electric GOT 1000 Series Manual

1 Overview

2 System Configuration

3 Specifications

4 Settings and Procedures before Use of the Mes Interface

5 Mes Interface Function

6 Mes Interface Function Setting

7 Db Connection Service and Setting Tool

8 Troubleshooting

Appendices

Appendix.1.1 ASCII Code Table

Appendix.1.2 Characters Applicable to Item Names, Component Names, Variable Names, Etc

Appendix.1.3 Characters Applicable to Character String Constants, Etc

Appendix.1.4 Characters Applicable to Field Names, Table Names, Etc

Appendix.3.1 Overview of Warning Messages

Appendix.3.2 Methods for Disabling Warning Messages

Quick Links

Related Manuals for Mitsubishi Electric GOT 1000 Series

Summary of Contents for Mitsubishi Electric GOT 1000 Series

Table of Contents