Home

mes interface configuration

1. 11 1 INDEX Index 1 to Index 2 FURTHER READING REFERENCE LIST The following manuals are also related to this product If necessary order them by quoting the details in the list below Manual Number Manual Name Model Code SH 080644ENG 13JR95 18 0800354 13JY02 MES Interface Module User s Manual MES Interface Module User s Manual Hardware SH 080483ENG QCPU User s Manual Hardware Design Maintenance and Inspection 13JR73 SH 080484ENG QCPU User s Manual Function Explanation Program Fundamentals 13JR74 GX Developer Version 8 Operating Manual eee V r Version rating Manua eveloper Versio perating 13JU41 1 INTRODUCTION CHAPTER 1 MELSECKEY cries INTRODUCTION The MES interface enables simple highly reliable data connectivity between automated machinery and manufacturing related computing applications such as Manufacturing Execution MES and Production Control PCS These applications depend on correct data collection and timely delivery Compared to conventional connectivity implemented using gateway computers direct database connectivity implemented using the MES Interface will decrease system complexity improve reliability and eliminate data loss resulting in better agility less maintenance and reduces total cost of ownership TCO This guide aims to provide an introductory guide to setting up the MES Interf
2. CHAPTER 10 CONCISE ERROR CODE LIST a g 2 10 1 Viewing MES Interface Module Error Codes oy ME Check MES interface module error codes with the information linking function setting tool zz Q Select Online from the menu a Operation History menu a The Operation History will appear Proceed referring to the explanation below Bas Working log Error log Information of errors and system Date Error code Summary Zo 2006 07 31 14 30 47 8 Communication message reception timeout P 2006 07 31 14 24 48 Start operation 2006 07 31 14 20 02 Start operation 2006 07 31 14 18 56 0883 Communication connection error 2006 07 31 14 18 46 OB8C Communication message reception timeout 2006 07 31 14 18 23 Start operation ake 2006 07 31 14 17 26 8 Communication message reception timeout lt 2006 07 31 14 17 03 Start operation 2 2006 07 31 14 16 13 Start operation 3 0717101 14 10 12 Carmmunicskian connackian mee Update Clear Update cm po Zg Event log Information of job execution lt lt 4 ECE Date Job name Summary 2 1 Error log g a Refer to the error log error and system information and check the error codes Item Description Date 1 The date and time of the error information occurrence is displayed Ze co Error code 9 The code for the error is displayed E
3. From the previous page Error code Error name Action Check if data can be written to 0B20h Tag write error the device specified for the tag component Please consult your local Mi ishi representative OB21h System error taunts a e y explaining a detailed description of the problem Check if Device tag settings is correct 0B22h Tag access error Check if the ERR LED is on or flashing on the MES interface module Please consult your local Mitsubishi representative OB23h System error explaining a detailed description of the problem Check if Device tag settings is 0B24h Tag value read error 9 ings i correct PI local OB25h ease consu t you Mitsubishi representative to System error un 2 explaining a detailed description of the problem 0B29h Type conversion to tag Check the tag component type component error or the substitute value Pl local OB2Ah ease your oca Mitsubishi representative to System error NA explaining a detailed OB2Dh n description of the problem OB2Eh Replace the CompactFlash DB buffer content error 0B2Fh Partial correction of B30h 0839 DB buffer content Please consult your local Mitsubishi representative OB31h System error p explaining a detailed description of the problem 0832 DB buffer clear error Repl he CompactF
4. 9 8 11 1 11 2 11 3 po 1 1 6 3 6 5 6 6 11 2 11 3 Pu ROWS MR 1 1 11 2 11 3 5 Sample DB 6 1 Sample system 3 1 4 1 a SC SC cM 1 2 8 7 9 3 9 4 SEE Sequence program 3 2 4 2 9 10 Server service 8 5 9 3 Server service settings 7 1 8 5 9 3 9 8 Setup procedure 1 3 6 1 6 6 Es ONTP ien 1 3 9 12 10 11 11 1 Software registration 5 5 SQL 1 2 1 3 1 4 3 1 9 11 10 13 10 20 10 21 11 1 B SQL failure 09 1 4 9 6 10 17 10 18 we SOL SGM ted 11 1 E d ix Porte rdi 3 1 82 SWITCH 1 3 10 10 10 15 System setting 1 4 8 3 9 2 9 3 9 11 IE 6 1 6 3 6 5 SEM Timestamp srie 1 3 Transaction 10 13 2 10 12 11 2 Trigger condition 8 1 3 8 6 8 8 9 4 9 9 9 10 9 11 9 12 11 2 Twisted 3 1 4 1 Update RR eet 1 2 28 User s manual eese 1 1 X x nut hie et tie tes 10 21 11 1 8 XML data base 1 1
5. Select File on the menu bar and then click Save As In the dialog box that appears select History in the Table Destination field and Table in the type of affixation field Click the OK button When the following dialog box appears select No Microsoft Office Access After saving the table close the Design View Sample DB Database Access 2000 file format 7 ODBC SETTING CHAPTER Perfo and Maintenance De ER Took 5 Pertormance and Maintenance Administrative Tools 8 Fomes Joos tep AG e 7 ODBC SETTING 2 a 2 This section explains setting method for the following basic software OS and relational databases Pu Basic software OS Microsoft Windows XP Professional Operating System ub gt Relational database Microsoft Access 2003 EB When using software or relational database other than above refer to MES Interface 5 Module User s Manual Set the following conditions gag Data source name 1 SAMPLEDS e Database name 2 C mes Sample_BD mdb 1 Data source name can be set as desired P The name in this setting is to be used as the data source name in Server service setting 2 database name is the name for accessing a Microsoft Access database Specify the path in which the database file created in Microsoft Access is stored o 2 Start
6. MME 5 NewProject 7 System setting 3eb nam etin Enable at module startup Startup logging 25 Access target CPU settings Trigger buffering Test mode oy controicru Trigger conditions a Sy Device tag settings Combinati D v The job starts when the trigger conditions 55 GettingData changes from false to true PuttingData Trigger 1 At module startup Y EJ c Server service settings sampleserver 9 Sy Job settings Ki GettingPlan o Trigger 2 Disable X 8 8 Actions E 5 20 Setting item Setting description Setting method Job name GettingPlan Text input Enable at module startup Place checkmark Checkmark Trigger buffering Remove checkmark Checkbox reversion Trigger conditions First condition At module startup List selection lt e Next specify an action Select Communication action in the list box as shown below and click the Add button i Actions 5 8 Type Summary 2 ui Communication action hd E 4 8 6 8 MES INTERFACE CONFIGURATION Choose Select in the list box for Action type and set the communication action parameters as is shown below Default setting is acceptable for the exception processing settings After the setting SQL sentence to be sent to a database is automatically generated The generated SQL sentence can be confirmed in the Generated SQL text box on
7. eee get e tret 8 12 8 3 1 General Description 3c dette idein e tbe arreglos tread 8 12 8 3 2 Writing Parameters onto QU71MES96 Module sse 8 12 8 3 8 Checking Data Written into DB enne nenne 8 13 CHAPTER9 FAQGs 9 1to9 12 9 1 Troubleshooting e 9 1 9 1 1 When using MES Interface Function Configuration 0 9 1 9 1 2 When using DB Connection Service Setting Tool 9 6 9 1 3 When operating the MES interface module sss eene 9 7 CHAPTER 10 CONCISE ERROR CODE LIST 10 1 to 10 21 10 1 Viewing MES Interface Module Error Codes nennen 10 1 10 2 Viewing Server Computer Error Codes sse ener snnt 10 2 10 24 uetus bee ae notre lasci orte E 10 3 10 32 Erol Gode EISE aee eene ae De aene da 10 9 10 3 1 Error codes for the MES interface 10 9 10 3 2 Error codes of DB Connection Service sss 10 15 10 3 3 Error codes returned in XML response messages 10 21 CHAPTER 11 TERMINOLOGY 11 1to11 4 11 1 DEFINITIONS AND DESCRIPTIONS OF 5
8. Please consult your local Mitsubishi representative explaining a detailed description of the problem Select Job settings Communication action in MES Interface Function Configuration Tool and set update conditions correctly Check if the database has been filled with registered data 0 20600026 to 0x20600028 System error Please consult your local Mitsubishi representative explaining a detailed description of the problem 0x2060002B Data source name Transmitting Commit Success Response Failed Failed to transmit the COMMIT success response Check if it is connected to the network Check if the gateway and or hub is operating Check if the power of the module is not turned off 10 3 3 Error codes returned in XML response messages Error code Error name Action Please consult your local Mitsubishi representative 0x41170101 System error explaining a detailed description of the problem 0x41170103 XML message length error Ox41171101 XML request message interpretation error 0x41171111 Duplicated XML request message route Check the content of the 0x41171201 XML request message route sent XML message error 0x41171205 AME request message attribute error 0x41171301 ut request message jobname error Check if the job is already in execution Check if the MES interface module is
9. Detected failure of the MES interface module during response transmission SID Session ID Response Transmit Error 0x20310013 IP address Send I O error SID Session ID DB Connect Data source 0x20400001 User Failed Failed in DB connection due Terminate any to insufficient memory unnecessary applications SID Session ID DB Add more memory to the Connect Data source computer 0x20400002 User Failed Failed in DB connection due to insufficient resources SID Session ID DB Connect Data source Check if the source IP 0x20400010 User Failed address belongs to the Invalid DB connection MES interface module request Please consult your local Mitsubishi representative System error explaining a detailed 0x20400012 description of the problem SID Session ID DB Terminate any Connect DataSource unnecessary applications 0x20400020 User Failed Failed to create a DB handle Add more memory to the computer To the next page Error code CONCISE ERROR CODE LIST Error description and cause Corrective action Please consult your local Mitsubishi representative Error code Error description cause SID Session ID SQL lt gt Failed SID Session ID COMMIT Failed SID Session ID ROLLBACK Failed MELSECKE eries From the previous page Corrective action Check if the sour
10. Specify file name as Sample DB mdb and click Ee os Sac the Create button Sample _DB mdb Microsoft Office Access Database mdb DER The above step opens the following dialog box Select Create a table in Design View To the next page 6 CREATING A DATABASE TABLE Ml ALS 5 From the previous page 8 l E Tablet Table When a table properties window Design View H S H n Number appears enter into the first line OrderCode as bw field name Number as data type and Integer up Field Properties 20 s field size 52 General Lookup as ae Field Size Integer Format Decimal Places The size type of Input Mask numbers to enter in the c Caption field The most common 9 Default Value settings Double and E Validation Rule Long Integer If joining Yaldation Text e toa relationship the Feld ase Mio m nm be piis g 3 E amp fe 5 5 Tablet Table EEK Enter into the 2nd line ProductCode as field Data Type Description m S 9 ME Number name Text as data type and 2 as field size Field Properties E General Lookup ug Field Size lt 5 Format lt Input Mask Sees The maximum number of QS
11. Text input Component 4 Specify another action Select Communications action the list box as shown below and click the Add button Actions Type Summary 1 Operation Conversion lt lt GettingData Weight_g 1000 Add Edit Delete 8 9 MES INTERFACE CONFIGURATION Select Insert in the Action Type combo box list box and specify parameters for the communication action as shown below After the setting SQL sentence to be sent to a database is automatically generated The generated SQL sentence can be confirmed in the Generated SQL text box on the lower part of the screen Communication action Action type Insert Database SampleServer v Table name History DB tag link settings Field name Tag Type Component 1 SerialCode lt GettingData SCode 1 2 Time lt lt Date Module time 3 Weight mg lt lt Variable Conversion lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt v Delete row s Insert a whole tag Generated SQL text INSERT INTO History SerialCode Date Time Weight mg VALUES GettingData SCode Date YvYY MM DD hh mm ss Conversion Field name Condition Tag Type Component Field name NN No of
12. 88 Clicking Performance and Maintenance the Om O Pwr erm 7 Control Panel displays the Performance and E lt tr Maintenance dialog box 98 and Maintenance E To display the Control Panel select Start BE H oa gt Control Panel 9 S Rearrange it on your hard disk to make programs run faster E e or pick a Control Panel icon administrative Tools i Power Uptions 86 Scheduled Tasks v System e 8 i BS 85 20 Clicking Administrative Tools displays O d Dawe pir Administrative Tools dialog box 5 rm aS 28 88 5 o 2 ui To the next page 7 ODBC SETTING MELSEC From the previous page ODBC Data Source Administrator Double clicking Data Sources ODBC displays ODBC Data Source Administrator dialog box Select the System DSN tab then click the Add button 3 The Create New Data Source dialog box is a displayed then select Microsoft Access Driver mdb Create New Data Source Driver do Microsoft Access mdb Driver do Microsoft dBase dbf Driver do Microsoft Excel xls Driver do Microsoft Paradox Dri osoft Visual FoxPro Driver mdb Microsoft Access T reiber mdb Microsoft dBase Driver dbf Microsoft dBase Driver dbf Vn displayed Set the following and click the Database se
13. characters you enter Med Rule inthe field The largest Val lation Text maximum you can set is Required No 255 Press F1 for help on Allow Zero Length Ives field size Indexed No Unicode Compression Wes IME Mode IME Sentence Mode Smart Tags E FE 29 Ea lt lt nS lt Tablet Table DER Enter into the 3rd line PlanNumber as field Field Name Data Type Description Number name Number as data type and Integer as field size PlanNumber Number ODBC SETTING Field Properties General Lookup Field Size Format Decimal Places The size and type of numbers to enter in the z field The most common N settings are Double and Long Integer If joining Validation Rule this field to Validation Text AutoNumber field Required many to one Indexed relationship this Field Smart Tags must be Long Integer Input Mask MES INTERFACE CONFIGURATION FAQs To the next page CONCISE ERROR CODE LIST TERMINOLOGY 6 3 6 CREATING A DATABASE TABLE MELSEG From the previous page Select File on the menu bar and then click Save Save Table Table1 To f As In the dialog box that appears enter OderTable 17 OrderTable in the Table Destination field and amp select Table in the Type of affix
14. Was a program executed which requires administrator privileges users in the administrators group for execution Programs which require administrator privileges users in the administrators group cannot be executed Specify a program which does not require administrator privileges for execution Was the program associated with the display executed with the application server personal computer logged off When executing the program associated with the display ensure that the application server personal computer is logged on Was the program associated with the display executed with multiple users logged on to the application server personal computer When executing the program associated with the display only one user logged on to the application server personal computer is displayed on the program screen Log all users off of the application server personal computer and then execute with only one user logged on Job startup is delayed Were the trigger conditions for multiple jobs met concurrently If the trigger conditions for multiple jobs are met concurrently startup of some job may be delayed Was the job execution time prolonged If the job execution time is prolonged startup of the next job may be delayed Was the value in the Monitoring interval timeout count area buffer memory address 11510 increased Check and correct the number of job settings or trigger condition set
15. Check if Server service settings is correct Check if the ODBC setting is correct OB8Dh OB90h System error Please consult your local Mitsubishi representative explaining a detailed description of the problem OB91h DB transaction status error OB92h OB93h DB transaction start status error DB transaction end status error Check the status of the database 0B94h OB9Dh System error Please consult your local Mitsubishi representative explaining a detailed description of the problem OB9Eh OB9Fh Database connection error Message reception error OBAOh Received message data error Check the Ethernet connection Check if Server service settings is correct Check if the ODBC setting is correct OBA1h OBASh System error Please consult your local Mitsubishi representative explaining a detailed description of the problem OBA6h Wait for DB access program execution completion timed out Check the Ethernet connection Check if Server service settings is correct Check if the ODBC setting is correct OBA7h System error Please consult your local Mitsubishi representative explaining a detailed description of the problem From the previous page version error Error code Error name Action OBAgh SELECT execution
16. Double click SETUP exe To display Windows Explorer right click Start then select Explore To the next page 5 SOFTWARE INSTALLATION From the previous page INTRODUCTION The dialog box for selecting the component to be SSS UTENTI installed is displayed Select the component which wants to be installed ee ior aon oa S tth tt b t d ith th pelted elect the component to be installed wi e installing setting computer EE Coa acti MO SD It is possible to be installed on the same radio button then click the Install button jis interface function configuration too computer as DB connection service and MX MESInterface EXAMPLE SYS TEM OUTLINE car EQUIPMENT FOR REQUIRED START UP If the left message appears click the Cancel EQUIPMENT SETUP button and after uninstalling MX MESInterface This package has already been installed i There is possibility For improper installation IF you execute without uninstalling it install this product 4 tt lt lt EX e If the left message appears install this product a computer to which the basic software OS compatible with the product is installed Severe Q The OS this parsona computer isn t being supported at a movement environment of this package mu 08
17. 2 2 Index 2 REVISIONS The manual number is given on the bottom left of the back cover Print date Manual number Apr 2008 First edition Revision This MES Quick Start Guide 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 2008 MITSUBISHI ELECTRIC CORPORATION Mitsubishi Programmable Controllers MES Interface Module Quick Start Guide Precautions for Choosing the Products This catalog explains the typical features and functions of the Q series Programmable Controllers and does not provide restrictions and other information on usage and module combinations When choosing the products always check the detailed specifications restrictions etc of the products in the Q series data book When using the products always read the user s manuals of the products Mitsubishi will not be held liable for damage caused by factors found not to be the cause of Mitsubishi machine damage or lost profits caused by faults in the Mitsubishi products damage secondary damage accident compensation caused by special factors A For safe use To use the products given in this catalog properly always read the manuals before starting to use them This product has been manu
18. 92 Example Success 2007 10 01 12 00 00 000 0xL00000000 SID 00000001 DB Disconnect DataSource ID Success CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e 5 2 a Q 9 TERMINOLOGY 1 Q CONCISE ERROR CODE LIST MELSECKE ries d SQL statement receiving processing results For details on Database error number and Database cause of error message in the output log format at the time of failure check each database s manual Depending on the Error code the Database Messages below may not be output Check the error and take corrective action according to the error code SELECT Item Description Output Success Date Error Code SID Section ID SQL lt SQL statement gt Success selection code number ig formats Date Error Code SID Section ID SQL SQL statement gt Failed Database Message Database error number Database cause of error message Success 2007 10 01 12 00 00 000 0xL00000000 SID 00000001 SQL lt SELECT COL from TABLE gt Success 1 Example Failure 2007 10 01 12 00 00 000 0xL20600023 SID 00000001 SQL lt SELECT COLL from TABLE gt Failed Database Message 0xL00000388 Oracle ODBC Ora ORA 00904 COLL invalid identifier Item UPDATE Description Output Success Date Error Code SID Section ID SQL lt SQL statement gt Success update co
19. directory When the access log file has been open in another application terminate the application Check the disk device for any fault The access log file could not be 404 opened When the disk space is full ensure a free disk space When the access log file has been open in another application terminate the application Check the disk device for any fault The log could not be written to 405 the access log file When the attribution of the oldest access log file is set to read only cancel the setting If read write is disabled for the oldest access log file Failed to delete an old access eens 406 log file setting When the oldest access log file has been open in another application terminate the application Check the disk device for any fault Error Error description and cause Corrective action code The mask bit length setting of 115 the connection permitted IP address is out of range 116 The access log setting is not correct 117 The setting of the access log file name is not correct 118 The access log file name is too long 119 The maximum file size setting for the access log is not correct The maximum file size setting 120 for the access log is out of range The maximum number of 121 access log files is not set corecty Configure the settings again EE maximum number af with DB Connection Service acce
20. operating 0x41173101 Job execution error Check CompactFlash card status X1 and File access status X2 Execute the job after starting the module and sampling tag data 0x41173103 Please consult your local Mitsubishi representative System error explaining a detailed 0x41173105 description of the problem 10 21 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e 5 2 a Q 9 TERMINOLOGY 1 1 TERMINOLOGY 86 el series CHAPTER 11 TERMINOLOGY 11 1 DEFINITIONS AND DESCRIPTIONS OF TERMS The following table shows the definitions and descriptions of the terms used in this manual Term Description Abbreviation for Comma Separated Values cay Text file in which the data are aligned and set off by commas and double quotations DB buffering Function temporarily stores SQL text that failed to be sent due to a communication error and resends the text when the communications have been recovered Abbreviation for Hyper Text Transfer Protocol HTTP Protocol to exchange XML format messages between the MES interface module and user applications in the XML processing function Tag for IndustrialSQL Server Name for data unit in the data base IndustrialSQL Server Abbrev
21. the error and take corrective action 10 2 1 0 CONCISE ERROR CODE LIST 10 2 1 Log Format Output character The log format used in the explanations in this section is shown below Date Error Code message line feed Item Description Year bol 1 4th bytes 4 integers single byte numbers Year month break bol 5th byte single byte slash 2Fh Month bol 6 7th bytes 2 integers 01 12 single byte numbers Month day break bol 8th byte single byte slash 2Fh Day bol 9 10th bytes 2 integers 01 31 single byte numbers Day hour break bol 11th byte single byte space 20h Date Hour bol 12 13th bytes 2 integers 00 23 single byte numbers Hour minute break bol 14th byte single byte colon 3Ah Minute bol 15 16th bytes 2 integers 00 59 single byte numbers Minute second break bol 17th byte single byte colon 3Ah Second bol 18 19th bytes 2 integers 00 59 single byte numbers Second millisecond break bol 20th byte single byte period 2Eh Millisecond bol 21 23 bytes 3 integers 00 999 single byte numbers Error code millisecond break bol 24th byte single byte space 20h Error Code bol 25 34th bytes Ox 8 hexadecimal single byte digits Error code message break bol 35th byte single byte space 20h Message bol 36th byte on Follow specifications for each log Line feed eol CR
22. 20 Delete unnecessary files from the I CompactFlash card Be 2 Troubleshooting about network connection Corrective action Change the mode to Online Connect the MES interface module to the Checked item Is it in Online mode Is the MES interface module connected to Symptom FAQs E the network X4 ON network g Is there any disconnection in the ut Unable to access the MES interface Connect the cables properly e connection route 2a module 88 Is the IP address duplicated Correct the IP address setting Is there a firewall and or a proxy server in the connection route Ask your network administrator about the firewall and proxy server settings Is there a problem with the computer Replace it with another computer TERMINOLOGY FAQs MELSEC 3 Troubleshooting about communication between the MES interface module and access target CPU Symptom Unable to access another station via Q series E71 Checked item Is a remote password set for the GX Developer communication port UDP IP of the Q series E71 on the target or relay station Corrective action Remove the remote password set for the GX Developer communication port UDP IP of the Q series E71 on the target or relay station An error occurs when accessing the Redundant CPU Is MES interface accessing the Redundant CPU of other station Mou
23. 8 6 8 8 9 3 9 4 9 10 9 11 10 20 10 21 M Manufacturing execution software application 1 3 Manufacturing execution system 1 4 3 1 MELS EC 1 3 2 1 1 3 1 4 10 9 10 14 MELSECNET G 1 4 10 9 10 14 1 3 1 4 10 9 10 14 MES interface 1 1 1 2 1 4 2 1 MES interface function 3 1 8 1 11 1 11 2 Message 1 3 5 1 5 2 5 3 11 1 Microsoft 1 1 3 2 4 1 6 1 7 1 7 2 10 13 MX 5 3 1 5 1 5 2 N Numerical 6 1 6 3 6 6 ODBC 7 1 7 2 9 8 10 11 10 12 10 13 11 1 ODBC Data Source Administrator 7 2 Operation action 8 8 8 9 9 4 11 1 Operation log 3 1 9 9 9 10 9 11 9 12 Sc E 1 1 1 2 6 1 6 4 6 5 Parameters 8 1 8 3 8 4 8 5 8 7 8 10 10 9 10 16 e 5 1 5 5 Production 3 1 7 1 596 Herten 3 1 4 2 R E Record 1 1 1 2 9 9 9 10 10 20 10 21 11 3 Relational database
24. 9 2 9 3 10 9 10 10 10 11 10 14 10 15 E Ethernet 1 3 4 1 10 9 10 11 10 12 10 13 10 14 Example system 1 1 2 1 Exception processing settings 8 10 F Field 1 1 1 2 1 3 9 5 9 9 10 13 10 20 10 21 11 2 11 3 Field 6 1 6 3 6 5 6 6 10 21 Field siZ amp ence 6 1 6 3 6 5 6 6 ettet tin 9 1 9 7 9 8 10 19 G 1 3 1 4 GT 1 4 Index 1 GX Developer 9 8 GX Developer 9 5 9 7 H Hierarchical database 1 1 FISIOry a 4i 6 1 6 5 6 6 How to install 5 1 EL 3 1 4 1 10 19 10 21 I IndustrialSQL Server 11 1 Information system 3 1 TINTE 1 2 8 10 9 4 Integer 6 1 6 3 Integrated programming 3 2 IP address 4 1 9 1 9 5 9 6 9 7 10 16 10 19 10 20 IT infrastruture devices 1 3 J Job 9 4 9 5 9 9 9 10 9 11 10 11 10 20 11 1 11 2 8 6 8 8 Job setting
25. CREATING A DATABASE TABLE If the left message appears execute EnvMEL Setup exe in the CD ROM for this This package is not in proper aperating environment Please install this package after executing EnvMEL Setup Exe from CD ROM product Severe After executing Setup exe install this product If the product is not installed correctly restart the computer ODBC SETTING The left screen appears Check that all applications have been closed then click the Install MES INTERFACE CONFIGURATION A posse for morer if you execute without closing all the running applications Including resident programs Ok button If any applications are running close them all To the next page CONCISE ERROR FAQs CODE LIST TERMINOLOGY 5 SOFTWARE INSTALLATION MELSEC From the previous page Setup starts The left screen appears Check the description then click the Next button Inforsnation Enter a user company name then click the Next gt button y MITSUBISHI ELECTRIC Co Check the user name and company name registered If the registration contents are correct click the Registration Confirmation Yes button When changing the registration contents click the button to return to the previous screen To the next page 5 SO
26. Device tag name GettingData Sampling settings Normal sampling for a period of one second Component name CPU name Device Data type Statistical type 1 Ocode ControlCPU 0100 Single precision 2 Scode Controicpu 0300 0302 Character string 6 lt 3 Weight_g ControlCPU 0400 Single precision 4 ReportingTrigger ControlCPU Bit Device tag name PuttingData Sampling settings Do not sample Component name CPU name Device Data type Statistical type 1 Plan ControlCPU D200 Single precision Character string 2 PCode ControlCPU 0202 2 characters Server service settings Server service name SampleServer Server type Database server IP address 192 168 3 1 Port number 5112 User name Blank Password Blank Data source name SAMPLEDS Database type Access 2003 2007 Communication timeout interval 10 seconds Job settings Job name GettingPlan Enabled or not at module startup Enabled Trigger buffering None Trigger condition At module startup Action 1 Type of action SELECT Table name OrderTable DB tab link settings Filed name Component ProductCode PuttingData PCode PlanNumber PuttingData Plan Select update conditions Filed name Condition Component OrderCode GettingData OCode 8 MES INTERFACE CONFIGURATION of setting Desc
27. Errors detected by the access target CPU 1 System error itsubis i representative 4FFFh explaining a detailed 9000h Please consult your local description of the problem i ishi i Check th f Bysiaimemit Mitsubishi representative FFF2h Memory cassette errot Check the memory cassette 9006h explaining a detailed the access target CPU description of the problem Check the block No of the 9008h Send buffer full Check the CPU s on the extension file register device access route FFF3h Write protect error 9202h P Check the write protect DIP 9204h Please consult your local Switch on the memory cassette 920Ah Mitsubishi representative of the access target CPU System error Check the block No of th 9920h explaining a detailed eck the block No of the 9922h description of the problem FFF4h Block error extension file register device 9923h type Check the CPU s on the FFF5h Please consult your local 9E20h Processing code error FFF8h Sysiomertor Mitsubishi representative laining a detailed Correct the device type entered FFFAh SAP 9E81h Device type error rst vice typ o in Device tag settings description of the problem Correct the device number 9E82h Device No error Correct tho device number FERBN Slee error entered in Device t ttin entered in Device tag settings ed in ence lag 95 gessh Number of device Correct the device number Chec
28. Example Success 2007 10 01 12 00 00 000 0 1 00000000 SID 00000001 COMMIT Success KE Eo ROLLBACK HE Item Description OmU Success Date Error Code SID Section ID ROLLBACK Success E Date Error Code SID Section ID ROLLBACK Failed 2 a log format Failure Database Message Database error number Database cause of error message Example 2007 10 01 12 00 00 000 0 1 00000000 SID 00000001 ROLLBACK Success GetNext request for next record Item Description Out Success Date Error Code SID Section ID GetNext Success Failure Date Error Code SID Section ID GetNext Failed aa Database Message Database error number Database cause of error message Example Success 2007 10 01 12 00 00 000 0xL00000000 SID 00000001 GetNext Success mo F Program execution receiving processing result Item Description 82 Output Success Date Error Code SID ProgramExec Connection origin IP lt Command line gt Success Return value log format Failure Date Error Code SID SID ProgramExec Connection origin IP Command line gt Failed Example Success 2007 10 01 12 00 00 000 0xL00000000 ProgramExec 192 168 3 3 lt hoge exe gt Success 0 CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e 5 2 a Q 9 TERMINOLOGY 10 N 1 Q
29. LF ODh OAh INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR REQUIRED START UP EQUIPMENT SETUP SOFTWARE INSTALLATION CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e m Q 2 a Q 9 TERMINOLOGY 10 3 1 Q CONCISE ERROR CODE LIST MELSECKE cries 1 Access Log Internal communication between the MES interface module and the DB connection service is output in the access log Access log details are shown here a Service start end Start Output log format Date Error Code Service Start Example 2005 07 01 12 00 00 000 0xL00000000 Service Start End Output log format Date Error Code Service Stop Example 2005 07 01 12 00 00 000 0xL00000000 Service Stop b MES interface module connection disconnection Connection Item Description Date Error Code SID Section ID MIFWS Connected Connection origin IP Connection target data source Connection ID 2005 07 01 12 00 00 000 0xL00000000 SID 0 MIFWS Connected 192 168 3 3 DataSource ID Output log format Example Disconnection Item Description Date Error Code SID Section ID MIFWS Disconnected Connection origin IP Connection target data source Connection ID 2005 07 01 12 00 00 000 0xL00000000 SID 0 MIFWS Disconnected 192 168 3 3 DataSource ID Output log format Example 10 4 1 0 CONCI
30. Microsoft Access 2003 e Selecting History and clicking the Open button will open the History table f Sample DB Database Access 2000 file format open We new X Create table in Design view Create table by using wizard Create table by entering data OrderTable After starting the MES interface module 35 pieces of data are inserted into the History table at intervals of 10 seconds The results can be checked in a chart like the one below E History Table DER ProductCode Weight mg i 10 9 2007 1 15 00 109200 10 9 2007 1 45 00 10 9 2007 2 00 00 PM 10 8 2007 1 00 00 10 9 2007 1 15 00 PM 10 9 2007 1 30 00 PM 10 9 2007 1 45 00 10 9 2007 2 00 00 _ 10 9 2007 1 00 00 10 9 2007 1 15 00 PM 10 9 2007 1 30 00 10 9 2007 1 45 00 PM 10 9 2007 2 00 00 PM 10 9 2007 1 00 00 PM 10 9 2007 1 15 00 10 9 2007 1 30 00 10 9 2007 1 45 00 PM 10 9 2007 1 30 00 PM 10 9 2007 1 45 00 PM 10 9 2007 2 00 00 10 9 2007 1 00 00 10 9 2007 1 15 00 PM 10 9 2007 1 30 00 PM 10 9 2007 1 45 00 Record gt of ot FAQs CHAPTER 9 FAQs INTRODUCTION 9 1 Troubleshooting by symptom EXAMPLE SYS TEM OUTLINE 9 1 1 When using MES Interface Function Configuration Tool This section explains troubleshooting information on the setting of MES
31. Retry writing the setting with fi ion Tool 0831h Setting file error Configuration E MES Interface Function 060Ah Component device the device Configuration Tool error E setting Retry writing the setting with the module anid then 0832h MES Interface Function 0610h setting error configure the Access target Configuration Tool CPU settings again 08A1h Please consult your local Remove the cause of the a Nar 08A2h Mitsubishi representative 0617h Module stop error module stop error and reset System error laining a detailed the programmable controller __ oP a gece CPU 08 1 description of the problem Reexecute the setting update To the next page 0618h g up Reset the programmable 1 0 CONCISE ERROR CODE LIST Error code Error name Action 0A00h Initialization error 0A01h Start error Replace the CompactFlash 0A02h Stop error card 0A03h Reset error Check if the network on the 0A04h Tag related error programmable controller CPU side is normal Please consult your local Mitsubishi representative 0A05h System error _ explaining a detailed description of the problem EE Initial SNTP server Check if the specified SNTP time enquiry error server is operating normally or if no error has occurred on the SNTP server time network linked to the sp
32. for communicating with a database and Operation action for Action operating tag component values Communication action is a processing unit for sending one SQL text Select Update Insert Operation action is a unit up to 20 dyadic operations can be processed System switching Function for the Redundant CPU to switch between control system and standby system of the redundant system Switching from control system to standby system and vice versa COMMIT 11 1 Processing for finalizing the changes to a database To the next page 1 1 TERMINOLOGY Term CompactFlash card CF card From the previous page Description Storage card regulated by the CF and CompactFlash Specification issued by the Compact Flash Association This memory card is necessary for the MES interface module to operate the MES interface function Server service Generic term for the services can be offered by a server computer to which DB Connection Service is installed There are database server service and application server service The database server service is a service for accessing a database The application server service is a service for linking with a program Server computer There are database server computers and application server computers The database server is a computer with a relational database which links information with the MES interface module The application server
33. free space on the drive An SQL failure log output error is recorded in Event Viewer of Administrative Tools in Windows Is the file set in Output destination read only Correct the file specification Is the access to the folder containing the file set in Output destination authorized Check the right of access to the folder Is the drive space of the server computer full Check the free space on the drive The DBConnector service failed to start due to the following error The system cannot find the file specified is recorded in Event Viewer of Administrative Tools in Windows Does the following file exit in the installing destination directory of DB connection service and Setting tool MESIF DBConnector exe Has the computer been restarted after uninstalling DB connection service and Setting tool Uninstall DB connection service and Setting tool and restart the computer before reinstallation FAQs 9 1 3 When operating the MES interface module 5 This section shows the troubleshooting of problems that may arise during operation of the MES interface module 1 Troubleshooting about LED indication and signals Bg ar Symptom Checked item Corrective action Is the module in preparation Wait for startup of the module 5 If a watchdog timer error is identified E 3 The RUN LED does not t
34. in Completion notification of Handshake operation A desired device tag name is not displayed in the field of Substitution tag for Select in Communication action A desired device tag name is not displayed in the field of Substitution tag in Exception processing of Communication action A desired device tag name is not displayed in the field of Substitution tag in Operation action A desired device tag name is not displayed under Notify errors job cancellation that occur during job execution Is the tag set to data write disabled Set the tag to data write enabled Unable to set Exception processing in Communication action Is the DB buffering enabled Is Insert set for Action type Disable the DB buffering Set any other than Insert for Action type FAQs 5 a 7 Online Symptom Checked item Corrective action Delete any unnecessary field settings f Unable to write a project to the MES Is the total number of fields in the project nn Up to 8192 fields can be set within one 25 interface module more than 8192 project 2 E Select Online Transfer setup and ae correct the setting Is the IP address set in Transfer setup of g 3 Perform the online operation for the MES E interface module selected from Onli
35. in Section 5 into associated fields C mes Sample_Conf mup MES interface function configuration tool 5 5 Project Edit View Help gu Doe B Transfer setup 9 sa Read Xbnsm Reporting IV Enable at module startup Startup logging Access tar Verify Trigger buffering Test mode E ffi contre Trigger conditions ul 8 T gem dem Combination xc adam e a Puen Trigger 1 Value monitoring startup b 89 Sampleserver Component Condition Tag Type Component iss Job settings GettingData ReportingTrigger Constant ON GettingPlan Ex Exe al Su 7 Edu Q When the target setting screen shown below appears enter a user name and password and click the OK button Default settings are as follows 3 E User name QJ71MES96 8 Password MITSUBISHI 8 Transfer setup IP address 192 S T3 User name QJ71MES96 uz oo i rc ES a Ee d 88 o Password Connection test 8 Upon the completion of the writing step reset the sequencer CPU to start the E QJ71MES96 module LE After resetting switch the sequencer CPU to RUN 88 5 When the QJ71MES96 module starts writting data into the database starts automatically 8 12 8 MES INTERFACE CONFIGURATION MELSEC S 8 3 3 Checking Data Written into DB Table cQ Open C mes Sample_DB mdb with
36. is a computer with a program that operates upon request from the MES interface module Job Unit for accessing a database Update settings Processing updates the MES interface module settings from MES Interface Function Configuration Tool Configuration computer Computer used for configuring various settings required for the MES interface function in the MES interface module This computer can be shared with a server computer Time zone Standard time zone for each region of the world Each nation uses the time difference 12 hours maximum 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 The standard time for Japan is 9 hours ahead of the GMT In some nations daylight time in which the clock is advanced for one hour is used in summer Tag component Component Data source Generic term for a component Device data making up a device tag Tag This data organizes the communications path data type device etc for access to each programmable controller CPU device data as a single data unit Connection information necessary for accessing data using ODBC With Windows a data source name is assigned to connection information for management The database can be accessed via ODBC by specifying the data source name in the MES interface function Database DB or relational database RDB Data ma
37. made in Job settings From the previous page Corrective action Select another tag component or check the Job settings and disable data writing to the relevant tag component Was the device value of the relevant tag component manipulated in the programmable controller CPU Specify another device Or do not manipulate the relevant device value in the programmable controller CPU Failed to communicate with the server computer several times after module startup Was the programmable controller powered ON immediately after OFF Turn OFF the programmable controller and after several minutes turn it ON Is there any problem on the server computer Restart the server computer 5 Troubleshooting about the XML processing function Symptom The XML processing function does not work Checked item Corrective action When Stopped is displayed execute Restart from Remote operation Alternatively turn the power OFF and then ON or reset the programmable controller CPU Is Running displayed in the status indication area of Remote operation 6 Troubleshooting about the time synchronization function Symptom Time is not synchronized with the SNTP server computer 9 12 Checked item Is the SNTP server address setting correct Corrective action Correct the SNTP server address setting 1 0 CONCISE ERROR CODE LIST
38. the Yes want to i restart my computer now checkbox then click 9 Setup has finished copying files to your computer Before you can th 5 use the program you must restart Windows or your computer the OK button z E Choose one of the following options and click OK to finish setup To not restart the computer check the No will 88 restart my computer later checkbox then click the OK button 5 o It is recommended to restart the computer after installation E the next page 5 5 5 SOFTWARE INSTALLATION MELSEC From the previous page The dialog box for selecting the component to be installed is displayed MX MESInterface When installing the other software select the component to be installed with the radio button then click the Install button When the installation is complete click the Exit button End After installing MES Interface Function Configuration Tool and DB Connection Service Setting Tool the following icons are registered MESInterface 5 DB connection service setting tool All Programs To MELFANSweb Homepage MES interface function configuration tool P Computer 6 CREATING A DATABASE TABLE MELSEC CHAPTER 6 CREATING A DATABASE TABLE 6 1 General Description This section explains the procedure for making a sample DB table using the database Microsoft Acce
39. the lower part of the screen Communication action OrderTable Action type ERN Database SampleServer DB tag link settings Field name Tag Type Component 1 ProductCode gt gt PuttingData PCode gt gt PuttingData Plan gt gt gt gt gt gt gt gt gt gt gt gt gt gt Delete row gt gt Select sort settings gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt v v Insert a whole tag Table name Select Update conditions Field name Condition OrderCode Combine Tag Type GettingData Component OCode Field name 4 Delete row Exception process setting Delete row Generated SQL text SELECT ProductCode PlanNumber FROM OrderTable WHERE OrderCode GettingData OCode No of fields in project 6 Tag component data length in job words total Setting item Setting description Setting method Action type Select List selection Table name OrderTable Text input Field T Text input DB tag link settings 1 me ETE T dian name List selection 2 PlanNumber PuttingData Plan Tag Component Text input SCRI Field name Condition Tag Component Field name OrderCode GettingData OCode List selection Condition Tag Component 8 7 8 MES INTERFACE CONFIGURATION Specify another job setting Select Jo
40. to log in once at least user with an empty password Execution error cannot be specified Program execution Set a password for the function specified user OBBEh OBBFh OBCOh Check if the program specified 0 1 with the program execution OBC2h function is executable with the OBC3h specified account OBC4h OBC5h Install the latest version of DB 0BC6h DB connection service Connection Service to a server computer of the connection target To the next page 10 13 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION c e O 2 Q a 9 TERMINOLOGY 1 Q CONCISE ERROR CODE LIST MELSECKEY cries From the previous page 10 14 Error code Error name Action Error code Error name Action ocooh Please consult your local Please consult your local Mitsubishi representative Mitsubishi representative to System error n FFDOh System error M 0 56 explaining a detailed explaining a detailed description of the problem description of the problem Check if the CompactFlash FFDih Monitor condition Delete the monitor condition by card is damaged dissatisfied error GX De
41. 0 10 15 Action eset eme ed eee 8 7 Action type ee 8 10 9 4 Add button 8 3 8 4 8 5 8 6 8 7 8 8 8 9 B Bar code reader 1 4 Basic software 3 2 5 3 9 8 C CAI 9 1 9 7 COLIN eu 1 3 1 4 10 9 10 14 CGO LinleIE 1 10 9 10 14 Communication action DNO MEET 8 7 8 10 9 3 9 4 10 20 10 21 11 1 Communication gateway 3 1 Communications action 8 9 Configuration computer 3 1 4 1 9 5 11 2 Configuration 1 3 1 1 1 2 Gross cable upecao 3 1 4 1 D 1 1 Data source name 7 1 7 2 10 19 10 20 11 2 Data type 6 1 6 3 6 5 6 6 10 10 10 21 11 2 Database name 7 1 7 2 6 1 6 5 DB Connection service setting tool P PA 1 4 5 1 5 6 9 6 9 8 10 16 10 17 10 18 10 19 DB connection service setting tool 3 1 Design 6 2 6 3 6 4 6 5 6 6 Device tag 8 3 8 4 9 1 9 2 9 3 9 4 Device tag setting 8 3 8 4
42. 00002 Failed to start the service computer due to insufficient resources Please consult your local Mitsubishi representative 0x20100010 System error explaining a detailed description of the problem Service Not Start If firewall software has 0x20100011 Failed tosan the service beeni installed set the due to failure of the server specified server port port initialization operational Terminate the application Service Not Start a 0x20100012 Another application has opened the server port bed anonier No with DB Connection Service Setting Tool Please consult your local Mitsubishi representative 0x20100013 System error explaining a detailed description of the problem Not Initialize a service for Terminate any IF unnecessary applications 0x20200001 Failed to initialize a service memory to the for each client due to computer insufficient memory Deny network connection Using DB Connection request from IP address Service Setting Tool add 0x20200002 Rejected the connection the IP address to those request from the non with connection permitted IP address permission Please consult your local Mitsubishi representative 0x20200003 System error explaining a detailed description of the problem SID Session ID Request Terminate any Receive Error IP address unnecessary applications 920890001 Failed to
43. CONCISE ERROR CODE LIST MELSEC 2 SQL failure log When an error occurs while executing SQL statements in the database the error details are output to the SQL failure log SQL failure log details are shown below For details on Database error number and Database cause of error message in the output log format at the time of failure check each database s manual Depending on the Error code the Database Messages below may not be output Check the error and take corrective action according to the error code Item Description Date Error Code Connection target data source SQL statement Database Message Database error number Database cause of error message 2007 10 01 12 00 00 000 0xL00000000 DataSource INSERT INTO TABLE COL VALUES gt Database Message 0xL00000388 Oracle ODBC Ora ORA 00904 COL invalid identifier Output log format Example 10 8 1 0 CONCISE ERROR CODE LIST The error code list is shown below 10 3 Error Code List 10 3 1 Error codes for the MES interface module Error code Error name Action Please consult your local Mi ishi representati 0001h System error 006 di rails explaining a detailed description of the problem Correct Access target CPU settings Response time out 0002h As Check the communic
44. Changes for the Better MITSUBISHI ELECTRIC Mitsubishi Programmable Controllers MES Interface Module Quick Start Guide EXAMPLE SYSTEM OUTLINE INTRODUCTION REQUIRED EQUIPMENT FOR START UP EQUIPMENT SETUP SOFTWARE INSTALLATION U CREATING ST ART N Guide YS MES INTERFACE CONFIGURATION FAQs CONCISE ERROR CODE LIST TERMINOLOGY INDEX CONTENTS ES 1 FURTEER READING REFERENGE LIST CHAPTER1 INTRODUCTION 1 1to1 4 WA Database Overview ocu e ed ene a ee 1 1 1 2 MES Interface Module Overview 1 3 CHAPTER2 EXAMPLE SYSTEM OUTLINE 2 1 CHAPTER 3 REQUIRED EQUIPMENT FOR START UP 3 1to3 2 CHAPTER 4 EQUIPMENT SETUP 4 1to4 2 CHAPTER5 SOFTWARE INSTALLATION 5 1to5 6 Installation ROSE peo 5 1 CHAPTER6 CREATING A DATABASE TABLE 6 1t06 6 631 General Description ipiis code Ee E a e E e e dod 6 1 6 2 OrderTable Creation ati atti dai the Debe aia en A ie 6 1 6 3 History Table enne nnne nnnm 6 5 CHAPTER7 ODBC SETTING 7 1to7 3 CHAPTER 8 MES INTERFACE CONFIGURATION 8 1to 8 13 8 1 General Description a 8 1 8 2 Sp cifying Parameters ene eae ea a ee 8 3 8 3 Operational Check
45. DATABASE TABLE Exit Which software is MES Interface Function Configuration Tool ODBC SETTING DB Connection Service and Setting Tool Enter user information Enter the product ID Select the installation destination Enter user information Enter the product ID MES INTERFACE CONFIGURATION Select the installation destination FAQs Installation CONCISE ERROR CODE LIST Installation complete Point If a confirmation message for overwriting DLL files is displayed at installation click TERMINOLOGY the button and overwrite the DLL files Not overwriting the DLLs may fail to execute MX MESInterface correctly 5 SOFTWARE INSTALLATION 2 MX MESInterface installation For system configurations refer to the following EJ Point 1 When installing MX MESInterface log on as a user with Administrator authority 2 Before installing MX MESInterface close any other applications running on Windows 3 Updates for the OS or software from other companies such as Windows Update or java applets automatically restart the computer and in some cases the installer will not operate normally Install the software after changing the settings so that updates do not automatically restart the computer eb Start Windows Explorer then click the drive in which the CD ROM is loaded
46. ED EXAMPLE EQUIPMENT FOR START UP EQUIPMENT SOFTWARE SETUP CREATING A MES INTERFACE CONFIGURATION CONCISE ERROR CODE LIST Q o 2 e SYSTEM OUTLINE DATABASE TABLE INSTALLATION ODBC SETTING FAQs TERMINOLOGY 2 EXAMPLE SYSTEM OUTLINE CHAPTER 2 EXAMPLE SYSTEM OUTLINE This section describes the process of building a simple data collection system using the MES Interface unit Machining Stamping Inspection m Our example uses metal parts manufacturing line automated by MELSEC and the MES Interfaces Machining Station Executes machining processes that convert blanks into finished parts Stamping Station Imprints a lot code and unique serial number on the surface of each finished part Inspection Station Measures the weight of each completed parts Interactions between the control system and production database are as follows 1 Acquiring Production Scheduling Information Database MES Controller Before starting production the MES Interface acquires the target production quantity and lot ID code from a table in the production control database Then part manufacturing occurs according to the target quantity The Lot ID code is added as a prefix before the serial number is stamped on each part Delivering As produced Information Controller gt MES Database After each part exi
47. ES implementation and operation by providing a high quality high function link to the factory equipment Setup of the MES functions is made using PC based configuration software For most applications no computer language programming or control logic programming is required The person making setup need not know SQL language or XML language because setup is made in a menu driven format and deeper technical aspects are handled automatically The idea is that standard engineering or IS staff can easily handle initial setup and subsequent modification of the MES Interface configuration The general setup procedure is simple 1 Associate map controller data devices to the appropriate fields or records in the database table s 2 Set trigger conditions under which data are to be collected and transferred 3 Build transactions associating triggers with the specific data and action The MES Interface provides enhanced functions beyond simple data transfer that provide significant benefits Store and forward buffering of transactions when the database connection is lost supports zero data loss and guaranteed information delivery One MES Interface can transact data with up to 32 database connections and it can route communications to remote MELSEC systems via CC Link IE MELSECNET 10 H Ethernet and CC Link including support for legacy controller lines Communications between the MES Interface and the host computer system occur in a secure encr
48. FTWARE INSTALLATION ALS a6 5 5 From the previous page Register the product ID Input ProductiD Enter the product ID then click the Next gt Please enter the product ID of the product i Please input in single byte English characters button 29 5 ees 35 lt Back Cancel T Choose Destination Location E3 Specify the folder for installation destination The setup will install SWnDNC MESIF in the following directory When using the default folder click the Next Click Next to install in this directory Browse and select the directory for installing in other butto n tory Click Cancel for not installing 4 tt lt 5 EX e To change the folder click the Browse button then specify the drive and folder for installation 5 destination F ac Destination Folder Poi nt 5 Browse Up to 100 characters including MESIF can be used for the installation destination This means 8 that up to 94 characters can be used when specifying a destination folder as a directory When the left screen appears installation is Information MES INTERFACE CONFIGURATION complete Completed the installation of this product Click the button E To restart the computer check
49. ID Reset field names and Select Failed Update conditions Failed in SQL execution Also set a correct data type for the data entered in the fields Please consult your local Mitsubishi representative 0x20600024 System error explaining a detailed description of the problem To the next page 10 19 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION FAQs e 5 2 CODE LIST TERMINOLOGY Q CONCISE ERROR CODE LIST Error description and Error code 0x20700020 Error description cause ProgramExec IP address lt gt Failed Failed to log on in remote execution From the previous page Corrective action Set correct user name and password in Server service settings of MES Interface Function Configuration Tool Check if the user account is invalid or not by the administrative tool of Windows Check if the setting is forcing the user to enter password at next logon by the administrative tool of Windows Check if the user password is expired or not by the administrative tool of Windows 0x20700021 ProgramExec IP address lt gt Failed Failed to load user profile during remote execution No user pro
50. Interface Function Configuration Tool 1 Common to all settings Symptom Unable to connect MES Interface Function Configuration Tool to the MES interface module Checked item Is there any disconnection in the connection route Is the IP address setting correct Is the user name and password setting correct Corrective action Connect the cables properly Correct the IP address setting Correct the user name and password setting Is the IP address duplicated Correct the IP address setting Is there a firewall and or a proxy server in the connection route Ask your network administrator about the firewall and proxy server settings Is the MES interface module connected to the network Network connection status X4 ON Connect the MES interface module to the network Is it in Online mode Change the mode to Online Is there any problem on the computer Replace it with another computer MES Interface Function Configuration Tool will not start Have five MES Interface Function Configuration Tools already started Terminate any of the MES Interface Function Configuration Tools and then start another Up to five MES Interface Function Configuration Tools can be started Unable to import a project file The specified project file is incorrect or corrupted Specify a correct project file Is there any inconsistency in the setting Che
51. P address to 192 168 3 1 Change this setting in the Internet Protocol TCP IP Properties dialog box Example If the Microsoft Windows XP Professional operating system is used Internet Protocol TCP IP Properties You can get IP settings assigned automatically if your network supports this capability Otherwise you need to ask your network administrator for the appropriate IP settings Obtain an IP address automatically Use the following IP address IP address 192 168 Subnet mask aaa 2997 10 Default gateway Use the following DNS server addresses Preferred DNS server Alternate DNS server REQUIRED EXAMPLE SYS EQUIPMENT FOR START UP INTRODUCTION TEM OUTLINE A 2 Fa 5 Ow SOFTWARE CREATING A MES INTERFACE CONFIGURATION CONCISE ERROR CODE LIST DATABASE TABLE INSTALLATION ODBC SETTING FAQs TERMINOLOGY 4 EQUIPMENT SETUP 2 MES Interface Module QJ71MES96 Mount the MES interface module in a slot other than the base module CPU slot Mount the Compact Flash card in the MES interface module Compact Flash card mount slot The Compact Flash card is formatted using the format function of the information linking function configuration tool Do not format the Compact Flash card in Windows In the event of accidentally formatting the Compact Flash card in Windows reformat following the
52. PU s on the access route 0087h Please consult your local Mitsubishi representative to System error es explaining a detailed 0089h description of the problem 00D2h RUN time disable error Check the CPUs onthe access route Error code Error name Action Please consult your local Mi ishi representati 00D4h System error 15058 bs Fais explaining a detailed description of the problem Receive data length 00D7h eror Check the cables on the access route 00D8h Protocol error 00D9h Address error Check the CPU s on the OODBh Write error access route Check the station number OOEOh Station No error setting in Access target CPU settings Check the PLC series in OOEth Processing mode error 9 Access target CPU settings Intelligent function Correct buffer 00E2h module specification memory data in Device tag error settings Check the CPU s on the OOE3h Other data error 9 access route Check the access route 00E4h Link specification error referring to the accessible range Please consult your local Mi ishi representati 00 8 System error 058 explaining a detailed description of the problem O0E9h Link timeout Reconnect the access target on the access route Examine the hardware of the OOEAh Special module BUSY intelligent or special function module 00 Access target BUSY Check the access target O0FOh Link error perd the link to connec
53. R CODE LIST TERMINOLOGY FAQs MELSEC 9 1 2 When using DB Connection Service Setting Tool This section explains troubleshooting information on the setting of DB Connection Service Setting Tool Symptom Unable to start Connection Service Setting Tool Checked item Has another DB Connection Service Setting Tool been already started Corrective action Terminate the already started DB Connection Service Setting Tool Only one DB Connection Service Setting Tool can be activated Unable to reflect the setting Was a user ID having the administrator authority used for the login Log in again with a user ID having the administrator authority Is there no permitted IP address Uncheck the Limit IP addresses permit to connect checkbox or add an IP address for which connection is permitted Unable to export a file Is there no permitted IP address Uncheck the Limit IP addresses permit to connect checkbox or add an IP address for which connection is permitted An access log output error is recorded in Event Viewer of Administrative Tools in Windows Is the file set in Output destination read only Correct the file specification Is the access to the folder containing the file set in Output destination authorized Check the right of access to the folder Is the drive space of the server computer full Check the
54. S Summary An error message and system information is displayed 28 1 When using SNTP with synchronized time the time of the No 1 CPU will displayed for the interval from module startup until the time query to the SNTP server succeeds 2 Date will not be displayed for errors information occurring before the time from the No 1 CPU is obtained 3 Error codes will not be displayed in the case of system information 2 Error code updates Clicking the Update button will update the error codes e Q 2 s e 9 3 Error log clear e Clicking the Clear History button will clear the error log TERMINOLOGY 10 1 1 Q CONCISE ERROR CODE LIST MELSEC ries 10 2 Viewing Server Computer Error Codes The method of checking server computer error codes is shown below 1 DB connection service access log Open the log file below with a text editor and check the error codes C MELSEC MESIF dbConnector log 2 DB connection service SQL failure log Open the log file below with a text editor and check the error codes C MELSEC MESIF sq Failed log 3 Windows event log 9 Select Start a Control Panel from the Windows Start menu to display the Control Panel e Select Performance and Maintenance a Administrative Tools to display Administrative Tools Double click on Event Viewer check the DB connection service error codes check
55. SE ERROR CODE LIST Database connection disconnection For details on Database error number and Database cause of error message in the output log format at the time of failure check each database s manual Depending on the Error code the Database Messages below may not be output INTRODUCTION Check the error and take corrective action according to the error code ea Connection 29 Item Description Output Success Date Error Code SID Section IDJ DB Connect Connection target data source Connection ID Success z eo tomar esie Date Error Code SID Section ID DB Connect Connection target data source Connection ID Failed dE Database Message Database error number Database cause of error message Success 2007 10 01 12 00 00 000 0xL00000000 SID 00000001 DB Connect DataSource ID Success noe Bengle 2007 10 01 12 00 00 000 0xL20400022 SID 00000001 DB Connect DataSource ID Failed Failure Database Message 0xL00000319 Oracle ODBC Ora ORA 01017 invalid username password logon denied 5 Disconnection Description Output Success Date Error Code SID Section ID DB Disconnect Connection target data source Connection ID Success log format Failure Date Error Code SID Section ID DB Disconnect Connection target data source Connection ID Failed E Database Message Database error number Database cause of error message
56. a Bangkok 10120 Thailand Indonesia P T Autoteknindo Sumber Makmur Tel 62 21 663 0833 Muara Karang Selatan Block A Utara No 1 Kav No 11 Fax 62 21 663 0832 Kawasan Industri Pergudangan Jakarta Utara P O Box 5045 Jakarta 11050 Indonesia India Messung Systems Pvt Ltd Tel 91 20 2712 3130 Electronic Sadan Unit No15 M I D C Bhosari Pune 411026 India Fax 91 20 2712 8108 Australia Mitsubishi Electric Australia Pty Ltd Tel 61 2 9684 7777 348 Victoria Road Rydalmere N S W 2116 Australia Fax 61 2 9684 7245 L NA 16013E A 0807 MEE NAGOYA WORKS 1 14 YADA MINAMI 5 HIGASHI KU NAGOYA JAPAN afa MITSUBISHI ELECTRIC CORPORATION HEAD OFFICE TOKYO BUILDING 2 7 3 MARUNOUCHI CHIYODA KU TOKYO 100 8310 JAPAN When exported from Japan this manual does not require application to the Ministry of International Trade and Industry for service transaction permission New publication effective Jul 2008 Specifications subject to change without notice
57. ace Module The guide is broken down into an example system setup and maintenance sections For further reading please refer to the associated users and hardware manuals provided by Mitsubishi Electric 1 1 Database Overview This section provides general information on databases that the MES Interface uses as a source or destination for information exchanged with MELSEC controllers For this example a database is defined as software which provides a virtual filing system for storing groups of related data It also provides a set of commands that enable access editing and manipulation of the stored data The following are some examples of practical functions that may occur in a database During processing of a set of data items an error occurs In response the user might apply a rollback command that restores the data to its original state While certain stored data items are being retrieved in one process new data arrive that need to be stored in a second process The database should handle completion of both actions without conflict or user intervention researcher desires to retrieve a specific set of 15 data items that was originally stored in the database on July 15th at 2 30 AM 5 years ago The user will create a query or command structure that the database understands as a request for data retrieval The database will return the specified information when the query is executed There are various database types includ
58. ange the item or add an item Since the control CPU is set as the first item deletion or setting change is not allowed for it Only the CPU name can be changed Is the selected item used in Device tag settings As the error dialog box appears identify the location stop using it for another item and then delete the item An item used for another item is unable to be deleted FAQs 4 Device tag settings Symptom Unable to change or delete an item in Device tag settings Unable to set or change Device tag name Checked item Is the selected item used in Job settings Is the selected item used in DB buffering settings of System setting Is the selected item used in Access error notification setting of Server service settings Is the same name used for Server service name or another Device tag name Corrective action As the error dialog box appears identify the location stop using it for another item and then delete the item An item used for another item is unable to be deleted Because a unique name must be used for Server service name and Device tag name use a different name Unable to select High speed sampling Is High speed sampling selected in another Device tag settings Uncheck the High speed sampling checkbox in the Device tag settings Registration of High speed sampling is limited to on
59. ation cable status and access target CPU status 0041h Please consult your local Mitsubishi representative to System error a 0044h explaining a detailed description of the problem Check the CPU s on the 0045h Processing code error S access route Check the station number Station No T 0046h am setting in Access target CPU Specification error settings Check the CP n th 0047h Receive data error ONEEK ME GREIS access route 0048h 0049h Please consult your local 004Dh Mitsubishi representative System error vci 004Eh explaining a detailed 0050h description of the problem 0051h Check the Ethernet module 0055h Channel No error setting of the access target CPU Please consult your local Mi ishi representati 0064h System error itsubishi representative explaining a detailed description of the problem Set routing parameters to the 0065h Routing parameter CC Link IE MELSECNET H error and or MELSECNET 10 module s 0066h Data send error Cities 0067h Data receive error onthe access route 0080h Read size error Correct the device type entered 0081h Device type error ee in Device tag settings 0082h Device error Correct the number entered in Device tag settings 0083h Device point error Check the CPU s on the 0084h Write size error access route Set a correct link parameter for 0085h Link parameter error the programmable controller C
60. ation field Click the OK button When the following dialog box appears select No Microsoft Office Access key isnt required it s highly recommended A table must have a primary key for you to define a relationship between this table View create Mese Next select OrderTable and click the Open reate table by entering data button to bring it up to the screen When the table shows up enter data as shown below Upon the completion of data entry close the table Orderlable Table OrderCode Record 6 CREATING A DATABASE TABLE 6 3 History Table Creation History table is created in a similar way to the OrderTable Start l Sample DB Database Access 2000 file format Desin New X 22 Objects Queries Forms Reports Pages Macros Modules Groups Ga Favorites table in Des Create table by using wizard Create table by entering data OrderTable Table Table Description Field Properties General Lookup Field Size Format Input Mask Caption Default Value Validation Rule Validation Text Required Allow Zero Length Indexed Unicode Compression IME Mode IME Sentence Mode Smart Tags The maximum number of characters you can enter in the field The larg
61. b Settings and click the Add button 5 C AMELSEC My Projects SampleProjec Project Edit Online Help c Access target CPU settings fff controiceu 3 Device tag settings GettingData PuttingData Server service settings SampleServer ees GettingPlan Enter Reporting into the Job Name field and specify trigger conditions as shown below a C MMELSECMMy Projects SampleProject mup MES interface function configuration tool Project Edit View Online Help s BMA 5 NewProject System setting XD nae Reporting Enable at module startup Startup logging Access target CPU settings Trigger buffering Testmode is ControlCPU Trigger conditions 4X Device tag settings Combination fano gt The job starts when the trigger conditions GettingData ange alse to true PuttingData Value monitoring startup Server service settings sampleserver Tag Component Condition Tag Type Component 29 Job settings GettingData ReportingTrigger Constant GettingPlan Reporting Trigger 2 Disable Ed Actions Type Summary Setting item Setting description Setting method Job name Reporting Text input Enable at module startup Place checkmark Checkmark Trigger buffering Place checkmark Checkmark First condition Value monitoring startup Trigger condition Condition Tag Type Compon
62. ce IP 0x20400021 System error explaining a detailed description of the problem Set correct data source SID Session ID DB name user name and Connect Data source password in Server User Failed service settings of MES Failed in DB connection Interface Function Configuration Tool 0x20400023 70520500011 your ee l Mitsubishi representative Cewe System error explaining a detailed description of the problem 0x20500022 SID Session ID SQL lt gt Failed SID Session ID COMMIT Failed SID Session ID ROLLBACK Failed 0x20600001 sip Session ID GetNext Failed SID Session ID Reset Failed Failed in SQL execution due Terminate any to insufficient memory unnecessary applications SID Session ID SQL Add more memory to the Failed computer SID Session ID COMMIT Failed SID Session ID ROLLBACK Failed 0x20600002 sip Session ID GetNext Failed SID Session ID Reset Failed Failed in SQL execution due to insufficient resources SID Session ID SQL lt gt Failed SID Session ID COMMIT Failed SID Session ID EOS E Check if the source IP 0x20600010 address belongs to the SID Session ID GetNext MES interface module Failed SID Session ID Reset Failed Invalid SQL execution request Please consult your local CANS Mitsubishi representative S
63. ck the setting and correct it if any Did the number of settings exceed the upper limit Check the number of settings Unable to import a CSV file Is the CSV file description correct Correct the CSV file description Is there any inconsistency in the setting Check the setting and correct it if any Did the number of settings exceed the upper limit Check the number of settings Device tag name is not displayed for the setting item by which data are written to a tag All the text is not displayed in a table The text display is truncated Is the tag set to data write disabled Is the column to narrow Set the tag to data write enabled Adjust the column width of the table EQUIPMENT FOR REQUIRED START UP EQUIPMENT SETUP SOFTWARE INSTALLATION CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION FAQs CONCISE ERROR CODE LIST TERMINOLOGY FAQs 2 System setting Symptom A desired device tag name is not displayed in DB buffering settings Checked item Is the tag set to data write disabled Corrective action Set the tag to data write enabled 3 Access target CPU settings Symptom Unable to change or delete an item in Access target CPU settings Checked item 5 it the first item Corrective action If itis any item other than the first one ch
64. d Terminate the job that is in execution or use another Server service settings item If a job uses the same Server service settings item that is currently used for another job the job is not executed until another job execution is completed Has an error or job cancellation occurred during job execution If an error has occurred identify the error cause and take corrective actions When the job uses a tag component for which Moving average Moving maximum or Moving minimum is specified check if sampling for the specified number of times is completed 9 10 To the next page FAQs Symptom The program specified by the program execution function is not executed Checked item Has an error occurred in Error log of Working log From the previous page Corrective action f an error has occurred identify the error cause and take corrective actions Was the Windows account specified in Server service settings used to log on the application server computer once or more Use the account that has been used to log on once or more An account that has not been used before cannot be used Was the password of the Windows account specified in Server service settings set empty Set a password of the account or use another account that does not have an empty password An account that has an empty password cannot be used
65. database or any other application Change the port number to another that is not being used for the database or any other application Has any Check Point software been installed in the server computer Uninstall the Check Point software Is the ODBC setting of the database correct Correct the ODBC setting of the database In the tag component where statistical processing is set the average maximum or minimum value to be calculated is reset Is there any setting that enables data writing to the tag component where statistical processing is set Disable the write setting Writing data to the tag component where statistical processing is set will reset the statistical values To the next page FAQs Symptom Values will not be stored in the database Checked item Has an error occurred in Error log of Working log From the previous page Corrective action error has occurred identify the error cause and take corrective actions When trigger conditions of a job with Startup logging setting are met is the startup logged in Event log of Working log If no startup data is logged refer to the following Refer to the symptom item Job will not start up If the startup log is identified in the above case is there an error in Error log of Working log In Change job status of Remote operation is Disable wr
66. de number ane Date Error Code SID Section ID SQL lt SQL statement gt Failed Database Message Database error number Database cause of error message Success 2007 10 01 12 00 00 000 0xL00000000 SID 00000001 SQL lt UPDATE TABLE SET COL 1 gt Success 1 Example Failure 2007 10 01 12 00 00 000 0xL20600023 SID 00000001 SQL lt UPDATE TABLE SET COL COL gt Failed Database Message 0xL000006ba Oracle ODBC OraJORA 01 722 invalid number INSERT Item Description Output Success Date Error Code SID Section ID SQL lt SQL statement gt Success insert code number Date Error Code SID Section ID SQL lt SQL statement gt Failed Database Message Database error number Database cause of error message ee 2007 10 01 12 00 00 000 0xL00000000 SID 00000001 SQL lt INSERT INTO TABLE COL VALUES Example 1 gt Success 1 Failure 2007 10 01 12 00 00 000 0xL20600023 SID 00000001 SQL lt INSERT INTO TABLEE COL VALUES 1 gt Failed Database Message 0xL000003ae Oracle ODBC Ora ORA 00942 table or view does not exist 1 0 CONCISE ERROR CODE LIST COMMIT Item Description Success Date Error Code SID Section ID COMMIT Success Date Error Code SID Section ID COMMIT Failed Database Message Database error number Database cause of error message INTRODUCTION Output log format Failure
67. e MES interface module QJ71MES96 Cables must be compliant with the standard of IEEE802 3 10BASE T 4 100BASE TX Use straight cables when using a hub or use a crossing cable when not g using a hub Qa 28 88 gt 8 2 3 REQUIRED EQUIPMENT FOR START UP Microsoft Access 2003 Basic software that is run on a server computer and used to create a sample database provided in this guide A programmable controller CPU system that uses the MES interface module For applicable CPU modules quantity and base units refer to MES Interface Module User s Manual An integrated programming tool for performing design debugging and maintenance of sequence programs for programmable controller CPUs By using this sequence program monitoring program or data modification during program execution and ON OFF of inputs outputs are also available For the operation method refer to GX Developer Operating Manual 4 EQUIPMENT SETUP CHAPTER 4 EQUIPMENT SETUP Components required to build a sample system are shown below MES interface module Twisted pair cable cross cable Ethernet Computer 192 168 3 3 192 168 3 1 or MES interface module Twisted pair cable straight cable Computer 192 168 3 1 192 168 3 3 1 Computer Install the Microsoft Access 2003 on the computer concerned Set computer I
68. e tag only Is any other than the first item Control CPU in Access target CPU settings selected in CPU name in Component setting input Delete the component setting with selection of any other than the first item or change the setting so that the first item will be used for it If High speed sampling is selected only the first item in Access target CPU settings Control CPU can be selected for the tag component Is the number of device points set in the tag setting more than 96 Reduce the number of device points in the tag setting to 96 or less When High speed sampling is selected set tag component devices within the total of 96 points Unable to change the Prohibit data writing setting Is the tag used for a setting item by which data are written to the tag Completion notification of Handshake operation substitution tags of Select in Communication action etc 5 Server service settings Symptom Unable to set or change Server service name Checked item Is the same name used for another Server service name or Device tag name Stop using the tag for the setting item by which data are written to the tag before changing the setting If the tag is used for a setting item by which data are written to the tag unchecking the Prohibit data writing box is not allowed Corrective action Because a unique name must be used for Server service name and D
69. ecified 0A07h enquiry error SNTP server computer 8 0405 4 Replace the CompactFlash to Setting read error 0 Install CompactFlash card OAOFh CF access stopped Turn the power OFF and ON error or reset the programmable controller CPU OA11h No CF card installed OA12h CF directory operation error Install a CompactFlash card Transferred setting file OA13h check error 0A14h Setting file check error Please consult your local OA80h SORE Mitsubishi representative to System error 222 0A83h explaining a detailed description of the problem Check the actions in Job settings 0A84h Illegal action setting In Job List of Remote error operation the job having any illegal action can be checked Such a job is not displayed Please consult your local OBOOh Mitsubishi representative to System error E OBOAh explaining a detailed description of the problem OBOBh Replace the CompactFlash Setting read error P P card OBOCh Check the Ethernet connection Check if Server service DB connection service OBODh communicatiometror settings is correct Check if the ODBC setting is correct PI local OBOEh ease consult your oca Mitsubishi representative to System error w OB1Eh explaining a detailed description of the problem Change the setting so that type OB1Fh Type conversion error conversion will be available in any case
70. ent List selection GettingData ReportingTrigger Constant ON Next specify an action Select Operation action in the list box as shown below and click the Add button Actions Type Summary POSEEN tls EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR REQUIRED START UP EQUIPMENT SOFTWARE SETUP CREATING A DATABASE TABLE INTRODUCTION INSTALLATION ODBC SETTING uz oo cr c EO z Ee d 35 20 CONCISE ERROR CODE LIST FAQs TERMINOLOGY 8 MES INTERFACE CONFIGURATION 26 Q series Specify the aspects of operation action as shown in the diagram below Operation action Substitution tag Component Operation tag Component Operator Operation tag Component Variable Conversion lt lt GettingData Weight q l Number 1000 lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt t Delete row Tag component data length in job 4 words total Setting item Setting description Setting method List selection Substitution Operation Operation ian Component t n Component Operator Component Substitution tag mponen ration 1 Variable Conversion GettingData Weight Number 1000 ce t Ope 2 5 a Componen Operation action 1 2 3 4 9 1 2 Operator Operation tag 3
71. error COMMIT execution Check the sent SQL text and OBA9h Sor database contents ROLLBACK Check if the table and field OBAAh settings are correct error OBABh DB update error Check the sent SQL text and database contents Check if the table and field settings are correct OBACh SQL execution error 9 Check if the uniqueness constraint of the database PRIMARY KEY constraint is violated or not 50 OBADh error during SQL a Check if the table and field execution settings are correct OBAEh Please consult your local Mitsubishi representative to System error OBBSh explaining a detailed description of the problem OBB6h Execution error Program execution OBB7h function Check if the program specifie Specified program file prog with the program execution OBB8h not exist Program dy function is executable with the execution function ji specified account Specified program file OBB9h duplicated Program execution function OBBAh Check if the program specified error with the program execution CREED Program execution 9 function function is executable with the OBBCh specified account Check if the program specified with the program execution function is executable with the specified account After creating an account used OBBDh for the program execution function be sure
72. est maximum you can set is 255 Press Fl for help on field size Phrase Predict Table1 Table Field Name Data Type Description SerialCode Date Time Text Date Time Field Properties General Lookup Format Input Mask Caption Default Value Validation Rule Validation Text Required Indexed IME Mode IME Sentence Mode Smart Tags The data type determines the kind of values that users can store in the field Press F1 for help on data types Phrase Predict To the next page The operation of the DB interface function is shown below When the screen for table properties Design Review appears enter into the first line SerialCode as field name Text as data type and 6 as field size Enter into the 2nd line Date Time as field name and Date Time as data type REQUIRED EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT SETUP SOFTWARE INTRODUCTION INSTALLATION lt 2 MES INTERFACE CONFIGURATION CONCISE ERROR CODE LIST E 7 lt g lt ODBC SETTING FAQs TERMINOLOGY 6 CREATING A DATABASE TABLE MELSEC e From the previou page 4 Enter into the 3rd line Weight_mg as field name Number as data type and Single as field size
73. evice tag name use a different name Unable to change Server type Is the Server service name same as the existing one Correct the Server service name A desired device tag name is not displayed in Access error notification setting Is the tag set to data write disabled Set the tag to data write enabled INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR REQUIRED START UP EQUIPMENT SETUP SOFTWARE INSTALLATION CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION FAQs CONCISE ERROR CODE LIST TERMINOLOGY FAQs 6 Job settings Symptom Unable to set DB buffering settings Checked item Is there any Select action set for the job Corrective action Do not use Select actions in the job where DB buffering is enabled The DB buffering is not available for jobs performing Select actions Unable to set a new variable Are there 64 variables that were already defined in the job Delete any unnecessary variable settings of the job Up to 64 variables can be set for one job Unable to select Trigger 2 in Trigger conditions Is Handshake operation selected for Trigger 1 Select any other than Handshake operation for Trigger 1 When Handshake operation is selected selection is not allowed for Trigger 2 A desired device tag name is not displayed
74. factured as a general purpose part for general industries and has not been designed or manufactured to be incorporated in a device or system used in purposes related to human life Before using the product for special purposes such as nuclear power electric power aerospace medicine or passenger movement vehicles consult with Mitsubishi This product has been manufactured under strict quality control However when installing the product where major accidents or losses could occur if the product fails install appropriate backup or failsafe functions in the system unpredictable by Mitsubishi damages to products other than Mitsubishi products and to other duties Country Region Sales office Tel Fax U S A Mitsubishi Electric Automation Inc Tel 1 847 478 2100 500 Corporate Woods Parkway Vernon Hills IL 60061 USA Fax 1 847 478 2496 Brazil MELCO TEC Rep Com e Assessoria Tecnica Ltda Tel 55 11 3262 4759 Rua Correia Dias 184 Edificio Paraiso Trade Center 8 andar Fax 55 11 288 3047 Paraiso Sao Paulo SP Brazil Germany Mitsubishi Electric Europe B V German Branch Tel 49 2102 486 0 Gothaer Strasse 8 D 40880 Ratingen Germany Fax 49 2102 486 1120 U K Mitsubishi Electric Europe B V UK Branch Tel 44 1707 276100 Travellers Lane Hatfield Hertfordshire AL10 8XB U K Fax 44 1707 278992 Italy Misubishi Electric Europe B V Italian Branch Tel 39 039 60531 Viale Colleoni 7 20041 Agrate Brianza Milan
75. fields in project 6 Tag component data length in job 4 words total Setting item Setting description Setting method Action type Insert List selection Table name History Text input Field name Component Text input DB tag link 1 SerialCode GettingData SCode Field name settings 2 Module time List selection 3 Variable Conversion Tag Upon the completion of the setting operation save associated parameters Select Projects on the menu bar and then click Save As 5 C MELSEC My Projects SampleProjec 19288 Edit View Online Help New Ctrl N Open Ctrl O Save Ctrl S Import gt Export Recent files Exit Job settings n GettingPlan mmm 8 10 EXAMPLE SYS EQUIPMENT FOR REQUIRED START UP EQUIPMENT SOFTWARE SETUP CREATING A DATABASE TABLE INTRODUCTION TEM OUTLINE INSTALLATION ODBC SETTING uz oo cc zo 35 o CONCISE ERROR CODE LIST FAQs TERMINOLOGY 8 MES INTERFACE CONFIGURATION Enter Sample Config into the File Name field and save the project Save As Savein MyPriects File name Sample Confid mup Save as type MES interface function project file Cancel Select Menu Online a Remote operation e When the transfer setting screen in the diagram below is shown
76. file for Windows has been created With the server service setting set in MES Interface Function Configuration Tool log on Windows once and reexecute 0x20700022 System error Please consult your local Mitsubishi representative explaining a detailed description of the problem Error code Corrective action cause SID Session ID SQL lt gt Failed ID ion ID COMMIT Be UP re Select Job settings Communication action in SID Session ID MES Interface Function ROLLBACK Failed Configuration Tool and set 0x20600025 SID Session ID GetNext 9 Failed update conditions correctly 2190 Check if the database has SID Session ID Reset been filled with registered Failed data No record was updated or inserted by the SQL execution Please consult your local 0x20600026 Mitsubishi representative to System error Jo 0 2060002 explaining a detailed description of the problem po ession ID Check if it is connected to Transmitting Commit 5 R nse Failed the network Check if the gateway and or 0x2060002B hub is operating Failed to transmit the Check if the power of the COMMIT success module is not turned off response ProgramExec IP address 0x20700001 lt gt Failed Failed in remote execution E Terminate any unnecessary due to insufficient memory Ke Exec TIP add applications P
77. he MES interface module Is the number of databases set for the database server computer sufficient Correct the set number of databases or change the number of Server service settings items to the set number of databases One database connection must be used for one item of Server service settings Job will not start up Has an error occurred in Error log of Working log If an error has occurred identify the error cause and take corrective actions Did the Trigger conditions change from false to true completely Correct the Trigger conditions Start the job when the Trigger conditions change from false to true Did the Combination of Trigger conditions change from false to true completely Correct the Trigger conditions Start the job when the Combination of Trigger conditions change from false to true When Value monitoring startup is set for Trigger conditions is the time for the monitoring target device value change long enough for the sampling interval of the device tag Increase the time for the monitoring target device value change Latch it in the sequence program Shorten the sampling interval of the device tag In Change job status of Remote operation is the job set to be disabled Enable the job To enable the job at startup of the module select Job settings Enable at module startup Is there any other ob that is being execute
78. iation for Manufacturing Execution Systems Systems for controlling and monitoring the plant status in real time to optimize production MES activities The systems enable to speed up the responses to production plan and status changes that lead to efficient production processes and optimization of production activities ODBC Abbreviation for Open DataBase Connectivity Standard specifications for software to access databases Abbreviation for Simple Network Time Protocol SNTP Protocol for synchronizing computer time via a TCP IP network SNTP server computer Computer that provides time information to the MES interface module This computer can be shared with a server computer Abbreviation for Structured Query Language por Data manipulation language and used for relational database operations Abbreviation for Uniform Resource Locator Notation method for indicating the locations of information resources on the Internet Converts character strings into characters can be used in URLs URL encode This designates percent encoding defined by RFC3986 XML Abbreviation for eXtensible Markup Language Markup language for describing documentation data meanings and structures Item One setting group unit included each setting type for editing Designates the right to use the MES interface module or server computer or an ID necessary for their use Unit for processing defined in a job There are Communication action
79. ing relational hierarchical and XML The MES Interface operates with relational databases provided by Microsoft or Oracle Relational databases organize data into tables consisting of fields columns and records rows The contents in one database can range from one table to many thousands o T 8 Produect name H Number of modules No of modules scheduled for manufacture manufactured ecor 1 INTRODUCTION All common databases implement a standardized command format called SQL Structured Query Language SQL defines each command action a user can apply to operate the various database functions and the syntax for the command and response messages paragraph change The MES Interface implements certain of these commands For Acquiring data stored ina record one uses a Select command For placing data in a record one uses the Insert command For placing modified data in existing records one uses the Update command Of many SQL commands available these three cover direct data exchange between controllers and databases Creation of tables deletion of records and all other database operations must be implemented outside the MES Interface INTRODUCTION SYSTEM OUTLINE EXAMPLE EQUIPMENT FOR REQUIRED START UP Initial Table Structure Part Product
80. input the IP address user name and password and click the OK button The default settings are given below IP address 192 168 3 3 User name QJ71MES96 Password MITSUBISHI Transfer setup address 192 168 3 3 User name QJ71MES96 Password Connection test Cancel e The Compact Flash card is formatted with the following operations Formatting the Compact Flash card will erase all data on the Compact Flash card Back up required data before executing the following operations e Check the Compact Flash card operation format and click the Execute button to format the Compact Flash card Resend C Clear Execute CompactFlash card operation Format e Once formatting is complete click the Close button and close remote operation Turn the power of the programmable controller CPU from OFF to ON and restart the MES interface module 8 11 8 MES INTERFACE CONFIGURATION 9 8 3 Operational Check 5 2 8 3 1 General Description gy The procedure described in this section checks the results of the entire process from a5 writing parameters by the MES Interface Configuration Tool to starting QU71MES96 EB module to writing data into the database 5 8 3 2 Writing Parameters onto QU71MES96 Module TR Gs Sak Select On line on the menu bar and then click Write Write parameter settings established
81. instructions in the Compact Flash card manual 3 Sequencer CPU Write the following sequence program which simulates a metal part manufacturing line into the CPU Manufacturing code setting 1402 1 K2 D100 Stop operation when pecified number of modules manufactured is reached 12 gt 00 0200 1 GOEND Generate a signal at intervals of 10 seconds SMADO K50 34 TO 49 M RST T Generate a serial number MO 56 ft INC D H 00 K2000 02 H BINDA D2 D300 MOY D202 D300 Take weight measurements emulation NO 78 RND D10 D10 K30 011 K490 D12 D400 105 END 5 SOFTWARE INSTALLATION CHAPTER 5 SOFTWARE INSTALLATION INTRODUCTION This section explains how to install MX MESInterface function configuration software in each operating environment EXAMPLE SYS TEM OUTLINE In this guide the method when using Microsoft amp WindowsSXP Professional Operating System is explained When using other basic software OS refer to the MES Interface Module User s Manual 5 1 Installation EQUIPMENT FOR REQUIRED START UP This section explains how to install MX MESInterface EQUIPMENT SETUP 1 MX MESInterface installation procedure Installation start Execute SET UP exe Select the component to be installed F4 we Ta EE CREATING A
82. ion Production Number Plan Actual M7000 300 120 J581 583 500 500 EQUIPMENT SETUP 1 Add a new record to the table that has part number production schedule and production actual fields Insert command executed via the production scheduling software SOFTWARE INSTALLATION Part Production Production Part Production Production Number Plan Actual Number Plan Actual a M7000 300 120 M7000 300 120 g J581 583 500 500 Inserting data 581 583 500 500 2 lt amp CREATING A gt 10 30 0 2 After execution add the production actual count to the record Update command executed by the MES Interface moves production count from the controller to the database ODBC SETTING Part Production Production Part Production Production Number Plan Actual Number Plan Actual WB M7000 300 120 M7000 300 120 E J581 583 500 500 Updating data 581 583 500 500 10 30 0 EH10 30 12 28 Final Table Structure FAQs CONCISE ERROR CODE LIST TERMINOLOGY 1 INTRODUCTION 1 2 MES Interface Module Overview The MES Interface provides a highly reliable and easy to implement method for exchanging data between MELSEC Q controllers or GOTs and common industrial quality databases Most Manufacturing Execution Software Applications use a database to source data and deposit results The product is named MES Interface because it greatly improves M
83. iting to database set f an error has occurred identify the error cause and take corrective actions Enable writing to the database Has an error occurred in the access log of DB Connection Service f an error has occurred identify the error cause and take corrective actions Are the relevant records or table locked on the database when inserting or updating data Unlock them on the database and execute it If they are locked the execution is delayed until they are unlocked In Connection result of previous job execution of Remote operation is Connected displayed under Result If Disconnected is displayed correct the setting of Server service settings Check the network connection route to the database server computer Is the Database type setting in Server service settings of MES Interface Function Configuration Tool correct Set the database being used Is No of updated or inserted records indicated as 0 in the access log of DB Connection Service Check if Select Update conditions are met Check if there is any missing field into which a value is to be inserted Check if the uniqueness constraint of the database PRIMARY KEY constraint is violated Check if the value to be stored exceeds the number of characters defined for the field Database values will not be stored in programmable controller devices Has an error occurred in Erro
84. itsubishi representative 064Bh device points for high total device points will not 0493h explaining a detailed speed sampling tag exceed 96 description of the problem Ensure a system area in the Check if the CompactFlash program memory of the card was inserted properly programmable controller CPU 0494h CF card format error Check the CompactFlash card oe pling Format the PLC memory for any error Perform check m For the Redundant CPU check disk on the computer 9 the system area for the Check the CompactFlash card Redundant CPU of both 0495h CF card check error for any error Perform check systems disk on the computer Retry writing the setting with 0496h CF card response Replace the CompactFlash 0650h Setting file error MES Interface Function error card with another Configuration Tool 04DOh Battery error pattety 06A0h Please consult your local gox the battery connection 06 Mitsubishi representative CPU fault detected Check the CPU status of 06ABh explaining a detailed module mounting station 06ADh description of the problem Retry the transmission m Retry writing the setting with 0502h APS mismatch Ai P Correct Access target CPU 0830h MES Interface Function settings TW 7 Configuration Tool Retry writing the setting wi UE y wnang gwit Install a CompactFlash card 0607h Setting file error MES Interface Function
85. k the settings of the points error entered in Device tag settings network module on the access Boneh FFFCh CPU error Pint 078 to Errors detected in the CC Link system ee tl station number BFFFh setting in Access target CPU CO000h settings to Errors detected in the Ethernet interface module FFFDh Device type error Correct the device type entered CFFFh in Device tag settings E000h FFFEh Device No error number to Errors detected in the CC Link IE controller network entered in Device tag settings EFFFh e Please consult your local Mitsubishi representative F000h j hi Errors detected in the MELSECNET H 10 network EL System error explaining a detailed FEFFh system description of the problem 1 0 CONCISE ERROR CODE LIST Error code 10 3 2 Error codes of DB Connection Service 1 Event log of Windows Error description and cause There is no setting file Start the service using the default setting Corrective action Configure the settings again with DB Connection Service Setting Tool Error Error description and cause Corrective action code 1 Unable to start the service due Terminate any unnecessary to insufficient memory applications B Unable to start the service due Add more memory to the to insufficient resources computer 3 Please consult your local Mitsubishi representative System error explaining a de
86. lash OB33h DB buffer file error Space the 0B34h DB buffer content error Please consult your local 0B35h B hA ARS Mitsubishi representative to System error ic P OB3Ah explaining a detailed description of the problem k th k 0B3Bh__ DB buffer full error Oneek status Ensure a DB buffering capacity 0B3Ch Please consult your local Mitsubishi representative System error ae explaining a detailed OB3Dh description of the problem To the next page 10 11 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e ul 2 Q I a Q 9 TERMINOLOGY 1 Q CONCISE ERROR CODE LIST Error code Error name Action Check the CompactFlash card OB3Eh DB buffering error If the CompactFlash card is damaged replace it OB3Fh Please consult your local Mitsubishi representative System error m explaining a detailed 0B40h description of the problem 0B41h DB buffer read error Check the CompactFlash card 0B42h DB buffer clear error If the CompactFlash card is 0B43h DB buffer read error damaged replace it Do not clear the DB buffer during resending of DB buffered data DB buffer empty Check the CompactFlash ca
87. lection button Data source name SAMPLEDS system Database To the next page 7 ODBC SETTING From the previous page Select Database Database Name Directories Sample_DB mdb c mes Bo Cancel gt mes Help Read Only Exclusive List Files of Type Drives Access Databases c Network End Ed The Select Database dialog box is displayed Select the following and click the OK button Folder C mes Database Name Sample DB mdb Click the button in the ODBC Microsoft Access Setup dialog box Click the button in the ODBC Data Source Administrator dialog box REQUIRED EXAMPLE SYS EQUIPMENT FOR START UP EQUIPMENT SETUP CREATING A SOFTWARE J MES INTERFACE CONFIGURATION CONCISE ERROR CODE LIST INTRODUCTION TEM OUTLINE INSTALLATION DATABASE TABLE ODBC SETTING FAQs TERMINOLOGY 8 MES INTERFACE CONFIGURATION CHAPTER 8 MES INTERFACE CONFIGURATION 8 1 General Description This section explains the procedure for specifying parameters using the MES Interface Configuration Tool Table below lists the parameters to be specified System settings Item of setting Description Default settings Access target settings Default settings Device tag settings
88. nagement method that follows relational data model logic One data is expressed as a collection of multiple items Fields and the data collection is expressed as a table Data can be easily merged and selected using key data Table Data management format managed with relational databases It is a two dimensional table format composed of rows and columns Device Variety of memory data in the programmable controller There are devices handled in units of bits and devices handled in units of words Device tag Tag Data table that contains a set of information Component required to access the device data in the programmable controller CPUs on the network The MES interface module collects device data in units of tags at an interval defined in the tag Trigger condition Startup conditions for job operation To the next page 11 2 EXAMPLE SYS EQUIPMENT FOR REQUIRED START UP EQUIPMENT SOFTWARE SETUP CREATING A DATABASE TABLE MES INTERFACE CONFIGURATION CONCISE ERROR imd CODE LIST INTRODUCTION TEM OUTLINE INSTALLATION ODBC SETTING FAQs TERMINOLOGY 1 1 TERMINOLOGY From the previous page Term Description Trigger buffering When trigger conditions conditions for data transmission of multiple jobs are met ina concentrated manner their data and trigger times are buffered in the module s internal memory so that actions data ope
89. ne Gi Transfer setup 5 Send a PING request from the EPUM If no response is returned check if the Failed in online operation configuration computer to the IP address of module is powered up if the network is the MES interface module Is there a properly connected response Select Online Transfer setup and BS Has the account set in Transfer setup of i pl correct the setting Online been registered to the MES Specify the account that is registered in interface module the MES interface module Select the job for one shot execution we Unable to select One shot execution from Was the job for one shot execution and then select Online One shot EE Online selected 92 execution from the menu By the error code check the error details Check for an error code in System monitor and take corrective actions Re execute formatting of the 99 Failed to format the CompactFlash card of GX 3 S CompactFlash a Is the MES interface module operation Stop the MES interface module 2215 stopped operation and then execute formatting It takes time to write the settings to the Is the MES interface module operation in Stop the MES interface module 2 MES interface module the Stop state operation and then write the settings 2 20 FAQs CONCISE ERRO
90. nt a MES interface module to the extension base unit of the Redundant CPU that is access target and access it The MES interface cannot access the Redundant CPU of other station Is system switching consecutively occurring Review the system so that system switching will not occur consecutively 4 Troubleshooting about the DB interface function Symptom The DB interface function does not work No communication has been made with the server computer Checked item Is Running displayed in the status indication area of Remote operation Was the computer restarted after installing relational database Corrective action If Stopped is displayed execute Restart from Remote operation turn the power OFF and ON or reset the programmable controller CPU Restart the computer Is the port No set in Service port of DB Connection Service Setting Tool the same as the port No set in Port No of Server service settings of MES Interface Function Configuration Tool Set the same value Communication is not available if different port numbers are set Is the firewall function of the operating system OS or security software enabled on the server computer Disable the firewall setting Or enable the communication of the port number for the TCP IP port to be used Default 5112 Is the port specified in Service port of DB Connection Service Setting Tool being used for the
91. o Italy Fax 39 039 6053312 Spain Mitsubishi Electric Europe B V Spanish Branch Tel 34 93 565 3131 Carretera de Rubi 76 80 Fax 34 93 589 2948 E 08190 Sant Cugat del Valles Barcelona Spain France Mitsubishi Electric Europe B V French Branch Tel 33 1 5568 5568 25 Boulevard des Bouvets F 92741 Nanterre Cedex France Fax 33 1 5568 5685 South Africa Circuit Breaker Industries Ltd Tel 27 11 928 2000 Private Bag 2016 ZA 1600 Isando South Africa Fax 27 11 392 2354 Hong Kong Mitsubishi Electric Automation Hong Kong Ltd Tel 852 2887 8870 10 F Manulife Tower 169 Electric Road North Point Hong Kong Fax 852 2887 7984 China Mitsubishi Electric Automaiton Shanghai Ltd Tel 86 21 2322 3241 16 F ChuangXing Fainancial Center No 288 West Nanjing Road Fax 86 21 3366 3332 Shanghai China Taiwan Setsuyo Enterprise Co Ltd Tel 886 2 2299 2499 6F No 105 Wu Kung 3rd Rd Wu Ku Hsiang Taipei Hsine Taiwan Fax 886 2 2299 2509 Korea Mitsubishi Electric Automation Korea Co Ltd Tel 82 2 3660 9552 1F 660 11 Deungchon dong Kangseo ku Fax 82 2 3664 8372 Seoul 157 030 Korea Singapore Mitsubishi Electric Asia Pte Ltd Tel 65 6470 2480 307 Alexandra Road 05 01 02 Fax 65 6476 7439 Mitsubishi Electric Bulding Singapore 159943 Thailand F A Tech Co Ltd Tel 66 2 682 6522 896 19 20 21 22 S V City Building office Tower1 Floor 12 Fax 66 2 682 6020 14 Rama III Rd Bangpongpang Yannaw
92. r Change the setting to avoid division by zero Change the setting so that any 0B54h Operation error invalid operation will not 10 12 performed Error code 0B55h Error name System error MELSEC cries From the previous Action Please consult your local Mitsubishi representative explaining a detailed description of the problem 0B56h Trigger buffer full error Reduce the frequency of job startups and their processing loads 0B57h to OB63h System error Please consult your local Mitsubishi representative explaining a detailed description of the problem 0B64h 0B80h 0B81h DB buffering write error System error Communication start error Change the setting of the buffering capacity to ensure a sufficient free space on the CompactFlash card Check if the CompactFlash card is damaged or not Please consult your local Mitsubishi representative explaining a detailed description of the problem Check the Ethernet connection Check if Server service settings is correct Check if the ODBC setting is correct 0B82h System error Please consult your local Mitsubishi representative explaining a detailed description of the problem 0B83h Communication connection error 0B84h 0B85h to 0B87h Communication connection timeout System error Check the E
93. r log of Working log f an error has occurred identify the error cause and take corrective actions When trigger conditions of a job with Startup logging setting are met is the startup logged in Event log of Working log If no startup data is logged refer to the following Refer to the symptom item Job will not start up In Change job status of Remote operation is Disable writing to PLC device set Enable writing to programmable controller devices Has an error occurred in the access log of DB Connection Service error has occurred identify the error cause and take corrective actions To the next page INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR REQUIRED START UP EQUIPMENT SETUP SOFTWARE INSTALLATION CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION FAQs CONCISE ERROR CODE LIST TERMINOLOGY FAQs Symptom Database values will not be stored in programmable controller devices Checked item Is No of selected records indicated as 0 in the access log of DB Connection Service From the previous page Corrective action Check if Select Update conditions are met Was the relevant device value manipulated in the programmable controller CPU Do not manipulate the device value in the programmable controller CPU at the time of writing from t
94. r number 2 PCode ControlCPU D202 Character string 2 characters List selection CPU data type 8 4 EXAMPLE SYS EQUIPMENT FOR REQUIRED START UP EQUIPMENT SOFTWARE SETUP CREATING A DATABASE TABLE INTRODUCTION TEM OUTLINE INSTALLATION ODBC SETTING 2 oo zo 2c 35 o CONCISE ERROR CODE LIST FAQs TERMINOLOGY 8 MES INTERFACE CONFIGURATION Specify server service settings Select Server Service Settings and click the Add button 27 New MES interface function configu Project Edit D c b ue NewProj ct lt System setting Sy Access target CPU settings fff Controlceu 9 Device tag settings f GettingData PuttingData Server service settings Job settings Online Help Enter into the Server Service Name field and specify parameters as shown below New MES interface function configuration tool Project Edit View Online Help Da g AmE 5 NewProject System setting Access target CPU settings controlcpu Device tag settings fs GettingData fs PuttingData Sy Server service settings SampleServer Job settings Server service name Server type IP address Port No 1024 to 65535 User name Password Confirm password Data source name Database type Access error notification se
95. ration transmission can be executed later using the buffered data Even if the frequency of data transmission triggers is high jobs are executed without missing any trigger Data separation New data and old data are mixedly exists in units of 16 bits 1 word in 32 bits data 2 words or larger data due to data reception timing Handshake For highly reliable processing programmable controller CPU devices are used to manage processing between the programmable controller CPU and MES interface module Field Corresponds to a column in a relational database and indicates a type of data Record attribute Variable Temporary variable Variable that can be used in a single job for temporary storage of values selected from a database and for writing operation values to a database or tag components Record Corresponds to a row in a relational database One row Record stores the values of multiple columns Fields Rollback 11 Processing for canceling changes to a database 1 1 TERMINOLOGY NOILONGOULNI Memo ANNLNO WIL SAS d IdWVX3 dfi 1HVIS LNAWNdINOA qaauinoagu 9013 LNAWdINOA NOLIVTIVISNI 3HVMLJOS gnay 3Svaviva V SNILV3HD SNILL3S SOVSYSLNI SIW SOV 151 3909 HOHH33SIONCO A90 ONIINH3 L 11 INDEX A Access target CPU setting 8 3 9 2 9 3 10 9 10 1
96. rd If the CompactFlash card is damaged replace it Check the CompactFlash card 0B45h DB buffer empty error If the CompactFlash card is damaged replace it 0B46h Please consult your local Mitsubishi representative System error EA explaining a detailed 0B47h description of the problem Error in conversion Change the setting so that type 0B48h from character string conversion will be available in to number any case Please consult your local 0B49h System error perii representative explaining a detailed description of the problem Error in conversion Change the setting so that type OB4Ah from character string conversion will be available in to number any case Please consult your local OB4Bh System error representative explaining a detailed description of the problem Error in conversion Change the setting so that type OB4Ch from character string conversion will be available in to number any case Please consult your local OB4Dh System error Mitsubishi representative explaining a detailed description of the problem Error in conversion Change the setting so that type OB4Eh from character string conversion will be available in to number any case OB4Fh Please consult your ocal Mitsubishi representative to System error EM OB52h explaining a detailed description of the problem Check the tag component type Overflow or zero divide or the substitute value OB53h erro
97. receive data due to Add more memory to the insufficient memory computer SID Session ID Request 0x20300010 IP address Connection disconnected during request reception SID Session ID Request 11 ooo Error IP address check if it is connected to Timed out during request reception the Check if the gateway and SID session ID Request or hub is operating Receive IP address Check if the power of the 0x20300012 Detected failure of ihe MES modulais not turned off interface module while waiting for or receiving a request SID Session ID Request 0x20300013 Receive Error IP address 10 18 Receive error Error code Corrective action cause SID Session ID Request 0x20300014 Receive Error IP address Buffer overrun Request Check if the source IP length exceeded address belongs to the SID Session ID Request MES interface module 0x20300015 Receive Error IP address Received an invalid request SID Session 10 Response Transmit Error 0 20310010 l address Failed to transmit a response due to disconnection SID Session ID Response Transmit Error m 0x20310011 IP address Check if it is connected to Timed out during response the network transmission Check gateway and or hub is operating SID Check if the power of the uc Error module is not turned off
98. rective action 0x20600001 cause Failed in SQL execution due to insufficient memory 0x20600002 Failed in SQL execution due to insufficient resources Terminate unnecessary applications Add more memory to the computer 0 20600020 DB Connection Service does not support the SQL instruction to be executed Check if the source IP address belongs to the MES interface module 0x20600021 Failed in preparation before SQL execution 0x20600022 Failed to obtain the number of fields in the record that is to be obtained by the SQL execution Set a correct database type in Server service settings of MES Interface Function Configuration Tool Select Job settings Communication action in MES Interface Function Configuration Tool and set a correct table name 0 20600023 Failed SQL execution Set a correct database type in Server service settings of MES Interface Function Configuration Tool Select Job settings Communication action in MES Interface Function Configuration Tool and set a correct table name field names and Select Update conditions Also set a correct data type for the data entered in the fields Check if the uniqueness constraint of the database PRIMARY KEY constraint is violated or not 0 20600024 0 20600025 System error No record was updated or inserted by the SQL execution
99. ription Job settings Job name Reporting 2 Enabled or not at module startup Enabled Trigger buffering Provided Trigger condition Value monitoring startup Condition Tag type GettingData ReportingTrigger Constant ON 25 gt lt lt Action 1 gt of action Operation g Substitution Operation Operation ais Component Component Operator z tag tag tag Gag Variable Conversion GettingData Weight g Number 1000 lt Action 2 gt Type of action Insert zo Table name History gu DB tag link settings Field name Component SerialCode GettingData SCode Date_Time Date Module time m E DE Weight_mg Variable Conversion 2 E 9 2 4 oo zo Zu 35 o CONCISE ERROR FAQs CODE LIST TERMINOLOGY MES INTERFACE CONFIGURATION 8 2 Specifying Parameters Start the MES Interface Configuration Tool from the Windows Startup menu System settings and Access target CPU settings need not be established because they take default settings Specify a device setting Select Device Settings and click the Add button E New MES interface function configura Project Edit Online Help B 8 System setting J Access target CPU settings fff controlceu 3 De
100. rogram xec IP address Add more memory to the lt gt Failed computer 0x20700002 Failed in remote execution due to insufficient resources Please consult your local Mitsubishi representative 0x20700003 System error explaining a detailed description of the problem Check if the source 0x20700010 ae address belongs to the MES Invalid remote execution interface module request 0x20700011 Please consult your local Mitsubishi representative System error e explaining a detailed 0x20700012 description of the problem 10 20 0x20700023 ProgramExec IP address lt gt Failed Failed to generate process during remote execution Check if the application to be executed in remote execution exists or not Check if the name of the application to be executed in remote execution is a directory Make a proper security setting for the application to be executed in remote execution 0x20800010 SID Session ID TCPOpen Request Error IP address Invalid TCPOpen request Check if the source IP address belongs to the MES interface module 0x20800011 0x20800012 0x2FE00010 System error Please consult your local Mitsubishi representative explaining a detailed description of the problem To the next page 1 0 CONCISE ERROR CODE LIST 3 SQL failure log of DB Connection Service Error code Error description and Cor
101. rrect 107 The version of the setting file is not correct 108 The server port No setting is not correct 109 The server port No setting is out of range 110 The timeout time setting is not correct 111 The timeout time setting is out of range 112 There are too many connection permitted IP address settings Description of the connection 113 permitted IP address setting is not correct The mask bit length setting of 114 the connection permitted IP address is not correct Corrective action Configure the settings again with DB Connection Service Setting Tool To the next page 10 15 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e 5 2 a Q 9 TERMINOLOGY 1 Q CONCISE ERROR CODE LIST MELSEC cries From the previous Error Corrective action code Error description and cause If no directory exists for storing the access log file create it When the attribution 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 in the security setting When the access log file name represents a directory rename or delete the
102. ss 2003 Two types of DB table shown below will be prepared INTRODUCTION EXAMPLE SYS TEM OUTLINE Table name Table design Data OrderTable 5 Filed name Data type Field size OrderCode ProductCode PlanNumber SEE OrderCod Numerical intended 1 EN 20 m SIS SU type PENES 2 US 35 ProductCode Texttype 2 3 CN 25 E Numerical 2 PlanNumber Integer type a s History No data because this table is for Insert action Filed name Data type Field size SerialCode Text type 6 E Date time Date_Time Numerical Weight_mg Single type 6 type 6 2 OrderTable Creation Microsoft Access Insert Tools Window Help Adobe PDF To the next page e Start the Microsoft Office Access 2003 from the Windows Start menu e Select File on the menu bar and then click New zi E FE 22 lt lt lt oa ODBC SETTING MES INTERFACE CONFIGURATION CONCISE ERROR FAQs CODE LIST TERMINOLOGY 6 CREATING A DATABASE TABLE MELSEC From the previous page Choose Blank Database from the menu appearing at the right to create a new database Project using existing data Project using new data From existing file Templates Search online For Go E Templates on Office Online On my computer l File New Database
103. ss log files is out of range Setting Tool 123 The SQL failure log setting is not correct 124 The setting of the SQL failure log file name is not correct 125 The SQL failure log file name is too long The maximum file size setting 126 forthe SQL failure log is not correct The maximum file size setting 127 forthe SQL failure log is out of range The maximum number of SQL 128 failure log files is not set correctly 129 The maximum number of SQL failure log files is out of range The computer ran out of 401 memory when initializing the Terminate any unnecessary access log file applications The computer ran out of Add more memory to the 402 resources when initializing the computer access log file Shorten the path to the 403 The full path name of the access log file with DB access log file is too long 10 16 Connection Service Setting Tool When the attribution of the new and old access log files is set to read only cancel the setting If read write is disabled for the new and old access log Failed to rename the access log files enable it in the security file setting When the new and old access log files have been open in another application terminate the application Check the disk device for any fault 407 the next page 1 0 CONCISE ERROR CODE LIST Error code 501 Error description and cause The computer ran out of memory when initializing
104. t Flash card For more on usable Compact Flash cards please refer to MES Interface Module User s Manual EQUIPMENT SETUP Configuration software MX Only specifying necessary data allows data communications SQL texts MESInterface SW1DNC MESIF E without any programming This software includes the following tools MES interface function configuration tool Software that is run on a configuration computer and performs settings required for the MES interface function of the MES interface module In addition to the settings checking the operating status or operation logs and stopping restarting the MES interface function operation are also available with this software SOFTWARE INSTALLATION CREATING A DATABASE TABLE DB connection service Software that is run on a server computer and is used for linking a database to the MES interface module ODBC SETTING DB connection service setting tool Software that is run on a server computer and is used to change the settings of DB connection service Computer The computer is used as a server computer and a configuration computer In this guide Microsoft Windows XP Professional Operating System is used as the basic software OS in explanations For hardware requirements of the computer to be used refer to MES Interface Module User s Manual MES INTERFACE CONFIGURATION Twisted pair cables and a hub Used to connect the computer to th
105. t the station on the access route Special module bus 00F1h Examine the hardware of the Special modul intelligent or special function IN modue module timeout 0100h to Please consult your local Mi ishi representati 0104h Systemi itsubis i rep Bee tative explaining a detailed description of the problem 0112h Check the intelligent function modul itch ing 0180h Switch setting error edule switch setting Conduct the hardware test again To the next page 10 9 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e O 2 I a 9 TERMINOLOGY 1 Q CONCISE ERROR CODE LIST MELSEC cries From the previous 10 10 out error controller CPU Error code Error name Action Error code Error name Action 0181h ROM check sum error Conduct the hardware test Refer to the accessible device 0182h RAM test error again 0619h Device name error list and reenter a correct 0190h Timeout error Hardware error device name 0191h Communication error Please consult your local Multiple CPU setting 0192h Comparison error Mitsubishi represen
106. tailed 4 description of the problem Refer to the actions of error 5 Failed to read the setting file codes 101 to 129 The service is stopped Actions are displayed with error codes 101 to 129 Refer to the actions of error codes 401 to 403 and 501 to 6 Failed to initialize the log file 503 The service is stopped Actions are displayed with error codes 401 to 403 and 501 to 503 Please consult your local Mitsubishi representative System error explaining a detailed 8 description of the problem The server port has already Change the server port No 9 been opened with DB Connection Service The service is stopped Setting Tool 10 Please consult your local Mitsubishi representative System error explaining a detailed 11 description of the problem The computer ran out of uideri 101 memory while reading the Add more memory to the setting file computer Reinstall the DB Connection 102 The setting file path is too long Service to the directory whose path name is shorter 103 The setting file name indicates the directory Reinstall the DB Connection 104 The setting file could not be Service opened Terminate other applications 105 Description of the setting file is and make the setting again not correct with DB Connection Service Setting Tool Error Error description and cause code 106 Parameter specification of the setting file is not co
107. talive Correct Access target CPU explaining a detailed Network settings 0193h In frame position error description of the problem 0627h communication route 0200h error Please consult your local IR to Tag sampling interval ishi i 0628h Correct Device tag settings 0203h System Mitsubishi representative setting error Devi g settings explaining a detailed 29h T 4 description of the problem _ 0629h Retry writing the setting with 0300h 062Ah Setting file error MES Interface Function Install a CompactFlash card 062Ch Configuration Tool 0301h Setting file read error Retry writing the setting with SEEN No CPU specification Specify an existing CPU as the MES Interface Function error access target Configuration Tool ET Data type incorrect 0400h Please consult your local error M System error Mitsubishi representative 062Fh Excessive number of Correct the component 0402h explaining a detailed characters error setting description of the problem n 0630h Decimal Exponential 0480h CF card initialization Check if the CompactFlash form setting error error i card was inserted properly 0631h Retry writing the setting with 0481h CF card drive data the CompactFlash Bons Setting file error MES Interface Function retrieve error Configuration Tool 0490h youn Keg Excessive number of Change the setting so that the System error M
108. the SQL failure log file 502 The computer ran out of resources when initializing the SQL failure log file Corrective action Terminate any unnecessary applications Add more memory to the computer 503 The full path name of the SQL failure log file is too long Shorten the path to the SQL failure log file with DB Connection Service Setting Tool 504 The SQL failure log file could not be opened If no directory exists for storing the SQL failure log file create it When the attribution of the SQL failure log file is set to read only cancel the setting If read write is disabled for the SQL failure log file enable it in the security setting When the SQL failure log file name represents a directory rename or delete the directory When the SQL failure log file has been open in another application terminate the application Check the disk device for any fault 505 506 The log could not be written to the SQL failure log file Failed to delete an old SQL failure log file When the disk space is full ensure a free disk space When the SQL failure log file has been open in another application terminate the application Check the disk device for any fault When the attribution of the oldest SQL failure log file is set to read only cancel the setting If read write is disabled for the oldest SQL failure log file enable it in the security setting When
109. the oldest SQL failure log file has been open in another application terminate the application Check the disk device for any fault From the previous page Error Corrective action code Error description and cause When the attribution of the new and old SQL failure log files is set to read only cancel the setting e If read write is disabled for the new and old SQL failure log files enable it in the security setting When the new and old SQL failure log files have been open in another application terminate the application Check the disk device for any fault Failed to rename the SQL 7 failure log file To the next page 10 17 REQUIRED INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR START UP EQUIPMENT INSTALLATION SETUP SOFTWARE CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION e 5 2 a Q 9 TERMINOLOGY Error code CONCISE ERROR CODE LIST 2 Access log of DB Connection Service Error description cause Service Not Start Corrective action Error description and 0x20100001 Failed to start the service Terminate any due to insufficient memory unnecessary applications Service Not Start Add more memory to the 0x201
110. thernet connection Check if Server service settings is correct Check if the ODBC setting is correct Check if the server computer has no problem referring to the following Please consult your local Mitsubishi representative explaining a detailed description of the problem OB88h Message transmission error 0B89h Message transmission timeout Check the Ethernet connection Check if Server service settings is correct Check if the ODBC setting is correct 0B8Ah System error Please consult your local Mitsubishi representative explaining a detailed description of the problem To the next page 1 0 CONCISE ERROR CODE LIST Error code OB8Bh Error name Message reception error Action Check the Ethernet connection Check if Server service settings is correct Check if the ODBC setting is correct Check if the database has been restarted or not When the database is Microsoft Access 2000 2003 Check if 128 or more fields are set in Update actions Check the sent SQL text and the database contents Check if the table and field settings are correct Check if the uniqueness constraint of the database PRIMARY KEY constraint is violated or not Check if multiple MES interface modules are accessing one file at the same time OB8Ch Message reception timeout Check the Ethernet connection
111. tings Selecting Resend from DB buffering operation of Remote operation will not resend buffered SQL texts of the job for which manual resend is selected Is there any problem on the connection routes to all of the database server computers Check the connections with all of the database server computers When buffered SQL texts are to be sent to more than one destination unless the communication with all the database Server computers is recovered resending is not started Are the DB Connection Services in all the database server computers operating normally Check each of the DB Connection Services in all the database server computers When buffered SQL texts are to be sent to more than one destination unless DB Connection Services in all the database server computers are operating resending is not started To the next page 9 11 INTRODUCTION EXAMPLE SYS TEM OUTLINE EQUIPMENT FOR REQUIRED START UP EQUIPMENT SETUP SOFTWARE INSTALLATION CREATING A DATABASE TABLE ODBC SETTING MES INTERFACE CONFIGURATION FAQs CONCISE ERROR CODE LIST TERMINOLOGY FAQs Symptom Data such as DB buffering status No of DB bufferings DB buffer full or DB buffer utilization will not be stored in the tag component which is selected in DB buffering settings of System setting Checked item Was the setting that enables data writing to the tag component
112. tion configuration tool Project Edit View Online Help 9 B Np NewProject amp System setting Ei Access target CPU settings ff Controiceu y Device tag settings f GettingData PuttingData amp Server service settings amp Job settings No of tag components in project 6 Prohibit data writing Device tagname PuttingData Sampling settings a Enhance sampling efficiency Devices must be connected in series Normal sampling 7 High speed sampling up to 96 points Do not sample Array setting Use array Component setting input Component name PCode CPU name ControlCPU Head device 0202 Data type String 2 bytes Add Replace Delete Statistical type TENE Component List Component name CPU name 1jPlan ControlCi 2 PCode Data type d No of statistical processings project 0 No of device points 2 Setting item Device name PuttingData Setting description Setting method Text input Sampling settings Do not sample Radio button selection After inputting the information in Statistical Statistical name name tatistical type type a row click the Add button setting input Pen 0200 Single precision Text input component device i characte
113. ts the inspection station the actual serial number production time and part weight are collected by the MES Interface and transferred to the production control database Modifying Data to Improve Usability Scaling in the MES The inspection scale reports part weight to the control system in grams decimal but a production report from the database information should read in milligrams To avoid control logic changes and extra processing at the database level the weight data is converted to mg format in the MES interface Production Target 35 pieces E Code US US2001 10 00 00 0 ee OOO 10 00 10 0 ee MELSECQwith MES Interface unit US2035 10 05 50 0 512 Production Control 3 REQUIRED EQUIPMENT FOR START UP MELSEC CHAPTER 3 REQUIRED EQUIPMENT FOR START UP INTRODUCTION Before creating a sample system the following items must be prepared MES interface module QJ71MES96 The MES interface module establishes linkages between device data of a programmable controller production equipment and a database of an information system MES Manufacturing Execution System without using a communication gateway EXAMPLE SYS TEM OUTLINE e 2 gt 5 e ul di g ast G2Qa wor Compact Flash card GT05 MEM 128MC The MES interface module is equipped with and uses one Compac
114. tting Connection timeout 1 to 180 Setting item Setting description SampleServer Database server bd ie d 5112 SAMPLEDS Access2003 2007 Notify the access error status 10 seconds Setting method Server service name SampleServer Text input Server type Database server List selection IP address 192 168 3 1 Text input Port No 1024 65535 5112 Text input User name Empty Password Empty Confirm password Empty Data source name SAMPLEDS Text input Database type Access2003 2007 List selection Communication timeout time 1 180 10 Text input 8 5 8 MES INTERFACE CONFIGURATION aL 5 2 Specify job settings Select Job Settings and click the Add button E 1 New interface function configu New MES interface funct fig Project Edit Online Help mz u ee D eH R x RE z 2 lt 29 NewProject EB 9 System setting 4S Access target CPU settings 3 fff Controlcpu 2 E Sy Device tag settings 925 a T GettingData ii PuttingData Server service settings SampleServer z3 Job settings E 2 a Enter GettingPlan into the Job Name field and specify trigger conditions as shown below 5 ae New MES interface function configuration tool DER Project Edit View Online Help 92 Dg b 5
115. urn on Is the Watchdog timer error X1F ON please consult your Mitsubishi E representative explaining a detailed description of the problem Is the battery connected Or has the Check the battery connection battery voltage dropped Replace the battery Is of the error detection signals X11 BE X12 X16 and X1C ON According to the error code obtained by Tho EAR X11 Sampling error the eror detection shown on the left X12 Information linkage error identify the error cause and take A X16 Access target CPU error corrective actions He X1C Another error zz Check the error code in System monitor of By the error code identify the error and 82 GX Developer take corrective actions Depending on the number of items set in Is the module in preparation Access target CPU settings it may take ons several minutes until XO turns ON Module READY does not turn ON or it If many files are stored in the takes time to turn ON CompactFlash card it takes time to turn Are there many files in the installed X0 ON Delete unnecessary files from the E CompactFlash card Is file access stopped X2 is Cancel the file access stop 8 If many files are stored in the CompactFlash card status X1 does not 2 CompactFlash card it takes time to turn 58 turn ON or it takes time to turn ON pee there many esiin the X1 ON EE CompactFlash card
116. veloper ocson CF card check error Tum the power OFF and ON PI it your local event log writing p FFD2h pase t your oca or reset the programmable D Mitsubishi representative controller CPU FFD4h explaining a detailed OC81h CF card full error Check the capacity of the description of the problem event log writing CompactFlash card Change the TC setting value FFD5h ROM operation error ODOOh Setting file out of during RAM operation range access error FFD6h PI i New setting file FFD7h 00018 Mitsubishi representative creation error Turn the power OFF and ON FFD9h System error A explaining a detailed 0D02h Setting file open error or reset the programmable to daserintior atithe problem 0DO3h Setting file seek error controller CPU FFDEh P 00048 Setting file read error FFDFh Incorrect access target Correct Access target CPU 0D05h Setting file write error error settings 0DO6h Setting file close error FFEOh OD80R FFEih Please consult your local Mitsubishi FFEDR System error itsubis i r pr s ntative 0D82h Please consult your local explaining a detailed ppl uus o i ishi i description of the problem 100Eh System error Bb FFEFh 20001 of the problem Station or Network No station No and to FFFOh ae network in Access target 20FFh CPU settings 4000h Please consult your local Mitsubishi to
117. vice tag settings Server service settings 8 Job settings 4 Enter GettingData into the Device Tag Name field and specify parameters as shown below T New MES imterface funtion configuration 1001 Setting item Setting description Setting method Device name GettingData Text input Sampling setting Normal sampling 1 second Radio button selection sampling Text input No of seconds Statistical Component name CPU name Device Data type type After inputting the information in a i isi row Click the Add button 1 OCode ControICPU 0100 Single precision TER D300 Character string setting input 2 ICP S p 3000 0302 6 characters character number 8 3 3 Weight_g ControlCPU D400 Single precision 4 ReportingTrigger ControICPU et List selection CPU data type MES INTERFACE CONFIGURATION Specify another device setting Select Device Settings and click the Add button 8 New MES interface function configu Project Edit D c Arx 29 NewProject System setting Access target CPU settings M ControlCPU EEG Device tag settings 5 GettingData Server service settings Job settings Online Help Enter PuttingData into the Device tag name field and specify parameters as shown below New MES interface func
118. ypted format and the messages exist in XML format which is well suited to passage through common IT infrastructure devices such as firewalls routers and switches Automatic time adjustment to an SNTP server keeps time stamps and database sequencing accurate 1 INTRODUCTION MES interface basic system configuration The overall system configuration when using the MES Interface module is shown below Database Oracle SQL Server Access etc products from other companies See Chapter 6 SNTP server personal computer 1 2 4 Server personal computer DB connection service DB connection service setting tool Ethernet MES interface module MES interface Chapter 8 tool Personal computer used for operational settings Q QnA ACPU 4 4 Functions provided by the MX MES Interface 1 The SNTP server personal computer and the personal computer used for operational settings can be used with the server personal computer 2 MES interface module time is required when SNTP server personal computer time is used 3 In this guide the DB connection service setting is set to the default to shorten explanations 4 This is not used in the system configuration examples given in this guide REQUIR
119. ystem error explaining a detailed 0x20600012 description of the problem 0x20600020 SID Session ID GetNext address belongs to the Failed MES interface module SID Session ID Reset Failed DB Connection Service does not support the SQL instruction to be executed SID Session ID SQL lt gt Failed SID Session ID COMMIT Failed SID Session ID ROLLBACK Failed 0x20600021 SID Session ID GetNext Failed SID Session ID Reset Set a correct database Failed type in Server service Failed in preparation before settings of MES Interface SQL execution Function Configuration SID Session ID SQL lt gt Tool Failed Select Job settings SID Session ID COMMIT Communication action in Failed MES Interface Function SID Session ID Configuration Tool and ROLLBACK Failed set a correct table name 0x20600022 SID Session ID GetNext Failed SID Session ID Reset Failed Failed to obtain the number of fields in the record that is to be obtained by the SQL execution Set a correct database type in Server service SID Session ID SQL lt gt settings of MES Interface Failed Function Configuration SID Session ID COMMIT Tool Failed Select Job settings SID Session ID Communication action in 0x20600023 ROLLBACK Failed MES Interface Function SID Session ID GetNext Configuration Tool and Failed Set a correct table name SID Session

mes interface configuration

Contents

Download Pdf Manuals

Related Search

Related Contents