Emonitor ® INSTALLATION MANUAL INSTALLING EMONITOR SOFTWARE WITH A GUPTA MULTI-USER DATABASE PUBLICATION EMONTR-IN002E-EN-E–September, 2011 Supersedes Publication EMONTR-IN002D-EN-E
Contact Rockwell Customer Support Telephone — 1.440.646.3434 Online Support — http://www.rockwellautomation.com/support/ Copyright Notice © 2011 Rockwell Automation Technologies, Inc. All rights reserved. This document and any accompanying Rockwell Software products are copyrighted by Rockwell Automation, Inc. Any reproduction and/or distribution without prior written consent from Rockwell Automation, Inc. is strictly prohibited. Please refer to the license agreement for details.
Contents 1 • Introduction Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Emonitor system requirements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Database system requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Planning for the installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 4 • Upgrading from a previous version Updating the SQLBase software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Running the Emonitor upgrade program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Installing the EDS files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Restructuring the database . . . . . . . . . . . . .
1 Introduction This chapter introduces you to the Emonitor® software, and gives an overview of the installation process. Overview This installation guide offers information on the entire installation process, including software installation, database server and client installation, database maintenance, and database connection information. This installation guide is intended for first-time installations or upgrades from earlier versions of Emonitor software.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Planning for the installation Be sure to perform the following tasks before installing Emonitor for the first time. FIND THE SERIAL CERTIFICATE. NUMBER AND PRODUCT KEY ON THE ACTIVATION Emonitor requires that you activate your software using license files. As part of the Emonitor installation process, you must install the FactoryTalk Activation software.
BE SURE YOU HAVE THE CORRECT VERSION OF THE DATABASE SOFTWARE INSTALLED. BE On the database server computer: Before installing Emonitor, make sure the database server version is compatible. You might need to consult with your database administrator to verify which version of the database server you are using. The Gupta SQLBase database version supported by Emonitor is SQLBase version 9.0.1. If you need to install a new version, ask your database administrator for assistance.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE To get started quickly, read the Emonitor Getting Results Guide. The Emonitor Getting Results Guide introduces you to the software, and shows you how to use the online help included with the software. This Guide is also located on the Emonitor Install DVD. Refer to the online help for detailed instructions on using all the functions of the software.
You might also be required to provide information about any product updates that are installed on your computer. THE ROCKWELL AUTOMATION SUPPORT WEB SITE The Rockwell Automation support web site includes comprehensive searchable databases of support information for all Rockwell Automation products. It also includes online support, software utilities and downloads, case studies, and literature. The support web site is located at: http://www.rockwellautomation.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 6
2 Installing the database server This chapter guides you through the database server installation process. Installing the Gupta SQLBase database server If you already have the Gupta SQLBase database server version 9.0.1 or later installed and you have checked the version number to make sure it is compatible with Emonitor, you can skip this section. Gupta SQLBase is the new name for the Centura database software. If you do not already have a Gupta SQLBase database server, you must install it.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 3. Rename the entek.dbs file to the name of the directory (if you did not name the directory Entek). For example, name it plantdata.dbs, and put it in a directory named Plantdata. 4. Change the attributes of the .dbs file by right-clicking on the file in Explorer, then click Properties. Clear the Read-only checkbox on the General tab. Click Advanced. Clear the File is ready for archiving box. 5.
u 3 Installing Emonitor This chapter guides you through the installation process for Emonitor. If you are upgrading from an existing version, refer to Chapter 4, Upgrading from a previous version. When you upgrade from an earlier version of the Emonitor software (version 2.3 and earlier), the Process data type is replaced with the new Numeric data type for existing measurement definitions. Installing FactoryTalk Activation Manager Emonitor requires that you activate your software using license files.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 2. After the Autorun screen appears, click Documentation. The list of available documentation appears in your default HTML browser. 3. Click FactoryTalk Activation. 4. After reviewing the FactoryTalk Activation documentation, return to the Autorun screen. 5. From the Autorun screen, click FactoryTalk Activation to install the FactoryTalk Activation Manager from the DVD drive. 6.
database server for information on installing the database server (typically on a separate computer). The SQLBase multi-user software is not included with your Emonitor Installation DVD. If you do not have the Gupta SQLBase software 9.0.1 or later installed, you must contact Gupta Software to purchase the version 9.0.1 multi-user software. As always, if you are upgrading, back up your database directories to ensure that you have a backup copy (see Backing up your data on page 32).
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 3. Expand SQLBase and TCP/IP to display the server. 4. Select the server, and then click Properties.
5. Enter the IP address of the database server computer in Host Name, and then click OK. 6. Click OK to exit the Connectivity Administrator. 7. Click Finish to exit the installation program. If you are directed to reboot the computer, please do so before continuing with the installation. Installing the XML Gateway prerequisites If you are using the Emonitor CMMS XML gateway with your Emonitor system, you must install the necessary software.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Portable systems use walk-around data collectors for collecting data, and all Emonitor components can be installed on one computer. Online systems use networked systems that monitor and collect data, and Emonitor can be installed on different computers to increase efficiency. You may also use a combination of portable and online systems, and use different computers for each part.
10. The installation is nearly complete. Select Yes, I want to restart my computer now and click OK to restart your computer. The Emonitor installation is now complete. Installing the EDS files If you are want to import data from XM or XM DYN modules into Emonitor, you must install the lattest EDS files for the XM and XM DYN modules.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE and Unload Station are all on the same computer. This section covers setting up a multiple-computer Emonitor online system with an Unload Station and a Viewing Station. For more information on the Emonitor Online system, please refer to the Emonitor Online Getting Results Guide and the help for the Online Data Management Console (Click Start > Programs > Rockwell Software > Emonitor > Help > Online Data Management Console).
Setting up Scheduler to automate tasks You can use the Scheduler program to automate many data-related tasks. A task automated in Scheduler is called an event. A Scheduler profile defines not only the event, but also when and how often the event should occur. The Scheduler has two parts: The Scheduler program that allows you to create and edit profiles. The Scheduler service that runs in the background and launches (executes) the scheduled profiles.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE These steps show you how to set up two different online profiles. The first is the Online Import Event, which looks for unload files (containing data from the data collection instruments) in the unload directory and sends the information to the Emonitor database.
8. Enter the Executable file and the Command line using the following guidelines, then click OK. This example used the default Emonitor installation directory. If you installed Emonitor in a different directory, use the path to your Emonitor program directory. For Online Import Event: Executable file: C:\Program Files\Rockwell Software\ Emonitor\didaemon.exe Command line: C:\Program Files\Rockwell Software\ Emonitor\odonline.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 20
4 Upgrading from a previous version This chapter guides you through the process of upgrading from an earlier version of the Emonitor software. If you have a version of Emonitor earlier than version 3.20 (some earlier versions were called Emonitor for Windows - EFW - or Odyssey), please contact Customer Support for assistance. You must perform several additional steps to upgrade to the current Gupta SQLBase database software (see Statement of Technical Support on page 4).
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Running the Emonitor upgrade program Use the installation program on the Emonitor DVD to upgrade your Emonitor software. Make sure you follow these steps before upgrading. 1. Unload all data collectors before upgrading. You will not be able to unload them after the upgrade. 2. Back up your databases before upgrading to the latest version (see Backing up your data on page 32). 3. If you are upgrading from Emonitor 3.
same computer. Follow the instructions on the screen to install or upgrade RSLinx Classic. The XM/DYN Online Data and Logix Online Data software require the RSLinx Classic software. It is recommended that you upgrade RSLinx before you upgrade Emonitor. 6. When finished, return to the main Autorun screen. If you are using the XML Gateway with your Emonitor system, click XML Gateway Prerequisites. Follow the instructions on the screen. 7.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 9. Enter or select the folder where the installation program stores the Emonitor configuration files. This includes all the data collector INI files, as well as any configuration files for any of the Emonitor programs (such as the Emonitor Scheduler and the Emonitor Online components). This allows you to protect your configuration files during an upgrade, and then bring them back into the new version. 10.
then automatically converts them to work with SQLBase 9. You must manually copy any other Centura 6 databases that you want to convert to SQLBase 9 from their Centura 6 working folders to corresponding SQLBase 9 working folders. After you copy the database files, you must then add the new databases to SQLBase 9. You can find the steps for adding new databases in Adding a new database on page 34.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE If you are upgrading from Emonitor version 3.40 to version 3.50, you do not need to restructure your database before you can connect to the database from a client computer. This allows you to continue to use Emonitor during the process of upgrading, and then restructure the database after all the client computers are upgraded. Note that some new features in Emonitor 3.50 may not be available until you restructure the database.
4. Make sure that no users are still attached to the database, then click OK to continue. Allow plenty of time to restructure your database. It may appear to stop or be locked up, and stay at 99% for a long time. Do not try to restart your computer during restructure–just be patient and let the program finish. 5. When the process is finished, click Close. You can now run the new version of Emonitor.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 28
5 Database maintenance This chapter describes specific procedures for maintaining your database. These steps will help your database speed and efficiency. Note that the procedures in this document apply to Emonitor installations using the single-user or network (multi-user) versions of the Gupta SQLBase database software. Using SQLTalk Interactive SQLTalk is the Gupta SQLBase program that allows you to communicate directly with your database.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Checking the integrity of your database A database is a file, or set of files, stored on your computer. In rare instances, a database can be damaged or corrupted. If this happens, you may not know about it until you attempt to recall information from the damaged part of the database. In some cases, you may not discover the damage for days, weeks, or months.
This command may take some time depending on the size of your database, so please be patient. Run this command on both the Entek and the Econfig databases. Running the Gupta SQLBase Server as a program By default, the Gupta SQLBase Server runs as a Windows service. This means the Server starts when you start Windows, and you cannot close the SQLBase Server program (the Exit button is disabled). You can change the way the Server starts, so that it only starts when it is needed by Emonitor. 1.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Backing up your data How often should I back up my data? You should back up as often as you can afford to lose data. If you can lose a week’s worth of data, back up once a week. If you need to have all of your data from each day, back up daily. What files and directories do I need to back up? The name of the directory that contains the SQLTalk database has changed from Centura to Gupta.
DATABASE CHECKED If any other message appears, your database may be corrupt. Contact Customer Support immediately for assistance. Repeat these steps for the Econfig database. 9. Type the following in the Input window (top pane), including the semicolon: Update statistics on database; 10. Press Shift+F2 to execute the command. After SQLTalk executes the command, it displays a message similar to this one depending on the number of rows in your database: STATISTICS UPDATED ON 13,443 ROWS 11.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Adding a new database You may want to add another database to your system. You can use one Econfig database for your configuration data and have multiple other databases for storing data similar to the Entek database. Before you add a new database, you must restart your computer at least once since you installed Emonitor, in order to restart the Gupta SQLBase server.
6. The SQLConsole appears. Double click Tools, and then double-click Connection Manager. 7. In the Connection Manager dialog, enter the SQLBase server name, and then click OK. The default server name is Server1 (“server”, followed by the number 1).
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 8. Exit and then restart SQLConsole. 9. The name of the SQLBase server appears in the tree below Tools. Add the new database If the SQLBase server name appears in the SQLConsole display, you can add a new database to the server. 1. Create a directory in the \Program Files\Gupta\SQLBase901 folder with the name for your database. You have to have a separate directory for each database. 2. Copy entek.
4. Rename the entek.dbs file to the name of the directory. In this picture, the new database and directory are named Newtest. 5. Start the SQLConsole if it is not running (select Start > Programs > Gupta > SQLBase 9.0.1 > SQLConsole DBA Utility). 6. Right-click the server name in the SQLConsole display, and then select Manage Database > Install. 7. Enter the name of the new database that you created steps 1-4, and then click Install. The new database appears in the tree under the database server name.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 38
6 Troubleshooting This chapter offers troubleshooting information for Emonitor installations. Troubleshooting database connections What version ODBC driver should I use? Use Gupta SQLBase ODBC driver version 9.00.01 or later. The previous version does not work with this version of Emonitor. What is this error message about a DLL conflict when I start the program? ODBC, the database driver, gives an error message when certain files are newer than others.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE Make sure that you have only one copy of SQL.INI on your computer. Make sure that the SQL.INI file has not been renamed or deleted. If you log in to your computer, make sure that you used the correct login name and password. Why can’t I connect to the database? If you cannot connect to databases after installing, ensure that your databases have been added to the server configuration and that they are enabled.
Troubleshooting during the installation Client-server applications like Emonitor can be complicated. This section is provided to give you a guide if things don't go quite right the first time. Do I have to install certain online components to certain computers? No. The current Emonitor installation program installs all Emonitor components to each computer if you are using a multi-user version of Emonitor. The single-user version of Emonitor with SQLBase has all components on the same computer.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 4. Follow the installation process as described in Chapter 3, Installing Emonitor. Troubleshooting FactoryTalk Activation If you experience any problems with the FactoryTalk Activation, refer to the FactoryTalk Activation online help file, installed when you installed FactoryTalk Activation.
Index A B database client software, installing 10 database server installing 7 installing on NT 7 setting up 8 database software, upgrading 21 DBNTSRV message 40 disk space requirements 2 DLL conflict errors 39 documentation, Emonitor 3 backing up data 32 backing up databases 32 E activation see FactoryTalk Activation activation key see CD Activation Key adding a new database 36 Adobe Reader, installing 2 C CD Activation Key 2 Centura website 11 checking database files
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE G Gupta website online systems installing components Unload Station 16 Viewing Station 16 7, 11 I installation program starting 14 unable to run 41 installing Adobe Reader 2 database client software 10 database server 7 EDS files 15, 25 Emonitor 9, 13 FactoryTalk Activation 9 MSXML 6.
storage media 33 system requirements 1 T Technical Support Technical Phone Support 4 Technical Support Website 5 telephone support 4 troubleshooting database 39, 40 DLL conflict 39 FactoryTalk Activation 42 installation 41 ODBC Driver Manager error 39 SQL.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE MULTI-USER DATABASE 46
