Advanced Search
Search Results
725 total results found
Encrypting EC2 Cloud Configuration Files using API Calls
Controller Page (Knowledge Base Articles)
Contents Unable to view test execution details after the test is complete This section contains a collection of articles from the Appvance Knowledge Base. ...
Unable to view test execution details after the test is complete
When the scenario is executed successfully and user selects "Test Case executions" from the dropdown and tries to view each of the executed test cases the user will not be able to view the details and if we check the console we will see a 500 response request....
Databases - MySQL Knowledge Base Articles
Databases - MySQL Knowledge Base Articles This page should be used as an index for AIQ MySQL database knowledge base content. Keep it focused on database maintenance, troubleshooting, upgrades, backups, retention, and safe operational procedures. Recommended i...
Exception: "org.appvance.hibernate.exception.GenericJDBCException: Cannot open connection"
Exception may appear in error logs within a controller while executing a Database Scenario This topic assumes you are capable of creating sql scripts in MYSQL or other similar, as well as capable of creating Scenari...
How to drop a schema/database from mysql in Linux (ubuntu) machine?
Open mysql using myql -u root -p command. #To see the list of databases run below command show databa...
How to upgrade MySQL database ?
For upgrading MySQL from 5.6 to 5.7 version: ** Windows OS only ** Backup the APC database instance using workbench or through command-line steps. ...
Installing sqlplus to connect to RDS and run queries
Download Tools Go to: (win x64) http://www.oracle.com/technetwork/topics/winx64soft-089540.html Go to: (win x86) http://www.oracle.com/technetwork/topics/winsoft-085727.h...
MySQL performance improvement
MySQL 5.7 and 5.6 performance improvement By Default MySQL performs a flush operation per commit which is inoffensive on not demanding environments but on medium and high demanding environment, it could induce to I/...
MYSQL: Drop Schema is taking way too long to drop the schema.
Solution: Stop mysql service. goto task manager > Go to services tab > look for MYSQL. Right click the service an...
Precedence of MySQL credentials in Appvance IQ
There are 3 different ways a user can provide the MySQL credentials in Appvance IQ. 1. Scenario Builder - Options Panel - Database logging. 2. Options Page - Pref...
Question on SQL Testing in Appvance IQ
Is there a way to check in Appvance IQ that load is actually simulated on the DB under test . Something like graphs which shows activity during the test on the DB with which we can confirm that requests are actually fired? ...
Response times in SQL Reports.
There are 2 entries in the report for response times, can you highlight the line which we are suppose to interpret as response time for query execution? The first line is the step time, it includes the request t...
Troubleshooting MySQL
Packet for query is too large Please change max_allowed_packet=1024M in my.init. For more information MySQL performance improvement ...
Unable to connect to database - Password expired
My local machine's SQL password got expired and I did change it from Workbench, but AIQ still thinks that it is not changed, I tried restarting both AIQ and MYSQL services, but no luck. ...
Windows: Unable to connect database when Running a test in a different location
If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked. To allow a SQL Server to communicate through Windows Firewall, please follow the below steps. ...
Manually Remove AIQ Executions from MySQL - Controlled Procedure
High-risk maintenance guidance Manually removing executions from the AIQ database is a high-risk maintenance action. Use supported product cleanup features first. Direct database changes should only be performed with backups, approval, and support guidance. Be...
Stacktrace com.mysql.jdbc.PacketTooBigException: Packet for query is too large
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (6862323 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3671) at com.mysql.jdbc.Mysql...