Speed up linking of tests to configurations
There are only 2 ways to link a test to a configuration...either 1. select the test (or test set), open the link to items, select the configuration folder, and check each sub item (e.g. Windows8>IE, and Chrome and Firefox), repeating for each config folder. 2. select the configuration, open the link to items, specify type and folder, and individually check every item (test) in the folder. Repeat for every configuration. Even with just a few Windows environments, each with 3 or 4 different browsers, times our 2500 tests, and this is a monumental task. While we could have done it as we created tests, our focus was on creating the tests, and not linking..that was a mistake. However now, we need to make these links, yet we are looking at nearly 10,000 clicks/steps. If nothing else, in the selection of tests (or sets) drop down, add a "Select All" to check all tests in that folder. Then we would just need to repeat for each Configuration, each folder...a much more manageable task.14KViews8likes6Commentsjava.sql.SQLException : ORA-12269: client uses weak encryption/crypto-checksumming version
I am getting following error while building query (Data Connection) in ReadyAPI (3.5.1): java.sql.SQLException : ORA-12269: client uses weak encryption/crypto-checksumming version but no such error I get while executing same query on SQL Developer for the same connection. Any particular reason why this is happening and what can be done to resolve this issue?Solved7.7KViews0likes3CommentsBearer Auth Token - How to pass as header for each API resource
Hello People, I am new to Ready API and API automation in general. For our API testing (JSON), initially we have to authorize with a bearer token in SWAGGER UI. Two API resources are present /auth/login & /auth/base64 and both these return an access token and user details respectively in encrypted format. The final bearer token format is: </auth/login: accesstoken>.</auth/base64 : message> The bearer token has session time of 15 minutes after which we need to generate a new one. Could anyone please let me know resources or steps on how to set the bearer token details for every Test Case in Ready API?Solved5KViews0likes2CommentsUpload File to AWS S3 Bucket Error due to AWS Signature Problem
Currently I'm trying to upload a file to an AWS S3 Bucket but I didn't manage to get it done. Firstly I tried using the REST Request step, in which after I set the credentials for AWS Signature, as a response I get error 400 with message "XAmzContentSHA256Mismatch", so I thought that I can calculate myself the SHA256 hash for the file and set the header for that field myself, but when I do that I get 403 with "SignatureDoesNotMatch" so I gave up on REST Request step (I also tried HTTP Request step without any luck). Secondly I tried to do it using Groovy Script but with that I get "com.amazonaws.SdkClientException: Unable to execute HTTP request: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target" when calling the PutObject function for S3 object. I tried to set the keystore in both the preferences and directly in the code but the error stays the same. Just to be sure that all policies are set correctly in IAM and that I have credentials that I can use to GET/PUT files into the bucket, I created requests in Postman which works seamlessly, the problem is that I want to automate this upload.Solved4.3KViews0likes1CommentStress Test API - Ramp up settings and execution issues
Hi all, I created a Stress Test in LoadUI pro (ReadyAPI 3.3.1) for a test case which has a DataSource and 7 API methods. the datasource is an excel sheet with 70 inputs for the 7 methods. We are licenced to max 100 VU (part of our ReadyAPI suite) and I want to stress test from 1 - 100 VU where possible. How can I set the "Base VU" and the interval to increment by 5 VU's? I have included image of setup below in ReadyAPI. When I run this test it appears in our New Relic tool that we are only Load testing. do we need to extend our licences to fully stress test? How can I ensure the setup is correct that it: - Base VU is 1 - increments by 5 VU - increments every 10 mins by this 5 VU thanks.Solved3.2KViews0likes5CommentsRandom String Generator for REST Request
Hi All, I was wondering if anyone could help with being able to create random data for a POST request that contains about 1000 lines of json. So it would just REPLACE "string" any time it is mentioned/displayed with random data... Part of Example below: "newBusinessRatingReferenceId": "string", "offerOriginChannelEntCd": "string", "offerOriginSubChannelEntCd": "string", "originalOfferOriginChannelEntCd": "string", "originalOfferOriginSubChannelEntCd": "string", "ratingReferenceId": "string", "schemaVersionNbr": "string", "sourceSystemEntCd": "string", "transactionEffDtTimeStr": "string", "transactionProcessedDtTimeStr": "string", "transactionSubEntCd": "string", "transactionTypeEntCd": "string", "transactionUserId": "string"2.7KViews0likes8CommentsFailed to obtain JDBC Connection / Failed do update dashboard db?
I asked question earlierRe: Failed to import a definition / no subject alt... - SmartBear Community Briefly description: I try to make a API call via HTTPS, the definition of URL couldn't import and parsed successfully. The testing environment, both the web service server and testtool client are within private network. I followed some suggestion to enable log (cmd > ready-api.bat>C:\log.txt 2>&1) And found there are several ERROR related to DB as the following. What's the dashboad db? Should I setup a JDBC connection before call API? I thought JDBC connection is only for DataSource purpose, am I wrong? Are those ERRORS the causes that I always get the invalid responses? ERROR [DashboardSchemaChecker] Failed do update dashboard db. ERROR [SoapUI] An error occurred [Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process: C:/Users/Administrator/.readyapi/db/dashboard.lock.db". Possible solutions: close all other connection(s); use the server mode [90020-200]], see error log for details 08:56:14,969 ERROR [errorlog] org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process: C:/Users/Administrator/.readyapi/db/dashboard.lock.db". Possible solutions: close all other connection(s); use the server mode [90020-200] org. springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process: C:/Users/Administrator/.readyapi/db/dashboard.lock.db". Possible solutions: close all other connection(s); use the server mode [90020-200] ERROR [MixpanelCustomEngine]analytics01.smartbear.com2.5KViews0likes5CommentsJDBC connection error indicating SSL issue
I have configured a MS SQL DB in my data source step. If i test it , the connection is successful. But while running the data source step alone, i am facing the following error: I have copied the latest MS SQL JDBC Drivers(12.4.1 and 12.4.0) into the ReadyAPI bin path. Kindly help me to resolve the same. Cannot get a connection for the specified properties com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. ClientConnectionId:6f0f5b46-4e69-446f-80ee-866d05e2b8e2 I have added the following properties "encrypt" as false and "trustServerCertificate" as true in the database configuration.Solved2.4KViews0likes2CommentsMore than 95% of Java heap memory is being used warning.
Hello Since the update to 3.40.0, I've been getting the following message, "More than 95% of the Java heap memory is being used. The test results may be impacted. It is recommended you increase the VM option -Xmx or -XX:MaxHeapSize in the file ReadyAPI.vmoptions." I have a collection of test steps that are initializing a list of pretty lightweight java objects -- I assumed in each test step, previous initializations of objects would no longer be in memory. My -Xmx value is-Xmx8000m -- I assume that's 8GB* of RAM basically? Is there a way to clear out previous object initializations between test steps, or let previous objects carry over into new test steps? Any thoughts or insights would be appreciated. So far I've tried manually setting the objects to null within the java package to try to force garbage collection, and from the ReadyAPI Groovy scripts (between test cases) but that didn't make the warning go away. I ran my program once outside of ReadyAPI to check some of the memory sizes, getRuntime().totalMemory(); heapSize: 264241152 getRuntime().maxMemory heapMaxSize: 4221566976 getRunTime().freeMemory(); heapFreeSize: 236652272 Best regards, -MdarSolved2.4KViews0likes6Comments