Viewing Results from a Previous Test Run

AIQ stores the results of every test, every step, and every failure to a Results Repository (normally MySQL or Oracle RDBMS) as it operates the test. View results from the previous test run using the Analyze buttons from the Start Screen. Results Analysis Reports display the results in a browser-based Web page by making live requests to the Results Repository.

AIQ keeps the results by execution. Each time you click the Play button in a Controller, or a Continuous Integration environment like Hudson, Jenkins, or Bamboo, execute a test AIQ stores a new execution.

Choose an execution, click the Analyze button, and a new browser window appears displaying the list of Reports for the chosen execution.

Printing Reports and Charts

AIQ presents the results in a set of Web pages. Use your browser's Print command to print reports.

Configuration

AIQ uses a relational database (RDBMS) for its Repository. AIQ logs every test operation, test step, and monitored resource to the Repository. AIQ MySQL and Oracle. Contact IQ Global Services for support of IBM DB2 and Microsoft SQL Server. For information, see Repository configuration in Appvance IQ.

AIQ builds its own database schema to store the logs. The DB contains a catalog of scenarios (scenario, use-cases, and steps) and tables to store the results of executions (executions, transactions results, steps times). Use the Global Options link from the Start Screen, Navigate to the Preferences tab, Click Results under Preferences - Download SQL - to receive a copy of the schema.

Database administrators use the Download SQL button to populate a database with the AIQ tables. For example, for MySQL users, after creating a user account and granting ALL privileges to the user, enter the Username, Password, URL (in the format of jdbc:mysql://localhost:3306/aiq,) and choose the database type. Make sure the URL does not include the AIQ database path. Click Result Schema. View the Output panel for any error messages. Then add the utp name to the URL (jdbc:mysql://localhost:3306/aiq) and click Accept.

MySQL database administrators who run MySQL in Unix and Macintosh operating environments must start the database with the --lower_case_table_names=1 option. Without this option, the Results Analysis Engine encounters SQL syntax errors when MySQL processes AIQ's reports-related queries.

You must also change your Test-scenario to log to the correct repository. Use the Options tab in the Scenario Builder to change the repository location.