ADMINISTRATION GUIDE Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 Supersedes Publication BZWARE-IN001L-EN-P-June 2013
Contacting Rockwell Customer Support Telephone — 1.440.646.3434 Online Support — http://www.rockwellautomation.com/support/overview.page Copyright Notice © 2014 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.
Table of Contents Chapter 1 Welcome to RSBizWare Intended audience .......................................................................................11 The RSBizWare architecture.................................................................... 12 FactoryTalk Administration Console............................................... 14 Service Console.......................................................................................15 Security Services Manager ........................................
Table of Contents Step 11: Verify if the local computer is added to the FactoryTalk Administration Console....................................................................... 59 Step 12: Configure FactoryTalk groups and users ......................... 60 Configure Windows-linked FactoryTalk users ......................... 60 Configure FactoryTalk users ......................................................... 64 Step 13: Install RSBizWare .................................................................
Table of Contents Step 4: Keep your ODBC data source configuration for reference 123 Step 5: Keep your FactoryTalk Administration Console configuration for reference ............................................................... 124 Step 6: Install Internet Information Services (IIS) ..................... 126 Step 7: Install SQL Server 2012 Service Pack 1 ........................... 132 Step 8: Install FactoryTalk Services Platform ..............................
Table of Contents Step 30: Register FactoryTalk Transaction Manager ................. 187 Step 31: Register the configuration in the Service Console ...... 188 Step 32: Configure SQL Server Reporting Services (SSRS) ..... 191 Step 33: Verify the SSRS configuration ......................................... 193 Step 34: Install and configure Report Expert ............................... 196 Step 35: Configure the FTMetricsEditors group ........................
Table of Contents Managing FactoryTalk user groups and users.................................... 231 Configuring FactoryTalk user groups ............................................ 231 Configuring Windows-linked user groups ................................... 233 Updating the Service Console with users and groups changes . 235 Chapter 9 Managing user access Assigning application privileges to groups .................................... 237 Assigning object permissions to users and groups ...............
Table of Contents Tuning the Oracle database for FactoryTalk Historian Classic 265 Improving the performance of your RSBizWare Oracle database 265 Preparing to run the Oracle database ........................................ 267 Appendix C Data compression Benefits of using the data compression ............................................... 269 How the data compression works ........................................................ 270 Compression ratio ...................................................
Table of Contents Data types supported by SQL Server ................................................... 289 Behaviors when setting substitution options for FactoryTalk data points ........................................................................................................... 289 Resolving IP address to host name issues ............................................ 290 Removing a Configuration Server computer from FactoryTalk Transaction Manager ..................................................
Table of Contents 10 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Chapter 1 Welcome to RSBizWare RSBizWare is a suite of tools and services aimed at increasing your manufacturing floor effectiveness and profitability with solutions that target scheduling, performance analysis and improvement, and data acquisition and integration. With the RSBizWare suite of tools you can: • Improve gross margins and net profit without adding capacity or increasing your order volume.
Chapter 1 Welcome to RSBizWare • Microsoft Windows operating systems. • User accounts and security in the enterprise. • Microsoft SQL Server or Oracle Enterprise Manager. • Open Database Connectivity (ODBC). • RSBizWare administrators Install and configure the RSBizWare system so that it is ready for use for the end users. They should be familiar with: • Microsoft Windows operating systems. • User accounts and security in the RSBizWare system. • Open Database Connectivity (ODBC).
Welcome to RSBizWare Chapter 1 To understand this relationship, you need to understand the RSBizWare software architecture as shown in the following diagrams.
Chapter 1 Welcome to RSBizWare FactoryTalk Administration Console The FactoryTalk Administration Console is a stand-alone tool that allows you to configure and manage FactoryTalk-enabled applications. You must install at least one instance of the FactoryTalk Administration Console. You will use the FactoryTalk Administration Console to: • Create and configure application, area, and data server elements in the FactoryTalk Directory. • Set up redundancy for OPC data servers.
Welcome to RSBizWare Chapter 1 • View system-wide diagnostic messages. • Create and configure system groups and users. Service Console The Service Console is the center of the RSBizWare architecture. The Service Console is a Microsoft Management Console (MMC) snap-in that provides administrative functions for RSBizWare services. The Service Console is capable of accessing and controlling RSBizWare services that are running on computers across a TCP/IP network or on the local computer.
Chapter 1 Welcome to RSBizWare If you plan to use a Microsoft SQL Server database, SQL Server 2008 R2 and any required service packs can be installed from the DVD included with the software. • An Oracle database. If you plan to use an Oracle database, the Oracle database software must be installed on a computer that is accessible to the computers that will host the RSBizWare applications.
Welcome to RSBizWare Chapter 1 Manager hosts a special Web page, the Quick Web Home Page, to give users view-only access to RSBizWare reports stored on the server. FactoryTalk Transaction Manager Configuration Server The FactoryTalk Transaction Manager Configuration Server is a Windows service that runs continuously to provide a single interface to the configuration files (.dat files) that make up FactoryTalk Transaction Manager.
Chapter 1 Welcome to RSBizWare • Creates FactoryTalk Metrics Workcell History records in the RSBizWare database. • Creates FactoryTalk Metrics Event History records in the RSBizWare database. Where can I go for help? Consult the following resources for additional information about the product: • Release notes The release notes contain current information about the product, including hardware and software requirements, new features, known and fixed anomalies.
Chapter 2 RSBizWare prerequisites In this chapter you will learn about the following: • Hardware and software requirements (page 19) • Running RSBizWare in a distributed environment (page 19) • RSBizWare product dependencies (page 19) Hardware and software requirements For up-to-date information on hardware and software requirements of the RSBizWare suite, refer to the RSBizWare Release Notes, available on the RSBizWare installation DVD.
Chapter 2 RSBizWare prerequisites The following RSBizWare products are dependent on the FactoryTalk Services Platform: • FactoryTalk Historian Classic • FactoryTalk Metrics The following RSBizWare products depend on the RSBizWare Platform features: • FactoryTalk Historian Classic • FactoryTalk Metrics • FactoryTalk Historian for Batch • FactoryTalk Web Services (FTWS) • FactoryTalk Transaction Manager Datapoint Migration Tool The following RSBizWare products are dependent on FactoryTalk Transaction Manager
Chapter 3 Installing RSBizWare In this chapter you will learn how to perform a clean installation and then configure the RSBizWare software on your computer. The RSBizWare suite consists of the following components: • FactoryTalk Historian Classic • FactoryTalk Metrics • FactoryTalk Transaction Manager The installation can be performed on: • Microsoft Windows Server 2012 • Microsoft SQL Server 2012 Service Pack 1 You should avoid running the RSBizWare installation from a network DVD image.
Chapter 3 Installing RSBizWare patch number. It is usually located in the \Documents and Settings\username\Local Settings\Temp folder, where username is the name of the installing user. However, this location can vary depending on the value of the %TEMP% environment variable. This file contains information that can help the support identify the cause of your installation problem.
Installing RSBizWare Chapter 3 Installation on two computers Installation and configuration checklist In order to successfully install and configure your RSBizWare and Report Expert software, follow the steps in the order presented below.
Chapter 3 Installing RSBizWare Step 6: Install RSLinx Enterprise (page 45) Setting up your RSBizWare SQL Server environment Step 7: Create an RSBizWare SQL Server database (page 46) Step 8: Create an RSBizWare SQL Server database user (page 47) Step 9: Install SQL Server 2012 Native Client (page 51) Step 10: Configure the ODBC data source (page 52) Configuring FactoryTalk Administration Console Step 11: Verify if the local computer is added to the FactoryTalk Administration Console (page 59) Step 12: Con
Installing RSBizWare Chapter 3 Step 19: Assign application privileges to users (page 82) Configuring data collection Step 20: Register FactoryTalk Transaction Manager (page 85) Step 21: Define FactoryTalk Transaction Manager configurations (page 87) Step 22: Register FactoryTalk Transaction Manager configurations (page 91) Installing and configuring Report Expert Step 23: Configure SQL Server Reporting Services (SSRS) (page 95) Step 24: Verify the SSRS configuration (page 98) Step 25: Install and configu
Chapter 3 Installing RSBizWare 3. Click Next. The Select installation type page appears. 4. Click Role-based or feature-based installation. 5. Click Next. The Select destination server page appears. 6. Click Select a server from the server pool. 7. Under Server Pool, select the local server computer (i.e., the computer on which you are performing these steps). 8. Click Next. The Select server roles page appears. 9. Click Web Server (IIS). The Add Roles and Features Wizard dialog box appears.
Installing RSBizWare Chapter 3 10. Click Add Features. 11. Click Next. The Select features page appears. 12. Select the following features: Feature group .NET Framework 3.5 Features .NET Framework 4.5 Features Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 Individual features • .NET Framework 3.5 (Includes .NET 2.0 and 3.0) • .NET Framework 4.5 • ASP.NET 4.
Chapter 3 Installing RSBizWare The Add Roles and Features Wizard dialog box appears. 13. Click Add Features. 14. Click Next. The Web Server Role (IIS) page appears. 15. Click Next. The Select role services page appears.
Installing RSBizWare Chapter 3 16. Select the following role services: Role group Web Server Management Tools Services • Common HTTP Features • Default Document • Directory Browsing • HTTP Errors • Static Content • Security • Request Filtering • Windows Authentication • Application Development • .NET Extensibility 4.5 • ASP.NET 4.
Chapter 3 Installing RSBizWare 19. Select the Restart the destination server automatically if required option. The Add Roles and Features Wizard dialog box appears. 20. Click Yes to confirm selecting the option.
Installing RSBizWare Chapter 3 21. Click Install. The features that you have selected are being installed to your server. 22. Once the installation is complete, click Close. 23. Open your web browser, and type http://localhost. The IIS 8.0 logo displayed in the window of the web browser confirms that the installation has been successful.
Chapter 3 Installing RSBizWare Step 2: Install SQL Server 2012 Service Pack 1 TIPS • If you have chosen the installation on two computers, perform the following steps on the Database server computer. • It is recommended that you create a Windows user account or a Windows Domain user account on the computer on which you are installing SQL Server. You will use this account to install and configure SQL Server. For details, refer to the Microsoft Windows user documentation.
Installing RSBizWare Chapter 3 The Setup Support Rules page appears. 3. Click OK. The Product Key page appears. The product key is already provided on the page. 4. Leave the default settings, and then click Next. The License Terms page appears. 5. Read the license terms, click I accept the license terms, and then click Next. The Product Updates page appears. 6. Leave the default settings, and then click Next. The SQL Server setup files are installed.
Chapter 3 Installing RSBizWare The Setup Support Rules page appears. 7. Click Next. The Setup Role page appears. 8. Click SQL Server Feature Installation, and then click Next. The Feature Selection page appears.
Installing RSBizWare Chapter 3 9. Select the following features: 10. Click Next. The Installation Rules page appears. 11. Click Next. The Instance Configuration page appears.
Chapter 3 Installing RSBizWare 12. Leave the default settings, and then click Next. The Disk Space Requirements page appears. 13. Click Next. The Server Configuration page appears. 14. On the Service Accounts tab, define accounts for each SQL Server service. 15. Click the Collation tab, and then click Customize. The Customize the SQL Server 2012 Database Engine Collation dialog box appears. 16. Click SQL collation, used for backwards compatibility. 17. In the list, select SQL_Latin1_General_CP1_CI_AS.
Installing RSBizWare Chapter 3 18. Click OK, and then click Next. The Database Engine Configuration page appears. 19. Select Mixed Mode... as the authentication method. 20. Under Mixed Mode..., type the password for the SQL Server System Administrator account (sa). IMPORTANT Make sure that you do not lose or forget the password for the sa account. You will need to provide this password when you will be configuring the SQL Server Reporting Services (SSRS). 21.
Chapter 3 Installing RSBizWare 22. Click Next. The Reporting Services Configuration appears. 23. Click Next. The Error Reporting page appears. 24. Click Next. The Installation Configuration Rules page appears. 25. Click Next. The Ready to Install page appears.
Installing RSBizWare Chapter 3 26. Click Install. The Installation Progress page appears. SQL Server 2012 is being installed. 27. Once your SQL server is installed successfully, close the SQL Server Installation Center wizard. Verify the configuration of SQL Server TIPS • If you have chosen the installation on two computers, perform the following steps on the Database server computer.
Chapter 3 Installing RSBizWare The Product Updates page appears. 4. Leave the default settings, and then click Next. The SQL Server setup files are installed. The Setup Support Rules page appears. 5. Click Next. The Installation Type page appears. 6. Click Add features to an existing instance of SQL Server 2012. 7. In the list, select the SQL Server 2012 instance that you will use with RSBizWare.
Installing RSBizWare Chapter 3 Click Next. The Feature Selection page appears. 8. Make sure that your SQL Server configuration contains the following features: 9.
Chapter 3 Installing RSBizWare • If your configuration contains all the features listed above, click Cancel, and then quit the SQL Server setup. • If your configuration misses any features listed above: 1. Add the features. 2. Continue with step 10 in "Step 2: Install SQL Server 2012 Service Pack 1 (page 32)", and finish the configuration of your SQL Server.
Installing RSBizWare Chapter 3 5. On the License Agreement page, click: 6. Click Next. 7. On the Setup Type page, leave the default setting: 8. Click Next. 9. On the Ready to Install the Program page, click Install. The Installing page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 10. Click Finish. A message prompting you to restart the computer appears. 11. Click Yes.
Chapter 3 Installing RSBizWare Step 4: Install FactoryTalk Activation TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. To install FactoryTalk Activation: 1. Run the RSBizWare installation DVD. The RSBizWare installation wizard appears. 2. Click FactoryTalk Metrics > Installation > Install FactoryTalk Activation. The installation wizard appears. 3. Click Next. 4. On the License Agreement page, click: 5. Click Next. 6.
Installing RSBizWare Chapter 3 Step 5: Configure FactoryTalk Activation If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. TIP You need to activate your RSBizWare suite so that you can use its features. You activate RSBizWare by obtaining license activation file(s) from the Rockwell Automation licensing website and assigning them to the RSBizWare suite using the FactoryTalk Activation Manager. To configure FactoryTalk Activation: 1.
Chapter 3 Installing RSBizWare The RSLinx Enterprise installation wizard appears. 4. Click Next. 5. On the License Agreement page, click: 6. Click Next. 7. On the Setup Type page, leave the default setting: 8. Click Next. 9. On the Ready to Install the Program page, click Install. The Installing... page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 10. Click Finish.
Installing RSBizWare Chapter 3 To create an SQL server database for the RSBizWare software: 1. On the Start screen, click SQL Server Management Studio. The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 2. Select the computer that hosts SQL Server. 3. Type the login and password, and then click Connect. 4. In the Object Explorer, right-click Databases and select New Database. The New Database dialog box appears. 5.
Chapter 3 Installing RSBizWare The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 2. Select the computer that hosts SQL Server. 3. Type the login and password, and then click Connect. 4. In the Object Explorer, expand the Security folder. 5. Right-click Logins, and then click New Login. The Login - New dialog box appears. 6. In the Login name box, type a name for the database user. In this example we will use RSBizWareUser. 7. Click SQL Server authentication. 8.
Installing RSBizWare Chapter 3 12. In the left pane of the Login - New dialog box, under Select a page, click User Mapping. 13. Under Users mapped to this login, in the Map column, check the box next to the name of your RSBizWare database.
Chapter 3 Installing RSBizWare 14. In the Default Schema column, in the row of your RSBizWare database, type the name of your database user. 15. Under Database role membership for , select the db_owner check box. 16. Click OK.
Installing RSBizWare Chapter 3 Step 9: Install SQL Server 2012 Native Client TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. Otherwise, go to "Step 10: Configure the ODBC data source (page 52)".
Chapter 3 Installing RSBizWare 8. On the License Agreement page, click: 9. Click Next. 10. On the Feature Selection page, leave the default settings, and then click Next. 11. On the Ready to Install the Program, click Install. 12. Once the installation is complete, click Finish. Step 10: Configure the ODBC data source TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer and the Database server computer.
Installing RSBizWare Chapter 3 To configure the data source name (DSN) for ODBC: 1. On the Start screen, click Server Manager. The Server Manager window appears. 2. On the Tools menu, click ODBC Data Source (32-bit). The ODBC Data Source Administrator (32-bit) dialog box appears. 3. Click the System DSN tab, and then click Add. The Create New Data Source dialog box appears. 4.
Chapter 3 Installing RSBizWare 6. In the Name box, type the name of the data source. In this example we will use ODBC RSB. 7. (Optional) In the Description box, type the description of the data source. 8. In the Server list, do either of the following: • If your RSBizWare SQL Server database is on the computer on which you are performing these steps, select (local). • If your RSBizWare SQL Server database is on the database server computer, select the name of this computer.
Installing RSBizWare Chapter 3 13. Click Next. 14. Leave the default settings or modify them according to your needs. 15. Click Finish. The ODBC Microsoft SQL Server Setup dialog box appears.
Chapter 3 Installing RSBizWare 16. Verify the new ODBC data source configuration, and then click Test Data Source.
Installing RSBizWare Chapter 3 A message box with the test results appears. TIP Repair the connection to SQL Server TIP If the test does not complete successfully, make sure that you have selected the correct authentication mode for your SQL Server (page 57), and then run the test again. If you have chosen the installation on two computers, perform the following steps on the Database server computer. The RSBizWare configuration requires the mixed mode as the authentication method for the SQL server.
Chapter 3 Installing RSBizWare The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 2. Select the computer that hosts SQL Server. 3. Type the login and password, and then click Connect. 4. In the Object Explorer, right-click the server name, and then select Properties. The Server Properties dialog box appears. 5. Under Select a page, click Security. 6. Under Server authentication, check the selected server authentication mode.
Installing RSBizWare Chapter 3 10. Click Yes. The server authentication mode will be updated. Step 11: Verify if the local computer is added to the FactoryTalk Administration Console TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. By default, the computer on which you have installed FactoryTalk Services Platform is automatically added to the FactoryTalk Administration Console, which is a part of FactoryTalk Services Platform.
Chapter 3 Installing RSBizWare In this section you will create FactoryTalk user groups and users. Step 12: Configure FactoryTalk groups and users The final infrastructure of groups and users will depend on your specific requirements and may differ from the one presented below. In the following examples, we will add the local Windows Administrator account to FactoryTalk users.
Installing RSBizWare Chapter 3 To add a local Administrator account as a Windows-linked user: 1. In the FactoryTalk Administration Console, in the Explorer, expand System > Users and Groups. 2. Right-click Users, and then click New > Windows-Linked User. The New Windows-Linked User dialog box appears. 3. Click Add. The Select Users dialog box appears. 4. Click Advanced.
Chapter 3 Installing RSBizWare The Select Users dialog box appears. 5. Click Find Now. 6. Under Search results, users from the selected location are listed.
Installing RSBizWare Chapter 3 7. Select a user, and then click OK. The Windows user that you have chosen appears under Enter the object names to select. 8. Click OK. The Windows user appears in the New Windows-Linked User dialog box.
Chapter 3 Installing RSBizWare 9. Click OK. The newly added Windows-linked user appears under the Users folder in the Explorer. TIP Configure FactoryTalk users For more information on users and user groups in the FactoryTalk Administration Console, refer to the FactoryTalk help. To open the help file, on the Help menu click Contents. If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. TIP To create FactoryTalk users: 1.
Installing RSBizWare Chapter 3 The New User dialog box appears. 5. In the User name box, type a name of the user. In this example we will use RSBizWareUser. 6. In the Password box, type a password for the user. 7. In the Confirm box, retype the password. 8. Click the Group Membership tab, and then click Add. The Select User Group dialog box appears. 9. Click Administrators. 10. Click OK.
Chapter 3 Installing RSBizWare In the New User dialog box, the Administrators group is listed under Member of. 11. Click OK. The newly created user appears under the Users folder in the Explorer. The user belongs to the FactoryTalk Administrators group. For more information on configuring the FactoryTalk Administration Console, refer to the FactoryTalk help. To open the help file, on the Help menu click Contents.
Installing RSBizWare Chapter 3 4. On the License Agreement page, click: 5. Click Next. 6. On the Customer Information page, type the following information: 7. Click Next. 8. On the Setup Type page, click: 9. Click Next. 10. On the Ready to Install the Program page, click Install. The Installing page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 11. Click Finish. A message prompting you to restart the computer appears.
Chapter 3 Installing RSBizWare 12. Click Yes. Step 14: Register the Security Services Manager If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. TIP The Security Services Manager is a Windows service that is responsible for the following: • Starting and stopping the RSBizWare server services. • Administering licenses for all RSBizWare servers that are registered with the Security Services Manager.
Installing RSBizWare Chapter 3 3. In the Hostname or IP address box, type the name or IP address of the local computer. Alternatively, click , and then search for the computer. 4. Click OK. You have logged on to the Security Services Manager. The explorer tree in the Service Console is populated with Security Services Manager items. NOTE Step 15: Register the Information Services Manager TIP Logging on to the Security Services Manager will activate the FactoryTalk single sign-on user functionality.
Chapter 3 Installing RSBizWare 2. In the Server Type list, click Information Services Manager. The Hostname or IP address box contains the name or the IP address of the local computer. 3. Click OK. 4. The Information Services Manager server appears under the Security Services Manager with the following icon: . 5. Click Information Services Manager. 6. In the Data Sources list, select the name of the ODBC data source that you created in "Step 10: Configure the ODBC data source (page 52)". 7.
Installing RSBizWare Chapter 3 Item Description Connection Pool Type the number of database connections that the server should keep open. Each time a client makes a request for data from the database, a connection is assigned to the client from this pool. A small number of connections in the pool with a large number of connected users will create delays while users wait for an available connection. The default value is 5.
Chapter 3 Installing RSBizWare Item Description HTTP Port Type the port number on which the server will listen for requests from Configuration Consoles. The Configuration Console uses HTTP in addition to raw TCP/IP to communicate to the Information Services Manager. The default HTTP port is 8080. Note: Oracle 9.2.0.1.0 uses port 8080. If you are using this version of Oracle, you must set the HTTP port to a value other than 8080.
Installing RSBizWare Chapter 3 15. Click OK. Once the server is restarted, the Information Services Manager server appears under the Security Services Manager with the following icon: . Step 16: Associate Metrics Server Manager with Information Services Manager TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. To associate the Metrics Server Manager with the Information Services Manager: 1.
Chapter 3 Installing RSBizWare 9. Click OK. 10. (Optional) Click Advanced. Review the following for additional information. For this item: Type: Max Records to Return The maximum number of records that the server should return for any single non-time-series query against the database. This is a useful way to control queries that are returning a large amount of data. Connection Pool The number of database connections that the server should keep open.
Installing RSBizWare Chapter 3 For this item: Type: Report User The report user name that will be used to connect to the Configuration Console to run the scheduled reports. If you are using scheduled reports, provide a user with sufficient privileges to run all of the scheduled reports. The password of the report user. The port number on which the server will listen for requests from the Configuration Console. The default HTTP port is 8080.
Chapter 3 Installing RSBizWare If you want to use the User-Defined Summarization Fields (Flex-Fields) in you configuration, configure them in the Metrics Server Manager (page 76). Configure user-defined summarization fields (flex-fields) A summarization criterion is a FactoryTalk Metrics Performance Parameter field for which you can collect activity area data.
Installing RSBizWare Chapter 3 By default, the user-defined summarization fields are disabled. To enable and configure user-defined summarization fields: 1. In the Service Console, expand Metrics Server Manager, and then click FactoryTalk Metrics Flex- Fields. In the right pane of the window, a list of 5 user-defined summarization fields appears. 2. Select the field that you want to configure, and then click Edit. The Configure Summarization Criteria dialog box appears. 3.
Chapter 3 Installing RSBizWare • String Value Select this option, if you intend FactoryTalk Metrics to communicate with your ControlLogix controller. The FactoryTalk Metrics Configuration Tool, which uses the FactoryTalk Metrics user-defined data type (UDT) to establish the communication with ControlLogix controllers, uses only the string values in the UDT to define flex-fields.
Installing RSBizWare Chapter 3 Step 17: Assign activations to RSBizWare servers TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. To assign activations to the RSBizWare servers: 1. Under Security Services Manager, expand Administration. 2. Click Activations. In the right pane of the window, activation details are provided.
Chapter 3 Installing RSBizWare Item Description Assigned The number of activations that have been assigned to the selected RSBizWare server. Only assigned activations will be detected by the product running on the selected server. In the table, you may see the following types of activations: Activation type Description Metrics Server Manager XX Workcells A FactoryTalk Metrics server license for the specified number of work cells. You can assign more than one license.
Installing RSBizWare Chapter 3 The activation is assigned to the server. The number of Available activations is reduced by 1, and the number of Assigned activations is increased by 1. See also • Software activation options (page 222) Step 18: Assign client activations to users TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer. To assign client activations to users: 1.
Chapter 3 Installing RSBizWare The Security Control dialog box appears. 6. Click the License & Activation tab. 7. In the Server Type list, select the type of the server for which you want to assign privileges. 8. Under Place a check..., select the check box to the left of the activation that you want to assign to the user. 9. Click OK. Step 19: Assign application privileges to users TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer.
Installing RSBizWare Chapter 3 You can manage the privileges and permissions that a user has either by assigning privileges and permissions directly to the user or by assigning privileges and permissions to a user group, and then placing the user in one or more user groups. A user belonging to a group will inherit the privileges and permissions that have been assigned to the group. Since users can belong to multiple groups, groups can be broken down into logical areas of application functionality.
Chapter 3 Installing RSBizWare TIP While it is perfectly acceptable to assign privileges on a user-by-user basis, the process will become very tedious when you have a large number of users in the system. For this reason, you may want to assign privileges at a group level.
Installing RSBizWare Chapter 3 Privilege Description Type of Author activation required Allows the selected user or group to save the data from a text report object to a comma separated values (.csv) or html (.htm) file. Organize Plant Model Allows the selected user or group to create and modify activity areas in the plant model. Manage Reporting Allows the selected user or group to use the Time-Series Tags Reporting Tags dialog box to create, modify, and configure reporting tags.
Chapter 3 Installing RSBizWare to control the FactoryTalk Transaction Manager configurations that will be used to collect data. In order to use FactoryTalk Transaction Manager configurations in the RSBizWare system on your computer or another computer in the network, register the computer as a FactoryTalk Transaction Manager configuration server. To register a FactoryTalk Transaction Manager configuration server: 1. In the Service Console, expand Security Services Manager. 2.
Installing RSBizWare Chapter 3 The FactoryTalk Transaction Manager server appears under FactoryTalk Transaction Manager Configurations with the following icon: . See also • Configuring data collection (page 243) Step 21: Define FactoryTalk Transaction Manager configurations TIP If you have chosen the installation on two computers, perform the following steps on the RSBizWare server computer.
Chapter 3 Installing RSBizWare that you want to use and the computer on which those services will run. To define FactoryTalk Transaction Manager configurations: 1. In the Service Console, right-click your FactoryTalk Transaction Manager under FactoryTalk Transaction Manager Configurations, and then click Add Configuration. The Add FactoryTalk Transaction Manager Configuration dialog box appears. 2. In the Name box, type a name for your configuration. 3. Next to the File Location box, click .
Installing RSBizWare Chapter 3 By default, the file name is the same as the configuration name. 5. In the Run As User box, type the name of the Windows system account that will be used by FactoryTalk Transaction Manager. The account must have administrative privileges in the operating system. 6. In the Run As Password box, type the password of the Windows system account. 7.
Chapter 3 Installing RSBizWare 8. Click OK. 9. The Add FactoryTalk Transaction Manager Connector dialog box appears for each connector that you have selected in your FactoryTalk Transaction Manager configuration. 10. Change the default settings, if necessary. NOTE If you provide other Windows system account for the connector than the one that you have set for your configuration, make sure that the account has administrative privileges in the operating system. 11. Click Done.
Installing RSBizWare Chapter 3 See also • Configuring data collection (page 243) If you have chosen the installation on two computers, perform the Step 22: Register FactoryTalk TIP following steps on the RSBizWare server computer. Transaction Manager To register FactoryTalk Transaction Manager configurations: configurations 1. In the Service Console, expand Information Services Manager. 2. Right-click Data Collection, and then click Register FactoryTalk Transaction Manager Configuration.
Chapter 3 Installing RSBizWare The Local or Remote page appears. 4. Select either of the following: • Search for FactoryTalk Transaction Manager Configurations on this computer. • Search for FactoryTalk Transaction Manager Configurations on another computer. If you have selected this option, point to the computer which you want to search for the configurations: 1. Next to the Computer box, click . The Browse for Computer dialog box appears. 2. Navigate to and click the name of the computer. 3. Click OK.
Installing RSBizWare Chapter 3 NOTE You can register only one FactoryTalk Transaction Manager configuration at a time. 7. Under Choose which RSBizWare application(s)..., click FT Metrics. 8. Click Next. The Completing the Wizard page appears. 9. Review the choices you have made during the registration of your FactoryTalk Transaction Manager configurations.
Chapter 3 Installing RSBizWare 10. Click Finish. Your configuration appears in the tree under Data Collection. Now you can use your configuration to create transactions in the Configuration Console. At this point, there are no FactoryTalk Transaction Manager transactions in the configuration. FactoryTalk Transaction Manager transactions are created when users define time-series data collection (FactoryTalk Historian Classic) or performance parameters (FactoryTalk Metrics).
Installing RSBizWare Chapter 3 For information on defining time-series data collection, refer to the FactoryTalk Historian Classic User Guide. For information on defining performance parameters, refer to the FactoryTalk Metrics User Guide. See also • Configuring data collection (page 243) Step 23: Configure SQL Server Reporting Services (SSRS) TIP If you have chosen the installation on two computers, perform the following steps on the Database server computer.
Chapter 3 Installing RSBizWare 6. In the right pane of the window, make sure the Use built-in account option is selected, and that it points to ReportServer. 7. In the left pane of the window, click Database. 8. In the right pane of the window, under Current Report Server Database, make sure that SQL Server Name points to the local computer, and Database Name points to ReportServer. 9. Under Current Report Server Database Credential, click Change Credentials.
Installing RSBizWare Chapter 3 13. Click Test Connection. If the test is successful, the following message appears: 14. Click OK, and then click Next. 15. On the Credentials page, leave the default settings. 16. Click Next. 17. On the Summary page, review the database details.
Chapter 3 Installing RSBizWare 18. Click Next. 19. Wait until the database is configured, and then click Finish. Step 24: Verify the SSRS configuration TIP If you have chosen the installation on two computers, perform the following steps on the Database server computer. To verify the configuration of SQL Server Reporting Services (SSRS): 1. On the Start screen, type any part of the name SQL Server Management Studio, and then click its shortcut. 2.
Installing RSBizWare Chapter 3 6. Click Connect. The Report Server appears in the Object Explorer. 7. Exit the SQL Server Management Studio. 8. On the Start screen, type any part of the name Reporting Services Configuration Manager, and then click its shortcut. The Reporting Services Configuration Manager window and the Reporting Services Configuration Connection dialog box appear.
Chapter 3 Installing RSBizWare 9. In the Reporting Services Configuration Connection dialog box, click Connect. 10. In the left pane of the window, click Report Manager URL. 11. In the right pane of the window, click the link in the URLs box. The home page of the SQL Server Reporting Services appears in a web browser window. Step 25: Install and configure Report Expert TIP If you have chosen the installation on two computers, perform the following steps on the Database server computer.
Installing RSBizWare Chapter 3 2. On the Welcome page, click FactoryTalk Metrics > Installation > Install Report Expert. The installation program checks for installed applications. 3. On the Welcome page, click Next. 4. On the License Agreement page, click: 5. Click Next. 6. On the Customer Information page, type the following: 7. Click Next. 8. On the Setup Type wizard page, select: • Complete, if you want to install all the features. • Custom, if you want to install specific components.
Chapter 3 Installing RSBizWare 10. Click Next. 11. On the Database connection information page, provide the following information: Item Description System DSN Name Select the name of the ODBC data source that you have configured for your RSBizWare SQL Server database. Type the user name of your RSBizWare database. Type the password for the RSBizWare database user. Username Password 12. Click Next. 13. On the Ready to Install the Program page, click Install. The Installing...
Installing RSBizWare Chapter 3 18. Under Available Product Modules, select these options: TIP Select both options so that you have access to FactoryTalk Metrics and Report Expert sample data. 19. Click Finish to load data. 20. Click Close to exit the wizard. Step 26: Configure the FTMetricsEditors group TIP If you have chosen the installation on two computers, perform the following steps on the Database server computer.
Chapter 3 Installing RSBizWare The default name for the group in the Report Expert configuration is host\FTMetricsEditors. You can use this name or choose another. 4. Add the Windows domain user name of each editor to the newly created group. If you intend to use a local group that already exists in the system, or you have created a new group and chosen for it a different name than the default one, you need to update the Report Expert configuration file. To update the Report Expert configuration file: 1.
Installing RSBizWare Chapter 3 Step 27: Verify the Report Expert installation If you have chosen the installation on two computers, perform the following steps on the Database server computer. TIP To verify the Report Expert installation: 1. On the Start screen, type any part of the name Report Expert, and then click its shortcut. TIP By default, Report Expert is located in the following directory: C:\Program Files (x86)\Rockwell Software\Report Expert\RE.
Chapter 3 Installing RSBizWare Congratulations! 106 You have completed the installation and configuration of your RSBizWare environment. You are now ready to start the Configuration Console and begin to use the products.
Installing RSBizWare Chapter 3 Removing RSBizWare To modify the existing installation of RSBizWare software: 1. Run the RSBizWare installation DVD. 2. Select Install for the component that you want to modify. 3. Select one of the available options: Modify or Repair. 4. Follow the on-screen instructions to complete the process. To remove RSBizWare applications: • Use the installation DVD: 1. Run the RSBizWare installation DVD. 2. Select Install for the component that you want to remove. 3. Select Remove.
Chapter 3 Installing RSBizWare 108 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Chapter 4 Migrating RSBizWare In this chapter you will learn how to migrate your RSBizWare environment between the following configurations: From: To: Microsoft Windows Server 2003 R2 with Microsoft Windows Server 2012 Service Pack 2 Microsoft SQL Server 2005 Standard Microsoft SQL Server 2012 Service Pack 1 Edition with Service Pack 3 If your current RSBizWare environment is maintained on: • Microsoft Windows Server 2008 R2 with Service Pack 1 • Microsoft SQL Server 2008 R2 Standard Edition with Servic
Chapter 4 Migrating RSBizWare Migration: supported migration scenarios To perform a migration of RSBizWare and Report Expert, choose one of the following scenarios: Migration from one source computer to one target computer (all-in-one installation) Migration from a source computer to two target computers: 110 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Migrating RSBizWare Chapter 4 Migration from two source computers to two target computers: Migration from two source computers to one target computer (all-in-one installation): Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 111
Chapter 4 Migrating RSBizWare Migration checklist In order to successfully migrate your RSBizWare and Report Expert software, follow the steps in the order presented below.
Migrating RSBizWare Chapter 4 Step 13: Recreate your RSBizWare SQL Server database user (page 144) Step 14: Install SQL Server 2012 Native Client (page 148) Step 15: Recreate the ODBC data source (page 150) Recreating your FactoryTalk Administration Console configuration Step 16: Verify if the local computer is added to the FactoryTalk Administration Console (page 156) Step 17: Recreate your applications (page 157) Step 18: Add a local Administrator account as a Windows-linked user (page 158) Step 19: Re
Chapter 4 Migrating RSBizWare Step 26: Assign application privileges to users (page 176) Restoring your FactoryTalk Transaction Manager configuration Step 27: Restore your FactoryTalk Transaction Manager configuration (page 179) Step 28: Register the configuration in the RSBizWare SQL Server database (page 181) Step 29: Update your FactoryTalk Transaction Manager configuration (page 183) Step 30: Register FactoryTalk Transaction Manager (page 187) Step 31: Register the configuration in the Service Console
Migrating RSBizWare Step 1: Back up your FactoryTalk Transaction Manager configuration TIP Chapter 4 If you are migrating the RSBizWare suite from two computers, perform the following steps on the Source RSBizWare server computer. To successfully restore your FactoryTalk Transaction Manager configuration, you need to keep for reference the location in which the configuration is saved in FactoryTalk Transaction Manager, and create the configuration backup.
Chapter 4 Migrating RSBizWare 3. Click Yes. 4. Wait until all the services are stopped and the traffic lights icon next to the configuration in the tree view changes to the red light. 5. On the Configuration menu, click Backup. The Remote rsq File Browse dialog box appears. 6. In the tree view, select the folder to which you want to save your configuration, or create a new one. To create a new folder: 1. In the File Path text box, type the path to the folder and the folder name, and then click New.
Migrating RSBizWare Chapter 4 The following message appears: 2. Click Yes. The following message appears: 3. Click OK. 7. Click OK. The following message appears: 8. Click OK.
Chapter 4 Migrating RSBizWare The following message appears: 9. Click OK. Step 2: Back up your RSBizWare SQL Server database TIP If you are migrating the RSBizWare suite from two computers, perform the following steps on the Source Database server computer. To back up your RSBizWare SQL Server database: 1. Open SQL Server Management Studio. The Connect to Server dialog box appears. 2. If necessary, type your login and password, and then click Connect. 3. In the Object Explorer, expand Databases. 4.
Migrating RSBizWare Chapter 4 The Back Up Database dialog box appears. Under Destination, the default location to which the backup will be saved is provided. Leave it or choose another location. To choose another location for your database backup: 1. Under Destination, click Remove. The default location is removed. 2. Click Add. The Select Backup Destination dialog box appears. 3. Under File name, click Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 .
Chapter 4 Migrating RSBizWare The Locate Database Files dialog box appears. 4. Navigate to the location, in which you want to save the file. 5. In the File name text box, type the file name under which you want to save your RSBizWare SQL Server database backup. 6. Click OK. 7. In the Select Backup Destination dialog box, click OK. Under Destination, your location and the file name of the RSBizWare database backup is listed. 5.
Migrating RSBizWare Chapter 4 7. Under Reliability, select the Verify backup when finished check box. 8. Click OK. Once the backing up process is complete, the following message appears: 9. Click OK. Step 3: Keep your database users for reference TIP If you are migrating the RSBizWare suite from two computers, perform the following steps on the Source Database server computer.
Chapter 4 Migrating RSBizWare Since there is no automatic way of backing up this information, use your preferred method of storing it for reference. To view your RSBizWare SQL Server database users: 1. In the Object Explorer, expand your RSBizWare database tree item. 2. Expand Security, and then Users. Under Users, the database users are listed. To view database user roles: 1. Under Users, right-click a user, and then click Properties. 2. The Database User dialog box appears.
Migrating RSBizWare Chapter 4 If you are migrating the RSBizWare suite from two computers, perform Step 4: Keep your ODBC data TIP the following steps on the Source RSBizWare server computer. source configuration for It is necessary that you restore on the target computer the following reference elements of the ODBC data source configuration: • The data source name. • The login ID and the password of your RSBizWare SQL Server database to which you are connecting with the ODBC data source.
Chapter 4 Migrating RSBizWare Native Client 10.0 driver or the SQL Server driver to configure your ODBC data source: • The configuration using the SQL Server Native Client 10.0 driver: • The configuration using the SQL Server driver: If you are migrating the RSBizWare suite from two computers, perform Step 5: Keep your FactoryTalk TIP the following steps on the Source RSBizWare server computer.
Migrating RSBizWare Chapter 4 • Shortcuts to controllers • User Groups • Users Since there is no automatic way of backing up this information, use your preferred method of storing it for reference.
Chapter 4 Migrating RSBizWare Step 6: Install Internet Information Services (IIS) TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. To install Internet Information Services (IIS): 1. On the Start screen, click Server Manager. The Server Manager window appears. 2. Under Configure this local server, click Add roles and features. The Add Roles and Features Wizard appears. 3. Click Next.
Migrating RSBizWare Chapter 4 10. Click Add Features. 11. Click Next. The Select features page appears. 12. Select the following features: Feature group .NET Framework 3.5 Features .NET Framework 4.5 Features Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 Individual features • .NET Framework 3.5 (Includes .NET 2.0 and 3.0) • .NET Framework 4.5 • ASP.NET 4.
Chapter 4 Migrating RSBizWare The Add Roles and Features Wizard dialog box appears. 13. Click Add Features. 14. Click Next. The Web Server Role (IIS) page appears. 15. Click Next. The Select role services page appears.
Migrating RSBizWare Chapter 4 16. Select the following role services: Role group Web Server Management Tools Services • Common HTTP Features • Default Document • Directory Browsing • HTTP Errors • Static Content • Security • Request Filtering • Windows Authentication • Application Development • .NET Extensibility 4.5 • ASP.NET 4.
Chapter 4 Migrating RSBizWare 19. Select the Restart the destination server automatically if required option. The Add Roles and Features Wizard dialog box appears.
Migrating RSBizWare Chapter 4 20. Click Yes to confirm selecting the option. 21. Click Install. The features that you have selected are being installed to your server. 22. Once the installation is complete, click Close. 23. Open your web browser, and type http://localhost. The IIS 8.0 logo displayed in the window of the web browser confirms that the installation has been successful.
Chapter 4 Migrating RSBizWare Step 7: Install SQL Server 2012 Service Pack 1 TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. To install SQL Server: 1. Run the SQL Server 2012 Service Pack 1 installation DVD. The SQL Server Installation Center wizard appears. 2. Click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation. The Setup Support Rules page appears. 3.
Migrating RSBizWare Chapter 4 The Product Updates page appears. 6. Leave the default settings, and then click Next. The SQL Server setup files are installed. The Setup Support Rules page appears. 7. Click Next. The Setup Role page appears. 8. Click SQL Server Feature Installation, and then click Next.
Chapter 4 Migrating RSBizWare The Feature Selection page appears. 9. Select the following features: 10. Click Next. The Installation Rules page appears. 11. Click Next.
Migrating RSBizWare Chapter 4 The Instance Configuration page appears. 12. Leave the default settings, and then click Next. The Disk Space Requirements page appears. 13. Click Next. The Server Configuration page appears. 14. On the Service Accounts tab, define accounts for each SQL Server service. 15. Click the Collation tab, and then click Customize. The Customize the SQL Server 2012 Database Engine Collation dialog box appears.
Chapter 4 Migrating RSBizWare 16. Click SQL collation, used for backwards compatibility. 17. In the list, select SQL_Latin1_General_CP1_CI_AS. 18. Click OK, and then click Next. The Database Engine Configuration page appears. 19. Select Mixed Mode... as the authentication method. 20. Under Mixed Mode..., type the password for the SQL Server System Administrator account (sa). IMPORTANT Make sure that you do not lose or forget the password for the sa account.
Migrating RSBizWare Chapter 4 22. Click Next. The Reporting Services Configuration appears. 23. Click Next. The Error Reporting page appears. 24. Click Next. The Installation Configuration Rules page appears. 25. Click Next. The Ready to Install page appears.
Chapter 4 Migrating RSBizWare 26. Click Install. The Installation Progress page appears. SQL Server 2012 is being installed. 27. Once your SQL server is installed successfully, close the SQL Server Installation Center wizard. Step 8: Install FactoryTalk Services Platform TIP NOTE If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer.
Migrating RSBizWare Chapter 4 7. On the Setup Type page, leave the default setting: 8. Click Next. 9. On the Ready to Install the Program page, click Install. The Installing page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 10. Click Finish. A message prompting you to restart the computer appears. 11. Click Yes.
Chapter 4 Migrating RSBizWare 6. On the Ready to Install the Program page, click Install. The Installing page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 7. Click Finish. A message prompting you to restart the computer appears. 8. Click Yes. Step 10: Configure FactoryTalk Activation If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer.
Migrating RSBizWare Chapter 4 3. Double-click setup.exe. The RSLinx Enterprise installation wizard appears. 4. Click Next. 5. On the License Agreement page, click: 6. Click Next. 7. On the Setup Type page, leave the default setting: 8. Click Next. 9. On the Ready to Install the Program page, click Install. The Installing... page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 10. Click Finish.
Chapter 4 Migrating RSBizWare Server database (page 118)" from the source computer to the computer on which you are performing these steps. 2. On the Start screen, click SQL Server Management Studio. The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 3. Select the computer that hosts SQL Server. 4. Type the login and password, and then click Connect. 5. In the Object Explorer, right-click Databases, and then click Restore Database.
Migrating RSBizWare Chapter 4 9. Click OK. The backup file is listed under Backup media. 10. Click OK. The Device text box points to the backup file, and the Database text box reads the database name from the backup file. Under Destination, the Database text box reads the database name from the backup file. IMPORTANT Make sure that the database name is the same as the name of the database that you are about to restore. 11. In the left pane of the dialog box, under Select a page, click Options. 12.
Chapter 4 Migrating RSBizWare Once the restoring process is complete, the following message appears: 14. Click OK. The database that you have restored appears under Databases in the Object Explorer. Step 13: Recreate your RSBizWare SQL Server database user TIP NOTE If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. Perform the following steps using a database user that has privileges to create databases.
Migrating RSBizWare Chapter 4 The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 2. Select the computer that hosts SQL Server. 3. Type the login and password, and then click Connect. 4. Expand Database > > Security > Users. 5. Under Users, delete all the users that were originally created for this database before the migration. You will create them from scratch, because otherwise the existing users may generate errors. 6.
Chapter 4 Migrating RSBizWare 11. In the Confirm password box, retype the password that you have created. 12. Clear the Enforce password expiration check box. 13. In the Default database list, select the name of your RSBizWare database that you restored in "Step 12: Restore your RSBizWare SQL Server database (page 141)". 14. In the left pane of the Login - New dialog box, under Select a page, click User Mapping.
Migrating RSBizWare Chapter 4 15. Under Users mapped to this login, in the Map column, select the check box next to the name of your RSBizWare database. 16. In the Default Schema column, in the row of your RSBizWare database, type the name of your database user. 17. Under Database role membership for , select the db_owner check box.
Chapter 4 Migrating RSBizWare 18. Click OK. Step 14: Install SQL Server 2012 Native Client TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. Otherwise, go to "Step 15: Recreate the ODBC data source (page 150)".
Migrating RSBizWare Chapter 4 2. Expand Install Instructions. 3. Scroll down to Microsoft® SQL Server® 2012 Native Client. 4. Click X64 Package. 5. Download the file. 6. Double-click sqlncli.msi. The Microsoft SQL Server Native Client Setup wizard appears. 7. Click Next. 8. On the License Agreement page, click: 9. Click Next. 10. On the Feature Selection page, leave the default settings, and then click Next.
Chapter 4 Migrating RSBizWare 11. On the Ready to Install the Program, click Install. 12. Once the installation is complete, click Finish. Step 15: Recreate the ODBC data source TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer and the Target database server computer. To recreate your ODBC data source: 1. On the Start screen, click Server Manager. The Server Manager window appears. 2.
Migrating RSBizWare NOTE Chapter 4 Choose this driver even if you had the ODBC data source configured with the SQL Server driver on your source computer. 5. Click Finish. The Create a New Data Source to SQL Server dialog box appears. 6. In the Name box, type the name of the data source. IMPORTANT Make sure that this is the same name as it was for the ODBC data source configured on the source computer. 7. (Optional) In the Description box, type the description of the data source. 8.
Chapter 4 Migrating RSBizWare restored in "Step 13: Recreate your RSBizWare SQL Server database user (page 144)". 11. Click Next. 12. Click Change the default database to, and then select the database that you restored in "Step 12: Restore your RSBizWare SQL Server database (page 141)". 13. Click Next. 14. Leave the default settings or modify them according to your needs.
Migrating RSBizWare Chapter 4 15. Click Finish. The ODBC Microsoft SQL Server Setup dialog box appears. 16. Verify the new ODBC data source configuration, and then click Test Data Source.
Chapter 4 Migrating RSBizWare A message box with the test results appears. 17. Click OK. TIP Repair the connection to SQL Server TIP If the test does not complete successfully, make sure that you have selected the correct authentication mode for your SQL Server (page 154), and then run the test again. If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer.
Migrating RSBizWare Chapter 4 The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 2. Select the computer that hosts SQL Server. 3. Type the login and password, and then click Connect. 4. In the Object Explorer, right-click the server name, and then click Properties. The Server Properties dialog box appears. 5. Under Select a page, click Security. 6. Under Server authentication, check the selected server authentication mode.
Chapter 4 Migrating RSBizWare 10. Click Yes. The server authentication mode will be updated. Step 16: Verify if the local computer is added to the FactoryTalk Administration Console TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer.
Migrating RSBizWare Step 17: Recreate your applications TIP Chapter 4 If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To recreate the configuration, use the data from your source computer. For details, see "Step 5: Keep your FactoryTalk Administration Console configuration for reference (page 124)". To recreate your applications: 1.
Chapter 4 Migrating RSBizWare 10. Under Name, type the same server name that you used in your original FactoryTalk Administration Console configuration. 11. Click OK. 12. In the Explorer, expand the server item, and then double-click Communication Setup. 13. In the right pane of the window, under Device Shortcuts, click Add. A new shortcut appears in the list, available for editing. 14. Type the same shortcut name that you used in your original FactoryTalk Administration Console configuration. 15.
Migrating RSBizWare Chapter 4 To add a local Administrator account as a Windows-linked user: 1. In the FactoryTalk Administration Console, in the Explorer, expand System > Users and Groups. 2. Right-click Users, and then click New > Windows-Linked User. The New Windows-Linked User dialog box appears. 3. Click Add. The Select Users dialog box appears. 4. Click Advanced.
Chapter 4 Migrating RSBizWare The Select Users dialog box appears. 5. Click Find Now. 6. Under Search results, users from the selected location are listed.
Migrating RSBizWare Chapter 4 7. Select a user, and then click OK. The Windows user that you have chosen appears under Enter the object names to select. 8. Click OK. The Windows user appears in the New Windows-Linked User dialog box.
Chapter 4 Migrating RSBizWare 9. Click OK. The newly added Windows-linked user appears under the Users folder in the Explorer. Step 19: Recreate your users TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To recreate the configuration, use the data from your source computer. For details, see "Step 5: Keep your FactoryTalk Administration Console configuration for reference (page 124)". To recreate your users: 1.
Migrating RSBizWare Chapter 4 6. In the Password box, type the password that you used for this user in your original FactoryTalk Administration Console configuration. 7. In the Confirm box, retype the password. 8. Click the Group Membership tab, and then click Add. The Select User Group dialog box appears. 9. Click Administrators. 10. Click OK. In the New User dialog box, the Administrators group is listed under Member of.
Chapter 4 Migrating RSBizWare 11. Click OK. The newly created user appears under the Users folder in the Explorer. The user belongs to the FactoryTalk Administrators group. Repeat the steps to restore other users that existed in your original FactoryTalk Administration Console configuration. Make sure that they have the same names, passwords, and user groups as in your original FactoryTalk Administration Console configuration.
Migrating RSBizWare Chapter 4 The RSBizWare installation wizard appears. 2. Click FactoryTalk Metrics > Installation > Install RSBizWare. The installation wizard appears. 3. Click Next. 4. On the License Agreement page, click: 5. Click Next. 6. On the Customer Information page, type the following information: 7. Click Next. 8. On the Setup Type page, click: 9. Click Next. 10. On the Ready to Install the Program page, click Install.
Chapter 4 Migrating RSBizWare The Installing page presenting the installation status appears. Once the installation is complete, the InstallShield Wizard Completed page appears. 11. Click Finish. A message prompting you to restart the computer appears. 12. Click Yes. Step 21: Register the Security Services Manager If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. TIP To register the Security Services Manager: 1.
Migrating RSBizWare Chapter 4 You have logged on to the Security Services Manager. The explorer tree in the Service Console is populated with Security Services Manager items. NOTE Step 22: Register the Information Services Manager TIP Logging on to the Security Services Manager will activate the FactoryTalk single sign-on user functionality. For more information about the FactoryTalk single sign-on, refer to the FactoryTalk Security online help.
Chapter 4 Migrating RSBizWare Recreate your RSBizWare SQL Server database user (page 144)". 9. In the Database Password box, type the password of your RSBizWare database user. 10. Click Test Connection. A message confirming a successful connection appears. 11. Click OK. 12. Click Advanced. 13.
Migrating RSBizWare Item Chapter 4 Description Connection Pool Type the number of database connections that the server should keep open. Each time a client makes a request for data from the database, a connection is assigned to the client from this pool. A small number of connections in the pool with a large number of connected users will create delays while users wait for an available connection. The default value is 5.
Chapter 4 Migrating RSBizWare Item Description HTTP Port Type the port number on which the server will listen for requests from the Configuration Console. The Configuration Console uses HTTP in addition to raw TCP/IP to communicate to the Information Services Manager. The default HTTP port is 8080. Note: Oracle 9.2.0.1.0 uses port 8080. If you are using this version of Oracle, you must set the HTTP port to a value other than 8080.
Migrating RSBizWare Chapter 4 16. Click OK. Once the server is restarted, the Information Services Manager server appears under the Security Services Manager with the following icon: . Step 23: Associate Metrics Server Manager with Information Services Manager TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To associate the Metrics Server Manager with the Information Services Manager: 1.
Chapter 4 Migrating RSBizWare A message confirming a successful connection appears. 9. Click OK. 10. Click Apply. The following message appears: 11. Click Yes. The Metrics Server Manager appears under the Information Services Manager with the following icon: . Step 24: Assign activations to RSBizWare servers TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To assign activations to the RSBizWare servers: 1.
Migrating RSBizWare Chapter 4 The table provides the following information: Item Description Total The total number of activations installed on the computer where the selected Security Services Manager is running. The Security Services Manager checks all RSBizWare activations out of the FactoryTalk Activation. The number of unassigned activations on the computer where the selected Security Services Manager is running. Unassigned activations will not be returned to the FactoryTalk Activation.
Chapter 4 Migrating RSBizWare Activation type Description FactoryTalk Metrics Author A single-user Authoring license that is assigned to a specific user. With this license, you can configure a FactoryTalk Metrics system using the Configuration Console. FactoryTalk Historian A single-user Authoring license that is assigned to a specific Author user. With this license, you can configure a FactoryTalk Historian Classic system using the Configuration Console.
Migrating RSBizWare Step 25: Assign client activations to users TIP Chapter 4 If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To assign client activations to users: 1. In the Service Console, expand Security Services Manager > Administration. 2. Click Users and Groups. 3. In the right pane of the window, under Users, click Refresh. 4. Click the user name for which you want to assign application privileges. 5.
Chapter 4 Migrating RSBizWare 9. Click OK. Step 26: Assign application privileges to users TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. A privilege is a distinct function of FactoryTalk Metrics and FactoryTalk Historian Classic applications that is assigned to security groups or individual users.
Migrating RSBizWare Chapter 4 groups can be broken down into logical areas of application functionality. For information on privileges available with individual client activations, see "FactoryTalk Historian and FactoryTalk Metrics privileges (page 178)". To assign application privileges to users: 1. In the Service Console, expand Security Services Manager > Administration. 2. Click Users and Groups. 3.
Chapter 4 Migrating RSBizWare FactoryTalk Historian and FactoryTalk Metrics privileges Privilege The following FactoryTalk Historian Classic and FactoryTalk Metrics (Configuration Console) privileges are available, depending on the assigned Author activation type. Description Type of Author activation required Allows the selected user or group to create reports for personal use. A report that has been created under this privilege can be viewed and edited by the user who created the report.
Migrating RSBizWare Privilege Description Type of Author activation required (FactoryTalk Historian Classic users only) Allows the selected user or group to view the Value, X-Axis, and Y-Axis comments that have been associated with time-series data. (FactoryTalk Historian Classic users only) Allows the selected Add Time-Series user or group to associate Value, X-Axis, and Y-Axis comments Comment with time-series data.
Chapter 4 Migrating RSBizWare 4. In the folder tree, navigate to the folder that contains the backup file. 5. Select the backup file, and then click OK. The FactoryTalk Transaction Manager Restore Configuration dialog box appears. 6. In the Path text box, leave the default setting or select another location in which you want to save the configuration. The location should be the same like the location of the original configuration before the migration. 7. Click OK.
Migrating RSBizWare Chapter 4 The following message appears: 8. Click Yes. The following message appears: 9. Click OK. The configuration is restored. Step 28: Register the configuration in the RSBizWare SQL Server database TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. To register your FactoryTalk Transaction Manager configuration in the RSBizWare SQL Server database: 1.
Chapter 4 Migrating RSBizWare The Microsoft SQL Server Management Studio window and the Connect to Server dialog box appear. 2. Select the computer that hosts SQL Server. 3. Type the login and password, and then click Connect. 4. In the Object Explorer, expand Databases > > Tables. 5. Navigate to the RSSqlConfig table. 6. Right-click the table, and then click Edit Top 200 Rows. 7.
Migrating RSBizWare Step 29: Update your FactoryTalk Transaction Manager configuration TIP Chapter 4 If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To update your FactoryTalk Transaction Manager configuration: 1. In FactoryTalk Transaction Manager, on the Configuration menu, click Checklist. The Configuration Checklist dialog box appears. 2. Under Define Configuration, click Step 1.
Chapter 4 Migrating RSBizWare The following message appears: 5. Click Yes. The following message appears: 6. Click OK. 7. Click Close. 8. In the Configuration Checklist dialog box, under Define Connectors, click Step 2. The Connector Definition dialog box appears. 9. In the Host Name text box, replace the name of the source computer on which you backed up the FactoryTalk Transaction Manager configuration with the name of the target computer on which you restored the configuration. 10.
Migrating RSBizWare Chapter 4 12. Click Host / User. The following message appears: 13. Click OK. The following message appears: 14. Click OK.
Chapter 4 Migrating RSBizWare You have updated the host names, user names, and password for all the connectors defined for your FactoryTalk Transaction Manager configuration. 15. Click Apply. The following message appears: 16. Click OK. The following message appears: 17. Click Yes. The following message appears: 18. Click OK.
Migrating RSBizWare Chapter 4 See also • Configuring data collection (page 243) Step 30: Register FactoryTalk Transaction Manager TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. To register a FactoryTalk Transaction Manager configuration server: 1. In the Service Console, expand Security Services Manager. 2. Right-click FactoryTalk Transaction Manager Configurations, and then click Register Server.
Chapter 4 Migrating RSBizWare See also • Configuring data collection (page 243) Step 31: Register the configuration in the Service Console TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer. Although you have already registered your configuration in "Step 28: Register the configuration in the RSBizWare SQL Server database (page 181)", you need to repeat the process on the Service Console level.
Migrating RSBizWare Chapter 4 The Select FactoryTalk Transaction Manager Configuration page appears. It lists your restored FactoryTalk Transaction Manager configuration in status the RSBizWare applications for which the configuration has already been registered in the RSBizWare SQL Server database. 5. Select the configuration, and then click Next.
Chapter 4 Migrating RSBizWare The following message appears: 6. Click Yes. The Completing the Wizard page appears. 7. Click Finish. Your configuration is listed in the tree under Data Collection.
Migrating RSBizWare Step 32: Configure SQL Server Reporting Services (SSRS) TIP Chapter 4 If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. To configure SQL Server Reporting Services: 1. On the Start screen, type any part of the name Reporting Services Configuration Manager, and then click its shortcut. 2. The Reporting Services Configuration Manager window and the Reporting Services Configuration Connection dialog box appear.
Chapter 4 Migrating RSBizWare 8. In the right pane of the window, under Current Report Server Database, make sure that SQL Server Name points to the local computer, and Database Name points to ReportServer. 9. Under Current Report Server Database Credential, click Change Credentials. The Report Server Database Configuration Wizard dialog box appears. 10. In the Authentication Type list, select SQL Server Account. 11. In the Username box, type sa (SQL Server System Administrator account). 12.
Migrating RSBizWare Chapter 4 If the test is successful, the following message appears: 14. Click OK, and then click Next. 15. On the Credentials page, leave the default settings. 16. Click Next. 17. On the Summary page, review the database details. 18. Click Next. 19. Wait until the database is configured, and then click Finish.
Chapter 4 Migrating RSBizWare To verify the configuration of SQL Server Reporting Services (SSRS): 1. On the Start screen, type any part of the name SQL Server Management Studio, and then click its shortcut. 2. The SQL Server Management Studio window and the Connect to Server dialog box appear. 3. In the Connect to Server dialog box, click Connect. 4. In the Object Explorer, click Connect > Reporting Services. The Connect to Server dialog box appears. 5.
Migrating RSBizWare Chapter 4 6. Click Connect. The Report Server appears in the Object Explorer. 7. Exit the SQL Server Management Studio. 8. On the Start screen, type any part of the name Reporting Services Configuration Manager, and then click its shortcut. The Reporting Services Configuration Manager window and the Reporting Services Configuration Connection dialog box appear. 9. In the Reporting Services Configuration Connection dialog box, click Connect. 10.
Chapter 4 Migrating RSBizWare The home page of the SQL Server Reporting Services appears in a web browser window. Step 34: Install and configure Report Expert TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. To install and configure Report Expert: 1. Run the RSBizWare installation DVD. The RSBizWare installation wizard appears. 2. On the Welcome page, click FactoryTalk Metrics > Installation > Install Report Expert.
Migrating RSBizWare Chapter 4 6. On the Customer Information page, type the following: 7. Click Next. 8. On the Setup Type wizard page, select: • Complete, if you want to install all the features. • Custom, if you want to install specific components. If you choose this option, the Custom Setup page appears. Select the components that you want to install and their locations on the computer. 9. Click Next. The Virtual directory information page appears.
Chapter 4 Migrating RSBizWare 12. Click Next. 13. On the Ready to Install the Program page, click Install. The Installing... page presenting the installation status appears. 14. On the InstallShield Wizard Completed page, click Finish. The Database Load and Update wizard appears. 15. On the Welcome page, click Next. 16.
Migrating RSBizWare Chapter 4 21. On the Start screen, type any part of the name Report Expert, and then click its shortcut. TIP By default, Report Expert is located in the following directory: C:\Program Files (x86)\Rockwell Software\Report Expert\RE.url The Internet Explorer window and the Windows Security dialog box appear. 22. In the Windows Security dialog box, type the user name and the password to the computer on which you have configured ODBC for RSBizWare.
Chapter 4 Migrating RSBizWare Step 35: Configure the FTMetricsEditors group TIP If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target Database server computer. In the initial configuration, Report Expert grants data editing only to those users that are identified as Report Expert Editors and are members of the default local group named FTMetricsEditors.
Migrating RSBizWare Chapter 4 To update the Report Expert configuration file: 1. Open the \Website folder, and edit the Web.config file. 2. Replace the name of the default FTMetricsEditors group with the name of the group you have created or chosen to contain Report Expert editors. For example, if the group that you use is named RptExpEditors, do the following: Replace FTMetricsEditors: ...
Chapter 4 Migrating RSBizWare • For the all-in-one installation, this will be the local computer. • For the installation on two computers, this will be the RSBizWare server computer. If you have installed and configured Report Expert successfully, the Report Expert welcome page appears. Step 37: Start your FactoryTalk Transaction Manager configuration If you are migrating the RSBizWare suite to two computers, perform the following steps on the Target RSBizWare server computer.
Migrating RSBizWare Chapter 4 2. In the User text box, type the name of the user of your RSBizWare SQL Server database. 3. In the Password text box, type the user password. 4. In the Server text box, type or select from the list the name of the computer on which you have installed the RSBizWare SQL Server database: • If your RSBizWare SQL Server database is on the computer on which you are performing these steps, select localhost.
Chapter 4 Migrating RSBizWare 7. Select your restored configuration, and then click Start. Once the configuration is started, its traffic lights icon changes to green. Congratulations! 204 You have successfully completed the migration of your RSBizWare environment. You are now ready to start the Configuration Console and begin to use the products.
Chapter 5 Post-installation tasks Additional settings are required to use RSBizWare properly with Microsoft Windows operating systems and Internet Explorer, which provide additional security features intended to protect your system from unknown programs and web sites. Configuring Internet Explorer To view RSBizWare reports properly with Internet Explorer, you need to add the name of the RSBizWare server to trusted sites in trusted sites Internet Explorer. To configure trusted sites: 1.
Chapter 5 Post-installation tasks The Database Load and Update Wizard appears. 2. Click Next. The Product and Database Connection page appears. 3. In the ODBC DSN list, select your ODBC data source. 4. In the User text box, type the user name of your RSBizWare database owner. 5. In the Password box, type the password of your RSBizWare database owner. 6. Click Connect. Under Available Product Modules, a list of sample data appears. 7. Select the data that you want to import. 8. Click Finish.
Chapter 6 Upgrading RSBizWare on Microsoft Windows Server 2008 R2 SP1 If your current RSBizWare environment is maintained on: • Microsoft Windows Server 2003 R2 with Service Pack 2 • Microsoft SQL Server 2005 Standard Edition with Service Pack 3 Migrate it to the latest version following the steps presented in "Migrating RSBizWare (page 109)".
Chapter 6 Upgrading RSBizWare on Microsoft Windows Server 2008 R2 SP1 Preparing for the upgrade If you are upgrading from a prior version of the FactoryTalk Metrics or FactoryTalk Historian Classic software, there are several things that you should take into consideration before you proceed with the upgrade: • It is recommended that you create a backup copy of your RSBizWare database, FactoryTalk Transaction Manager configurations, and sesame.
Upgrading RSBizWare on Microsoft Windows Server 2008 R2 SP1 Chapter 6 software products must also be upgraded to compatible versions. • For a networked automation system, upgrade the computer hosting the Network Directory Server first, and then upgrade the client computers on the network. • After installing FactoryTalk Services Platform, reinstall the software products that you plan to use in the automation system.
Chapter 6 Upgrading RSBizWare on Microsoft Windows Server 2008 R2 SP1 During the installation, the wizard backs up existing FactoryTalk Directories, configures a FactoryTalk Local Directory and a FactoryTalk Network Directory. The Configuring FactoryTalk Directory dialog box displays the names of the files to which the existing FactoryTalk Directories have been backed up and the name of the Windows folder where the backup files are written. Backup locations are also logged to FactoryTalk Diagnostics.
Chapter 7 Administering RSBizWare servers To perform the server administration tasks, you must have the Windows System Administrator privilege, and your user account must be a member of the local administrator user group. Starting and stopping RSBizWare servers NOTE In order to start or stop a remote server successfully, your Windows user account must have permission to access the remote machine with specific permission to start and stop Windows service programs.
Chapter 7 Administering RSBizWare servers The Configuration Console supports the ability to schedule reports Managing Information Services Manager scheduled to be performed at some time in the future. items To view a list of reports scheduled by the Configuration Consoles that are connected to a particular Information Services Manager: • In the Service Console, expand your Information Services Manager tree item, and then click Scheduled Items.
Administering RSBizWare servers Chapter 7 The Data Source Properties dialog box appears. 3. In the Server DSN list, select the name of the ODBC Server DSN that the server will use to access the external database. The available DSNs are the ones that exist on the computer where the Information Services Manager is running. 4. In the Description box, type a description of the external data source.
Chapter 7 Administering RSBizWare servers Client requests can share a single connection, but more than one connection may help reduce delays for multiple client requests. 8. Click Test Connection. If the connection attempt is successful, the following message appears: 9. Click OK. Now the tables and views in your external data source will be available to users when they create new report data sources.
Administering RSBizWare servers Chapter 7 General ODBC errors: Oracle-only errors: S1008 S1009 S1010 S1109 01000 37000 If the server does not recognize the error message, the server will look for a text file called dberrors.txt that may contain additional error numbers. If the server finds the text file, and the database error matches any of the entries in the text file, the server will attempt to reconnect to the database.
Chapter 7 Administering RSBizWare servers For example, if you expect the Oracle ORA-08114 and ORA-10015 errors to cause temporary database connection loss on your system, enter 8114 and 10015 in separate lines in the text file: 3. Save the text file as dberrors.txt in the directory where the RSBizWare software was installed. By default, the RSBizWare software is installed in: C:\Program Files (x86)\Rockwell Software\RSBizWare.
Administering RSBizWare servers Chapter 7 The following Metrics Server Manager-specific settings can be stored in the file: Value name (units) Default Description value Location in pre-RSBizWare 9.0 software LogLocation ServerCalls (On or Off) On The LogLocation registry value, with bit 1 set in the hexadecimal bitmask.
Chapter 7 Administering RSBizWare servers Value name (units) Default Description value Location in pre-RSBizWare 9.0 software LogLocation CalcThreadFault Metrics (On or Off) Off The LogLocation registry value, with bit 200 set in the hexadecimal bitmask.
Administering RSBizWare servers Chapter 7 Value name (units) Default Description value not need to sleep. DataQueueWarning Threshold (# 500 or 5 * The number of items waiting to be of Data Queue Items) Sleep processed. When the number is reached, a warning log message is generated and the database update rate is changed to the configured warning state update rate. DataQueueError Threshold (# of 1000 or The number of items waiting to be Data Queue Items) 10 * processed.
Chapter 7 Administering RSBizWare servers Value name (units) Default Description value Location in pre-RSBizWare 9.0 software memory to process data for as many minutes as specified in the value and may release memory back to the system when more memory has been allocated to process a large influx of RSL files.
Chapter 8 Controlling access to your RSBizWare system In this chapter you will learn about the types of activations and privileges available for the RSBizWare suite. In order to assign activations, you need first to: 1. Install FactoryTalk Activation. For details, see: Step 4: Install FactoryTalk Activation (page 44) 2. Configure FactoryTalk Activation. For details, see: Step 5: Configure FactoryTalk Activation (page 45) 3. Register the RSBizWare servers.
Chapter 8 Controlling access to your RSBizWare system Activity: Performed in: Assigning server activations Service Console See "Step 17: Assign activations to RSBizWare servers (page 79)". Assigning client activations to users Service Console See "Step 18: Assign client activations to users (page 81)". Assigning application privileges to users and Service Console groups See "Step 19: Assign application privileges to users (page 82)". Assigning default object permissions to Service Console.
Controlling access to your RSBizWare system Chapter 8 A workcell is counted against the license when it is enabled in the Configuration Console. After your server reaches its workcell limit, you will not be able to enable any more workcells. The server activations include new activations for the Manual Data Editing (MDE) workcells. The licenses are required to: • Create manual workcells without using any data points during the configuration. • Create manual events that have no link with data points.
Chapter 8 Controlling access to your RSBizWare system the same Information Services Manager for a total of 75,000 reporting tags. NOTE Any FactoryTalk Historian Classic server activation will also activate a single FactoryTalk Metrics workcell. To view the total number of licensed reporting tags: 1. Open the Configuration Console. 2. On the Tools menu, click FactoryTalk Historian > Manager Time-Series Reporting Tags. The Time-Series Reporting Tags dialog box appears.
Controlling access to your RSBizWare system Chapter 8 runtime users who are permitted to login and view reports at the same time. This allows the System Administrator greater flexibility managing user activations. The following types of the RSBizWare Runtime Client activations are available: • Single-User Runtime Client activations Assign these activations to the Information Services Manager in sufficient quantity to accommodate the total number of concurrently connected Runtime users.
Chapter 8 Controlling access to your RSBizWare system Time Pattern, and many others) are individually assigned to users at the system administrator’s discretion.
Controlling access to your RSBizWare system Chapter 8 by hardware availability and network performance) to connect concurrently. This option is recommended if a large number of concurrent users is expected. • FactoryTalk Historian Classic Author activation The Author activations are single-user activations that add the ability to configure FactoryTalk Historian Classic data collection, develop custom reports, and publish them for use by runtime users.
Chapter 8 Controlling access to your RSBizWare system We have: • 30 runtime users across all shifts, 10 of which could be concurrently logged on (based on shift). • 6 authoring users across all shifts, 2 of which could be concurrently logged on (based on shift). In this scenario, a total of 36 user accounts would be configured or imported from the Windows domain, and 6 of those users would be given authoring privileges.
Controlling access to your RSBizWare system Chapter 8 Example: FactoryTalk Historian Classic activation Let’s say our factory has 100 employees running three shifts per day. Each shift has 10 individuals who need to view RSBizWare reports, and 2 individuals who configure FactoryTalk Historian Classic data collection and/or author reports. FactoryTalk Historian Classic collects, logs, and reports on 1625 tags.
Chapter 8 Controlling access to your RSBizWare system • The FactoryTalk Historian Classic Server activations and the 10 RSBizWare Runtime Client activations are assigned to the appropriate Information Services Manager. • A FactoryTalk Historian Classic Author activation is assigned to each of the 6 authoring users (2 per shift).
Controlling access to your RSBizWare system Chapter 8 The activation includes a FactoryTalk Historian Classic Server with 1500 Reporting Tag Limit activation and an RSBizWare Single-User Author Client activation. Managing FactoryTalk user groups and users User accounts are used to authenticate, and authorize or deny access to individual users in your FactoryTalk automation system. User accounts are also used to audit user activity.
Chapter 8 Controlling access to your RSBizWare system 3. Right-click the User Groups folder, and then click New > User Group. The New User Group dialog box appears. 4. In the Name box, type a name for the group. 5. In the Description box, type a description of the group. 6. Click Add.
Controlling access to your RSBizWare system Chapter 8 The Select User or Group dialog box appears. 7. Select the user accounts which you want to assign as members of the group, and then click OK. 8. In the New User Group dialog box, click OK. The new user group appears under User Groups. 9. Refresh the list of users and groups in the Service Console (page 235) to propagate the changes.
Chapter 8 Controlling access to your RSBizWare system The New Windows-Linked User Group dialog box appears. 4. Click Add. The Select Groups dialog box appears. 5. Do either of the following: • Under Enter the object names to select, type one or more names of groups, separated by semicolons, and then click Check Names to validate the names. • Click Advanced, and then search and select the groups in the Select Groups dialog box. 6. Click OK. 7. In the New Windows-Linked User Group dialog box, click OK.
Controlling access to your RSBizWare system Chapter 8 8. Refresh the list of users and groups in the Service Console (page 235) to propagate the changes. Updating the Service Console If you want group level permissions to take effect on individual users that are added to or removed from the group, refresh the Users and with users and groups Groups pane in the Service Console. changes To refresh the Users and Groups pane in the Service Console: 1. Open the Service Console. 2.
Chapter 8 Controlling access to your RSBizWare system 236 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Chapter 9 Managing user access Client activations control the functions that an individual user is permitted to perform on a specific RSBizWare server. Access to the content on that server is further restricted by assignment of application privileges and object permissions.
Chapter 9 Managing user access The Security Control dialog box appears. 6. In the Privileges tab, in the Server Type list, select the type of the server for which you want to assign privileges. 7. In the Server list, select a server of the specified server type. 8. Under Place a check..., select the check box to the left of the privilege that you want to assign to the group. 9. Click OK.
Managing user access Chapter 9 Report Object" default security for JLSmith for the "Report Object" object. There are the following types of permissions available: • Filter permissions • Report permissions • Report data source permissions • Report object permissions (page 240) Filter permissions There are the following filter permissions: Item Description Delete Filter Allows the selected users or groups to delete the filter. Author Licenses only.
Chapter 9 Managing user access Report data source permissions Permissions Description View Report Allows the selected users or groups to view the report. For the user or group to be able to view the report, you must make sure that the permissions for the report data sources, report objects, and filters (optional) used on this report are also set for the selected user or group.
Managing user access Permission Description Edit Report Object Security Allows the selected users or groups to grant security permissions for the report object to other users or groups. Author licenses only. Allows the selected users or groups to view the report object. The report object will be available for use by the selected users or groups. View Report Object Granting default object permissions Chapter 9 To grant permissions: 1.
Chapter 9 Managing user access 5. Select the check boxes to the left of the default permissions that you want to grant to the user. 6. Repeat the steps for other users (the Users tab), users groups (the Groups tab), and the general access (the Everyone tab). 7. Click Save.
Chapter 10 Configuring data collection The basic configuration of the data collection was already discussed in the following sections: • "Step 20: Register FactoryTalk Transaction Manager (page 85)" • "Step 21: Define FactoryTalk Transaction Manager configurations (page 87)" • "Step 22: Register FactoryTalk Transaction Manager configurations (page 91)" In this chapter you will learn about: • "Types of control connectors for the data collection (page 243)" • "Types of enterprise connectors for the data coll
Chapter 10 Configuring data collection You can use the following types of control connectors: Item Description Dynamic Data Exchange (DDE) The DDE control connector service is provided for legacy connections to DDE servers or to provide functionality that is not supported by the OPC specification.
Configuring data collection Chapter 10 Item Description Microsoft OLE DB The Microsoft OLE DB enterprise database connector should only be used for interfacing with Microsoft SQL Server. Microsoft OLE DB allows you to browse an SQL Server database without a data source name (DSN) and is the preferred method of connection. The Microsoft COM+ enterprise application connector allows you to interface with Microsoft COM+ application components.
Chapter 10 Configuring data collection To unregister a FactoryTalk Transaction Manager configuration: 1. Open the Service Console. 2. Expand Security Services Manager > Servers > Information Services Manager > Data Collection. 3. Right-click the FactoryTalk Transaction Manager configuration, and then click Stop Configuration. 4. Wait until the configuration is stopped. The traffic light icon next to the configuration changes to . 5.
Configuring data collection Chapter 10 9. Click Next. If you are unregistering a configuration from FactoryTalk Historian Classic, the Historical Data dialog box appears. 10. Do either of the following: • Leave the Delete all historical data... check box cleared, if you do not want to delete the data. Your users will still be able to report on the data. This is the default setting. • Select the Delete all historical data...
Chapter 10 Configuring data collection 12. Click Finish. Starting and stopping FactoryTalk Transaction Manager configurations At this point, there are no FactoryTalk Transaction Manager transactions in the configuration. FactoryTalk Transaction Manager transactions are created when users define time-series data collection (FactoryTalk Historian Classic) or performance parameters (FactoryTalk Metrics).
Configuring data collection Chapter 10 3. Right-click your configuration, and then click Stop Configuration. The traffic light icon next to the configuration changes to TIP Troubleshooting . For more information on traffic light icons, see "Starting and stopping RSBizWare servers (page 211)" You can view the transaction statistics of a running configuration, which are useful for determining the source of problems when they occur. To view the transaction statistics: 1. Open the Service Console. 2.
Chapter 10 Configuring data collection This item: Displays: DB Passed DB Failed DB Pending 250 The number of transactions that have been successfully inserted into the database or handed to the Metrics Server Manager. The number of transactions that have not been inserted into the database or handed to the Metrics Server Manager as a result of a database error. The number of transactions that are waiting to be inserted into the database or handed to the Metrics Server Manager.
Chapter 11 Reporting diagnostic messages When an RSBizWare service is running, it generates diagnostic reporting messages that are useful for determining the source of problems when they arise.
Chapter 11 Reporting diagnostic messages Ways of logging diagnostic messages You can log diagnostic messages using: • Log files Choose this method, if you want the diagnostic messages to be written directly to a text file. • Microsoft Event Viewer Choose this method, if you want the diagnostic messages to be sent to the Windows Log, and viewed in the Event Viewer on the server computer. • E-mail Choose this method, if you want the diagnostic messages to be sent via e-mail.
Reporting diagnostic messages Chapter 11 4. In the Log File Source list, select the name of the server or configuration for which you want to configure the log file. 5. In the Location box, either leave the default location of the file or choose another location. 6. In the Number of Messages, Max File Size, and Buffer Size boxes, either leave the default values, or change them.
Chapter 11 Reporting diagnostic messages Buffer Size of zero will turn off all buffering so that diagnostic messages are written as events occur. 7. In the Number of log file revisions to keep box, type the number of revisions of the log file that you want to store for diagnostic purposes. Keep the following in mind: • If you specify a number greater than zero, the server will create a new log file each time it is started, up to the number of revisions specified.
Reporting diagnostic messages Chapter 11 Viewing diagnostic logs To view diagnostic logs of a server: 1. Open the Service Console. 2. Expand Security Services Manager > Servers. 3. Click the server for which you want to view the log file. 4. In the right pane of the window, click View Log. To view diagnostic logs of a configuration: 1. Open the Service Console. 2. Expand Security Services Manager > FactoryTalk Transaction Manager Configurations > FactoryTalk Transaction Manager. 3.
Chapter 11 Reporting diagnostic messages 256 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Appendix A Advanced topics In this chapter you will learn about the following: • Remote connection to an RSBizWare server (page 257) • Registering the Excel Add-in (page 258) Remote connection to an RSBizWare server RSBizWare clients connect to RSBizWare servers over a TCP/IP socket connection, using the IP address and the port number of the RSBizWare server machine.
Appendix A Advanced topics changed through the Server Settings for the Information Services Manager in the Service Console. Registering the Excel Add-in NOTE Oracle 9.2.0.1.0 uses port 8080. If you are using this version of Oracle, you must set the HTTP port to something other than 8080. TIP For information on using the Excel Add-in, see the FactoryTalk Metrics User Guide and the FactoryTalk Historian Classic User Guide.
Advanced topics Appendix A The following message appears: 6. Click OK.
Appendix A 260 Advanced topics Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Appendix B Database tips In this chapter you will learn about the following: • Maintaining frequently used RSBizWare tables and indexes (page 261) • Using Oracle with RSBizWare (page 262) Maintaining frequently used There are certain RSBizWare database objects - tables and indexes that are frequently used by RSBizWare database views. The database RSBizWare tables and views are, in turn, used by most RSBizWare reports.
Appendix B Database tips The following table lists the frequently used RSBizWare tables and indexes, as well as the RSBizWare components that use them.
Database tips Recommended database settings Appendix B In this section you will learn about the following: • Creating tablespaces (page 263) • Configuring the database user (page 263) • Creating a Net Configuration connection (page 264) • Configuring the Oracle ODBC data source (page 265) Creating tablespaces The tablespaces for the RSBizWare installation should contain: • Data • Index • Temp • Rollback segments The RSBizWare data model will be loaded into the default tablespace of the user initializin
Appendix B Database tips • Synonyms • Tables • Triggers • Views The user should also be configured to use the following tablespaces: • Data. Default tablespace, quota unlimited. • Index. Quota unlimited. • Temp. Temporary tablespace. Creating a Net Configuration A Net Configuration connection is needed in order for processes, such as the Information Services Manager, to connect to the connection database.
Database tips Appendix B Configuring the Oracle ODBC RSBizWare services connect to Oracle using ODBC. Use the ODBC Data Source Administrator to create a new ODBC data source connection. To create a new ODBC connection to Oracle: 1. Open Data Sources (ODBC) from the Administrative Tools. The ODBC Data Source Administrator dialog box appears. 2. Click the System DSN tab. 3. Click Add. The Create New Database Source dialog box appears. 4. Select the Oracle ODBC Driver. 5.
Appendix B Database tips • Change the % Increase to 10. • Turn the Auto Extend ON. • Change Initial to 1024 (KB). • Check the Unlimited box. • ROLLBACK Tablespace: • Change the Size to 100 MB. • Turn Auto Extend ON. • Check the Unlimited box. • INDEX Tablespace: • Change the Size to 200 MB. • Change the % Increase to 10. • Turn the Auto Extend ON. • Check the Unlimited box. • TEMPORARY Tablespace: • Change the Size to 250 MB. • Change the % Increase to 10. • Turn Auto Extend ON.
Database tips Preparing to run the Oracle database Appendix B After you configured the tablespaces and the init.ora file, you can complete the configuration of your Oracle database. Do the following: 1. Restart the Oracle service for your database. For details, refer to your Oracle documentation. 2. Create a Net Configuration connection. For details, see "Creating a Net Configuration connection (page 264)". 3. Create the Oracle ODBC data source.
Appendix B 268 Database tips Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Appendix C Data compression The Time-series Data Compression Enterprise Connector stores time-series data in a predefined compressed format in either an Oracle or a Microsoft SQL Server database. The compressed data point records contain binary data that can only be viewed through the FactoryTalk Historian Classic application.
Appendix C Data compression Aside from the maintenance considerations involved in these two options, the ultimate result is that the logged data may have to be taken "offline", and may no longer be readily available to users who wish to view and/or report on it. This tends to make the archiving option undesirable. The Time-series Data Compression Enterprise Connector conserves disk space by storing the data in a compressed format.
Data compression Appendix C and compressed into a block of data that is then inserted into the database as a single record. The following user-readable summary information is included with the block of data: • An internal data point identifier. • The time range covered by the compressed data. • The maximum and minimum data point samples that were collected. • The number of data point samples that make up the compressed record. • The number of samples (if any) collected with bad OPC quality.
Appendix C Data compression range and options selected, the chart will display either individual values for the collected data point obtained by uncompressing the block, or the summary information from the compressed block. Additionally, the Information Services Manager utilizes a powerful sampling algorithm, which may be invoked if a large time span is selected for the chart. Compressed data can also be viewed through the Uncompress view, available only in the SQL Server RSBizWare database.
Data compression Appendix C The Select Users or Roles dialog box appears. 7. Under Enter the object names to select, type public, and then click Check Names. 8. Click OK. The name appears under Users or roles. 9. Under Permissions for public, select the Grant check box for the Execute permission. 10. Click OK. 11. Repeat the steps for the other stored procedures.
Appendix C Data compression worktables for the current Query Analyzer session, use the following stored procedures: Use this stored procedure: To clear: spClearUncompressTimeRange The time range from the worktable that is created by the spSetUncompressTimeRange stored procedure. The reporting tag name from the worktable that is created by the spSetUncompressReportingTag stored procedure.
Data compression Appendix C If the data cannot reach the database server, the Data Compression service caches its data on the local hard disk until the database becomes available. When the database becomes available again, the data is automatically sent to the database and the cache files are purged. If you view the Windows Task Manager or Service Control Panel, you may notice the Data Compression service running even though your FactoryTalk Transaction Manager configuration is stopped.
Appendix C 276 Data compression Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Appendix D Application notes for FactoryTalk Transaction Manager In this chapter you will learn about the following: • Setting the real-time clock in a ControlLogix processor using FactoryTalk Transaction Manager (page 278) • Getting date/time information from a ControlLogix processor to a database (page 281) • Special considerations for a distributed Microsoft COM+ application (page 283) • Enabling network COM+ access for COM+ connectors in FactoryTalk Transaction Manager (page 284) • Configuring the Ora
Appendix D Application notes for FactoryTalk Transaction Manager • Considerations for copying and pasting FactoryTalk data points (page 294) • Windows Event Viewer tips (page 296) • Running RSLinx Classic as a service (page 296) • Data block support (page 297) • Sybase values (page 303) • Int64 Signed/Unsigned in the Expression Editor (page 303) • Int64 Signed/Unsigned as an output parameter in a stored procedure (page 303) • Substituting values for a data point (page 304) • Verifying BigInt data types af
Application notes for FactoryTalk Transaction Manager Appendix D For more information and sample files, go to the Rockwell Automation Knowledgebase Web site (http://www.rockwellautomation.com/support/) and search for ID 23299. In the processor In the processor, define the following: • A 16-bit integer (for example, Result). • An array of 7, 32-bit integers (for example, Current). • An array of 7, 32-bit integers (for example, New). • Ladder logic to set the processor's wall-clock time when Result.
Appendix D Application notes for FactoryTalk Transaction Manager DECLARE @system_time as datetime, @difference as int, @tbin0 AS VARBINARY(4), @tbin1 AS VARBINARY(4), @tbin2 AS VARBINARY(4), @tbin3 AS VARBINARY(4), @tbin4 AS VARBINARY(4), @tbin5 AS VARBINARY(4) /* check current time */ SELECT @system_time = GETDATE(); /* Uncomment this section and create the ControllerTimeDiff table if you wish to log the difference */ /* SELECT @difference = DATEDIFF(second,@control_time_in,@system_time); INSERT INTO [db
Application notes for FactoryTalk Transaction Manager Appendix D GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO In FactoryTalk Transaction Manager In FactoryTalk Transaction Manager, configure: • A scheduled or device-scheduled data point defined as a signed short, pointing to the result tag. • A scheduled or device-scheduled data point defined as PLC TimeStamp, pointing to Current[0],L6 with the size of 6 elements.
Appendix D Application notes for FactoryTalk Transaction Manager Get system value Attribute name: Dest DateTime SystemTimeDINT[0] 4.
Application notes for FactoryTalk Transaction Manager Appendix D 2. Using the RSLinx Data Points dialog box, define the following: Item Description Item Address Datapoint Name SystemTimeINT[0],L6 Either type in a unique name or let the system name the point for you automatically. Use Default or the specific topic you have defined in RSLinx PLC Timestamp 6 Topic Data Type Elements 3.
Appendix D Application notes for FactoryTalk Transaction Manager "Enabling network COM+ access for COM+ connectors in FactoryTalk Transaction Manager (page 284)". Enabling network COM+ access for COM+ connectors in FactoryTalk Transaction Manager COM+ network access is disabled by default on Windows 2003 Server Standard Edition Server platforms. On these platforms, COM+ can be used only locally by default. To enable the network COM+ access for COM+ connectors in FactoryTalk Transaction Manager: 1.
Application notes for FactoryTalk Transaction Manager Appendix D 7. Click Start > Run, type regedit, and then press Enter. The Registry Editor appears. 8. Navigate to the following folder: My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\O RACLE 9. Right-click the folder, and then click New > String Value. In the right pane of the window, a New Value #1 appears, available for editing. 10. Rename the value to Oracle_Home. 11. Double-click the value. The Edit String dialog box appears. 12.
Appendix D Application notes for FactoryTalk Transaction Manager 3. In the Configuration List name, select the name of your configuration. 4. Under Define Configuration, click Step 4. The Data Object Definition dialog box appears. 5. Next to the Database Connection box, click . The Database Connection Definition dialog box appears. 6. In the User Name box, type the name of the RSBizWare SQL Server database user. 7. In the Password box, type the password for the RSBizWare SQL Server database user. 8.
Application notes for FactoryTalk Transaction Manager Appendix D 7. In the Object Explorer tree, expand Databases > > Security. 8. Right-click Users, and then click New Database User. The Database User - New dialog box appears. 9. In the User name box, type a name for the user. 10. Next to the Login name option, click . The Select Login dialog box appears. 11. Select the login that you created in steps 3-6. 12. Click OK. 13.
Appendix D Application notes for FactoryTalk Transaction Manager 3. To the Administrators group, add the same user that you added in "Configuring the Windows-only authentication (page 286)". 4. Go to Start > Administrative Tools > Local Security Policy. The Local Security Settings dialog box appears. 5. Expand Security Settings > Local Policies > User Rights Assignment. 6. In the right pane of the window, find and double-click Log on as a service. The Log on as a service Properties dialog box appears. 7.
Application notes for FactoryTalk Transaction Manager Appendix D The Database Connection Definition dialog box appears. 18. Make sure that the user and password boxes are blank.
Appendix D Application notes for FactoryTalk Transaction Manager If you select this option: And the device is off at startup, then the transaction: And the device is on at startup, then the transaction: Substitute Previous Value Fails because a previous value for substitution did not exist. For corrective action information, see the possible solution section for error 33175. Uses the bad quality value provided by the data server. Uses the substitution for bad quality value provided by the data server.
Application notes for FactoryTalk Transaction Manager Appendix D To resolve an IP address in a Windows Workgroup: If you are working in a Windows Workgroup, perform the following steps: 1. Go to \Systems32\Drivers\Etc. 2. Open the Hosts file in a text editor. 3. Type a host to ID mapping for each computer that is running FactoryTalk Transaction Manager. 4. Save the file. 5. At the command prompt, type: ping For example: ping FactoryTalk Transaction ManagerServerA 6.
Appendix D Application notes for FactoryTalk Transaction Manager If it does not work, remove the old server manually: 1. In the Registry Editor, find HKLM\Software\Rockwell Software\RSSql\Configuration Servers\. 2. Delete the folder with the old computer name. 3. Restart FactoryTalk Transaction Manager Starting and stopping FactoryTalk Transaction Manager services manually In some instances, it may be necessary to manually start or stop FactoryTalk Transaction Manager services from a DOS command prompt.
Application notes for FactoryTalk Transaction Manager Appendix D net start rssql_cfg_server Additionally, if you want to stop the FactoryTalk Transaction Manager service in the FactoryTalk Transaction Manager from a DOS command prompt, type the following: net stop rssql_tb Considerations for distributed configurations You can distribute FactoryTalk Transaction Manager control and enterprise connectors among several computers.
Appendix D Application notes for FactoryTalk Transaction Manager browse that computer's OCI connections, ODBC DSNs, and most files. The only files that FactoryTalk Transaction Manager does not browse remotely are DDE and RSLinx Classic connector tag files. • FactoryTalk Transaction Manager cannot query remote DDE servers to retrieve configured DDE topic information (excluding the RSLinx Classic OPC or RSView32 control connectors).
Application notes for FactoryTalk Transaction Manager Appendix D • You cannot copy individual cells. If you attempt to copy an individual cell, the entire row (all columns, including internally hidden columns) will be copied. • You cannot copy items when a configuration is running or if the configuration has pending edits. Pasting Consider the following rules when pasting FactoryTalk data points: • You must use Ctrl+V. • You can paste FactoryTalk data points in/from Microsoft Excel.
Appendix D Application notes for FactoryTalk Transaction Manager If these conditions are not met, the paste operation is terminated. • You cannot perform a paste when a configuration is running or if the configuration has pending edits. Windows Event Viewer tips FactoryTalk Transaction Manager supports sending error messages to the Windows Event Viewer.
Application notes for FactoryTalk Transaction Manager Appendix D If you do not run RSLinx Classic as a Windows 2012/2008/2003 service while you are configuring RSLinx Classic from a remote location, the following error message appears. To setup RSLinx Classic to run as a service: 1. Go to Start > Program Files > Rockwell Software > RSLinx > RSLinx Classic Launch Control Panel. The RSLinx Classic Launch Control Panel dialog box appears. 2.
Appendix D Application notes for FactoryTalk Transaction Manager N7:0,L100 (a block of 100 integers from N7:0 to N7:99) and pass this value to the stored procedure as outlined below. This stored procedure uses a table created with the CREATE TABLE testerout(run INT,my_val INT) command. NOTE The stored procedures only accept positive integers from 0 to 32,767.
Application notes for FactoryTalk Transaction Manager Appendix D SELECT @loop = @loop + 2 END --GREAT BIG WHILE LOOP END-- proc FactoryTalk Transaction Manager can write to a controller a data Sending data blocks from multiple rows in a table using block consisting of integers selected from multiple rows of a table.
Appendix D Application notes for FactoryTalk Transaction Manager INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INTO INTO INTO INTO INTO INTO INTO INTO INTO my_next_int_table my_next_int_table my_next_int_table my_next_int_table my_next_int_table my_next_int_table my_next_int_table my_next_int_table my_next_int_table values values values values values values values values values (8001,8002,8003,8004,4) (5001,8002,8003,8004,4) (4001,8002,8003,8004,4) (8001,8002,8003,8004,4) (8001,8002,8
Application notes for FactoryTalk Transaction Manager Appendix D -- uninitialized. Intializing it will alter the end value of the binary string.
Appendix D Application notes for FactoryTalk Transaction Manager INSERT INTO my_int_table values (31,32,33,34) INSERT INTO my_int_table values (41,42,43,44) INSERT INTO my_int_table values (5001,5002,5003,5004) INSERT INTO my_int_table values (6001,6002,6003,6004) INSERT INTO my_int_table values (7001,7002,7003,7004) INSERT INTO my_int_table values (8001,8002,8003,8004) INSERT INTO my_int_table values (9001,9002,9003,9004) INSERT INTO my_int_table values (10001,10002,10003,10004) CREATE PROCEDURE chunk_ma
Application notes for FactoryTalk Transaction Manager Appendix D Sybase values An application error occurs upon configuration startup when you attempt to connect to a Sybase back end. This error occurs because the system environment variable for Sybase is missing or invalid. Usually the ODBC driver installation sets the path and variables. However, if the drivers were installed as a user account other than administrator, the variables are not set.
Appendix D Application notes for FactoryTalk Transaction Manager • For the Int64 Signed data point types in a decimal format, the range is between -9,223,372,036,854,775,807 and 9,223,372,036,854,775,807. • For the Int64 Unsigned data point type in a decimal format, the range is between 0 and 18,446,744,073,709,551,615.
Application notes for FactoryTalk Transaction Manager Appendix D 3. Find My Computer\HKEY_CURRENT_USER\Software\Rockwel l Software\RSSql\Window State. 4. Do the following: Miscellaneous To reset the settings for: Do: The Step 3 dialog box of the Checklist. The Step 5 dialog box of the Checklist. The main window of FactoryTalk Transaction Manager. All dialog boxes in FactoryTalk Transaction Manager. Open the Windows State folder, and then delete the DlgRna key.
Appendix D 306 Application notes for FactoryTalk Transaction Manager Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014
Index A Administering RSBizWare servers 211 Advanced topics 257 Application notes for FactoryTalk Transaction Manager 277 Assigning application privileges to groups 237 Assigning object permissions to users and groups 238 B Behaviors when setting substitution options for FactoryTalk data points 289 Benefits of using the data compression 269 C Clean installation supported installation scenarios 22 Client activations for FactoryTalk Historian Classic 226 Client activations for FactoryTalk Metrics 224 Compr
Index FactoryTalk Historian and FactoryTalk Metrics privileges 84, 178 FactoryTalk Historian for Batch activation options 230 FactoryTalk Transaction Manager 17 FactoryTalk Transaction Manager Configuration Server 17 Filter permissions 239 G Getting date/time information from a ControlLogix processor to a database 281 Granting default object permissions 241 H Handling temporary database connection loss in the Information Services Manager 214 Hardware and software requirements 19 How the data compression
Index Removing RSBizWare 107 Repair the connection to SQL Server 57, 154 Report data source permissions 240 Report object permissions 240 Report permissions 239 Report Schedule Manager 16 Reporting diagnostic messages 251 Resolving IP address to host name issues 290 Restoring default dialog box sizes 304 Rockwell Automation Support 312 RSBizWare databases (SQL Server or Oracle) 15 RSBizWare prerequisites 19 RSBizWare product dependencies 19 Running RSBizWare in a distributed environment 19 Running RSLinx C
Index Recreate your users 162 Step 2 Back up your RSBizWare SQL Server database 118 Install SQL Server 2012 Service Pack 1 32 Step 20 Install RSBizWare 164 Register FactoryTalk Transaction Manager 85 Step 21 Define FactoryTalk Transaction Manager configurations 87 Register the Security Services Manager 166 Step 22 Register FactoryTalk Transaction Manager configurations 91 Register the Information Services Manager 167 Step 23 Associate Metrics Server Manager with Information Services Manager 171 Configure S
Index Step 9 Install FactoryTalk Activation 139 Install SQL Server 2012 Native Client 51 Substituting values for a data point 304 Sybase values 303 T The Metrics Server Manager settings file 216 The RSBizWare architecture 12 Troubleshooting 249 Tuning the Oracle database for FactoryTalk Historian Classic 265 Types of control connectors for the data collection 243 Types of diagnostic messages 251 Types of enterprise connectors for the data collection 244 U Unregistering FactoryTalk Transaction Manager con
Rockwell Automation Support Rockwell Automation provides technical information on the Web to assist you in using its products. At http://www.rockwellautomation.com/support/ you can find technical and application notes, sample code, and links to software service packs. You can also visit our Support Center at https://rockwellautomation.custhelp.com/ for software updates, support chats and forums, technical information, FAQs, and to sign up for product notification updates.
