java.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.5KViews0likes3CommentsBearer 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?Solved4.9KViews0likes2CommentsUpload 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.1KViews0likes1CommentStress 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.4KViews0likes5CommentsMore 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.2KViews0likes6CommentsCannot run loadtestrunner because the project is protected
Hello, I use the latest version from RedayAPI (3.0.0) and my project is password protected - the properties are encrypted. When I want to run functionaltestsin pipeline,I can give the password over the command-line parameter -p but this parameter doesn't exists for the lodtestrunner. How I can run load test over the loadtestrunner using a protected project? Greetings ... 15:18:36,575 ERROR [WsdlProject] Unable to decrypt the property [SampleUseCaseCode]. Error: null 15:18:36,577 ERROR [WsdlProject] Unable to decrypt the property [SampleUseCaseCode]. Error: null 15:18:36,578 ERROR [WsdlProject] Unable to decrypt the property [SampleUseCaseCode]. Error: null 15:18:36,580 ERROR [WsdlProject] Unable to decrypt the property [SampleUseCaseCode]. Error: null Wrong password. Reload the project using the correct password to get access to properties. ...Solved2.2KViews0likes5Comments