MTS RPC Reference Manual



be certain.

RPC® Data Manager Software Reference

100-172-934 D

Tradema rk in for m ation MTS, RPC, and Component RPC are registered trademarks and cRPC, eTIM,

SWIFT, MAST, and Remote Parameter Control are trademarks of MTS Systems Corporation within the United States. These trademarks may be protected in other coun t ries.

Proprietary information Software use and license is governed by MTS’s End User License Agreement

which defines all rights retained by MTS and granted to the End User. All Software is proprietary, confidential, and owned by MTS Systems Corporation and cannot be copied, reproduced, disassembled, decompiled, reverse engineered, or distributed without express written consent of MTS.

Software validation and

verification

Publication information

MTS software is developed using established quality practices in accordance with the requirements detailed in the ISO 9001 standards. Because MTSauthored software is delivered in binary format, it is not user accessible. This software will not change over time. Many releases are written to be backwards compatible, creating another form of verification.

The status and validity of MTS’s operating software is also checked during system verification and routine calibration of MTS hardware. These controlled calibration processes compare the final test results after statistical analysis against the predicted response of the calibration standards. With these established methods, MTS assures its customers that MTS products meet MTS’s exacting quality standards when initially installed and will continue to perform as intended over time.

MANUAL PART NUMBER PUBLICATION DATE

100-172-934 A April 2007 100-172-934 B May 2008 100-172-934 C May 2009 100-172-934 D February 2010

Contents

Technical Support 7

How to Get Technical Support 7

Before You Contact MTS 8

If You Contact MTS by Phone 9

Problem Submittal Form in MTS Manuals 10

Preface 11

Before You Begin 11

Documentation Conventions 11

Installation and System Settings 13

Data Manager Server PC Requirements 14

Software Product Installation 16

Install MTS Licensing Software 20

Update License File when Server Name Changes 22

Install or Upgrade to SQL Server Express 2008 23

Install RPC Data Manager Server 24

Data Manager Administrative Tasks 26

Firewall Setup for RPC License Software 27

Windows XP/Vista Firewall Setup for RPC License Software 28

Windows 7 Firewall Setup for RPC License Software 31

RPC Data Manager Software Reference

Introduction to Data Manager 33

About Data Manager 34

Archiving Projects - RPC Project Manager 35

Search, Data Retrieval, and Administration 36

About Archives 37

Keywords 38

Keyword Values 43

User Security Roles 45

RPC Data Manager Views 48

Administration Views 49

Server Selector Utility 50

Archiving a Project 57

Getting Started Archiving 58

Creating a New Archive 60

Updating an Existing Archive 67

Archiving when Disconnected from Network 75

Locating and Retrieving Archived Data 83

Archives View 84

Searching for Archived Data 89

Retrieving Archived Data 99

Deleting Archives 111

Locking and Unlocking Archives 112

Making Archives Remote or Local 114

Renaming Archives 118

Modifying Keywords in Archived Data 119

Modifying Archive Comments 124

RPC Data Manager Software Reference

Queries 127

Query Builder Window 128

Creating or Modifying a Query 134

Defining Query Expressions 136

Locking and Unlocking Queries 143

Deleting Queries 145

Administration 147

Role of the Administrator 148

Improving Security for Shared Folders 149

User Administration 152

Backup and System Management Tasks 157

Archive Management 159

Keyword Administration 164

Index 179

RPC Data Manager Software Reference

Technical Support

How to Get Technical Support

Start with your

manuals

Technical support

methods

The manuals supplied by MTS provide most of the information you need to use and maintain your equipment. If your equipment includes software, look for online help and README files that contain additional product information.

If you cannot find answers to your technical questions from these sources, you can use the Internet, e-mail, telephone, or fax to contact MTS for assistance.

MTS provides a full range of support services after your system is installed. If you have any questions about a system or product, contact Technical Support in one of the following ways.

www.mts.com The web site provides access to our technical support staff by means of an

onlineform:

www.mts.com > Contact MTS > Service & Technical Support button

E-mail RPC@mts.com

Telephone MTS Call Center 800-328-2255

Weekdays 7:00 A.M. to 5:00 P.M., Central Time

Fax 952-937-4515

Please include “Technical Support” in the subject line.

Outside the U.S. For technical support outside the United States, contact your local sales and

service office. For a list of worldwide sales and service locations and contact information, use the Global MTS link at the MTS web site:

www.mts.com > Global MTS > (choose your region in the right-hand column) > (choose the location closest to you)

RPC Data Manager Software Reference Technical Support

Before You Contact MTS

MTS can help you more efficiently if you have the following information available when you contact us for support.

Know your site

number and system

number

Know information

from prior technical

The site number contains your company number and identifies your equipment type (such as material testing or simulation). The number is typically written on a label on your equipment before the system leaves MTS. If you do not know your MTS site number, contact your sales engineer.

Example site number: 571167

When you have more than one MTS system, the system job number identifies your system. You can find your job number in your order paperwork.

Example system number: US1.42460

If you have contacted MTS about this problem before, we can recall your file based on the:

assistance

• MTS notification number

• Name of the person who helped you

Identify the problem Describe the problem and know the answers to the following questions:

• How long and how often has the problem occurred?

• Can you reproduce the problem?

• Were any hardware or software changes made to the system before the

problem started?

Know relevant

computer information

Technical Support

• What are the equipment model numbers?

• What is the controller model (if applicable)?

• What is the system configuration?

For a computer problem, have the following information available:

• Manufacturer’s name and model number

• Operating software type and service patch information

• Amount of system memory

• Amount of free space on the hard drive where the application resides

RPC Data Manager Software Reference

• Current status of hard-drive fragmentation

• Connection status to a corporate network

Know relevant

For software application problems, have the following information available:

software information

• The software application’s name, version number, build number, and (if

available) software patch number. This information can typically be found in the About selection in the Help menu.

• The names of other applications on your computer, such as:

– Anti-virus software

– Screen savers

– Keyboard enhancers

–Print spoolers

– Messaging applications

If You Contact MTS by Phone

A Call Center agent registers your call before connecting you with a technical support specialist. The agent asks you for your:

• Site number

• Name

• Company name

• Company address

• Phone number where you can be reached

If your issue has a notification number, please provide that number. A new issue will be assigned a unique notification number.

Identify system type To enable the Call Center agent to connect you with the most qualified

technical support specialist available, identify your system as one of the following types:

• Electromechanical material test system

• Hydromechanical material test system

• Vehicle test system

RPC Data Manager Software Reference Technical Support

• Vehicle component test system

• Aero test system

Be prepared to

Prepare to perform troubleshooting while on the phone:

troubleshoot

• Call from a telephone close to the system so that you can implement

suggestions made over the phone.

• Have the original operating and application software media available.

• If you are not familiar with all aspects of the equipment operation, have an

experienced user nearby to assist you.

Write down relevant

In case Technical Support must call you:

information

• Verify the notification number.

• Record the name of the person who helped you.

• Write down any specific instructions.

After you call MTS logs and tracks all calls to ensure that you receive assistance for your

problem or request. If you have questions about the status of your problem or have additional information to report, please contact Technical Support again and provide your original notification number.

Problem Submittal Form in MTS Manuals

Use the Problem Submittal Form to communicate problems with your software, hardware, manuals, or service that are not resolved to your satisfaction through the technical support process. The form includes check boxes that allow you to indicate the urgency of your problem and your expectation of an acceptable response time. We guarantee a timely response— your feedback is important to us.

Technical Support

Access the Problem Submittal Form:

• In the back of many MTS manuals (postage paid form to be mailed to

MTS)

• www.mts.com > Contact Us > Problem Submittal Form button

(electronic form to be e-mailed to MTS)

RPC Data Manager Software Reference

Preface

Before You Begin

Safety first! Before you use your MTS product or system, read and understand the Safety

manual and any other safety information provided with your system. Improper installation, operation, or maintenance can result in hazardous conditions that can cause severe personal injury or death, or damage to your equipment and specimen. Again, read and understand the safety information provided with your system before you continue. It is very important that you remain aware of hazards that apply to your system.

Other MTS manuals In addition to this manual, you may receive additional manuals in paper or

electronic form.

You may also receive an MTS System Documentation CD. It contains an electronic copy of the manuals that pertain to your test system, such as:

• Hydraulic and mechanical component manuals

• Assembly drawings

• Parts lists

• Operation manual

• Preventive maintenance manual

Controller and application software manuals are typically included on the software CD distribution disc(s).

Documentation Conventions

The following paragraphs describe some of the conventions that are used in your MTS manuals.

Hazard conventions Hazard notices may be embedded in this manual. These notices contain safety

information that is specific to the activity to be performed. Hazard notices immediately precede the step or procedure that may lead to an associated hazard. Read all hazard notices carefully and follow all directions and recommendations. Three different levels of hazard notices may appear in your manuals. Following are examples of all three levels.

RPC Data Manager Software Reference Preface

Note For general safety information, see the safety information provided

with your system.

DANGER

Danger notices indicate the presence of a hazard with a high level of risk which, if ignored, will result in death, severe personal injury, or substantial property damage.

WARNING

Warning notices indicate the presence of a hazard with a medium level of risk which, if ignored, can result in death, severe personal injury, or substantial property damage.

CAUTION

Caution notices indicate the presence of a hazard with a low level of risk which, if ignored, could cause moderate or minor personal injury or equipment damage, or could endanger test integrity.

Notes Notes provide additional information about operating your system or highlight

easily overlooked items. For example:

Special terms The first occurrence of special terms is shown in italics.

Illustrations Illustrations appear in this manual to clarify text. They are examples only and

Electronic manual

conventions

Hypertext links The electronic document has many hypertext links displayed in a blue font. All

Preface

Note Resources that are put back on the hardware lists show up at the

end of the list.

do not necessarily represent your actual system configuration, test application, or software.

This manual is available as an electronic document in the Portable Document File (PDF) format. It can be viewed on any computer that has Adobe Acrobat Reader installed.

blue words in the body text, along with all contents entries and index page numbers, are hypertext links. When you click a hypertext link, the application jumps to the corresponding topic.

RPC Data Manager Software Reference

Installation and System Settings

Contents Data Manager Server PC Requirements 14

Software Product Installation 16

Install MTS Licensing Software 20

Update License File when Server Name Changes 22

Install or Upgrade to SQL Server Express 2008 23

Install RPC Data Manager Server 24

Data Manager Administrative Tasks 26

Firewall Setup for RPC License Software 27

Windows XP/Vista Firewall Setup for RPC License Software 28

Windows 7 Firewall Setup for RPC License Software 31

RPC Data Manager Software Reference Installation and System Settings

Data Manager Server PC Requirements

Overview Before installing the Data Manager Server software, ensure the PC meets the

minimum system requirements. Ideally, the PC should meet the recommended system requirements for improved performance.

PC hardware

requirements

COMPONENT MINIMUM RECOMMENDED

Server type

Processor

RAM

Hard drive

Available disk space

Monitor

The following table lists the requirements that the PC must have in order to run the Data Manager Server software.

If the RPC Pro/Component RPC Pro software and the Data Manager Server software will be installed on the same PC, make sure the PC meets the requirements of both. Where the component requirements overlap, the Data Manager Server requirements should be used.

Single-user server Multi-user server

Intel Pentium, 1.0 GHz Intel Core Duo, 3.16 GHz

1 GB 2 GB

20 GB 50 GB (or more), RAID-5 Disk

Array

15 GB 40 GB (or more)

17 inch monitor Resolution 1024 x 768 65,536 or high colors

21 inch monitor Resolution 1280 x 1024 High or true colors

Supported operating

systems

Installation and System Settings

Data Manager Server software can run on any of the following operating systems:

• Windows XP 32 bit Professional with Service Pack 3

• Windows Vista 32 bit Business with Service Pack 2

• Windows Vista 64 bit Business with Service Pack 2

• Windows 7 32 bit Professional

• Window 7 64 bit Professional

RPC Data Manager Software Reference

Data Manager Server PC Requirements

Localization Data Manager Server software can run on a supported operating system in any

of the following language versions:

• English

• German

• French

• Japanese

RPC Data Manager Software Reference Installation and System Settings

Software Product Installation

Getting started with

the installations

MTS RPC License

Software Installation

RPC Data Manager

Server Installation

Summary

Log on to the computer using an account that has Administrator privileges.

Close all applications and place the Installation CD in its drive.

The RPC Pro/Component RPC Pro Software and MTS Licensing Software installations are on the first CD. All other product installations are on the second CD.

Install MTS Licensing Software.

Install the following components on the computer that will be used to run the RPC Data Manager Server software. RPC Data Manager Server software can operate on the same computer with the MTS RPC and Data Manager client software.

For storage and administrative reasons, you may find it best to install the RPC Data Manager Server software on a separate computer.

If Data Manager Server is installed on a computer separate from RPC Pro, you will need to install the MTS Licensing Software on both computers.

1. Install and configure SQL Server Express 2008.

2. Install RPC Data Manager Server.

Important If prompted, restart the computer at the end of each installation. When the

Installation and System Settings

3. Perform Data Manager administrative tasks.

computer is restarting, log on to Windows using the same administrator account that the software was installed under. Doing this allows the installation program to finish setting up the files. Then, start the software to verify that it is properly installed. After that, users can log on using their own account.

RPC Data Manager Software Reference

Software Product Installation

Main RPC Software

Product Installation

The first installation CD provides the following options.

Click Install Products to open the following install screen:

Click View Readme Files to access the Readme file, License Agreement, and Software Assistance form. The Readme file contains important installation information.

RPC Data Manager Software Reference Installation and System Settings

Software Product Installation

Click Contact Us to learn the best method for contacting MTS.

Click Exit to exit the installation program.

Other RPC Software

Product Installations

The second installation CD provides the following options.

Click Install Products to open the following install screen:

Installation and System Settings

RPC Data Manager Software Reference

Software Product Installation

Click Contact Us to learn the best method for contacting MTS.

Click Exit to exit the installation program.

RPC Data Manager Software Reference Installation and System Settings

Software Product Installation

Install MTS Licensing Software

Who should install Anyone who received an RPC license CD must install the MTS Licensing

Software on the appropriate computer(s). This includes customers upgrading to the latest version of RPC software, new customers or customers that have purchased advanced features.

MTS Licensing

Software overview

Client versus server

license install

Installation

instructions

MTS Licensing Software must reside on the RPC workstation(s). If the latest version of Data Manager Server software is going to be installed on a separate computer, make sure to install the MTS Licensing Software on that computer as well.

Determine whether the licensing software should be installed as a client or server.

If you have an RPC License CD that contains the license file specifically for your computer’s physical network address, your computer will be acting as a license server for itself.

If the MTS Licensing Software is installed using a license file built for another computer’s physical network address, your computer will be the license client.

1. Click MTS Licensing Software in the Install Products page.

2. Follow the instructions that are provided in the setup windows.

3. When prompted, choose to install as Client or as Server.

Installation and System Settings

RPC Data Manager Software Reference

Software Product Installation

4. Follow these steps when prompted for the location of the MTS license file:

A. Remove the RPC Installation CD, and insert the RPC License CD.

B. If you already know the drive letter for the CD, enter it in the box

(for example E:\), or click Browse and then choose the drive for the CD in the window that appears.

C. Click Next to install the MTS license.

5. Restart the computer at the end of the installation.

6. If you want to install more RPC software, insert the RPC Installation CD after the computer has restarted.

RPC Data Manager Software Reference Installation and System Settings

Software Product Installation

Update License File when Server Name Changes

License update

examples

Location of license

file

Update server name

in license file

If the name of the license server computer changes some time after the MTS license software was installed, the license file would need updating to reflect the computer name change.

• If the license server is used to serve itself, the license file would need

updating (locally) to reflect the new name of the computer.

• If the license server is used to serve other client computers, the license file

on the server and client computers would need updating to reflect the new name of the license server. If the name of the license client computer changes, the license file would not need updating.

Note If the computer’s network card has changed since the MTS license

software was installed, contact MTS.

The mts_license.dat file is typically located in the C:\MTS\License directory. The location of the license directory may vary depending on your installation.

The first line of the mts_license.dat file specifies the computer name. For example:

SERVER old-computer-name 0011550D6047

In this example, replace <old-computer-name> with the new Host name of the computer.

Installation and System Settings

After the license file is updated, restart the computer to restart the FLEXlm License Manager service.

RPC Data Manager Software Reference

Software Product Installation

Install or Upgrade to SQL Server Express 2008

Overview Data Manager Server is now supported on SQL Server Express 2008.

Data Manager Server will work with MSDE, so upgrading to SQL Server Express 2008 is not required.

Who should install New RPC Data Manager Server customers should install SQL Server Express

2008 on the computer that will have the Data Manager Server software installed.

Who can upgrade Previous RPC Data Manager Server users can upgrade MSDE to SQL Server

Express 2008 on the computer that will have the Data Manager Server software installed.

This upgrade will maintain your existing databases and bring them forward from MSDE to SQL Server Express 2008.

Instructions If you plan to use SQL Server Express 2008, it must be installed or upgraded

and configured before RPC Data Manager Server can be properly installed.

To upgrade MSDE to SQL Server Express 2008, open the MSDE to SQL Server Express 2008 Upgrade.doc file in the ..\\DataMgrSupport folder on the RPC Pro Media 2 CD, and then follow the instructions in that document.

To install SQL Server Express 2008, open the SQL Server Express 2008 Installation Instructions.doc file in the ..\\DataMgrSupport folder on the RPC Pro Media 2 CD, and then follow the instructions in that document.

RPC Data Manager Software Reference Installation and System Settings

Software Product Installation

Install RPC Data Manager Server

Who should install MTS RPC customers who plan to use Data Manager to manage, archive and

retrieve test information must install the RPC Data Manager Server software. Install the RPC Data Manager Server software on the computer that is licensed to run the software.

Installation

instructions

1. Ensure the computer meets the System Requirements.

2. New customers should install SQL Server Express 2008. Existing customers using MSDE can optionally upgrade to SQL Server Express

2008.

3. Click on RPC Data Manager Server in the Install Products page.

Follow the instructions that are provided in the setup windows.

During installation, setup looks for a previous version of Data Manager. Choose to uninstall the previous version of Data Manager if prompted by the setup. A previous version can be the Data Manager client which is installed with the RPC Pro software.

During the installation, you will be prompted to Enter SA account password. Enter the default password:

Installation and System Settings

Setup will continue to guide you through the remaining installation steps.

RPC Data Manager Software Reference

Software Product Installation

Change the “sa”

account password

Change the “sa” account password after the RPC Data Manager Server software is installed.

1. Open a DOS Command Prompt window.

2. Enter the following at the command prompt:

osql –S (local)\Datamgr –U sa –P sa

3. At the 1> prompt, enter the following to specify the new password (except, replace xxx with your new desired password):

exec sp_password @new=’xxx’, @loginame=’sa’

4. At the 2> prompt, enter the following to execute the password change:

5. Observe the “Password changed” message and new 1> prompt.

6. At the 1> prompt, enter the following to terminate the program:

quit

Important Remember the account password (record it and keep it in a

secure place). If you forget the password, you could potentially lose access to the database.

RPC Data Manager Software Reference Installation and System Settings

Data Manager Administrative Tasks

After the Data Manager client and server software are installed on the licensed computers, the person with Administrator privileges for Data Manager must complete all of the following tasks. Refer to the Data Manager documentation for more information.

Instructions 1. Add all users to a group with access privileges to shared network folders.

2. Add all users to the RPC Database and define their security role.

3. Review backup jobs that are automatically scheduled.

4. Plan and set up offline storage for historical or very large archives.

5. Define user keywords, set up restricted keyword values, define any additional product system keywords, and make sure appropriate system keywords are set as “required.”

6. Add new users to the RPC Database and define their security role.

7. Add new users to the group with access privileges to shared network folders.

Installation and System Settings

RPC Data Manager Software Reference

Firewall Setup for RPC License Software

Overview Firewall software can block licensing programs from accessing the network. As

a result, the MTS RPC Software will not be able to check out a license.

There are two types of license servers that can be affected by firewall software:

• A computer that is acting as a license server for itself

• A computer that is acting as a license server for other computers

Follow the instructions to configure Windows Firewall on the computer that is acting as the license server.

RPC Data Manager Software Reference Installation and System Settings

Firewall Setup for RPC License Software

Windows XP/Vista Firewall Setup for RPC License Software

You must be logged on as an administrator to perform these steps.

1. Open Windows Firewall control panel.

For Windows XP: Start menu > Settings > Control Panel > Windows Firewall.

Installation and System Settings

RPC Data Manager Software Reference

Firewall Setup for RPC License Software

For Windows Vista: Windows Start menu > Control Panel > Windows Firewall.

Windows Firewall can be turned on or off for different network connections.

If Windows Firewall is turned Off, the programs will not be blocked and therefore the remaining steps may be ignored. Turning Windows Firewall Off is not recommended.

2. If Windows Firewall is turned On in the General tab, ensure that exceptions are allowed.

For Windows XP: Un-check the Don’t allow exceptions box.

For Windows Vista: Un-check the Block all incoming connections box.

3. Click on the Add Program button in the Exceptions tab.

4. Click on the Browse button in the Add a Program window.

5. Browse to the C:\MTS\License directory, select lmgrd.exe, and then click Open in the Browse window.

6. Click OK in the Add a Program window.

RPC Data Manager Software Reference Installation and System Settings

Firewall Setup for RPC License Software

7. Repeat steps 3 through 6 for the mtsd.exe and mtsdmon.exe programs.

8. Ensure lmgrd.exe, mtsd.exe, and mtsdmon.exe programs are selected on the Windows Firewall Exceptions tab.

9. Click OK to save changes to the Windows Firewall.

Installation and System Settings

RPC Data Manager Software Reference

+ 154 hidden pages