Home
Rational® Integration Tester
Tester Guide
This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing.
Technical Tester Guide
Typically, a user with the Integration Tester role is also responsible for performance testing. This guide lists all such topics.
Creating and running performance tests
This topic describes how to create, configure, and run performance tests.
Troubleshooting: Running a performance test with a MySQL database
You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.

Rational® Integration Tester
- Release Notes
  This document contains information about What's new, installation, known issues, and contact information of IBM Support.
- System Requirements
  This document includes information about hardware and software requirements for HCL OneTest™ API.
- Getting Started
  This guide provides an overview and describes the tasks to get you started with HCL OneTest™ API.
- Administrator Guide
  This guide describes how to install HCL OneTest™ API. After you install the software, you can perform administration tasks such as configuration and integration of the product. This guide is intended for administrators.
- Tester Guide
  This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing.
  - Integration Tester Reference
    This guide provides the topics to help the Integration tester use the product by using the user interface, commands or scripts. This guide is intended for Integration testers.
  - Technical Tester Guide
    Typically, a user with the Integration Tester role is also responsible for performance testing. This guide lists all such topics.
    - Creating and running performance tests
      This topic describes how to create, configure, and run performance tests.
      - Before creating performance tests
        Agents (HCL OneTest™ API Agent) are required on the computers that will run HCL OneTest API tests and the probes that monitor the systems.
      - Creating performance tests
        A performance test is created within a HCL OneTest™ API project.
      - Performance tests
        Performance tests are executed in HCL OneTest™ API in the same way and from the same perspectives as any other test resource.
      - Troubleshooting: Running a performance test with a MySQL database
        You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.
    - View test results
      This topic describes how to work with __PTS_RR_NAME__ charts in the Results Gallery perspective.
    - Deploying probes
      A HCL OneTest™ API probe measures variables from a particular component in the system and reports back its findings for processing and storage.
  - Integration Tester Guide (Service Virtualization)
    This guide describes the tasks that you can perform for using virtual services or stubs to simulate parts of an environment if the real services are not yet available or because they are difficult or expensive to use. This guide is intended for Integration Testers.
- Test Manager Guide
  This guide describes the tasks that you can perform for tracking the quality of the application. This guide is intended for Test Managers.
- Troubleshooting HCL OneTest™ API
  While working with HCL OneTest™ API, you might encounter some problems that you can easily troubleshoot.
- HCL OneTest™ API reference
  HCL OneTest™ API is a scripting-free environment for developing tests for service-oriented architecture (SOA) messaging and business process integration projects. Tests can be built by recording existing system behaviors or from requirements, by entering the data to send and the data that is expected in return.
- Security Considerations
  You can take certain actions to ensure that your installation is secure, customize your security settings, and set up user access controls.
- Notices
  This document provides information about copyright, trademarks, terms and conditions for product documentation.

Troubleshooting: Running a performance test with a MySQL database

You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.

About this task

If you are using MySQL version 5.7 or later, the SQL mode ONLY_FULL_GROUP_BY is enabled by default. This mode must be removed, otherwise, when you run a performance test from HCL OneTest™ API with a MySQL database, an error is reported for the GROUP BY clause.

To remove this mode, follow these steps:

Procedure

For Windows or Linux follow these steps:
1. Edit the MySQL configuration file my.ini on Windows or my.cnf on Linux. Set the sql_mode parameter from a command line in one of two ways:
```
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
  
```
```
sql_mode=""
```
2. Restart the MySQL server.

For Ubuntu follow these steps:

Create the following file:

/etc/mysql/conf.d/disable_strict_mode.cnf

Edit the file. Copy and paste the following command into the disable_strict_mode.cnf file to set the sql_mode parameter:

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart the MySQL server.
```
sudo service mysql restart
```

Check that the mode was removed:

mysql> select @@sql_mode

The result shows you the following:

STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION