Home Omaha Kansas City Wichita Springfield St. Louis

Search


OR












Tech Articles Tech Articles

Top 5 Wonderware InTouch Development Tips 07/12/2017

Top 5 InTouch Development Tips 1 Secondary Source Each access name can be given a secondary source This results in redundant paths to a PLC Select Special, Access Names, and choose an access name of y...(read more)

Top 5 InTouch Development Tips 1 Secondary Source Each access name can be given a secondary source This results in redundant paths to a PLC Select Special, Access Names, and choose an access name of your choosing When enabled, the Failover button becomes active which allows the timing between failures to be manipulated In intermittent networks, it's best to allow an amount of seconds before switching over to the backup. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission 2 Change Default Font Size Placing text or buttons on your windows can appear with small or unreadable font. Change the default font from Special, Configure, WindowMaker At the bottom right, select text or button and adjust the settings. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission 3 True Fullscreen WindowViewer comes with a titlebar and toolbar constantly showing This coupled with the Windows Start Menu can make window creation and sizing more difficult To make the WindowViewer experience truely full screen, go to Special, Configure, WindowViewer, and Window Configuration tab Uncheck 'Menu Bar', check 'Hide Title Bar', and lastly check 'Always Maximize'. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission 4 Duplicate with a Pattern Creating duplicates or shapes or elements, it's typically important to keep them in line or at least follow a pattern After first duplicating, move it immediately to the spot you desire and select duplicate again Observe and breath a huge sigh of relief. 5 Delete Tags Has this ever been a problem? Wonderware has created a particular work flow for a tag to be deleted If we deleted tags willy nilly, the animations throughout the application would be left orphaned without parents and all alone No one wants to be alone Except creepy people who hang out in basements all day. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission First, run Special, Cross Reference, and search for the tag in question Leave the default settings. Delete or replace the tag everywhere it's being used The resulting cross reference can be saved as a file for later digestion. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission After the tag has been taken out of use, select Special, Update Use Counts This will be the final blow against our rogue tag. The delete button has now become available. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Make Standards A Reality With Protected Objects In Wonderware System Platform 07/12/2017

Make Standards a Reality with Protected Objects Enforced standard objects can be achieved with the new Wonderware System Platform 2014 feature of protected objects By protecting objects, standard obje...(read more)

Make Standards a Reality with Protected Objects Enforced standard objects can be achieved with the new Wonderware System Platform 2014 feature of protected objects By protecting objects, standard objects are enforced and plant employees will follow corporate standards. Here is how the exciting new Archestra IDE tool works: Protected objects are exported from one galaxy by right clicking the objects then selecting export as protected objects Then in another galaxy, the protected objects are imported as normal but can’t be changed The object has a small padlock icon See the screenshot below. A common case of protected objects is objects delivered from corporate Corporate needs to know their objects haven’t been changed when people are calling them for support The people at the plant can always derive a template off the protected objects to make an additions necessary to do their job, but they are prevented from changing the protected objects. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

A Few Useful SQL Queries For Wonderware System Platform 07/12/2017

A Few Useful SQL Queries for System Platform Here are some tips for more advanced Wonderware System Platform users. These are all SQL queries, and can be executed from SQL Management Studio, selecting...(read more)

A Few Useful SQL Queries for System Platform Here are some tips for more advanced Wonderware System Platform users. These are all SQL queries, and can be executed from SQL Management Studio, selecting the database that matches your Galaxy name. CAUTION: Do not make changes to any data in this database You are peeking behind the scenes of the IDE here, and could corrupt your galaxy very easily if you’re not careful. 1 Get a list of ALL checked-out objects sSelect tag_name from gobject where checked_out_by_user_guid is not NULL Formatted: Indent: Left: 1" 2 Get a list of all Attributes/UDAs with Alarming enabled select * from internal_all_alarms_view Formatted: Normal 3 Get a list of all objects on a platform. Substitute your actual platform name for ‘GRplatform’ below. select internal_common_obji.tag_name from gobject g inner join internal_common_obj i on gobject.gobject_id = internal_common_obji.myplatform where iinternal_common_obj.myplatform in ( select gobject_id from gobject where tag_name = 'GRplatform') Formatted: Indent: First line: 0.5" Formatted: Font: (Default) Consolas Formatted: Normal 4 Get a list of all Attributes/UDAs with History enabled select g.tag_name + '.' + p.primitive_name as name, p.gobject_id, p.package_id, p.mx_primitive_id from dbo.gobject as g Formatted: Indent: First line: 0.5" inner join dbo.primitive_instance as p inner join dbo.primitive_definition as pd inner join dbo.package as pkg where (g.is_template = 0) and (g.namespace_id = 1)

Moxa Finding A Better Protocol Conversion Solution Between PLCs And Devices 07/12/2017

WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices Casper Yang Senior Product Manager Edward Lin Product Manager WHITE PAPER Finding a Better Protocol Conversion ...(read more)

WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices Casper Yang Senior Product Manager Edward Lin Product Manager WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices Abstract Variable Frequency Drives (VFDs for short), are used in a number of industrial applications to save energy by controlling the speed of motors VFDs are important since Electric Motor Driven Systems (EMDSs) account for about 45% of all electricity consumption In this white paper, we show how industrial Ethernet gateways can be used to create a communication gateway between VFDs and PLCs that is easy to install and maintain. Released on January 15, 2015 © 2015 Moxa Inc All rights reserved. Moxa is a leading manufacturer of industrial networking, computing, and automation solutions With over 25 years of industry experience, Moxa has connected more than 30 million devices worldwide and has a distribution and service network that reaches customers in more than 70 countries Moxa delivers lasting business value by empowering industry with reliable networks and sincere service for automation systems Information about Moxa’s solutions is available at www.moxa.com. How to contact Moxa Tel: Fax: 1-714-528-6777 1-714-528-6778 © 2015 Moxa Inc. 1 WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices Overview According to the International Energy Agency (IEA), electric motor-driven systems (EMDSs) collectively use more electricity than any other single electrically powered application Perhaps somewhat surprisingly, EMDS applications consume more than twice as much electricity than lighting, which comes in a distant second It is estimated that globally, EMDS applications account for about 45% of all electricity consumption, with EMDS applications blamed for creating about 6040 megatons of CO2 emissions per year In addition, by some estimates, EMDS applications account for 70% of the electric energy used by industry, with common usages including pumps, fans, compressed air delivery, conveyors, and motive power for other machinery. The bottom line of all these stats is that if you want to save energy and promote energy efficiency in your industrial applications, you need to reduce the amount of energy consumed by EMDS applications This is where variable frequency drives (VFDs) come in VFDs can control motor speed to save energy, and can also decrease inrush current and apply a specified amount of torque. VFDs can be integrated into a control system through either a digital I/O, analog I/O, or communication interface connection The communication interface is accessible via either RS232, RS-485, or Ethernet, and gives operators a convenient way to not only control the VFD, but also obtain information about the VFD that might otherwise be unavailable The main problem, however, is how to handle conflicting protocols Most VFDs only support the Modbus RTU protocol, because it is easy to support and used widely for industrial automation applications PLCs, however, are more likely to use an industrial Ethernet protocol, such as Modbus TCP or EtherNet/IP. Communication Requirements for VFD Monitoring and Control A SCADA system usually includes an HMI and a PC, as well as PLCs and RTUs The PC is normally used to issue supervisory level commands, with most of the control performed by the PLCs and/or RTUs It is worth pointing out that even though PLCs and RTUs perform similar functions, there are key differences PLCs, for example, have more sophisticated embedded control capabilities, making them more suitable for local control operations such as production lines On the other hand, RTUs are suitable for connecting to devices distributed over a wider area since they have telemetry hardware capable of sending digital data to the supervisory system. Since VFDs are often used to control motors that operate pumps, fans, or conveyor belts— which means they are part of a local control system—we would expect the VFDs to be connected to a PLC For example, a typical architecture for controlling air quality in a factory building requires the SCADA operator to set a CO2 target level in ppm (parts per million) The resulting control system reads the current CO2 level from meters designed expressly for that purpose, and then the PLC issues the appropriate control signal to tell the VFDs how to adjust the speed of fans In order to ensure that the optimization control system operates as expected, provisions need to be made to guarantee that the VFDs use the correct industrial protocol to communicate with the PLC. © 2015 Moxa Inc. 2 WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices Existing Solution The first thing we should keep in mind is that PLCs available from different vendors don’t necessarily support the same fieldbus protocol For example, most Siemens PLCs support PROFINET, Rockwell PLCs support EtherNet/IP, and Schneider PLCs support Modbus TCP. Individual vendors accommodate other fieldbus protocols by providing communication modules that are installed right next to the PLC The advantages of using PLC communication modules are ease of installation and reliability Since the modules are connected directly to the PLC, users do not need to install additional wiring On the downside, the disadvantages of using PLC communication modules are the high cost, and limited versatility. On the VFD side of the connection, Modbus RTU is the protocol used by most vendors When the need arises to accommodate other fieldbus protocols, most vendors provide PCBs (printed circuit boards) that plug directly into the VFD to provide the necessary protocol conversion. The advantages of using VFD communication modules are essentially the same as the advantages of using PLC modules In addition, since the PCBs plug directly into a slot inside the VFD, they don’t take up any extra space. The cost is not particularly high, provided you only need one PCB module But if you need to install two, three, or more units, you’ll need to spend two, three, or more times as much money to get your solution up and running You should also factor in the amount of time required to install all of the modules. Introduction to Industrial Ethernet Gateways An attractive alternative to investing in PLC and/or VFD communication modules is the industrial Ethernet gateway A gateway is a standalone device that converts a signal from one protocol to another For example, a gateway could convert Modbus RTU to Modbus TCP, or convert Modbus RTU to PROFIBUS The gateway achieves this with a built-in CPU and memory storage capability In effect, the VFDs and PLC communicate directly with the gateway instead of with each other The process is transparent to the VFDs and PLC since the gateway handles all of the necessary protocol conversions. © 2015 Moxa Inc. 3 WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices The Benefits of Using Industrial Ethernet Gateways If you decide to use an industrial Ethernet gateway solution, you will need to spend time learning how to use the gateway, and also expend a certain amount of effort configuring and managing gateways as they are added to your system However, compared to using PLC and/or VFD communication modules, the gateway provides several attractive benefits In fact, if you use a gateway that comes with a user-friendly interface and good management functions, the additional effort required to configure and manage the gateway will be minimal. A good way of distinguishing the gateway solution from the PLC/VFD module solution is to compare the two solutions from a hardware and software perspective. Easy and cost-effective hardware integration If you decide to use a VFD communication module, you will need to remove the VFD’s housing to install the module As you might imagine, this operation could take quite a bit of time, particularly if you have dozens of VFDs that need to be upgraded, in which case the VFD module solution could be quite costly In fact, you might even have trouble finding a system integrator who will agree to upgrade an existing system in this way As far as PLC modules are concerned, installation is easier, but you will need to sacrifice one PLC slot that otherwise could be used for a different purpose If your PLCs are in a different location than the devices, you will need to contend with the fact that PLCs only support a serial connection Using a gateway to connect your devices to a common Ethernet base is the preferred solution because of the flexibility it adds to your system Another factor to consider is that with an Ethernet-based environment, you can use fiber to avoid interference from electromagnetic noise. Versatile and simple software integration The most important benefit of using a gateway solution is versatility For example, you may want to monitor different aspects of your VFDs after your system is up and running Or, you may want to install additional VFDs in your system after it has already been in operation for one or more years In fact, this is a very common situation faced by engineers responsible for managing a factory With a gateway solution, you can reserve I/O space in the PLC and the gateway configuration for future expansion When it comes time to add new VFDs, you will only need to configure the gateway, instead of tweaking the PLC software If you use a PLC module solution, you will need to update the PLC software by adding commands for dealing with the module Another advantage of using a gateway is that it has built-in CPU and memory that enables the gateway to handle protocol conversion by itself, instead of using the PLC for this purpose With a gateway solution, your system will be simpler, and easier to maintain. © 2015 Moxa Inc. 4 WHITE PAPER Finding a Better Protocol Conversion Solution between PLCs and Devices Moxa Industrial Ethernet Gateways Moxa’s MGate family offers a variety of gateway solutions that can be used for VFD applications MGate gateways have a rugged design suitable for harsh, high temperature environments, and provide the best reliability for dealing with electronic noise Since MGate gateways are PI and ODVA certified and support all major PLC protocols, including Modbus TCP, EtherNet/IP, PROFIBUS, and PROFINET, you won’t have any trouble connecting your VFDs to any of the commonly used PLCs In addition, Moxa’s MGate gateways come with a userfriendly web interface, a microSD card slot for configuration backup, and alarm and system log management functions to reduce your maintenance effort. For more information about Moxa’s MGate products, visit Moxa’s website at http://www.moxa.com/Event/Tech/2012/Industrial_Ethernet_gateways/index.htm. Disclaimer This document is provided for information purposes only, and the contents hereof are subject to change without notice This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied by law, including implied warranties and conditions of merchantability, or fitness for a particular purpose We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. © 2015 Moxa Inc. 5

Installing Wonderware InTouch 2014 R2 Development 07/12/2017

Installing InTouch 2014 R2 Dev Published: July 11, 2015 Overview This document details installing Wonderware 2014 R2 Development The first page (this page) lists bullet points of what needs to be don...(read more)

Installing InTouch 2014 R2 Dev Published: July 11, 2015 Overview This document details installing Wonderware 2014 R2 Development The first page (this page) lists bullet points of what needs to be done All of the following pages are step-by-step instructions with screenshots Please note the installer includes SQL Server Express making it unnecessary to install SQL Server on your own. Application Version(s)  InTouch 2014 R2 Development Windows Preparation  Consult the readme file on “Wonderware System Platform 2014 R2” disk to confirm which Windows service packs are supported.  Log in as an administrator for the install.  Exclude these folders from the virus scanner (Windows Defender, McAfee, etc.): C:ProgramDataArchestrA C:Program FilesCommon FilesArchestrA C:Program Files (x86)ArchestrA C:Program Files (x86)Common FilesArchestrA C:Program Files (x86)Wonderware C:UsersAll UsersWonderware C:Program Files (x86)ArchestrAFrameworkbin C:Documents and SettingsAll UsersApplication DataArchestrA C:ProgramDataArchestrALogFiles C:Documents and SettingsAll UsersApplication dataArchestraLogFiles  Exclude these file extensions from virus scanner: aFDX ixd pdx Installing InTouch  Let the installer install any needed prerequisites All the required prerequisites are on the disk, no internet required.  Install role based Select “Development Workstation”.  Configure Wonderware account with same username/password as other Wonderware computers.  Reboot when installer prompts for a reboot (last step of the installation wizard). 1 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Exact Steps Step 1: Run Setup.exe off the “Wonderware System Platform 2014 R2 with InTouch 2014 R2” disk. 2 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 2: Install the net framework The installation files are already on the computer removing the need for an internet connection Net is a large install taking a long time. Step 3: Click the “Install Prerequisites” button. 3 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 4: Select the “Wonderware System Platform Computer Roles” radio button (different from default) Then click next. Step 5: Select the “Development Workstation” checkbox Then select next. 4 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 6: Click next. Step 7: Click next. 5 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 8: Read the EULA for the four products Then check the “I have read…” checkbox Then click agree. Step 9: This step creates/defines the Windows account used for Wonderware software on this runtime PC to communicate with Wonderware software on other computers. Make sure to set this username and password the same on all computers. 6 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 10: Click next The statement about 5000 I/O is only relevant for System platform. Step 11: Click the button “Install Prerequisites” This step will take a long time because SQL Express is installed for you If SQL Server is already installed on the machine this step will be fast because SQL Express will not need to be installed. 7 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 12: Click “Install”. Step 13: Wait for installer to complete. 8 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 14: Click Finish. Step 15: Waiting for Language packs to install. Step 16: Click “Restart Now” button. 9 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 17: Launch “ArchestrA License Manager” by going to Start->All Programs>Invensys->License Manager->ArchestrA License Manager Step 18: Check the box “Do not ask this question again” Then click the button “No”. 10 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 19: Click then menu “File” then click “Install License File…” menu item. Step 20: Navigate to the location of the license file The suffix for the license file for this version of InTouch is ArchestrA.lic Then lick the “Open” button. 11 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Dev Step 21: Observe that the license file is installed Your license will have a different content. Step 22: Congratulate yourself on a successful install. 12 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Wonderware Scheduled SQL Express Database Backups 07/12/2017

Scheduled SQL Express Database Backups Scheduled SQL Express Database Backups Published: April 17, 2017 Overview SQL databases are the foundation for many Wonderware software programs They are const...(read more)

Scheduled SQL Express Database Backups Scheduled SQL Express Database Backups Published: April 17, 2017 Overview SQL databases are the foundation for many Wonderware software programs They are constantly updated and changed as projects evolve Backing these up becomes important in the event of computer hardware failure Instead of ad-hoc backing these up when remembered, setup a scheduled task and a simple batch file to do this automatically This applies to all Microsoft SQL Express versions and does not require Wonderware to be present SQL Standard has its own backup method using Agent which isn’t covered in this guide. Batch File Microsoft SQL gets installed with a command utility called sqlcmd.exe While this command has many uses, we’ll show the database backup feature. 1 Syntax sqlcmd -S [server name] -Q "backup database [database name] to disk=[filepath]" There are three variables in this command. 1 [server name] – replace with IP or node name of a SQL machine 2 [database name] – name of database as seen in Management Studio a. Figure 1 SQL Management Studio 3 [filepath] – This is a drive letter or UNC path down to the file and extension. a Example: C:sqlbackupsdatabase.bak 1 © 2017 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Scheduled SQL Express Database Backups 2 Batch A batch file contains one or many commands to be run one at a time If we have one or many databases to backup, we’ll make a line command for each This file can be created anywhere on a machine but must be named with a “bat” extension Editing the file is done through typical text editors like notepad Here is an example of backing up two databases: sqlcmd -S localhost -Q "backup database Runtime to disk=’C:sqlbackupsRuntime.bak’" sqlcmd -S localhost -Q "backup database ProductionGalaxy to disk=’\serverfilesharesqlbackupsProductionGalaxy.bak’" Both of these commands reside in one batch files Notice the disk filepath has single quotation marks while the entire ‘-Q’ parameter gets double quotation marks. Let’s take this a step further Each time this runs, it will overwrite the previous file which doesn’t give us revisions through time We’ll add date and time to the file which can give us a bit of history. set hr=%time:~0,2% if "%hr:~0,1%" equ " " set hr=0%hr:~1,1% set currentdatetime=%date:~-4,4%%date:~-10,2%%date:~7,2%_%hr%%time:~3,2%%time:~6,2% sqlcmd -S localhost -Q "backup database Runtime to disk='C:sqlbackupsRuntime_%currentdatetime%.bak'" Now we have a single database backed up to a filename containing date and time The first 3 lines do not need any modification and give us a full date/time string The fourth line runs the backup with the date/time expressed in the variable %currentdatetime%. Task Scheduler Now we need to run this batch file repeatedly without human interaction Task Scheduler is a part of Microsoft Windows operating systems and is found in Control Panel > Administrative Tools Right click onto Task Schedule Library and create a basic task Design the schedule to your needs When you arrive at the action step, select ‘start a program’ and browse for the batch file we created Ignore the ‘add arguments’ and ‘start in’ fields. To keep this automated such that no user must be logged in, modify the task so that ‘run this task whether user is logged in or not’ and type the user’s password. 2 © 2017 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

3 Quick Wonderware Historian Tips 06/06/2017

3 Quick Wonderware Historian Tips Published 06/07/2017 1 How to Configure Historian for Auto Start In the System Management Console Navigate to your Historian server -> Configuration Editor -> System...(read more)

3 Quick Wonderware Historian Tips Published 06/07/2017 1 How to Configure Historian for Auto Start In the System Management Console Navigate to your Historian server -> Configuration Editor -> System Configuration -> Parameters You are looking for the AutoStart parameter Make sure that parameter is set to 1 If not change the value to 1 and be sure to commit the changes. © 2017 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission 2 How to configure the Historian to be dependent on the SQL Service. If SQL Server starts up slowly for some reason, we have seen cases where Historian fails to autostart To prevent this, add a dependency to Historian so it waits on SQL Server Run the registry editor. Browse to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesInSQLConfiguration Edit the DependOnService multistring value Append the string “MSSQLSERVER” to the list Now on a reboot the Historian will wait until SQL Server is running before attempting to start. © 2017 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission 3 How to configure the alternate storage location in Historian By default your Historian has no alternate storage location defined This means if you run out of disk space, there is no place to fail over to and Historian stops In the System Management Console Navigate to your Historian server -> Configuration Editor -> System Configuration -> Storage -> Storage Locations You are looking for the Alternate storage location type Edit the Path to be a location valid on your local computer or network Be sure to commit the changes when you are finished editing. © 2017 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Wonderware SQL Server Express 2014 SP1 03/02/2017

LOGIC TECH SERVICES Wonderware's SQL Server Express 2014 R2 SP1 Revision: 1.0 Status: Public Published: February 28, 2017 1 Wonderware System Platform 2014 R2 SP1 includes SQL Server Express 2014...(read more)

LOGIC TECH SERVICES Wonderware's SQL Server Express 2014 R2 SP1 Revision: 1.0 Status: Public Published: February 28, 2017 1 Wonderware System Platform 2014 R2 SP1 includes SQL Server Express 2014 SP1 with Tools 32-bit (12.0.4100.1) This document covers the results from testing the installation and from verifying the components that get installed. Summary        The installation process is similar to installing SQL Server Standard, with a few differences. SQL Server Management Studio is available. SQL Server Profiler is available. Extended Events (a relatively new alternative to SQL Server Profiler) is available. SQL Server Reporting Services is not available. TCP/IP is not enabled by default, so use SQL Server Configuration Manager to enable it. SQL Server Agent gets installed but it will not run. Installation The installation runs you through an installation similar to what you see in Wonderware's TN548 "Installing Microsoft SQL Server 2012 for Wonderware Products" Of course this is SQL Server 2014 and also the Express edition so it's a little different This section covers some of the differences. The installer for SQL Server 2014 SP1 with Tools is found in the Wonderware System Platform installation media under InstallFilesRedistSQL2014EXPRSP1. Run SQLEXPRWT_x86_ENU.exe to extract the installation files to a folder of your choosing Once extracted, go to the folder containing the extracted files and run SETUP.EXE to begin the installation. There are relatively few features available for installation compared to the Standard edition: 2 For a minimal install, you can uncheck SQL Server Replication, Client Tools SDK, and SQL Client Connectivity SDK Be sure to select Management Tools – Complete in order to get SQL Server Profiler. The installer will want to install SQL Server Express as a named instance called "SQLExpress" by default When used with Wonderware software, you should opt to have it install as the default instance instead. There is no SQL Agent listed as a service In fact, it does get installed, but it will not run. Otherwise, the installation is similar to the Standard edition's installation. 3 TCP/IP is Not Enabled The TCP/IP protocol needs to be enabled for connectivity After installation, launch SQL Server Configuration Manager and select SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSEVER TCP/IP is Diabled by default Change it to Enabled, then restart the SQL Server service for the change to take effect. SQL Server Agent Will Not Run SQL Server Agent is often used for scheduled tasks, such as automated database backups With this version of SQL Server Express, SQL Server Agent gets installed but it will not run Therefore it cannot be used for backups and the like. See How to Schedule and Automate Backups of SQL Server Databases in SQL Server Express for Microsoft's recommendation on how to automate backups for SQL Server Express databases Alternatively, there are other methods and 3rd party utilities available that can be found by Internet search. SQL Server Reporting Services is Not Installed SQL Server Reporting Services (SSRS) is required for the Wonderware Information Server ArchestrA Reporting feature and for Wonderware MES Reports. The "with Tools" version of SQL Server Express that comes with Wonderware System Platform does include the SQL Server Reporting Services Configuration utility, but that is a bit misleading It does not come with SSRS itself. If SSRS is needed, thankfully the SQL Server Express with Advanced Services (SQLEXPRADV) version includes an Express version of SSRS Naturally it is not as fully-featured as the version of SSRS that comes with the Standard and Enterprise editions of SQL Server, but it is quite capable. If you already have SQL Server 2014 SP1 with Tools installed, you can download the Advanced Services version and use it to add SSRS to the existing installation. 4 When adding SSRS to an existing installation, the installation wizard will only allow the "Install only" option. SSRS will have to be configured using the Reporting Service Configuration Manager separately Doing so is outside the scope of this document Microsoft's website has documentation on how to configure SSRS. The various versions of SQL Server Express 2014 SP1, including the Advanced Services version, from Microsoft's website. Business Intelligence Development Studio is Not Installed Previous versions of SQL Server used to include an option to install Business Intelligence Development Studio (BIDS) It is quite useful if you need to work on SSRS reports, SQL Server Integration Services projects, and the like. BIDS is not included with any of the editions of SQL Server, Express or otherwise Nor do they call it BIDS anymore. Now Microsoft provides SQL Server Data Tools (SSDT) for development work You can download and install SSDT in order to get the tools need to work on SSRS reports and other SQL Server development projects. 5 References Features Supported by the Editions of SQL Server 2014 https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).ASPX Downloads of various types of SQL Server 2014 SP1 Express (With Tools, With Advanced Services, etc.) https://www.microsoft.com/en-us/download/details.aspx?id=46697 How to Schedule and Automate Backups of SQL Server Databases in SQL Server Express – Microsoft's official recommendation https://support.microsoft.com/en-us/help/2019698/how-to-schedule-and-automate-backups-of-sql-server-databasesin-sql-server-express Automate SQL Server Express Backups and Purge Old Backups – an alternative using PowerShell https://www.mssqltips.com/sqlservertip/3458/automate-sql-server-express-backups-and-purge-old-backups/ Reporting Services Configuration Manager (Native Mode) https://technet.microsoft.com/en-us/library/ms156305(v=sql.120).aspx Download SQL Server Data Tools (SSDT) https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt SQL Server Reporting Services Report Manager Site Permissions Error after Installation – potentially useful if you get permission errors in the SSRS Report Manager website https://www.mssqltips.com/sqlservertip/3144/sql-server-reporting-services-report-manager-site-permissions-errorafter-installation/ 6

Installing WonderwareInTouch 2014 R2 Runtime 07/12/2017

Installing InTouch 2014 R2 Runtime Overview This document details installing Wonderware 2014 R2 Runtime The first page (this page) lists bullet points of what needs to be done All of the following pag...(read more)

Installing InTouch 2014 R2 Runtime Overview This document details installing Wonderware 2014 R2 Runtime The first page (this page) lists bullet points of what needs to be done All of the following pages are stepby-step instructions with screenshots. Application Version(s)  InTouch 2014 R2 Runtime Windows Preparation  Consult the readme file on “Wonderware System Platform 2014 R2” disk to confirm which Windows service packs are supported.  Log in as an administrator for the install.  Exclude these folders from the virus scanner (Windows Defender, McAfee, etc.): C:ProgramDataArchestrA C:Program FilesCommon FilesArchestrA C:Program Files (x86)ArchestrA C:Program Files (x86)Common FilesArchestrA C:Program Files (x86)Wonderware C:UsersAll UsersWonderware C:Program Files (x86)ArchestrAFrameworkbin C:Documents and SettingsAll UsersApplication DataArchestrA C:ProgramDataArchestrALogFiles C:Documents and SettingsAll UsersApplication dataArchestraLogFiles  Exclude these file extensions from virus scanner: aFDX ixd pdx Installing InTouch  Let the installer install any needed prerequisites All the required prerequisites are on the disk, no internet required.  Install role based Select “Runtime Client”.  Configure Wonderware account with same username/password as other Wonderware computers.  Reboot when installer prompts for a reboot (last step of the installation wizard). 1 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Exact Steps Step 1: Run Setup.exe off the “Wonderware System Platform 2014 R2 with InTouch 2014 R2” disk. 2 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 2: Install the net framework The installation files are already on the computer removing the need for an internet connection. Step 3: Click the “Install Prerequisites” button. 3 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 4: Select the “Wonderware System Platform Computer Roles” radio button (different from default) Then click next. Step 5: Select the “Runtime Client” checkbox Then select next. 4 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 6: Click next. Step 7: Click next. 5 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 8: Read the EULA for the four products Then check the “I have read…” checkbox Then click agree. Step 9: This step creates/defines the Windows account used for Wonderware software on this runtime PC to communicate with Wonderware software on other computers. Make sure to set this username and password the same on all computers. 6 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 10: Click the button “Install Prerequisites”. Step 11: Click “Install”. 7 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 12: Wait for installer to complete. Step 13: Click Finish. 8 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 14: Waiting for Language packs to install. Step 15: Click “Restart Now” button. 9 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 16: Launch “ArchestrA License Manager” by going to Start->All Programs>Invensys->License Manager->ArchestrA License Manager Step 17: Check the box “Do not ask this question again” Then click the button “No”. 10 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 18: Click then menu “File” then click “Install License File…” menu item. Step 19: Navigate to the location of the license file The suffix for the license file for this version of InTouch is ArchestrA.lic Then lick the “Open” button. 11 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Installing InTouch 2014 R2 Runtime Step 20: Observe that the license file is installed. Step 21: Congratulate yourself on a successful install. 12 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Solution To Common Wonderware Questions 11/23/2015

Some Quick Solutions to Common Wonderware Questions InTouch Message: Key does not enable WindowViewer This means you have an InTouch for System Platform license, but your InTouch application is not of...(read more)

Some Quick Solutions to Common Wonderware Questions InTouch Message: Key does not enable WindowViewer This means you have an InTouch for System Platform license, but your InTouch application is not of the type InTouch ViewApplication The IT4SP license supports Galaxy I/O only, not local I/O via InTouch Access Names. In InTouch WindowMaker, select Special->Application Type Check the box for InTouch ViewApplication. If it does not allow this, it means you have Access Names configured and must delete those first. If they cannot be deleted, it means you have local I/O tags defined, and you either need to delete those from your database and from any animations, or it means you have the wrong license type, you need a standard InTouch Runtime license. Message: Another user is editing this application When WindowMaker is opened, it creates a file called APPEDIT.LOK in the project folder Its purpose is to prevent another session from editing the same project at the same time When WM is closed, this file is deleted. If you copy the contents of an InTouch project while WM is running, you will also copy this APPEDIT.LOK file So when you open the project on another machine, it thinks someone is already editing the application. Just delete the file APPEDIT.LOK from the InTouch project folder. Message: Repository [repository ID] doesn't exist in the local system This message is often seen when a modern InTouch application's folder has been copied from one development node to another. Modern InTouch applications are backed by a small galaxy repository, so their application folders cannot be simply copied like a stand-alone InTouch application The development node must have access to the galaxy as well. 890 N Mart-Way Ct Olathe, KS 66061 (800) 676-8805 www.logic-control.com To copy an InTouch application from one development node to another, first launch InTouch Application Manager on the original development node Right-click on the InTouch application and select Export to export the application as an aaPKG file. Then copy the aaPKG file to the second development node On this node, launch InTouch Application Manager Select File > Import In the Import InTouch Application dialog box, click the File button and select the aaPKG file Then complete the wizard to import the application. DA Servers DAServers not listed in SMC On a running system, you open the SMC and your DAServers are no longer visible. This is most likely because the password on your Archestra Services account has expired, or demoted to non-Administrator, or similar. First check the account and fix whatever problem it has – reset the password, make it an Administrator, whatever It is recommended this password be set to not expire, if permitted. Run Change Network Account and reset the account to your Archestra Services account credentials. These are likely not different credentials, but still needs to be re-run It will require the computer to be rebooted. Note: If you have to set that account to different credentials, you must reset all the Wonderware computers in your architecture to the same new credentials using Change Network Account. DAServer times out after 2 hours You are not licensed properly, so the DAServer is in demo mode. Most newer DAServers use the ARCHESTRA.LIC license file But older ones still use WWSUITE.LIC If you don’t know which one, install both. Historian Data Reception Timeout logger entries In the SMC Log, you see Data Reception Timeout messages every minute or two. Each topic in Historian has a 60-second timer during which it must see data change If it sees no changes, it drops the connection and reconnects This creates the data reception message, and also puts a NULL in your data history for tags within that topic. The solution is to make sure each topic has at least one tag that updates regularly, like a heartbeat. This keeps the topic active. If there are no tags that can update that fast, you can change the default Topic Timeout period to something more reasonable, or turn it off entirely. 890 N Mart-Way Ct Olathe, KS 66061 (800) 676-8805 www.logic-control.com Can only see 24 hours of data This is because you have a consignment license, such as a System Integrator license. The SI consignment license includes Historian for testing purposes, and as such only allows you to retrieve the last 24 hours of data Data is stored just fine, you just can’t see it You’ll need an actual Historian license, or a 30-day Temp license, to retrieve more than 24 hours. 890 N Mart-Way Ct Olathe, KS 66061 (800) 676-8805 www.logic-control.com

Wonderware UX Design Guidelines 08/27/2015

Wonderware design guidelines 1 Identify real tasks 2 Collect real content 3 Build a device strategy 4 Focus on real users Identify and define Prioritize Be specific and constructive Think pixels ...(read more)

Wonderware design guidelines 1 Identify real tasks 2 Collect real content 3 Build a device strategy 4 Focus on real users Identify and define Prioritize Be specific and constructive Think pixels 5 Don’t forget the interactions 6 Make it visual 7 Remember the design process 8 Build the hierarchy Structure Build a qualitative user experience Prioritize and be consistent Collaborate, learn, think positive www.schneider-electric.com 1 Focus on real users Identify and define « Obsess over customers : when given the choice between obsessing over competitors or customers, always obsess over customers Start with customers and work backward » USER PROFILE Reminder Here are some questions which will help you imagine the needs of your users : Jeff Bezos, founder and CEO of Amazon User profile Meet the end user Don’t ignore the end users, they are the key to a good interface Observe and talk to them to understand their skills and experience. Create personas If you can’t meet up with end users, don’t think you can avoid it and design the interface for yourself Build fictional personas with habits, skills and needs Make them real. Name : Age : Occupation : Hobbies : Devices : Favorite applications : Goals : Main tasks : Rare tasks Obligatory tasks : Problems : Operating procedures : Wishes : Profile • What is their name ? • How old are they ? • What is their job and salary ? • Are they in a relationship ? • What do they like to do in their free time ? Digital litterracy • What devices do they own ? • What devices do they use at work ? • What are their favorite applications ? SCENARIO - day 1 Scenario 1 2 Don’t start designing before you know exactly what your HMI is for To know so, imagine a scenario structured by the different tasks your users would do in a day. Co-create or share the story with the project stakeholders to build a shared vision. 3 4 Work habits • What is their goals during the day ? • What do they do most often ? • What do they do seldomly ? • How do they do it ? • What do they do when nothing is happening ? • What problems can occur ? • What do they do when something bad is going on ? • What do they feel they need and wish ? www.schneider-electric.com 2 Identify real tasks Prioritize Task inventory Don’t ease into the computer too quickly, work with a pen and paper or use a whiteboard to isolate your user’s key tasks. Make an inventory of all the tasks in the scenario and list all the situations that have arisen (servicing, restarting, change of procedure ). Functional categories TASKS Tasks in interface • Adjust set points • Launch procedure • Fill reports • Respond to an alarm Tasks on site • Check for misplaced product • Refill material • Replace die Reminder Situations • Beginning of shift • Setting up • Production • Changing order • Cleaning in place • Stopping the machine • Emergency shut down • End of shift Put the most important groups first and remove all redundant or irrelevant information. The main information should be accessible in maximum 3 clicks or taps. Categories Classify the tasks into functional groups according to how often they are used and how similar they are : alarms, manual commands, settings Sub categories List sub-categories which exist within the categories. There shouldn’t be more then 3 levels of depth of information. Naming Name the groups of functions with words familiar to the user They will help build your navigation elements. CATEGORIES New shift • Log in • Check performances Changing order • Select new workorder • Replace die • Adjust set points NAMING Production • Adjust set point • Fill reports • Respond to an alarm • Check for misplaced product • Refill material • Replace die DON’T TIC00_X22.27° In section 22 of machine XXFGH the average temperature measured in Celsius is about 27, 265875°. Don’t use too much abreviations and cryptic text DO Dryer / Section 22 Temperature : 27 ° Be explicit but concise. www.schneider-electric.com 3 Collect real content Be specific and constructive Data Don’t ignore complexity Know how detailed the interface must be and write down the units that need to be represented.The values shouldn’t be too long, if they are it means the unit should change (mm to cm, g to kg ) Always display the relevant unit of measurement to avoid input errors Understand the relationships between datas and actions and find the best objects to represent them (tables, pie charts, diagrams…). DATA REPRESENTATION Reminder To build a positive discourse, for instance : Repartition Percentage But try : “An account number should be eight digits in length.” Editorial content Clarity Don’t communicate in a lengthy and boring manner Write in the users own language. When possible, use full words and sentences, as opposed to abbreviations and codes. Try to accompany visual icons with text. Consistency Create consistency in the syntax and tone (neutral or directly addressed to the user ). Build a positive discourse Your messages should be worded positively and affirmatively and provide constructive insight into how to use the application properly. Don’t say : “You have entered the wrong information” Trends Balance DIALOG COPY DON’T Compared trend Relationships DO Do you whish to cancel the set point change ? The new set point is 25 liters Do you whish to save it ? OK Level Load Cancel No Yes The copy must be clear, concise and consistent with the buttons to avoid confusion. www.schneider-electric.com 4 Build a device strategy Think pixels Soft and hardware hand in hand SCREEN SIZES Reminder Don’t think an interface is always the same, it isn’t It is build and conceived according to the device it is going to be used in. According to the user’s needs, the market and your technical possibilities, determine the devices that your interface will be used in. Here are some questions which will help you decide on the device(s) : • Is it an old PC ? • Is it a tactile screen ? • A phone ? Android, Apple, Windows 8 ? • Is it present on multiple devices ? • Is it different according to the device or is it responsive ? • Is it a software, a web site or an application ? 1920/1080 px Grid Once you decide on a device strategy, you know how much available space you will have so build a grid for all you elements accordingly : 1280/1024 px tactile, 1024/930 px… 1440/900 px 1280/1024 px TOUCH SIZES Standards 26/26 px If possible, use the navigation and interaction standards of the device you are using to minimize the cognitive load of the user. 7 mm 800/600 px 34/34 px 768/1024 px Average touch size 9 mm 8 px 320/480 px Minimum touch size HD : 640/1136 px Percieved : 320/568 HD : 1080/1920 px Percieved : 540/960 px Minimum spacing 2 mm www.schneider-electric.com 5 Build the hierarchy Structure Navigation NAVIGATION Maximum 7 items in a navigation bar After making functional clusters, build a navigation bar that allows navigation at all times between the main pages of the interface (commands, alarms ). 1 2 3 4 6 Reminder 7 At all times the users must be able to : • Situate themselves clearly • Access the main navigation functions • Switch function or task • Move to the previous or next step • Log in or log out. Clusters Items that are logically connected should be grouped together on the screen, whereas items that have nothing to do with each other should be separated You can use white space between collections of items to group them and/or you can put boxes around them to get the same result Generic functions such as help, connection, language can be assembled.They can be placed in the upper bar with the logo, status, time and alarms 5 Try to keep the same layout from one page to the other. READABILITY DYNAMIC Readability Define a readability dynamic and place elements accordingly. Ex : top left to bottom right following the western societies reading dynamic or down to top following the Windows users habits… 1 2 3 4 www.schneider-electric.com 6 Don’t forget the interactions Build a qualitative user experience Feedbacks Always inform your users with visual cues or messaging of actions, changes in state, errors and exceptions. Provide different types of notification according to the severity of the message. Always include the ok or close function to start a process, confirm an order or after entering data. FEEDBACKS i Information Animation Don’t disturb your users for nothing, avoid flashing animations unless they express a fatal emergency. Things that are not the same shouldn’t look the same. Differentiate the static information from text fields or other dynamic elements. The best interface designs are invisible. Reminder Consistency Validation Do you want to save the new recipe ? NO YES Notification The packager roll will be finished in 1 hour. Make way for errors Every action of your user should be undoable. If the user does cause an error, use your messaging as a teachable situation by showing what action was wrong, and ensure that they know how to prevent the error from occurring again. OK The recipe’s new parameters have been saved. OK Alarm Please check the filter in the main dryer. OK BUTTON STATES OK OK OK Active Selected Disactivated When an application works consistently, it means that the users only have to learn the rules once, increasing their efficiency at each interaction. Create patterns by applying similar codes and actions to your design and if possible replicate patterns existing in interfaces popular to the user. Put your buttons in consistent places on all your windows, use the same wording in labels and messages, and use a consistent color scheme throughout your interface. Velocity INPUT TEXT DON’T Enter Colour DO Select Colour Pink Orange The interface shouldn’t be too crowded and heavy to avoid loading problems. All interactions should be extra fluid, your users won’t wait. Green Free text increases the chance of input error Default values reduce the chance for error www.schneider-electric.com 7 Make it visual Prioritize and be consistent Layout DON’T DO Reminder Work on a fixed grid, keep the same page layout from one page to another. With tactile interfaces, use as much screen space as possible, make elements big enough. Restrict the number of active zones and place them far enough to facilitate touch navigation. Text Create a library of standard elements : Don’t design without a grid Align all elements Only display essential information The rest of the information can be displayed using filters, toggle buttons, pop-ins… Make sure it is big enough to be read : minimum 14pt. Test maximum character height and width : Å is the tallest, y the lowest and W the widest. Align fields : left-justify edit fields, the corresponding labels should be right-justified and placed immediately beside the field. Justify data : right-justify integers, decimal align floating-point numbers, and left-justify strings Icons Limit the use of icons to standard functions or explain them with text. Too small for reading and touch Action Action is different froma link A link Plain text is different from a link Align Text Don’t align with the ascenders Big enough for reading and touch Action A button is for an action A link Underlined text often say link Align Text • buttons • dialogs • grids • lists • menus • sub header • switches • tabs • text fields • tooltips… Color and images Limit the number of colors to 5 or 6 and use them to create meaning For instance, use green when all is ok, yellow when something could be changed, red when things go wrong. Provide appropriate contrast, it has to be maximum 70 % : use dark text on light backgrounds and light text on dark backgrounds. The resolution of the imported images must be at least equal to the screen resolution. Align with the text X-height (not ascenders or descenders) www.schneider-electric.com 8 Remember the design process Collaborate, learn, think positive Iterate When developing interfaces, it is often said that you need to fail fast and iterate often. You will make mistakes but it will get you further than you think. Co-create and share Identify which stakeholders will be relevant for each phase of the project and work together with them If possible don’t just talk on the phone, meet up You’ll start to learn about each other’s disciplines, reducing pain points and allowing more autonomy in the decision making. Reminder Talk with your stakeholders to establish the tools that will be used and they way you will work together Ask yourselves : • Will the project be waterfall or agile ? • How often will there be deliveries ? • How will the files be sent, on what plateform ? • What will be the ways to keep track of changes and requests ? Show your sketches around to stakeholders, managers, engineers, designers and users. Take note of the reactions, explain your decisions, discuss and if necessary come to a compromise Always move forward. Communicate Communicate on your innovation in conventions, publications, social medias or other appropriate communication channels. www.schneider-electric.com

Don't Host Critical SCADA Applications On An Insecure Infrastructure 01/11/2015

Don’t Host Critical SCADA Applications on an Insecure Infrastructure On July 14, 2015, Microsoft will end extended support for its Windows Server 2003 operating system That means Microsoft will not ...(read more)

Don’t Host Critical SCADA Applications on an Insecure Infrastructure On July 14, 2015, Microsoft will end extended support for its Windows Server 2003 operating system That means Microsoft will not develop or release any updates for the Windows Server 2003 platform. Why is this important? Microsoft released 37 critical updates for Server 2003/R2 in 2013. Since security flaws could still be exploited in the soon to be unsupported Server 2003 platform, you should strongly consider your options for migrating to a supported operating system. Maintaining legacy systems can also be costly and in terms compliance with industry standards. Over time, it becomes harder to support (or find) the hardware to run legacy software. Running legacy systems might also cost your company in terms of compliance with industry standards Standards like NERC CIP already address systems security management Deliberately choosing to remain on an unsupported, potentially exploitable operating system like Windows Server 2003 may not be appropriate mitigation of risk exposure called out in the standard. Options for moving forward Fortunately, there are quality options for replacing your existing Windows Server 2003 infrastructure Just as Windows XP was replaced by Windows 7 and 8.1, Server 2003 has been replaced by Windows Server 2008/R2 and Windows Server 2012/R2. According to the IDC whitepaper, “Windows Server 2003: Why You Should Get Current”: Windows Server 2012 R2 offers relatively good application compatibility with Windows Server 2003 Although Windows Server 2012 R2 is delivered as a 64-bit operating system, most 32-bit applications that have no 16-bit code segments should install and run on Windows Server 2012 R2 through Windows on Windows 64 (WoW64) technology The main exception to this compatibility story is for applications that operate in kernel mode rather than user mode. Security applications and some system utilities such as backup and management agents are among the applications that are likely to need an upgrade as part of a migration to Windows Server 2012 R2. Lastly, since Windows Server 2008 is slated for end of mainstream support in January 2015, the whitepaper also recommends that customers looking to upgrade their Windows Server 2003 systems upgrade directly to Server 2012 R2. Options for Wonderware users Though operating system upgrades can be pricey and migrating applications can be timeconsuming, there are certainly some perks that come from upgrading software. The latest versions of Wonderware products (2014 and 2014R2) offer many new features Here are a few you may want to explore: · Content-Aware Script Editor: A comprehensive new “Auto-Complete” behavior in the Script Editor anticipates the engineer’s next move and provides intelligent choices that match the likely intent InTouch 2014 consolidates all scripting work within one development environment and helps shorten script engineering time by 40%. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission · Alarm Management tools: Improved alarm management minimizes nuisance alarms while enhancing operator focus on critical alarms through the use of alarm shelving, new alarm client symbols, and plant-based alarm suppression. Situational Awareness Graphics Library: Situation Awareness Library symbols are designed to enhance an operator’s situational awareness of current process conditions using a variety of visual techniques. To learn more about what the end of support for Windows Server 2003 could mean for your company, please visit http://www.microsoft.com/en-us/server-cloud/products/windows-server2003/ or check out Microsoft's Windows Server 2003 Migration datasheet. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Manage EIP Traffic With No Configuration 01/09/2015

Manage EIP Traffic with No Configuration! Moxa now has a version of their managed switch that has IGMP snooping enabled out of the box This means that you can install this switch and manage that pesky...(read more)

Manage EIP Traffic with No Configuration! Moxa now has a version of their managed switch that has IGMP snooping enabled out of the box This means that you can install this switch and manage that pesky EIP traffic without ever logging on to the switch As inventor Ron Popeil says, "Set it and forget it"! Some Moxa switch models are available with a -EIP model number The difference between an EIP and a non-EIP switch is a configuration setting The EIP models are factory configured for IGMP snooping. Non-EIP EIP Firmware in both switches is the same Both will forward EIP traffic Both can be accessed via an Allen Bradley ControlLogix add-on instruction The part number difference is only to enable IGMP snooping by default The non-EIP switch can be configured to be a -EIP switch by making the configuration change above Note: one switch in the network must be enabled as the Querier. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Building Simple InTouch SQL Viewer 01/08/2015

Building A Simple SQL Dataview There is a need for a simple sql dataview inside of intouch It is common to want to show data in an intouch screen from sql database There are a couple prebuilt controls...(read more)

Building A Simple SQL Dataview There is a need for a simple sql dataview inside of intouch It is common to want to show data in an intouch screen from sql database There are a couple prebuilt controls that come close to filling this need but fall just short enough to not be viable The first is the SQLDatagrid archestra graphic that comes out of the box with the archestra ide This is really intended to let intouch users add sql querys and modify sql querys from inside of InTouch, which it is good at It is bad at being data view because it has buttons for manipulating and running queries that are unnecessary and get in the way It is also bad because there aren’t enough net control properties exposed to control the appearance and when your goal is to present sql data appearance is critical The other controls is the historian client query control. It does show data but presents the user with too many options to pick from This tool is really intended for an advanced user doing analytics not just looking at a simple data screen. The rest of this article will show you the essentials for building a sql dataview Below is the results of what I built My hope is that if I give you the process of how to build it you can decide to add things, modify things, or remove things An example of something you might remove is the tag picker I included a tagpicker so the user can decide what they want to see but maybe in your intouch application that doesn’t make sense Maybe in your application they click on a tank then a dataview with that tanks temperature and pressure and level appears. Building A Simple SQL Dataview Initial Setup Import the ActiveFactory TagPicker Control aaHistClientTagPicker.dll located at C:Program Files (x86)Common FilesArchestrA This is the net control you see on the left of the above screenshot This is what makes it possible for the user to pick what tag they want to see in the datagridview. Import the script function library aaHistClientDatabase.dll from C:Program Files (x86)Common FilesArchestrA This will be necessary to make scripting work later This essential makes this namespace available: ArchestrA.HistClient.Database.aaServer. Import the net library This contains the datagridview This will be the heart of displaying data Import the script function library at C:WindowsMicrosoft.NETFrameworkv2.0.50727System.Windows.Forms.dll Datetime Picker Setup The key here is to have the correct format Open up the animations screen for the DateTime Picker then set the format to custom then set it to this: MM/dd/yyyy hh:mm:ss tt Also don’t forget to draw two tagpickers on the screen like in the screenshot. TagPicker Setup When the user selects a tag then needs to be a way to update the custom property “tags” so that another sql query can run to update the datagridview This can be done by going to animations on the tag picker then select the “OnTagsSelected” even script then add the below script Make sure to make a custom property called tags. dim tag as ArchestrA.HistClient.Database.aaTag; tag = selectedTag(0); tags = tag.name; Building the SQL Query I created a datachange script called update that ran anytime the discrete custom property update was changed (by the way create a custom property called update) Then I put in the script below. dim connection as System.Data.SqlClient.SqlConnection; dim command as System.Data.SqlClient.SqlCommand; dim reader as System.Data.SqlClient.SqlDataReader; LogMessage("here is a debug message 1"); connection = new System.Data.SqlClient.SqlConnection("server=penrowsupportvm;uid=sa;database=R untime;password=app|topic!1024"); Building A Simple SQL Dataview connection.Open(); LogMessage("here is a debug message 2"); DateTimePicker1.Value = System.DateTime.Now.AddDays(-1); DateTimePicker2.Value = System.DateTime.Now; command = new System.Data.SqlClient.SqlCommand("SET NOCOUNT ON DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @StartDate ='" + DateTimePicker1.Value + "' SET @EndDate = '" + DateTimePicker2.Value + "' SET NOCOUNT OFF SELECT Description ,DateTime = convert(nvarchar, DateTime, 20) ,Round(Value,2) AS Value From ( SELECT * FROM History WHERE History.TagName IN ('" + Tags + "') AND wwRetrievalMode = 'Delta' AND wwVersion = 'Latest' AND DateTime >= @StartDate AND DateTime = @StartDate ORDER BY DateTime DESC", connection); reader = command.ExecuteReader(); LogMessage("here is a debug message 3"); dataGridView1.Rows.clear(); dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "Description"; dataGridView1.Columns[1].Name = "Datetime"; dataGridView1.Columns[2].Name = "Value"; dataGridView1.Columns[0].Width = 313; dataGridView1.Columns[1].Width = 314; dataGridView1.Columns[2].Width = 313; LogMessage("Before adding the rows to the dataGridView"); while reader.Read() dataGridView1.Rows.add(reader("Description"),reader("DateTime"),reader( "Value")); endwhile; reader.Close(); connection.Close(); LogMessage("End of the script reached");

Load Balance Application Server 01/08/2015

Application Server Objects using all your CPU? Here is the scenario, over time you have developed your system and lots of objects have been added. Now there are so many objects running on your cpu th...(read more)

Application Server Objects using all your CPU? Here is the scenario, over time you have developed your system and lots of objects have been added. Now there are so many objects running on your cpu that performance is seriously hurts When pushing a button it takes 8 seconds to respond Well there is a solution Those objects can run on a different processor core on the same machine or a different machine all together In most cases this is a simple as dragging and dropping the objects to the other processor core. Lets go into more detail on what I mean by dragging and dropping to another processor You simply make another AppEngine and move the objects under it So now if you had a 4 core processor instead of the objects just running on one core they would be running on 2 cores Your thinking well why not use all 4 cores, that is a great idea, go for it What might even be a better idea is to leave 1 core open to run generic system processes, but I haven’t tested it myself. What if all your cores are maxed out? A few options come to mind Probably your best is going to be just buying a new machine, they just don’t cost much now a days Or you could deploy objects to another existing machine A nice feature of the galaxy is it doesn’t matter where the object is it can communicate with the rest of the galaxy Another option would be to upgrade the processor People don’t think about upgrading components much anymore because of how cheap it is to buy a whole new computer, but there is an advantage here, you wouldn’t have to get a new machine Some possible costs of a new machine are: finding the money, time to install software, implementing corporate standards, having to go through the process of undeploying/deploying Anyways it may be simpler to just upgrade a component instead of buying a new machine, in most cases just buying a new machine will be the way to go but something to think about. Being proactive by load balancing before a performance issue is noticed by operators would be a good idea The way you do that is by opening object viewer then going to your engines to check Scheduler.ExecutionTimeAvg, this value should not exceed 40% of an engine scan period Also the overall CPU usage should not exceed 40% If either of these are true you’ll likely run into performance issues. If you are wondering if issues have already occurred you can check Scheduler.ScanOverrunsCnt, this tells of if a scan took longer than the time allotted Basically if there are a lot of these there is a problem, a thousand overruns might be ok but not 100,000 Overruns occur naturally during deployment or initialization If checking for “a lot” isn’t scientific enough for you then compare Scheduler.ScanOverrunsCnt to Scheduler.ScanCyclesCnt, the percentage of overruns to runs should never be more than 0.05%. In summary, Application server makes it drag and drop easy to load balance your system If you see your Scheduler.ScanOverrunCnt get big then you simply need to add a new engine, buy a new computer, or upgrade your current computer’s hardware. Reference: tech note 671

Effects Of Increasing ArchestrA Objects On Computer CPU Usage Stability 01/08/2015

Effects of Engine Average Execution Time on CPU Usage Steadiness Hypothesis If the engine’s average execution time is greater than the scan period then the computer’s total CPU usage will not be s...(read more)

Effects of Engine Average Execution Time on CPU Usage Steadiness Hypothesis If the engine’s average execution time is greater than the scan period then the computer’s total CPU usage will not be stable. Materials     KC Small Training Room Laptop 8 Laptop Details – Model: XPS L702X, OS: Windows 7 SP1 Enterprise, Processor: Intel Core i7 Wonderware System Platform 2012 R2 Performance Monitor Fog Image: KCTrainingLaptopOptimizing Methods       Set engine scan time to 10,000 MS to help with measure performance Performance monitors lowest resolution is once a second Using an engine scan time of 1 second could have made for confusing results. Imaged KC Small Training Room Laptop 8 with fog image KCTrainingLaptopOptimizing The image already had a galaxy with object to generate load Only needed to adjust the engine execution time to 10,000 MS. Installed 2012 R2 to the physical machine’s operating system instead of using a virtual machine to avoid invalidating the CPU usage data with vmware’s automatically adjusting CPU capacity algorithms. Of the 8 available cores in the core i7 cpu 6 were disabled Only using two cores makes it simpler to understand how object CPU usage is divided among cores Disable cores by going to start->run->msconfig->boot->advanced options->number of processors. When running experiments closed all applications then waited 1 minute before recording any results This would reduce noise in the experiment from an application taking cpu or deployment using cpu. Used an object in the galaxy named “Loader” Loader is an object in the galaxy already deployed on the fog image “KCTrainingLaptopOptimizing” Loader is a simple object configured with a script to create cpu load The script is an execution type script with a while true condition checking an area object discrete attribute called “DoLoadTest” The float UDAs are defined “squareRoot”,”sine”,”count” There is also “cosine” as a Boolean, althought it should probably be float(just a mistake from creators of optimizing application server class) : dim i as integer; me.count = me.count+1; for i = 1 to 1000 me.sine = Sin( me.count ); me.squareRoot = Sqrt( me.count ); me.cosine = Cos (me.count ); 'me.sine = i; 'me.squareRoot = i; 'me.cosine = i; next;  Made 10,000 Loader objects using dbdump/load The naming convention was Loader_XXXX Starting at Loader_0000 and ending at Loader_9999 For a total for 10,000 loader objects. 6:00:00 PM 6:00:08 PM 6:00:16 PM 6:00:24 PM 6:00:32 PM 6:00:40 PM 6:00:48 PM 6:00:56 PM 6:01:04 PM 6:01:12 PM 6:01:20 PM 6:01:28 PM 6:01:36 PM 6:01:44 PM 6:01:52 PM 6:02:00 PM 6:02:08 PM 6:02:16 PM 6:02:24 PM 6:02:32 PM 6:02:40 PM 6:02:48 PM 6:02:56 PM 6:03:04 PM 6:03:12 PM 6:03:20 PM 6:03:28 PM 6:03:36 PM 6:03:44 PM 6:03:52 PM 6:04:00 PM 6:04:08 PM 6:04:16 PM 6:04:24 PM 6:04:32 PM 6:04:40 PM 6:04:48 PM 6:04:56 PM 5:20:01 PM 5:20:09 PM 5:20:17 PM 5:20:25 PM 5:20:33 PM 5:20:41 PM 5:20:49 PM 5:20:57 PM 5:21:05 PM 5:21:13 PM 5:21:21 PM 5:21:29 PM 5:21:37 PM 5:21:45 PM 5:21:53 PM 5:22:01 PM 5:22:09 PM 5:22:17 PM 5:22:25 PM 5:22:33 PM 5:22:41 PM 5:22:49 PM 5:22:57 PM 5:23:05 PM 5:23:13 PM 5:23:21 PM 5:23:29 PM 5:23:37 PM 5:23:45 PM 5:23:53 PM 5:24:01 PM 5:24:09 PM 5:24:17 PM 5:24:25 PM 5:24:33 PM 5:24:41 PM 5:24:49 PM 5:24:57 PM Data Results Engine Execution Time Average is 0.0 Seconds 100 90 80 70 60 50 40 30 20 10 0 Average Engine Execution Time is 2.0 Seconds 100 90 80 70 60 50 40 30 20 10 0 6:40:00 PM 6:40:08 PM 6:40:16 PM 6:40:24 PM 6:40:32 PM 6:40:40 PM 6:40:48 PM 6:40:56 PM 6:41:04 PM 6:41:12 PM 6:41:20 PM 6:41:28 PM 6:41:36 PM 6:41:44 PM 6:41:52 PM 6:42:00 PM 6:42:08 PM 6:42:16 PM 6:42:24 PM 6:42:32 PM 6:42:40 PM 6:42:48 PM 6:42:56 PM 6:43:04 PM 6:43:12 PM 6:43:20 PM 6:43:28 PM 6:43:36 PM 6:43:44 PM 6:43:52 PM 6:44:00 PM 6:44:08 PM 6:44:16 PM 6:44:24 PM 6:44:32 PM 6:44:40 PM 6:44:48 PM 6:44:56 PM 4:40:00 PM 4:40:08 PM 4:40:16 PM 4:40:24 PM 4:40:32 PM 4:40:40 PM 4:40:48 PM 4:40:56 PM 4:41:04 PM 4:41:12 PM 4:41:20 PM 4:41:28 PM 4:41:36 PM 4:41:44 PM 4:41:52 PM 4:42:00 PM 4:42:08 PM 4:42:16 PM 4:42:24 PM 4:42:32 PM 4:42:40 PM 4:42:48 PM 4:42:56 PM 4:43:04 PM 4:43:12 PM 4:43:20 PM 4:43:28 PM 4:43:36 PM 4:43:44 PM 4:43:52 PM 4:44:00 PM 4:44:08 PM 4:44:16 PM 4:44:24 PM 4:44:32 PM 4:44:40 PM 4:44:48 PM 4:44:56 PM Average Engine Execution Time is 9.2 Seconds 100 90 80 70 60 50 40 30 20 10 0 Average Engine Execution Time is 12.0 Seconds 100 90 80 70 60 50 40 30 20 10 0 Average Engine Execution Time is 72.8 Seconds 100 90 80 70 60 50 40 30 20 10 8:45:00 PM 8:45:08 PM 8:45:16 PM 8:45:24 PM 8:45:32 PM 8:45:40 PM 8:45:48 PM 8:45:56 PM 8:46:04 PM 8:46:12 PM 8:46:20 PM 8:46:28 PM 8:46:36 PM 8:46:44 PM 8:46:52 PM 8:47:00 PM 8:47:08 PM 8:47:16 PM 8:47:24 PM 8:47:32 PM 8:47:40 PM 8:47:48 PM 8:47:56 PM 8:48:04 PM 8:48:12 PM 8:48:20 PM 8:48:28 PM 8:48:36 PM 8:48:44 PM 8:48:52 PM 8:49:00 PM 8:49:08 PM 8:49:16 PM 8:49:24 PM 8:49:32 PM 8:49:40 PM 8:49:48 PM 8:49:56 PM 0 Analysis The hypothesis was shown to be true All of the trend graphics demonstrate CPU usage that is not stable The explanation for sudden reductions is CPU usage is the engine finishes executing objects then is left idle until the end of the scan period Each trend chart would be well served for it’s own analysis Engine Execution time is 0.0 The point of this experiment was to establish a baseline The trend chart shows about 5% CPU usage in a steady state There was also a time of about 50% CPU usage It is unknown what program was using this CPU, but the program(s) did add some noise to the other experiments Experiments with execution times of 72.8 and 12.0 have noise in them While this noise does cast some doubt on the experiments the trends are still clear to see and it seem unlikely the “noise” is really significant data or distorting the significant data If these experiments were to be conducted again it would be advisable to identify sources of noise then eliminate them The sources of noise were not eliminated in this experiment because of time constraints to conduct the experiment. Engine Execution time is 2.0 Seconds This experiment used the least amount of CPU The CPU usage is at about 55% for 2 seconds then about 5% for 8 seconds Up and down CPU usage is repeated of the course of the 5 minute experiment. Engine Execution time is 9.2 Seconds The minimum CPU usage was the least for this of all experiments Because the script execution took 9.2 seconds this left only 8 of IDLE time The operating system likely had a backlog of non-wonderware related process that needed to execute Leaving the minimum CPU usage at about 20% instead of about 5%. Engine Execution time is 12.0 Seconds The trend is very similar to the 2.0 Second experiment In the 2.0 Second experiment there was 8 seconds of about 5% CPU usage, the same is true of this experiment The only significant difference is there was 12 seconds of about 55% CPU usage instead of 2 seconds of about 55% CPU usage What this experiments mean is when the execution time exceeds the scan time another scan isn’t immediately started, there is still an idle period There were several spikes of 100% CPU usage and near 100% CPU usage, likely just noise from other processes. Engine Execution time is 72.8 Seconds The idea of this experiment was to do an extreme over run of the scantime to see if strange results happened The results were consistent with other experiments After running for 72.8 seconds there was a 7.2 second idle period. Conclusions Many people assume as object count increases the CPU usage will linearly increase meaning CPU loading is as simple as adding more CPUs for more Objects These experiments break the assumption. What this means for systems in the field is changing scan times, moving engines, creating more engines, etc are adjustments that can be made to make a system more responsive or performance Although these kinds of adjustments are likely not worth the effort on small or medium sized system On a small system any issue with responsiveness or performance will not occur because of how small they are are On a medium system any issue can be fixed by buying adding just a little more physical resources, add a little more physical resources will be much cheaper than spending money on engineering to load balance CPUs On medium systems it is still worth understanding an engine only uses one core’s worth of CPU capacity and adding more engines will use more cpus, but optimizing scan times does not seems worth the engineering to do so On large systems however it will be worth the engineering to get as much responsiveness and performance as possible Making savings on performance could save a dozen blade servers Making responsiveness improvements will improve dozens of operator’s effectiveness with the HMI every day. References  Used this article as a guide to write this Lab Report: http://chemistry.about.com/od/chemistrylabexperiments/a/labreports.htm

Do Not Use Platform Killer 01/12/2015

Don’t Use Platform Killer Platform killer is an unsupported tool Most people believe the tool is supported because it was so widely used, even recommend (out of necessity) by support people It was w...(read more)

Don’t Use Platform Killer Platform killer is an unsupported tool Most people believe the tool is supported because it was so widely used, even recommend (out of necessity) by support people It was written during a version of System Platform with some very difficult problems removing platforms making Platform Killer a necessaity The necessity has been eliminated in System Platform 2012, platforms remove much cleaner There is a supported reliable method for removing a platform It is done though the system management console Here are the steps. 1.) Open SMC – Navigate to Start | All Programs | Wonderware | System Management Console 2.) Navigate to Galaxy name – In the left pane find platform manager and expand it Click on the name of your galaxy. 3.) Remove Platform – Right click on the name of your plant then select remove platform from the context menu This removes the platform from the local computer and only the local computer, no other platforms will be removed Your screen will look like the screenshot below at this step. Please remember to use this supported method Platform Killer shouldn’t be used for System Platform 2012 and above Platform Killer can created problems requiring a system to be reformatted on 2012 and above Even for versions before 2012 it is better to try the supported method first then try Platform Killer.

Export Wonderware Log 01/12/2015

Export Wonderware Log This document details the steps of exporting a Wonderware log file. Step 1: Open System Management Console – In Windows search bar type “System Management Console” then la...(read more)

Export Wonderware Log This document details the steps of exporting a Wonderware log file. Step 1: Open System Management Console – In Windows search bar type “System Management Console” then launch it. Step 2: Select the logger – Click on “Log Viewer” in the left pane. Step 3: Select the relevant computer’s logger – Drill down into logger viewer then drill down into default group then click the relevant machine Most likely you are working on the local computer so “local” would be the relevant computer Below is a screenshot of what your screen should look like at this point. Step 4: Filter Data by Time Range – Refer to the above screenshot Select the filter icon by the black arrow Now select the Time Range time Adjust the time range to one day before the issue that occurred to one day after the issue occurred. Step 5: Select Export – Right click in the left pane on the computer you are working on Navigate in the context menu to messages then export Click export Refer to below screenshot for example. Step 6: Save the file – Put your company’s name at the start of the filename but leave the rest the same. Leave the save type the same Pick a location to save the file, anywhere you choose, then click save. Step 7: Sent Log file to Logic person - If the log file is smaller than 10 MB it can be sent through email to the logic person working on an issue with you Files greater than 10 MB will not go through Logic’s email servers and will need to be uploaded (you can try zipping a file to get it under 10 MB limit) To upload a file go here: http://www.logic-control.com/uploadform.php The upload is extremely easy to use, no username/password required Just let the Logic person know when the upload is done.

Moving DAServer Config 01/12/2015

Moving DAServer Config It is desirable to move a DAServer configuration from one computer to another via a file This avoids the process of moving the configuration over by looking at the original dase...(read more)

Moving DAServer Config It is desirable to move a DAServer configuration from one computer to another via a file This avoids the process of moving the configuration over by looking at the original daserver and The risk of manually moving the configuration is a configuration will be missed and you will be faced with all the challenges of integrating a DASserver with a device, leading to hours of work being lost To avoid the risk of losing hours of work follow the simple steps below. 1.) On source machine goto SMC->DAServer Manager->Default Group->local->Archestra.[DA Server Manager Name].[x]->Right Click On Configuration->Click Archive Configuration Set 2.) Give a meaningful name to the configuration set An example would be "DASABCIP_10_9_2013" DASABCIP indicates which DAServer it is and 10_9_2013 indicates the date. 3.) Copy the configuration set from the source machine to media like a flash drive The configuration set can be found in this location: C:ProgramDataWonderwareDAServer[DA Server Name][Configuration Set Name].aaCFG An example location would be C:ProgramDataWonderwareDAServerDASABCIPDASABCIP_10_9_2013.aaCFG. 4.) The file just copied to media needs to be copied to the destination machine Copy it to the same location it was copied from in Step 3. 5.) Deactivate the DAServer on the destination machine you want to restore the configuration set to. 6.) Right click on configuration like in Step 1 Then select "Use Another Configuration Set" and select the name you gave the configuration set in Step 2. 7.) Activate the DAServer.

Trend Live Mode Refresh Interval 01/12/2015

Trend Live Mode Refresh Interval To reduce load on your Historian server, change your live trend’s refresh interval By default the live trend will refresh itself every 1 second Generally every 5 sec...(read more)

Trend Live Mode Refresh Interval To reduce load on your Historian server, change your live trend’s refresh interval By default the live trend will refresh itself every 1 second Generally every 5 seconds will be satisfactory Just right click on your trend area and select properties. The refresh interval setting is the first one on the “General” tab. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Serial To Ethernet Adapter 01/12/2015

Serial to Ethernet Adapter Many devices today still utilize serial ports for their primary interface As Ethernet becomes more prevalent, it makes more sense to access legacy serial devices via this ne...(read more)

Serial to Ethernet Adapter Many devices today still utilize serial ports for their primary interface As Ethernet becomes more prevalent, it makes more sense to access legacy serial devices via this newer copper medium instead of expensive replacement Moxa features many serial device servers which give Ethernet network connectivity to RS-232, 422, and 485 serial networks Here's how to setup a Moxa NPort W2150. Out of the box, this unit has a default IP address listed on the back It features a built-in web server for configuring the IP address and serial port baud rate. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Lastly, download the Moxa NPort Com Port Driver This driver dynamically finds each Moxa NPort and creates each respective com port on the PC. http://www.moxa.com/support/DownloadFile.aspx?type=support&id=974 © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Time Sync 01/12/2015

Time Sync Computer clocks don’t keep perfect time and tend to drift Since Wonderware Software products are real-time systems it is important to keep the time correct to avoid problems like data loss...(read more)

Time Sync Computer clocks don’t keep perfect time and tend to drift Since Wonderware Software products are real-time systems it is important to keep the time correct to avoid problems like data loss, incorrect data, and a variety of other problems Such problems can be prevented by implementing a time sync strategy. There is a wide range of time sync strategies ranging from enabling the domain controller’s time sync feature to relying on a feature of Historian that is on by default The one strategy that stands out from the crowd is using a command line program called net time It is the simplest to implement and works better than the rest. Implementing net time is as simple as creating a Windows Scheduled Task to run the command “NET TIME \Historian /SET /YES” every hour on all control system PCs except the PC selected to be the time master The time master PC should sync to an atomic clock either through the Internet or an NTP time server available on the LAN If there is a Historian in the system it is the preferred time master For screenshots on implementing net time refer to Wonderware Tech Note 882. If you are using System Platform it would be good to consider implementing net time inside of an object The advantage is maintenance A small problem of having a Windows Scheduled Task is when replacing the PC years later the Windows Scheduled Task might be forgotten and not migrated to the new PC The Windows Scheduled Task isn’t remembered again until there is a problem with time synchronization and it has to be troubleshot/reimplemented This problem can be avoided by implement net time inside a platform object, this way it is automatically deployed to the computer Even the potential problem of the time master’s computer name changing could be dealt with by doing some engineering For example, you could place an attribute on the platform called “TimeMasterName” and use that when calling net time. It is important to turn off other time sync tools when implementing net time When multiple time sync tools are on they tend to conflict Below is the list of commonly used time sync tools on systems Exactly how to disable them varies between versions, but a quick Google search can look up disabling methods.  · Windows Automatic Time Sync to Internet  · VMWare’s Time Sync  · Hyper-V’s Time Sync  · Historian’s SuiteLink Time Sync (found in the system parameters) © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission  · The Domain Controller’s Automatic Time Sync (off by default) Helpful Links Wonderware Tech Note 882 on using net time Note that it isn't necessary to make a batch file like the tech note does, a windows scheduled task can run net time commands without a batch file: https://wdnresource.wonderware.com/support/kbcd/html/1/t002685.htm Microsoft article for Synchronizing to an atomic clock: http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/enus/windows_date_it_overview.mspx?mfr=true © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Horner Controlling A Stepper Drive 01/12/2015

Horner Controlling a Stepper Drive Horner features many HMIs that include I/O Today, we're using an XL4 which is equipped with two high speed digital outputs for two axis of motion Cscape, Horner's ...(read more)

Horner Controlling a Stepper Drive Horner features many HMIs that include I/O Today, we're using an XL4 which is equipped with two high speed digital outputs for two axis of motion Cscape, Horner's free programming software, configures the output between the options of PWM, high speed counter output, or stepper In our case, we just want a typical stepper for our stepper drive. This will allocate two regions of variables AQ421 through AQ440 for analog outputs and I1617 through I1620 for digital inputs The analog outputs are set points for both high speed outputs. Let's look at just stepper 1 axis Parameters start/run frequency and acceleration/run/deceleration count quantify our move profile The only required parameters however are run frequency and run count The others can remain zero. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Register %AQ421 %AQ423 %AQ425 %AQ427 %AQ429 Stepper Start Frequency Run Frequency Acceleration Count Run Count Deceleration Count Value 0 15000 0 3200 0 Finally, set Q1 to true and Q1 will output the pulse train at the requested frequency and count. In this example, the drive is set to 3200 counts per rev and it will move at 15kHz After the move is done, I1617 becomes true representing move complete If bad values are used in the move profile for axis one, I1618 will be a value of 1. What if you want to command direction? There are several more digital outputs you can use to command the direction bit on a stepper drive. What if you want to jog the drive? Make the value of run count a very large number like 4 billion and reset Q1 when you desire to stop. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Decrease Your Security Risk With GE QuickPanels 01/12/2015

Decrease your Security Risk with GE QuickPanels Decrease your security risk by giving certain users privileges GE's series of QuickPanel HMIs use security to do just this Here is how to configure and...(read more)

Decrease your Security Risk with GE QuickPanels Decrease your security risk by giving certain users privileges GE's series of QuickPanel HMIs use security to do just this Here is how to configure and implement security on QuickPanels. The act of configuring users is done during the runtime Typically this means downloading and running on the QuickPanel itself but you can simulate the project on the PC before downloading Click on the target within Machine Edition and enable the Simulate property. Next, create/edit a panel and add two buttons anywhere Double click one button to give a touch animation of Logon. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Double click the other button and give it a Touch animation with a script You'll be using the EditUserList command which can be found by right clicking in the script body. Now download the project and run The target has been set to simulate so it should run on your local PC Open the panel you've made and you'll see the two buttons we placed Click the first button to trigger the logon dialogue The default credential is: username: master password: control After logging in, click on the second button to trigger the EditUserList dialogue This window is where we create new users, access levels, and permissions. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission At this point, security has been configured but it hasn't been implemented Simply hide objects in all your panels by their Visibility Animation Objects can be visible based on user or access level as shown below. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Use A Web Browser On ABB Drives 01/12/2015

Use a Web Browser on ABB Drives! The FENA-01 Ethernet module for ABB drives can be reached through a web browser! 1 Using the keypad, enter a valid IP address in Group 51, Parameters 5105 through 510...(read more)

Use a Web Browser on ABB Drives! The FENA-01 Ethernet module for ABB drives can be reached through a web browser! 1 Using the keypad, enter a valid IP address in Group 51, Parameters 5105 through 5108. 2 Using the keypad, enter a valid subnet mask like 255.255.255.0 which shows up as option 24 in Parameter 5109 3 Parameter 51.27, Edit, Refresh to perform a parameter refresh or cycle power to the drive. 4 Connect the drive to the same network as your PC and type the IP address into the address bar of your favorite browser. You will have access to 3 major sections of information. Section 1: Status This will show all of the important facts about the Ethernet module like software version, MAC and serial number. Section 2: Configuration This will show all of the parameters needed to configure your Ethernet module to talk to your control system via EtherNet IP, Modbus TCP or ProfiNET. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Section 3: Support This section give you links to find important information like manuals and EDS files *Note: This is not a webpage that will show all of the parameters in the drive It will only show Ethernet card related parameters. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Configuring The Horner XL4 For Ethernet Communications With ABB VFD 01/12/2015

Configuring the Horner XL4 for Ethernet communications with ABB VFD's Multiple VFD installations can be enhanced with a centrally located HMI/Controller for display, alarming, and control of the remo...(read more)

Configuring the Horner XL4 for Ethernet communications with ABB VFD's Multiple VFD installations can be enhanced with a centrally located HMI/Controller for display, alarming, and control of the remote drives The following outlines the configuration for Ethernet communications of the new Horner XL4 OCS All-in-One controller to ABB VFD's. First install and configure the correct Ethernet Fieldbus Adapter Module for the ABB drive you want to communicate with ACS350/355 drives use the FENA-01 EthernetIPModbus TCP module The ACS550 and ACS800 use the RETA-01 EthernetIPModbus TCP module Set the Protocol, IP address, COMM PROFILE to ABB DRIVES, and configure the specific data you want to read and write to in the drive under Drive Parameter section 51 (See note) Next, using CScape version 9.3, Service Pack 3 or newer, select Protocols under the Networking configuration in the Project Navigator and then choose "Modbus Tcp/Ip Client v3.05" for the Ethernet protocol. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Next select the Network button on the Protocol Config screen In the Port configuration leave everything at default except change the Timeout from 10000 mSec to 1000 mSec In the Update Scan configuration, also change the Reacquire Time from 1000000 mSec to 10000 mSec These two settings should be kept short until communications with the drives has been established. Once configuration and programming is completed, the Timeout and Reacquire Time can be lengthened to optimize the communications. Under the Status configuration, enter a register that will contain the status of the Ethernet communications This is usually a register location outside your normal program registers. Notice that this is 4 Double Integers (DINT), so do not use any registers above this address for at least 8 registers Once this is completed, select OK and return to the Protocol Config screen. Now select the Devices button This brings up the Device List The Device List shows the devices that can be configured to communicate with To add a device, select the Add button. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission To add a device enter the Name and IP address of the first drive to communicate with Leave the Port at 502 and enable the Status monitoring if you want to monitor the status of communications to this device Be sure to include another unused register for the status word for communications to this drive Take note that this is also a DINT, so two register will be used for this status word Under Device Options select “Modbus PLC 5-Digit Addressing” as the Device Type Select OK and make sure the device you entered is now in the list of devices. You can select Add and repeat the Device Config steps to add any additional drives you want to communicate with on the network When done, select OK on the Device List and return to the © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission Protocol Config screen Then select the Scan List button The Scan List shows you the polling configuration of the XL4 to each device you have configured. Select Add to configure the Data Mapping between the XL4 and drive unit First select the drive you want to map to in the Device Name Then in the Device Register enter the Modbus start address of 40001 Next enter the number of words you want to read from the ABB Drive based on how many words you configured to read from and write to in the ABB drive In the Local section enter the starting register you want to write the data to in the XL4 Make sure the Update Type is set to "Polled Read/Write" for continuous polling. Now select OK to close the Data Mapping screen Select Add to map any additional drives you want to communicate with When done, select OK to close the Scan List screen, and OK to close © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission the Protocol Config screen This completes the configuration of communications to the ABB drives. Once the project is downloaded to the XL4 it will continuously poll all the drives in the Scan List and place the data at the registers you designated for each drive Display screens and logic can now be added to the Horner XL4 to display and control the remote ABB drives. For additional information on the XL series of the Horner OCS line, contact your Logic, Inc. sales engineer For a closer look at the new XL4, a 30 min YouTube video can also be viewed at: http://www.youtube.com/watch?v=BLqg0Wx9sw4. Note: For additional information on the ABB RETA and FENA modules you can contact our support department. © 2015 Logic, Inc ALL RIGHTS RESERVED No part of this content may be copied, reproduced or otherwise utilized without permission

Automatic Notification Of InTouch Patch 01/12/2015

Automatic Notification of InTouch Patch Written by Alex Richardson on 2/23/2012 This article details how to setup automatic email notifications when there is a new intouch patch, service pack, or vers...(read more)

Automatic Notification of InTouch Patch Written by Alex Richardson on 2/23/2012 This article details how to setup automatic email notifications when there is a new intouch patch, service pack, or version This can be helpful to stay up to date or help comply with the new power utility regulations of nerc cip (nerc cip requires new patchs are installed in 30 days) Setting up these notifications is a two step process The first step is to have wonderware send an email notification whenever there is a new software download, there isn’t a notification for just intouch The second step is to use outlook to filter down the nofications from wonderware to only intouch from all software downloads Below are the details on the steps. Step 1 Goto wdn.wonderware.com then navigate to downloads->software downloads then on the right side of the page click “alert me when updated” Once on the alert page change the drop down for “Some changes an item that appears in the follow view” to “software” That is the only configuration that needs to made There are a few other preferences that might be set, a screenshot is below to show an example When done configuring click ok and the alert will be setup. Step 2 Now outlook needs to be configured to filter down all the software updates to only intouch Outlook 2010 can create a rule to accomplish this goal To do this launch outlook then navigate to the inbox then navigate to Home->rules->Manage Rules & Alerts->new rule A rule can be setup many different ways, but one example is to move all emails with the subject containing “downloads –“and doesn’t contain “intouch” move to the trash Below is a screenshot with that example.

Talk to us

We can help with your next project.