Emonitor ® INSTALLATION MANUAL INSTALLING EMONITOR SOFTWARE WITH A GUPTA SINGLE USER DATABASE PUBLICATION EMONTR-IN001G-EN-E–December, 2013 Supersedes Publication EMONTR-IN001F-EN-E
Contact Rockwell Customer Support Telephone — 1.440.646.3434 Online Support — http://www.rockwellautomation.com/support/ Copyright Notice © 2013 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 1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Emonitor system requirements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Database system requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Planning for the installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 4 • Database maintenance Using SQLTalk Interactive . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Checking the integrity of your database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Speeding up database access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Running the Gupta SQLBase Server as a program . . . . . . . .
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 SINGLE-USER DATABASE Note that Emonitor system performance may be reduced by running the Emonitor OPC Server with a large database. In this case, upgrading the database server computer may resolve the problem. Planning for the installation Be sure to perform the following tasks before installing Emonitor for the first time. FIND THE SERIAL CERTIFICATE.
are additional disk space requirements depending on your database setup. Be sure to check with your database administrator about these requirements and about backing up your database. BE SURE YOU HAVE THE CORRECT VERSION OF THE DATABASE SOFTWARE INSTALLED. BE On the computer hosting the Emonitor software: Before installing Emonitor, make sure the database version is compatible. You might need to consult with your database administrator to verify which version of the database server you are using.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE What to read next To learn about new features and improvements in Emonitor, read the Emonitor Product Release Notes. These are located on the Emonitor Install DVD (insert the DVD and then click Documentation). 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.
The exact wording of any messages that appeared on your screen A description of what happened and what you were doing when the problem occurred A description of how you tried to solve the problem For information about all Rockwell Automation products or for technical support, select one of the following: http://www.rockwellautomation.com/rockwellsoftware/ http://www.rockwellautomation.com/support/ http://rockwellautomation.custhelp.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 6
ts 2 Installing Emonitor This chapter guides you through the installation process for Emonitor. If you are upgrading from an existing version, refer to Chapter 3, 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 SINGLE-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.
Installing SQLBase With the Gupta SQLBase single-user version of Emonitor, all of the database software (server and client) resides on the same machine. The Gupta SQLBase software must be installed before you can install Emonitor. Gupta SQLBase is the new name for the Centura database 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). Then go to Chapter 3, Upgrading from a previous version.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 7. Select No when prompted to restart your computer, and then click Finish. Rebooting your computer at this time is not required. 8. After the computer restarts, start the Emonitor Installation program again, and continue with the installation process as described below. The Gupta SQLBase server runs as a Windows service, and automatically starts when you start Windows.
Installing Emonitor This installation is intended for first-time installations. If you are upgrading from a previous version of Emonitor, see the chapter Upgrading from a previous version. The installation program installs all Emonitor components by default. You can, however, customize your selections during the installation. The CD Activation Key that was used to define the available features in Emonitor 3.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 9. The installation program installs the Windows Firewall Configuration Utility. The Firewall Configuration program then runs to automatically modify the Windows Firewall settings to allow the following Emonitor components to operate: Emonitor OPC Server and OPC Enumerator, SQL Server, DCOM, Enlive, and the Emonitor Online programs (Enwatch/6600 Setup, Online Data Console, Create Loadfile, Load and Unload).
Installing online components This section only applies to Emonitor Online systems. If you do not have Emonitor Online, you can skip this section and go to Setting up Scheduler to automate tasks on page 13. You can run all the components of the online system onto a single computer or you can use several computers for an online system. If you are using a multi-user database, you can designate certain computers as Unload Stations and Viewing Stations, as illustrated in this diagram.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE To start the Scheduler service You must have Administrator privileges to start the Scheduler service. 1. Click Start > Control Panel > Administrative Tools > Services. 2. Select Services (local) in the left side of the Services window. 3. Select SchedulrSvc in the right side of the Services window. 4. The SchedulrSvc Startup Type should be Automatic.
1. Start Scheduler (Start > Programs > Rockwell Software > Emonitor > Utilities > Scheduler) and click Add. 2. On the Profile dialog, enter the Profile Name, such as Storage Limit Updater or Online Import Event. You can enter notes about the profile as well. Select Enable profile for scheduling. Click Next to continue. 3. On the Response dialog, select Scheduled time/date/frequency. For the Storage Limit Updater, click Next and then skip to step 7.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE For Storage Limit Updater: Executable file: C:\Program Files\Rockwell Software\ Emonitor\stglimit.exe Command line (must be one of the following): /all - Remove all measurement data, system event log data and alarm event log data outside the storage limits. “/list:list name” - Remove measurement data which are saved to a list with “list name” and are outside the storage limits.
3 Upgrading from a previous version This chapter guides you through the process of upgrading from an earlier version of the Emonitor software. Emonitor version 3.7 has been tested on, and is supported on, Windows 7 Professional, Enterprise, and Ultimate (32-bit versions only). Emonitor 3.7 is not supported, and may not install or run as expected, on any other Windows operating system. If you have a version of Emonitor earlier than version 3.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE Emonitor version 3.5 or earlier, and want to use these configuration files with Emonitor version 3.70, you must copy them from your current Emonitor installation to the computer running Emonitor version 3.70. If you are upgrading from Emonitor 3.60 on the same computer, you do not need to manually back up your configuration files. The default directories for the configuration files are listed below.
Backing up your Emonitor database See Backing up your data on page 32 for instructions. Installing Emonitor version 3.70 on Windows 7 If you are upgrading from Emonitor 3.50 or earlier, install Emonitor version 3.70 on the computer running the Windows 7 operating system. See Chapter 2, Installing Emonitor for instructions. If you are upgrading from Emonitor 3.60 on Windows 7, see “Running the Emonitor upgrade program” on page 20.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE C:\Program Files\Gupta>SQLBase901\Econfig C:\Program Files\Gupta>SQLBase901\Entek Running the Emonitor upgrade program If you are upgrading from Emonitor version 3.60 on Windows 7, you can 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.
5. When finished, click Back to return to the main Autorun screen, and then click RSLinx Classic to upgrade RSLinx® Classic. If you want to use XM/DYN Online Data to import data from XM modules, or Logix Online Data to import data from the Logix family of controllers, RSLinx Classic version 3.60 or later must be installed on the same computer. Follow the instructions on the screen to install or upgrade RSLinx Classic. If you already have the latest version of the software, you can skip this step.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 9. The installation program detects that installed Emonitor components are not up to date. Upgrade all components installed by the previous setup. This option installs the upgraded version with the same configuration as your existing installation. Remove all installed components. This option removes the Emonitor software from your computer.
13. The next dialog shows the system requirements. If your system passes, click Next. 14. Choose the directory where you want to install Emonitor. Click Browse to change the installation directory. You can choose a different directory in which to install Emonitor, but the previous installation will no longer work. The installation program will not upgrade your previous installation or install a new database. 15. Select the program folder on the Start menu for Emonitor, then click Next. 16.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 1. Start your Emonitor software from the Start menu on any client computer (Start > Programs > Rockwell Software > Emonitor > Emonitor). Click Yes to update your database. After you enter the Admin user name and password, the restructure program automatically starts. The default Admin username and password are “admin” and “password”. 2. Click Restructure to begin the update process. 3.
5. When the process is finished, click Close. You can now run the new version of Emonitor. The amount of time needed for this process depends on your processor speed and the amount of RAM available. Restoring your Emonitor configuration files After you have restored the Emonitor database files, restore the Emonitor configuration files. Note that the default directories for Emonitor version 3.70 configuration files on Windows 7 are different than they were on versions prior to 3.60.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE OnlineDataConsole.xml (Windows 7) C:\Users\Public\Documents\Rockwell Software\Emonitor\OnlineDataConsole.
3. Edit C:\Program Files\Rockwell Software\Emonitor\odoonline.edi as follows: [Source] DataFileConfigFile=C:\Program Files\Rockwell Software\Emonitor\odonline.ini DataFileDir=C:\Users\Public\Documents\Rockwell Software\Emonitor\ud DataFiles=C:\Users\Public\Documents\Rockwell Software\Emonitor\ud\*.ulf [Options] BackupPathnameOnError=C:\Users\Public\Documents\Rockwell Software\Emonitor\online\backup\ LogFilePathname=C:\Users\Public\Documents\Rockwell Software\Emonitor\online\online.log 4.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 28
4 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 SINGLE-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 SINGLE-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.
7. In the Input Window (top pane), type the following, including the semicolon: check database; 8. Press Shift+F2 to execute the command. If the check is successful, SQLTalk displays the message: 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.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-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 SINGLE-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 SINGLE-USER DATABASE 38
5 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. Why am I getting a configuration file error? There could be several reasons for this type of error. Here is a list of potential fixes. Make sure that you have only one copy of SQL.INI on your computer.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE Why can’t it find the ERROR.SQL file? If you get an error like this, check your path by typing PATH at an MS-DOS prompt. If your path does not contain the SQLBase program directory, Emonitor cannot find the needed database files. Also, check to make sure error.sql is in the SQLBase directory and has not been renamed. My other SQLBase programs cannot find the SQL.INI file. The Emonitor installation program renames any SQL.
Why can’t I run the Emonitor installation program on Windows 2000, XP, or 7? The current version of Emonitor cannot be installed or run on any version of Windows 2000, Windows XP, or Windows 7 Home. In order to install the program on a computer running Windows 7 Professional, Enterprise, or Ultimate, you have to have Administrator rights. You might have to ask your computer staff to give you administrator rights in order to install Emonitor.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 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. Click the Windows Start button, then select Programs > Rockwell Software > FactoryTalk Activation > FactoryTalk Activation Manager, and then click Help in the FactoryTalk Activation Manager window.
Index A troubleshooting 39 unable to connect 39 versions 3 database software, installing 9 DBNTSRV message 40 disk space requirements 2 documentation, Emonitor 4 activation see FactoryTalk Activation activation key see CD Activation Key adding a new database 36 Adobe Reader, installing 2 E B backing up configuration files data 32 databases 32 17 C CD Activation Key 2 checking database files 30 configuration file error 39 configuration files backing up 17 restoring 25
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE G Gupta website R 9 reading Emonitor documentation 2, 4 removing Emonitor 22 restoring configuration files 25 database 19 restructure database 23 running 24 time required 25 Rockwell Automation Technical Support RSLinx, installing 8, 21 RSMACC EOL configuration files, backing up 17 running installation program 11 restructure 24 I installation program starting 11 unable to run 41 installing Adob
T upgrading back up configuration files Emonitor 20 upgrading Emonitor 3 Technical Support 4 troubleshooting database 39 FactoryTalk Activation 42 installation 40 SQL.
• • • • • INSTALLING EMONITOR SOFTWARE WITH A GUPTA SQLBASE SINGLE-USER DATABASE 46
