Chapter 2: Installing the Oracle MOC Extension
Contents
1. Click the Oracle GroupID tab and you should see the panel below This panel will be used to customize your creation of the Oracle Group ID and will be discussed in the Customization section of this document MESInterface IT Workbench admin 192 168 3 4 User Help an Nodes Oracle MOC Interface Administration Oracle MOC Interface B 192 168 3 4 Attention Bit Automated Log Export Events Diagnostics FTP Server Licenses Network Configuration La B Projects Node Administration Notifications Oracle GroupID System Variables Oracle GroupID Ent gt 1 The following parameter sets the current value of the GroupID the next transaction to fire will use the value specified Current Value 0 The following parameter controls how the GroupID changes when a transaction fires it will cause the GroupID to change by the specified value Change 1 Listeners B 2 Devices TN Logs amp Reports Local Database K Administration The local database table installation instruction will be discussed next 6 MESInterface IT Oracle MOC Extension Installing the Local Database Table The second step of the Oracle MOC installation is to import a local database table that is used for batching data prior to sending it to the Oracle Manufacturing Operations Center interface table Click on the Local DB icon Place the mouse2. 27 Customizing the Subtriggers 28 Chapter 5 UU 29 Pretace The Oracle MOC Extension is a MESInterface IT software configuration that allows communications with Oracle Manufacturing Operations Center This book describes how to install configure and customize the Oracle MOC Extension in conjunction with the MESInterface IT product Who should read this book This book is intended for engineers and programmers who will be defining and implementing data collection requirements to Oracle Manufacturing Operations Center using MESInterface IT This book is also intended for people who manage device interface systems It is assumed that the reader has some experience with the MESInterface IT product How this book is organized This book contains the following chapters Chapter 1 Introduction provides an overview of the Oracle MOC Extension and the assumptions for the reader Chapter 2 Installing the Oracle MOC Extension describes the installation process for the Oracle MOC Extension Chapter 3 Configuring for Your Oracle Environment describes the required configuration to communicate with your Oracle installation Chapter 4 Customizing Transactions describes how to customize the sample transactions into data collection transactions that meet your requirements Chapter 5 Troubleshooting Related documentation This book assumes you
3. Overflow Pending Edit Transport Name racle MOG Attributes DB Oracle 152 1683 1 Last Error Code Last Error Messaze Last Error Time EVALUATION LICENSE IN USE 14 MESInterface IT Oracle MOC Extension Configure the Transport There is only one transport map the MOC Insert Tag Readings Raw that needs to be configured The modifications that need to be made are to select the schema where the Oracle Manufacturing Operations Center interface table is located select the table and map the table To begin click the Transport Maps icon select the MOC Insert Tag Readings Raw transport map and click the Edit button MESInterface IT Workbench admin 192 168 3 4 User Help Lacal Inzert Recordz LOCALDB DB Local Select Records Ma GroupID LOCALDBI DB Local Select Records with GroupID LOCALDB DE Local Update Create Date LOCGALDB4 DB Lacal Update State LOCGALDBS3 DB 4 m Nodes Oracle MOC Interface Enterprise ay Oracle MOC Interface dz Projects Last Average Execution Execution c RE Enterprise Transport Type Successes Failures Time ms Time ms a MOG Insert Tag Readings Raw 7 Transport Maps c gt gt gt gt gt gt gt ao a Devices Logs amp Reports E Local Database Filte
4. 192 168 3 3 2 User Help Nodes ae oi Oracle MOG Interface 132 168 3 3 Automated Log Export Events FTP Server Network Configuration om Version Enterprise Oracle MOC Interface Administration jen EF Transport Maps 2n Transports PU Listener Maps Listeners ates Devices H Logs amp Reports E Lacal Database X Administration 4 MESInterface IT Oracle MOC Extension This will display your currently installed packages and it may be empty Click on the Add button and navigate to the Oracle MOC Extension folder Select the OracleMOCExtension_ CPU name Version pkg file and click the Select button MESInterface IT Workbench admin 192 168 3 3 cB x User Help 4 m Nodes H Oracle MOC Interface Administration Oracle MOC Intertace i Automated Log Export Events FTP Server Network Configuration c3 Package File Location mall Ei Enterprise B Jat AZ i a Transport Maps Ex ul Oracle MOG Interface id epa be i Transporte n 19 OracleMmOcExtension_Q12DCCPU_100A pkg 2 I Listener Maps ben Listenerz Sag Devices 725897 2 y Variables A E gt Logs amp Reports Documents Local Database Administration Jeti OracleMOGExtension_ 12DCGPU_100Apke MESInterfacelT Firmware Package Files pk T
5. NEXT col Tae Code STRING 255 1 oe cal col Tag Data STRING 255 1 LocalVariables O UT MR1 Value DWORD Success NEXT Failure ENDERR Store and Forward NEXT col User Attri STRINGCISO 1 o 5 Transaction MOC Local Insert Records col_User_Attr2 User Attr3 STRIN 5 NEXT Failure ENDERR St d Forward NEXT allure ore col User Attr STRING 50 col_User_Attr STRING 150 1 col User Measure1 DWORD col User Measure2 DWORD col Measure3 DWORD col User Measured DWORD col User Measureb DWORD col Quality Flag Do RD Input 6 Transaction MOC Local Insert Records Success NEXT Failure ENDERR Store and Forward NEXT 9 Transaction MOC Local Update State Success NEXT Failure ENDERR Store and Forward NEXT Once these fields are configured and both the collection and insert triggers are started device data can be batch inserted into the Oracle Manufacturing Operations Center using MESInterface IT Customizing the Subtriggers The subtriggers that are provided with the Oracle MOC Extension should not require customization to perform the functions they were designed for The only exception is if you require using the user attribute or user measurement columns from the Oracle Manufacturing Operations Center interface table If any of these columns are used you should create a new subtrigger by duplicating an existi
6. Overview of the Projects There are two projects included with the Oracle MOC Extension MOC SubTriggers and MOC Samples The MOC SubTriggers project contains two critical subtriggers that collect the records from temporary storage in the local database and inserts them into the Oracle Manufacturing Operations Center interface table One of these subtriggers MESInterface IT Workbench admin 192 168 3 4 User Help Nodes i Oracle MOC Interface Oracle MOC Interface Projects 199 168 34 J Projects hire Samples MOG Sub Trigeers Ingert Ma GrauplD Insert with GroupID SubTrigger State Status Calculate Counter Change SubTrigger 3X Stopped Unloaded n a SubTrigger Stopped Unloaded n a XX Stopped Unloaded n a Samples SubTriggers X Last Triggered Successes Item Count 3 Failures In Progress MOC_Insert_with_GroupID uses the Oracle Group ID to organize the records and the other Insert No GroupID does not The third subtrigger Calculate Counter Change is used calculate the difference between two readings of a device counter variable It is assumed that this counter variable will be reset at a predetermined level and this subtrigger can also calculate the difference when the reset occurs between readings Other subtriggers that are specific to your Oracle Manufacturing Operations Center implementation can be added to
7. Length Default GraupID DWORD n a IrCiount DWORD IrStatug RD n a MR Transaction ID Add Special Functions Data Collection t Value Transaction MOG_Local_Insert_Records Set Insert State Local ariables GroupID Success NEXT Failure ENDERR Store and F Transaction Local Ingzert Records Insert into Oracle Transaction Local Insert Records Success NEXT Failure ENDERR Store an Transaction Lacal llpdate State Success NEXT Failure UNDEFINED Store and Forward NEXT Execute SubTrigger MOC_Insert_with_GroupID from Project Sub Triggers Success NEXT Failure ENDERR Transaction ID The transaction ID is an internal identifier which keeps all the records from each trigger grouped together for processing within the MESInterface IT node The transaction ID must be unique for each direct trigger or batch trigger pair which sends data records to Oracle Special Functions Special functions are any data manipulation or identifier actions which are required for the Oracle records These are entered as the first actions in preparation for data collection Examples of special functions are the Oracle Group ID and counter value calculations 19 Data Collection The data collection actions will follow any special functions There will be one action for each data element that is being collected in this trigger
8. data tag The last field used col Tag Data is the address of the data tag in the device The next ten fields consist of user attribute and user measurement fields and can be used based on your configuration of the Oracle Manufacturing Operations Center The last field col Quality Flag is not currently supported by the MESInterface IT node Once these fields are configured and the trigger is started device data can be directly inserted into the Oracle Manufacturing Operations Center using MESInterface IT 22 MESInterface IT Oracle MOC Extension Setting up a Batch Insert Transaction The second transaction we will customize use s the Batch Insert Cumulative Counter Collect trigger as a Starting point This is a scheduled event trigger that fires every 15 seconds and collects multiple data variables and inserts the records into the Oracle Manufacturing Operations Center interface table as a batch insert It also uses the Oracle Group ID to group the values together for processing and has two counter variables that need the change in counter value to be inserted into Oracle The collect trigger stores the data records in the local database for each time it executes Trigger MOC Samples Batch Insert Cumulative Counter Collect Mame Batch Insert Cumulative Counter Collect Event Local Variables Static Variables Length Default n a n a n a n a n a n a Remove Actions Get Next GroupID Get Next GroupID Output Succ
9. for your Oracle Manufacturing Operations Center installation E3 MESInterface IT Workbench admin 192 168 3 4 m Nodes amp Oracle MOG Interface El 192 168 3 4 E Projects 5 Enterprise ie Listeners 5 Dey ites E gt Logs amp Reports Local Database Administration 4 H Oracle MOC Interface Enterprise Item Count 8 Transport Maps Transports Listener Maps Pending S F S F Queue SUCCESSES Failures Gueued Deleted Pendine Overflow Oracle MO G Type DEB Parameters Store amp Forward Mapping Log DB Type Oracle Port Password DE EE Oracle 182 168 1 121 um 0 0 Extended Attributes Connection Pool Size 1 n a Load transport at initialization Cancel After you have entered the information click the Validate button If the MESInterface IT node is able to connect you will see the message below If it fails please check the parameters and try again MESInterface IT Workbench admin 192 168 3 4 User Help m Nodes Oracle Interface i 192 158 3 4 JE Projects MOC Samples MOG SubTriggers SE Enterprise o Devices EE S Logs amp Reports E Local Database X Administration 4 H Oracle MOC Interface Enterprise Item Count 7 Transport Maps Transports Listener Maps Pending
10. in the empty space and click the right mouse button You should see a pop up selection list Select Import MESInterface IT Workbench admin 192 168 3 4 User Help m Nodes Oracle MOC Interface Local Database Oracle MOC Interface 192 168 3 4 Tables Management Execute SQL z Projects E Enterprise 6 Transport Maps New Transports i Duplicate Delete Import Export E a Devices 8 Logs amp Reports Local Database X Administration Navigate to the Oracle MOC Extension folder and select the LocalDB MOCInterfaceTable dwx file and click the Select button E3 MESInterface IT Workbench admin 192 168 3 4 181 User Help 4 Nodes Oracle MOC Interface Local Database Interface 5 192 168 T B Projects Import File Location 88 Oracle Extensi B se Enterprise E Oracle xtenzion tee NU P LocalpB MOCInterfaceTable dwx Transport Mag E i MOC_Project dwx Igor efc Transports Listener Maps Ww Listeners as Devices A Logs amp Reports Documents A X Administration Local Database HE LocalDB_ MOCInterfaceTable dwx moria MESInterfaceIT Export Files dw The following pop up should appear Select the Import button Import File rface Oracl
11. this project as well The MOC Samples project contains a variety of sample triggers that you can use as a guide to create the triggers for your specific data collection requirements Among the samples are batch MeSInterface IT Workbench admin 192 168 3 4 User Help Nodes al Oracle MOG Interface 182 158 3 4 Projects wane MOG Sampl Batch Ingzert Cumulative Counter Collect Wo E Batch Insert_Cumulative_Gounter_Insert Batch Inzert Group Event Collect MOG Sub Triggers Batch Inzert Group Event Insert Batch Inzert Group Scheduled Collect Batch Inzert Group Scheduled Insert Batch Inzert Graup Event Callect Batch Inzert Mo Group Event Inzert Batch Insert No Group Scheduled Collect i mah G maes Enterprise WEM j iy Transport Maps Direct Insert Group Event Transports Batch Insert No Group Scheduled Insert Direct Insert Group Scheduled Direct Insert No Group Event Direct Insert Group Scheduled i Listener Maps 18 MESInterface IT Oracle MOC Extension Oracle MOC Interface Projects Samples X XX SubTriggers X Scheduled Scheduled Data Scheduled Scheduled Scheduled Data Scheduled Scheduled Scheduled Data Scheduled Data Scheduled State X Stopped X Stopped amp Stopped Stopped Stopped Stopped Stopped Stopped Stopped Stopped Stopped Stopped Stopped Stopped Status Unloaded Unloaded U
12. 6 MESInterface IT Oracle MOC Extension These output values are highlighted in the red circle on the following trigger edit window Trigger MOC Samples Batch Insert Cumulative Counter Collect Batch Insert Cumulative Counter Callect Event Local Variables Static Variables Leneth Default n a n a n a n a n a n a Remove Actions T Execute SubTrigger 1 Get Next GroupID Project Hame MOC Sub Triggers Success NEXT i Sub Trigger Calculate Counter Change Wait for Completion True Execute SubTrigger Galculate Counter Change from Project SubTriggers Success NEXT Failure ENDERR Routing Details Transaction Local Insert Records Success MEST Failure ENDERR Store and Forward NEXT Transaction MOG_Local_Insert_Records Count success NEAT Failure ENDERR Store and Forward NEAT Delta DwoRD 1 LocalVariables OUT MR1 Value DWORD Transaction MOG_Local_Insert_Records MewLast RD 1 Static Variables OUT MR1 Last Dwo RD Success NEXT Failure ENDERR Store and Forward NEXT Transaction MOG_Local_Insert_Records Success NEXT Failure ENDERR Store and Forward NEXT Transaction MOC_Local_Insert_Records Success NEXT Failure ENDERR Store and Forward NEXT Transaction MOC_Local_Update_State Success NEST Failure ENDERRA Stare and Forward NEXT 0 Adding Data Collection Actions Adding data collection actions is the same fo
13. C 2008 Aicas MESInterface IT Oracle Extension installation and User s Guide MODEL CODE BAD 804Q015 A1 a MITSUBISHI ELECTRIC CORPORATION HEAD OFFICE TOKYO BUILDING 2 7 3 MARUNOUCHI CHIYODA KU TOKYO 100 8310 JAPAN NAGOYA WORKS 1 14 YADA MINAMI 5 CHOME HIGASHI KU NAOGYA JAPAN When exported from Japan this manual does not require application to the Ministry of Economy Trade and Industry for service transaction permission Specifications subject to change without notice
14. D TT Success 2 Transaction Local Insert Records Output Success NEXT Failure ENDERR Store and Forward ME hans lits ors 3 Transaction MOC_Local_Insert_Records GroupID LacalVariables GroupID DWORD Success MERT Failure ENDERR Store and Forward ME 21 Adding Data Collection Actions To add a data collection action either add an enterprise transaction using the transport map MOC_Local_Insert_Records or modify an existing action from the samples In the example below there are four data collection actions The first data collection record is highlighted and its parameters are displayed on the lower right section of the Trigger Edit window Trigger MOC Samples Direct Insert Group Event Direct Ingert Graup Event Local Variables Stati Variables Settings Details Length Default n a n a n a n a Remove Actions 2 Transaction 1 Get Next GroupID Transport map MOC Lacal Insert Records success NEXT 2 Transaction Local Insert_Records Input Output Routine Detailz Success NEXT Failure ENDERR Store and Forward NEXT Transaction Local Insert Records Success NEXT Failure ENDERR Store and Forward NEXT Logical Count Value Type 4 Transaction Local Insert Records p 1 Trang DWO RO Success NEXT Failure ENDERR Store and Forward NE
15. In this example there are four data elements All the information that is required by Oracle Manufacturing Operations Center for the data element is entered with each action The details of the data collection action will be covered in the Setting up a Direct Insert Transaction section Set Insert State The set insert state calls a transaction which sets a state variable in the collected records signifying all the data for this trigger has been successfully collected and is ready to insert into Oracle It is required directly after the data collection actions in the action list Insert into Oracle The final part is the execution of a subtrigger that inserts the data into Oracle For a direct insert this part will be the last item in the action list For batch inserts it will be the only action in a separate trigger Batch insert structure will be illustrated in the Setting up a Batch Insert Transaction section Setting up a Direct Insert Transaction The first sample transaction we will customize use s the Direct Insert Group Event trigger as a starting point This is a data event trigger that fires when a device variable changes value More information on configuring the trigger event type can be found in the MESInterface IT User s Guide The Direct Insert Group Event trigger collects multiple data variables and inserts the records into the Oracle Manufacturing Operations Center interface table as a single transaction It uses the Oracle Grou
16. Log Export OGPU Events FTF Server Network Gontiguration Oracle GraupID PU MOG Samples MOG SubTrizgers the next transaction to fire will use the value specified Oracle MOC Interface Administration The following parameter sets the current value of the GroupID Current Value 0 Ch Enterprise T The following parameter controls how the GroupID changes when a transaction fires E ev Transport Maps it will cause the GroupID ta change by the specified value Change By Listeners CA Devices gt Logs amp Reports E Local Database K Administration There are two parameters to set the Current Value and Change By The Current Value is the value that the next Group ID will receive and the Change By is the increment between Group ID s In the example below the starting Group ID will be 1 and it will increment by 1 for each Group ID as 1 2 3 4 and so on You should only have to set these parameters once during the implementation of the Oracle MOC Extension To use the Group ID you simply add the Get Next GroupID action to your action list In the example below the next Group ID is assigned to the local variable GroupID for later use Trigger MOC Samples Direct Insert Group Event Direct Insert Group Event Event Local Variables Static Variables Length Default n a n a n a n a Remove Actions 1 Get Next GroupI
17. MESInterface IT MITSUBISHI Oracle MOC Extension Installation and User s Guide Mitsubishi Programmable Controller M terface IT MELSEG Q VN SWMIT1 E 7 SAFETY PRECAUTIONS Always read these instructions before using this equipment Before using this product please read this manual and the relevant manuals introduced in this manual carefully and pay full attention to safety to handle the product correctly The instructions given in this manual are concerned with this product For the safety instructions of the programmable controller system please read the CPU module user s manual In this manual the safety instructions are ranked as DANGER and CAUTION X Indicates that incorrect handling may cause hazardous conditions resulting in DANGER death or severe injury CAUTION Indicates that incorrect handling may cause hazardous conditions resulting in i medium or slight personal injury or physical damage Note that the CAUTION level may lead to a serious consequence according to the circumstances Always follow the instructions of both levels because they are important to personal safety Please save this manual to make it accessible when required and always forward it to the end user Design Instructions lt gt DANGER When performing data changes or status control from the personal computer to the running PLC configure up an interlock circuit outside the PLC syste
18. XT DWI RD 1 LocalVariables GroupID RD 5 Transaction Local Insert Recordz T Macros EVENT TIME TIMESTAMP Success NEXT Failure ENDERR Store and Forward NEXT CONSTANT Transaction MOC_Local Update State STRING 255 Local CPU 1 01510 WORD Success NEXT Failure UNDEFINED Store and Forward NEXT er T Execute SubTrigger Insert with GrouplID from Project Sub Triggers Lean STRING 150 Success MEXT Failure ENDERR STRING 150 STRING 150 Dwo RD RD RD RD C A Uo User Measureb DWO RD Add Re sin rici col Quality Fla DWORD Up Down Validate For this record there are five fields that are used for data collection col rans ID the transaction ID col Group ID the Oracle GrouplD col Reading Time the time the data was read col Tag Code the name of the data tag col Tag Data the value of the data tag ee ie These are the five key fields for data collection when an Oracle Group ID is used The col Trans ID should be set to the local variable Trans ID The col Group ID should be set to the local variable GroupID If the Oracle Group ID is not used then the col Group ID would be left blank The col Reading Time should be set to the current timestamp by using the SEVENT TIME macro The col Tag Code should be set to the tag code configured in the Oracle Manufacturing Operations Center for this
19. ce IT Oracle MOC Extension When the import is finished the Import completed message will be displayed Click the button MeSInterface IT Workbench admin 192 168 3 4 User Help an Hodes Oracle MOG Interface El 192 169 34 Oracle MOC Interface Projects Item Count 2 Projects State Last State Changed Created Rai Samples Stopped 2012 04 20 18 59 32 2012 04 20 18 59 32 c SubTriegers Stopped 2012 04 20 18 58 82 2012 04 20 18 59 32 Be e Transport Maps o Devices e Logs amp Reports A Local Database x Administration The import should create two projects MOC Samples and MOC SubTriggers Both of these projects will be discussed further in the Customization section of this document MESInterface IT Workbench admin 192 168 3 4 User Help 4 LA Nodes H Oracle MOC Interface Projects Oracle Interface Count 2 EF 192 168 8 4 Projects a Ed Projects State Last State Changed Created nz Samples X Stopped 2012 04 20 18 59 92 2012 04 20 18 59 32 c RRS Enterprise MOG SubTriggers Stopped 2012 04 20 18 69 32 2012 04 20 18 59 32 ay Transport Maps j X ml Transports Listener Mapes m Listenerz C Devices e Logs amp Reports E Local Database he es Administrati Fo minigtratian 11 The import will also create six
20. count for insert into Oracle Trigger Samples Batch_Insert_Cumulative_Counter__Collect Name Batch Insert Cumulative Counter Collect Event Local Variables Static Variables Settings Details Mame Length Default GiraupID n a OUT Value n a n a n a n a n a There is also a static variable OUT MH1 Last which will hold the last value collected from a counter tag Trigger Samples Batch Insert Cumulative Counter Collect Mame Batch Insert Cumulative Counter Callect Event Local Variables Static Variables Settings Details Length Default Last RD n a SCR MR1 Last Dwad RD n a Add Remove When the Calculate_Counter_Change subtrigger is added to the action list there are four input parameters required and two out parameters The input parameters are as follows 1 Current the current counter value retrieved directly from the device 2 Last the last counter value retrieved from the static variable holding the last value Reset the highest value the counter will reach before resetting 4 Start the starting value after a counter reset 25 These input values are highlighted in the red circle on the following trigger edit window Trigger MOC Samples Batch_Insert_Cumulative_Counter_ Collect Batch Insert Cumulative Counter Callect Eve
21. cts 18 S schema 15 subtriggers 18 28 T triggers 18 deviceWISE enabled deviceWISE is a trademark of ILS Technology LLC Microsoft Windows Windows Vista SQL server and Visual Studio are registered trademarks of Microsoft Corporation in the United States and other countries Sun Sun Microsystems Java J2ME and J2SE are either trademarks or registered trademarks of Sun Microsystems Inc in the United States and other countries Oracle is a registered trademark of Oracle Corporation Adobe and Acrobat are registered trademarks of Adobe Systems Incorporation Pentium and Celeron are trademarks of Intel Corporation in the united States and other countries Ethernet is a trademark of Xerox Co Ltd in the United States CompactFlash is a trademark of SanDisk Corporation Other company names used in this document are trademarks or registered trademarks of respective owners The Program may contain some or all of the following third party components EZSocket Copyright C 2008 Mitsubishi Electric Corporation iconv Copyright C 2007 Free Software Foundation javasqlite Copyright C 2008 Christian Werner libxml2 Copyright C 2008 xmlsoft org log4j as originally developed by Apache org OpenSSL Toolkit Open SSL Project OpenSSL Copyright C 1998 2008 the Open SSL Project This product includes cryptographic software written by Eric Young eay cryptsoft com and by Tim Hudson tjh cryptsoft com Jamaica JVM Copyright
22. e MOG Interface LocalDB MOCInterface Table imc Items To Import y MTH TAG READINGS RAW SQLite table When the import is finished the Import completed message will be displayed Click the OK button MeSInterface IT Workbench admin 192 168 3 4 X User Help al Nodes Oracle MOC Interface Local Database Oracle Interface amp 192 168 Tables Execute SQL B Projects Name Columna 5 daB Enterprize MTH_TAG_READINGS RAW Seq Mo INTEGER PRIMARY KEY AUTOINGREMENT Trans ID INTEGER NOT NULL State INTEGER Listeners g ofa Devices e Logs amp Reports Local Database un Administrati Fo ministration 8 MESInterface IT Oracle MOC Extension There should be a new table named MTH TAG READINGS RAW in the local database as shown below MeSInterface IT Workbench admin 192 168 3 4 User Help 4 m Nodes Oracle MOC Interface Local Database Oracle Interface El 192 168 3 4 Tables Execute SL B Projects Columns MTH T G READIMGS RAW Seq Mo INTEGER PRIMARY KEY AUTOIMCREMENT Trang ID INTEGER NULL State INTEGER Enterprise ev Transport Maps S Row Number Seg Ma 10 State Group 10 Reading Time Gode o Devices gt Logs amp Reports Tag_Data Create_Date Lser_Attr K Administration The local database table import is completed Next the project will be ins
23. eeceaeeeessaeaeeesssaeseeseeaeeeessaaeeeeseaeeeess 4 Installing the Local Database Table ccccccccccccsseececeeeeeceeeeeeeeeeeeseeeeeseaeeeeseueeeseaeeesaeeessaeeessaees y Meela en au FO NER RT E E E E E EET 9 Chapter 3 Configuring for Your Oracle 13 Conroe mera ce VLAN SOM taeda cee pea scende 13 Coniig re the Transport 15 Chapter 4 Customizing 18 18 Oracle MOC Extension Trigger 19 19 19 5 ON E 20 20 OFAC 20 Seting up a Bir ct Insert 20 eeN 20 Sewn ID 21 Adding Data Collection Actions 22 Setting up a Batch Insert Transaction 23 Dew NG Transaction ID E E 24 lt TOUD 24 a Counter Variable 25 Adding Data Collection Actions naue raro etn e
24. ess WEST Execute SubTrigger Galculate_Gounter_Chanee from Project SubTriggerz Output Success NEXT Failure ENDERR Logical Gamat Leafs Execute SubTrigger Calculate Counter Change from Project SubTriggers GroupID DWORD 1 Success NEXT Failure EHDERR Transaction Local Inzert Recordz Success NEXT Failure ENDERR Stare and Forward NEXT Transaction MOG_Local_Insert_Records Success NEXT Failure ENDERR Store and Forward NEXT Transaction Local Inzert Records Success NEST Failure ENDERR Stare and Forward NEXT Transaction MOG_Local_Insert_Records Success NEXT Failure ENDERR Stare and Forward NEXT Transaction MOC_Local_Insert_Records Success NEXT Failure ENDERR Stare and Forward NEXT Transaction Lacal llpdate State Success NEXT Failure ENDERR Store and Forward NEXT Local Variables GrouplD 23 The Batch Insert Cumulative Counter Insert trigger selects the records from the local database based on the transaction ID and inserts them into Oracle every two minutes Using a batch insert methodology helps to reduce the network traffic and database activity EW Trigger MOC Samples Batch_Insert_Cumulative_Counter__Insert Name Batch Insert Cumulative Counter Insert Name DWORD Add Leneth n a Actions Success NEXT Failure UNDEFINED 1 Execute SubTrigger MOC_Insert_with_GroupID from Pro
25. have access to the following related documentation MESInterface IT User s Guide MESInterface IT Enterprise User s Guide MESInterface IT System Admintration User s Guide MESInterface IT Trigger Action Guide and Reference MESInterface IT Troubleshooting Guide MESInterface IT Quick Start TCP MESInterface IT Quick Start Database Insert MESInterface IT Quick Start WebSphere MQ ii MESInterface IT Oracle MOC Extension Chapter 1 Introduction Welcome to the Oracle Manufacturing Operations Center MOC Extension for MESInterface IT The Oracle MOC Extension provides the components to collect and format data from plant floor devices and inserts it directly into Oracle Manufacturing Operation Center for processing The Oracle MOC Extension has three components The Oracle MOC project import file contains the predefined transport transport maps and triggers to send data from a plant floor device to Oracle MOC The Oracle MOC local database table import file contains the predefined local database table for collecting data records prior to sending them to Oracle MOC The Oracle MOC package file contains special functions specifically required for the Oracle MOC interface This book provides step by step instructions on how to install and configure the Oracle MOC Extension components along with suggestions on how to customize your Oracle MOC Extension installation to meet your specific data collection requirements Assumptio
26. he following message box should appear Click the Yes button Add Package M This node may restart after the package 15 added Add the following package Mame Oracle Manufacturing Operations Genter Extension Version 1 0 010 20120218 Extension Once the installation is complete the following message will appear Click the Yes button and wait for the MESInterface IT node to restart You may have to manually restart the MESInterface IT node EN Add Package I When the MESInterface IT node has restarted return to the Administration panel by clicking on the Administration icon Click on the Packages tab and you should see entry for the Oracle Manufacturing Operations Center package You should also see a new tab Oracle GroupID MEsInterface IT Workbench admin 192 168 3 4 User Help m Nodes Oracle MOC Interface Administration 1 Oracle MOC Interface c 192 168 3 4 Ed Projects E Enterprise Attention Bit Automated Log Export Events Diagnostics FTP Server Licenses Network Configuration Notifications Oracle GroupID Packages Security Staging Browser System Variables Node Administration Time Management Name Version Oracle Manufacturing Operations Center Ex Extension 1 0 0 DW 20091001 g 7 Devices S Logs amp Reports Local Database lt Administration
27. ject MOC SubTriggers Execute SubTrigger Project Name SubTriggers SubTrieger Name Insert with GroupID Name of the trigger to execute Wait for Completion True Input Routing Details Input Name Logical Count Value Transaction ID DWORD 1 LocalVariables TransID DWORD L To customize these triggers for your data collection requirements there are four parts that need to be modified The transaction ID the Group ID the cumulative counter values and device data information To begin click the MOC Samples icon under Projects Then select the Batch Insert Cumulative Counter Collect trigger from the MOC Samples trigger list and click Edit Each of the parts can be modified through the Trigger Edit window Setting the Transaction ID To set the transaction ID for both triggers select the Local Variables tab near the top of the Trigger Edit window and add a default value to the Trans ID variable This can be any four byte integer value you want as long as each transaction ID is unique for this instance of MESInterface IT In the example following the transaction ID is 9 for both triggers Trigger Samples Batch Insert Cumulative Counter Collect Batch Inzert Cumulative Counter Collect Local Variables Static Variables Settings Details Mame GrouplD JO LIT Value rotatus SGR MR1 Value TransID Set
28. m Count 6 Logical L WORD TIMESTAMP STRING STRING STRING STRING STRING Average Execution Time ms Remove To Enterprise Schema ORAUSER Map Table Where Table Action Batch Insert Batch Count 500 Batch Ihsert Variable col GROUP ID col READING TIME col TAG CODE col TAG col CREATION DATE col USER_ATTRI col USER ATTR2 col USER ATTR3 d emn ATTN i Column DB NUMBER DATE VARGHAR2 VARGHAR2 DATE VARCHAR 2 VARGHAR2 VARGHAR2 TI Required 9 3 23232 23 MO C Insert Tag Readings Raw Transport Oracle MO w Name Version Mismatch Logical Length LWORD n a TIMESTAMP n a STRING 255 5 STRING 255 STRING 150 STRING 150 STRING 150 Average Execution Time ms Remove To Enterprise Map Table Schema RAUSER o Clear unused Input variables before mapping Table Where TAG REA Action Batch Insert Order By Batch Gount 500 Batch Insert Variable col GROUP ID col READING TIME col TAG_ CODE col DATA col GREATION DATE Column GROUP ID READING TIME DB NUMBER DATE VARGHAR2 VARCHAR2 DATE Required USER ATTR1 USER USER ATTR3 ATTU 4 VARCHAR2 VARCHAR 2 VARGHAR2 TAMAS IAMS 23233 23 16 MESInterface IT Oracle MOC Extension col USER ATTR1 c
29. m to ensure that the whole system will operate safely In addition predetermine corrective actions for the system so that you can take measures against any communication error caused by a cable connection fault or the like in online operations performed from the peripheral device to the PLC N CAUTION Read the manual carefully before performing the online operations especially forced output and operating status change which will be executed with the personal computer connected to the running CPU module Not doing so can damage the machine or cause an accident due to misoperation REVISIONS The manual number is given on the bottom left of the back cover Feb 2010 BAD 804Q015 A0 First edition Jun 2012 BAD 804Q015 A1 Correction Update the screen shot of the Workbench This manual confers no industrial property rights or any rights of any other kind nor does it confer any patent licenses Mitsubishi Electric Corporation cannot be held responsible for any problems involving industrial property rights which may occur as a result of using the contents noted in this manual 2012 ILS Technology Licensed to Mitsubishi Electric Corporation This book applies to the Mitsubishi Electric Corporation MESInterface IT product components and to all subsequent releases and modifications until otherwise indicated in new editions Make sure you are using the correct edition for the level of the produc
30. new transport maps MOC Insert Tag Readings Raw Local Insert Records Local Select Records No MOC Local Select Records with GrouplD MOC Local Update CreateDate and MOC Local Update State These will be discussed in the Configuration section of this document EJ MeSInterface IT Workbench admin 192 168 3 4 User Help Nodes ae E Oracle Interface Count 8 E Projects Ya Oracle MOC Interface Enterprise Last Average Execution Execution EF 4 Enterprise Transport Successes Failures Time ims Time me GettingData MESITDEMO DB 0 0 0 0 F Transport Maps Ingert Tag Readings Raw Oracle DB 0 0 0 0 MOC Ingzert Records LOGALDB DB 0 0 0 0 dU Tiaiisparts MOC Local Select Records Mo GroupID LOCALDB1 0 0 0 0 MOC Local Select Records with GrouplD LOCALDB2 0 0 0 0 Local Update Create Date LOCALDB4 DB 0 0 0 0 MOC_Local_Update_State LOCALDBS DB 0 0 0 0 Putting Data MESITDEMO DB 0 1 0 0 o Devices Logs amp Reports EE Local Database Filter Mone im Administration Finally the import file will create a new transport named Oracle We will discuss the configuring this transport for your environment in the next section B MESInterface IT Workbench admin 192 168 3 4 Sm User Help 4 m Nodes gt Oracle MOC Inte
31. ng one and include the new columns in the insert transaction You will also need to create a new transport map by duplicating one of the existing MOC Local Select Records xxxx transport maps to select the new user attribute or measurement columns from the local database Other subtriggers can be added to provide special functions like Calculate Counter Change This concludes the Customizing Transactions section 28 MESInterface IT Oracle MOC Extension Chapter 5 Troubleshooting The following provides troubleshooting help for problems specific to the Oracle MOC Extension Additional help can be found in the MESInterface IT Troubleshooting Guide The package file or export files fail during import Contact ILS Technology support for replacement files The Oracle MOC transport does not validate Check your database name host address port number user name and password If all of these are correct check your communication path to your Oracle database and make sure the Oracle database is operating properly can t find the TAG READINGS RAW table in the MOC Insert Tag Readings Raw transport map table list Select the correct schema from the Schema list then locate the MTH TAG READINGS RAW table If you cannot find the correct schema check with your database administrator to make sure your user name has access to the required schema l ve started a customized sample trigger but it won t run Check to make sure the Project it
32. nloaded Unloaded Unloaded Unloaded Unloaded Unloaded Unloaded Unloaded Unloaded Unloaded Unloaded Unloaded Last Triggered n a n a n a n a n a n a n a n a n a n a n a n a n a n a Item Count 14 User SUCCESSES Failures Ir co co co co co coco coco ceo So co co c co co coco coco co ecco triggers which collect records from multiple transactions and insert them into Oracle as a single batch insert and row transactions which collect records from a single transaction and inserts them into Oracle The batch triggers are comprised of a pair of triggers One trigger to collect the data from each transaction and place it in local storage and the other to pull the data from local storage and batch insert it into Oracle There are also transaction samples which are triggered by events which are triggered periodically which use the Oracle Group ID and which use cumulative counter variables Each of these conditions will be discussed through setting up a sample transaction Oracle MOC Extension Trigger Structure There are five parts to the Oracle MOC Extension trigger structure Transaction ID Special Functions Data Collection Set Insert State Insert into Oracle cc The Trigger Edit window below shows each of the five parts Trigger MOC Samples Direct Insert Group Event Direct Insert Group Event Event Local Variables Static Variables Settings Mame Count
33. ns Before using the information in this book the following should have occurred A target MESInterface IT node has been installed and is accessible on your network The MESInterface IT Workbench has been installed and can communicate to the target MESInterface IT node The Oracle Transport license has been installed on the target MESInterface IT node The target MESInterface IT node has been licensed and configured to communicate with the plant floor devices identified for Oracle MOC data collection The user is familiar with MESInterface IT terms concepts and Workbench operation Chapter 2 Installing the Oracle Extension There are three components to the Oracle MOC Extension that need to be installed in your MESInterface IT node a project a local database table and the Oracle MOC package Installing the Oracle MOC Package The first step is to install the Oracle MOC Package To start open the MESInterface IT Workbench and select the node that you want to load the Oracle MOC Extension on MESInterface IT Workbench admin Oracle MOC Interface 192 168 3 3 S Ed Projects Oracle Interface e Enterprise Transport Maps Transports g Listener Maps 4 Listeners a3 ale Devices ni H Logs amp Reports F ig Local Database Administration Then click on the Administration icon and select the Packages tab EJ MESInterface IT Workbench admin
34. nt Lacal Variables Static Variables Leneth Default DWORD n a DWORD n a DWORD DWORD DWORD RD Remove 4 7 Execute SubTrigger Ld 1 Get Next GroupID Project Hame MOG SubTrigeers Success NEXT i Sub Trigger Calculate Counter Change Wait for Completion True Execute SubTrigger Calculate Counter Change from Project SubTriggers Success NEXT Failure ENDERR Transaction Local Insert Records Success NEXT Failure ENDERR Store and Forward NEXT Transaction Local Insert Records e mca Count Value success NEXT Failure ENDERR Store and Forward NEXT Current DWORD 1 Local CFU 1 011506 WORD Transaction Local Ingzert Recordz Last Dwo RD 1 Static Variables OUT MRI_L DWwoRD Success NEXT Failure ENDERR Store and Forward NEXT Reset DWORD 1 999 CONSTANT Transaction Local Insert Records DWORD 0 GO NS TANT Success NEXT Failure ENDERR Store and Forward NEXT Transaction Local Insert Records Success NEXT Failure ENDERR Store and Forward NEXT Transaction MOC_Local_Update_State Success NEXT Failure ENDERR Store and Forward NEXT The output parameters are as follows 1 Delta the change in the two counter values and is assigned to the local variable holding the count 2 NewLast the current value from the device becomes the new last value and is assigned to the static variable holding the last value 2
35. ol USER_ATTR2 col USER ATTR3 1 The Input variables will be automatically mapped to their corresponding columns in the table Click the Save button and the transport map configuration will be completed Transport Map Name _Insert_Tag_Readines_Raw Version Mismatch Fail Transport Orac le MO Input From Trigger Item Count 6 Name Logical Length col GROUP ID n a col READING TIME n a col CODE Time ms col DATA col USER ATTR1 col USER ATTR2 col USER ATTR3 n a n a n a n a n a To Enterprise Schema ORAUSER Map Table Table MTH TAG READINGS RAW Where Action l Batch Insert Order 4 Batch Count 500 Batch Insert Column DB Required Variable GROUP ID NUMBER col GROUP ID READING TIME DATE col READING TIME CODE VARCHAR col TAG CODE TAG_DATA VARCHAR2 col TAG_DATA CREATION DATE DATE col GREATION DATE USER ATTR1 VARCHAR col 5 _ 1 USER_ATTR2 VARGHAR2 col_USER_ATTR2 USER ATTR3 VARGHAR2 col_USER_ATTR3 Ol eh ee TII l11 Crm ATTMs 4 RD Cr ers 201 RD AD CC This completes the configuration of the Oracle MOC Extension The next section will review how to customize the Oracle MOC Extension for your specific data collection requirements 17 Chapter 4 Customizing Transactions
36. p ID to group the values together for processing To customize this trigger for your data collection requirements there are three parts that need to be modified The transaction ID the Group ID and device data information To begin click the MOC Samples icon under Projects Then select the Direct Insert Group Event trigger from the MOC Samples trigger list and click Edit Each of the three parts can be modified through the Trigger Edit window Setting the Transaction ID To set the transaction ID select the Local Variables tab near the top of the Trigger Edit window and add a default value to the Trans ID variable This can be any four byte integer value you want as long as each transaction ID is unique for this instance of MESInterface IT In the example following the transaction ID is 7 E3 Trigger MOC Samples Direct Insert Group Event Mame Direct Insert Group Event Event Local Variables Static Variables Settings Details Length Default n a n a n a n a 20 MESInterface IT Oracle MOC Extension Setting the Group ID The Group ID 1 an identifier used by Oracle Manufacturing Operations Center to group records collected in the same transaction for processing To set the Group ID parameters Click on the Administration icon and select the Oracle GrouplID tab E3 MESInterface IT Workbench admin 192 168 3 4 3 User Help A Nodes Oracle MOG Interface 192 168 5 4 Automated
37. r Mone E KR Administration Mame MOC Ingzert Tag Readings Raw Transport Mame Oracle a nc E E This will display the Transport Map edit window Select your schema from the schema list Insert Tag Readings Raw Version Mismatch Fail z Transport Oracle MO 2 Input From Trigger Item Count 6 Name Logical Length col GROUP ID LWORD n a col READING TIME TIMESTAMP n a E Msi a col TAG CODE STRING 255 col TAG DATA STRING 255 In col USER ATTR1 STRING 150 col USER ATTR2 STRING 150 col USER ATTR3 STRING 150 To Enterprise Schema OLESTIE Rm Table MTH TAG READINGS RAW Available schemas in the database Where Action Batch Insert Order By Batch Count 500 Batch Insert Column DB Required Variable GROUP ID NUMBER col GROUP ID READING TIME DATE col READING TIME CODE VARGHAR2 col TAG_CODE TAG_DATA VARGHAR2 col TAG_DATA CREATION_DATE DATE col CREATION DATE USER ATTR1 VARGHAR2 col USER_ATTRI USER_ATTR2 VARCHAR col USER_ATTR2 USER ATTR3 VARGHAR2 col USER_ATTR3 erm ATTN TANG IANA lb11Crm 4 3 3 932232 15 Next select the READINGS_ RAW interface table from the table list The columns for this table will be listed at the bottom of the window C Insert Tag Readings Raw Transport Oracle MO mim Name Version Mismatch Fail Ite
38. r both direct and batch insert triggers The minor difference in this example is for the cumulative counter values Instead of assigning the device tag value to be inserted into Oracle the local variable that holds the difference in counter values is assigned This is the Delta output value from the Calculate_Counter_Change subtrigger This assignment is highlighted in the circle on the following trigger edit window 27 Trigger MOC Samples Batch Insert Cumulative Counter Collect Mame Batch Insert Cumulative Counter Collect Event Local Variables Static Variables Settings Details Name Leneth Default GroupID n a OUT Value n a rCount n a rStatus n a SOR MR1 Value n a n a Actions 2 Transaction 1 Get Next GroupID Transport map Local Insert Records Success NEXT 7 Execute SubTrieger Calculate Counter Change from Project MOC SubTrieeers Input Output Routing Details Success NEXT Failure ENDERR 8 Execute SubTrieger Calculate Counter Change from Project MOC SubTrieeers Success NEXT Failure ENDERR Name Logical Count Value Type 2 Transaction MOC Local Insert Records col Trans ID DWORD 1 LocalVariables TransID DWORD Success NEXT Failure ENDERR Store and Forward NEXT col Group ID DWORD 1 LocalVariables GroupID DWORD 1 3 Transaction Local Insert Records col Reading Time LWORD Macros SEVENT IIM TIMESTAMP Success NEXT Failure ENDERR Store and Forward
39. rface Enterprise Oracle MOC Interface ltem Count 8 8 Projects Pending SF SF Aueue Enterprise Type state SUCCESSES Failures Queued Deleted Pending Overflow Po is DB Down 0 0 0 0 0 0 EF Transport Maps DB Down 0 0 0 0 0 0 DB Down 0 0 0 0 0 0 DB Down 0 0 0 0 0 DB Down 0 0 0 0 0 0 DB Down 0 0 0 0 0 0 DB Down 0 1 0 0 0 0 E Oracle DB Bown Devices Mame Oracle Type DB eR Logs amp Reports State Down DB Oracle Database AE Host 192 168 1 121 Last Run n a Gonnect Time Minimum Gonnect Time Maximum Connect Time Last Re Administration Last Error Gode Last Error Time n a Last Error Message This completes the installation of the Oracle MOC Extension 12 MESInterface IT Oracle MOC Extension Chapter 3 Configuring for Your Oracle Environment There are two parts to configuring the Oracle MOC Extension The first part is to modify the Oracle_ MOC transport to use your specific location and identification parameters The second part is to modify the MOC Insert Tag Readings Raw transport map to use your instance of the Oracle Manufacturing Operations Center interface table First we will configure the transport Configure the Oracle Transport There are five key parameters which must be changed in the transport configuration to communica
40. s in has been started l ve started a customized sample trigger but it fails immediately Check to make sure the SubTriggers project has been started and that all the subtriggers in that project have been started l ve started a customized sample trigger but the transactions are going into the store and forward queue Validate the Oracle MOC transport and make sure the communication path to your Oracle database and the Oracle database are operating properly l m using a batch insert transaction but the data is staying in the local database Check to make sure the corresponding insert trigger has been started If it has check to make sure that the transaction ID for both the collect and insert triggers are the same The Oracle Group ID is not being inserted into the Oracle Manufacturing Operations Center interface table with my data Check to make sure that you are using the Get Next GroupID special function that you are populating the col Group ID in your data collection actions and that you are using the Insert with GrouplD subtrigger to insert the records into Oracle 29 Index A Administration icon 4 B batch triggers 19 C Configure the Oracle Transport 13 Configure the Transport Map 15 G Group ID 21 I Installing the Project 9 L local database table 7 Oracle Manufacturing Operation Center 3 Oracle MOC Extension 3 Oracle MOC Package 4 P Packages tab 4 proje
41. t Mitsubishi Electric Corporation PROVIDES THIS BOOK AS IS WITHOUT WARRANTY OF ANY KIND EITHER EXPRESS OR IMPLIED INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE Some states do not allow disclaimer of express or implied warranties in certain transactions therefore this statement may not apply to you This book could contain technical inaccuracies or typographical errors Changes are made periodically to the information herein Mitsubishi Electric Corporation May make improvements and changes at any time to the product s and or program s described in this book When you send information to Mitsubishi Electric Corporation you grant Mitsubishi Electric Corporation a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you Table of Contents ugi ie E Who should read this i How this book is organized sisisi cud ds i Related COCHIMEMLATION i 21 PP T UU mn 3 acram E SN xS 3 Chapter 2 Installing the Oracle MOC Extension ccccsssccccceeeeeesaeeeeeeeseeeeeeseeeeeeeseeeeeeeseaeeeesagaes 4 Installing the Oracle Package ccccceccccccessececeeeeeceeseeee
42. talled Installing the Project The last step of the installation imports the new project components for the Oracle MOC Extension Start by placing the mouse over the Projects icon and press the right mouse button Select Import from the list box MESInterface IT Workbench admin 192 168 3 4 User Help an Nodes Oracle Interface i 19216834 Projects Name Fd Oracle MOC Inte REA New aa Ente e Export ug Listeners Devices Logs amp Reports E Local Database A Administration Navigate to the Oracle MOC Extension folder and select the MOC_Project dwx file and click the Select bution MeSInterface IT Workbench admin 192 168 3 4 User Help m Mades 4 H Oracle MOC Interface Projects Oracle MOG Interface E 192 168 3 4 nd vi Enterprise Item Count 0 8 ema LocalDB MOCInterfaceTable dwx my MOC_Project dwx co gall Devices D gt Logs amp Reports Dacuments Local Database T A E R Administration Jee y 4a v4 HE d H7 5 MOC Project de MESInterfacelT Export Files The following pop up should appear Select the Import button Import File DXOracle InterfacesOracle Interface Oracle Items To Import 815 v MOG Samples Project Hy MOG SubTriggers Project 10 MESInterfa
43. te with the Oracle Manufacturing Operations Center These parameters are the database name the hostname or IP address of the server the port ID for the Oracle database the user name and the password to allow access to the database Once these parameters are changed and validated the database communication will be established The first step in configuring the transport is to click on the Transports icon in the left column and select the Oracle MOC transport so it is highlighted as shown below MeSInterface IT Workbench admin 192 168 3 4 User Help 4 m Nodes H Oracle MOC Interface Enterprise Oracle MOC Interface Item Count 8 EH Pending Queue Hi Enterprise State SUCCESSES Failures Qlueued Deleted Pending Overflow DB Drown Transport Maps DB Down i DB Down DB Down DB Down DB Down DB Down TS Oracle DE Down E Devices Mame Oracle Type DB Oracle 168 1 121 gt Logs amp Reports State Down DB ra i Database AE Host 182 MR Local Datahace Last Run n a Connect Time Minimum Connect Time Maximum 0 Connect Time Last 0 Adminigstratian Last Error Gode 0 Last Error Time n a i Last Error Messaze Then click the Edit button and the edit window will be displayed 13 Clear the DB Name Host Port User ID and Password fields and enter the specific information
44. ting the Group ID Length Default n a n a n a n a n a n a To use the Group ID you simply add the Get Next GroupID action to your action list In the example below the next Group ID is assigned to the local variable GroupID for later use 24 MESInterface IT Oracle MOC Extension Using a Counter Variable The counter variable assumes that values from a counter in a device are being collected and the difference in the counter values between two readings is the data required by the Oracle Manufacturing Operations Center This difference is the actual count over a given period of time For example if the counter value 1 5 at the first reading and 15 at the second reading then the difference or count would be 10 A counter also can reset after it reaches a defined value For instance a counter can start at 0 and count to 999 then reset to 0 and continue counting To accurately calculate the difference or count value the formula must also calculate the difference when a reset has occurred between readings All of these considerations were used in developing the Calculate_Counter_Change subtrigger To use the Calculate_Counter_Change subtrigger you need to define a local variable and a static variable The local variable will be set to the calculated count and the static variable will hold the last value of the counter for calculating the next count In the example below the local variable OUT MR1_ Value will be set to the calculated
Download Pdf Manuals
Related Search