Test Case not completing gracefully when Groovy Test Step accessing database.
Ready API 1.5.0 I have a Test Case with the following Steps: 1. A JDBC test step to get the count of rows in a certain table. 2. REST API Request 3. Groovy Script to compare API Response with database (database connection and query are executed within theGroovy Script) Upon running this test, once it gets to the groovy script all test steps become greyed out and the test case freezes. I have to close the test case. NOTE: Previously I was running Ready API 1.4.1 and this issue did not occur. This only started happing after the upgrade. I see thefollowing error apeparing in the Ready API Log: Wed Nov 11 14:37:14 GMT 2015:ERROR:Error notifying listener after run org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from test_step_run_history where execution_id = ?]; nested exception is org.h2.jdbc.JdbcSQLException: Column "icon_path" not found [42122-176] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) at com.smartbear.ready.db.repository.jdbc.JdbcTestStepRunHistoryEntryRepository.findByExecutionId(JdbcTestStepRunHistoryEntryRepository.java:142) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.a(DefaultLatestRunsProvider.java:357) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.a(DefaultLatestRunsProvider.java:329) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.a(DefaultLatestRunsProvider.java:317) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.getLatestRun(DefaultLatestRunsProvider.java:140) at com.eviware.soapui.impl.wsdl.panels.testcase.ProWsdlTestCaseDesktopPanel$InternalTestRunListener.afterRun(ProWsdlTestCaseDesktopPanel.java:921) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.notifyAfterRun(AbstractTestCaseRunner.java:316) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalFinally(AbstractTestCaseRunner.java:188) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalFinally(AbstractTestCaseRunner.java:1) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:154) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.h2.jdbc.JdbcSQLException: Column "icon_path" not found [42122-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:178) at org.h2.message.DbException.get(DbException.java:154) at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3122) at org.h2.jdbc.JdbcResultSet.get(JdbcResultSet.java:3210) at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:304) at com.smartbear.ready.db.repository.jdbc.JdbcTestStepRunHistoryEntryRepository$TestStepRunHistoryEntryRowMapper.mapRow(JdbcTestStepRunHistoryEntryRepository.java:383) at com.smartbear.ready.db.repository.jdbc.JdbcTestStepRunHistoryEntryRepository$TestStepRunHistoryEntryRowMapper.mapRow(JdbcTestStepRunHistoryEntryRepository.java:1) at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93) at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:708) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) ... 19 more Can this be investigated as a matter of urgency as this is affecting Regression on our Product. Or could the installer for Ready API 1.4.1 be supplied so I can downgrade to a more stable build.Solved7.3KViews0likes16Comments
how to extract "Rest Request properties" via groovy Script from Rest Test step
I need help in trying to extract the Rest Request Properties associated with a Rest Request test stepin ReadyAPI via Groovy Script. Scenario - want to extract the Resource property listed under Rest Request Properties. The Resource path property available under Rest request propertythen needs to be parameterized so that it can be updated at run time by using a project parameterand support two or more versions of code base by modifying one of the path parameters at run time. I have more than 30 APIs so cant go manually and change the Resource path to a parameterized. Using groovy script I am able to extract the custom parametersbut not able to extract the Rest Request properties. Cansomeone please help in guiding with a solution or pointing to an existing answer. I did found lot ofquestions asked byother userson extracting Custom properties from the request but could not find anything related to Rest Request properties.Solved6.4KViews0likes3Comments
Differences between Ready API and SoapUI NG (Free)
Hello, I have a project. I tried the SOAPUI NG and get java.net.connection reset Socket error. So, I went to the trial version of ReadyAPI. The same project worked there. No changes. No setting changes. I have compared between both and the settings were the same. What do I need to to to get the project to work in SOAPUI NG? (BTW: The free version trail of ReadyAPI expired.) Any advice is appreciated? Thank you. pnorm5.6KViews0likes3Comments
Add minutes to current date time using groovy
To get the Current Date Time value, im using this: ${= Calendar.getInstance(TimeZone.getTimeZone('GMT')).format("yyyy-MM-dd'T'HH:mm:ss")} which gives DateTime as2020-02-05T22:07:34 I want to add 40 minutes to the current DateTime Value: the expected result should becurrentTime + 40 min. Which is:2020-02-05T22:47:34Solved5.4KViews0likes1Comment
Receiving JVM error in jenkins when using testrunner.bat
Team, We are doing Continuous Integration with Jenkins by using SoapUI NG TestRunner. Daily 50 plus jobs are running in it. At times, we could see the below error in the job log, ------------------------------------------------------------------------------- The process cannot access the file because it is being used by another process. C:\Users\...\AppData\Local\Temp\jfxrtpath The process cannot access the file because it is being used by another process. The process cannot access the file because it is being used by another process. C:\Users\...\AppData\Local\Temp\readyxmx The process cannot access the file because it is being used by another process. Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit. Invalid maximum heap size: -Xmx Build step 'Execute Windows batch command' marked build as failure Recording test results readyapi.bat had -Xmx2048m. Not sure what caused this issue. We believe, it is not following any patterns , it occurs randomly for some jobs. Please suggest solution for this issue and let us know, if you need any further details.Solved4.8KViews0likes7Comments
Ready API 2 Don't Start on Mac OS
Hello guys, I try again start to SOapUi NG Pro (Ready API 2) on Mac OS with Sierra, but the app don't start! I have Java 8 installed. He show the message bellow in splash screen: License host for SoapUi NG: Host.local No license found for secure Someone, already this problem? Thank you. Márcio Dantas4.6KViews0likes11CommentsLooking for Ready!API Users
If you are a Ready!API user feel free to contact me directly. I'm looking to observe how you are using the product. I would like to capture your emotions and interactions when using the application as I'm working on improving the usability of the application. You can email me directly at veronica.clarke@smartbear.com. - Veronica {Lead Uxer}4.1KViews1like0CommentsHow can I include dependencies from an external jar file into a groovy script test step
Hello Community, I am using the ready-api maven plugin. I have my dependency in the pom.xml. The depedency is being downloaded. My question is how can I use the classes in this jar file in a groovy test step. I have tried using an import statement, but the script does not know where to locate the jar. As a side note, we do not have admin rights on our local machines so I cannot install the jar file to the soapUi install directory. So, I need a way to tell SoapUi how to find the Jar file. I pulled my code out into intelliJ and it works, but I cannot get it to work inside of soapUi.Solved3.7KViews0likes5CommentsHow to generate test case printable report during automation execution and Save in local system ?
Using TestRunner GUI, There are reports that can be generated such as Junit Report, Allure Report and Printable report. How to save these reports after execution of each testcase ?Solved3.3KViews0likes7CommentsHow to use access token in authorization from another API
Hi I am using JWT token in my Rest APIs and as it has expiration time , i need to refresh/get new token during my test case So here is an example : 1. first test step --> I create new Token using auth/api-key endpoint 2. second test step --> use this token in another Api endpoint to create new client (/client/create) asaccess token in authorization In this case i try to use data transfer between this 2 step , and receive new token but can manage to use it as access token in target ! in between , i am not good in scripting so i prefer to do it via available tools & pages in ReadyAPI 3.5.0 Thanks in advanceSolved3.2KViews0likes6Comments
Differences between Ready API and SoapUI NG (Free)
Hello, I have a project. I tried the SOAPUI NG and get java.net.connection reset Socket error. So, I went to the trial version of ReadyAPI. The same project worked there. No changes. No setting changes. I have compared between both and the settings were the same. What do I need to to to get the project to work in SOAPUI NG? (BTW: The free version trail of ReadyAPI expired.) Any advice is appreciated? Thank you. pnormReady API 2 Don't Start on Mac OS
Hello guys, I try again start to SOapUi NG Pro (Ready API 2) on Mac OS with Sierra, but the app don't start! I have Java 8 installed. He show the message bellow in splash screen: License host for SoapUi NG: Host.local No license found for secure Someone, already this problem? Thank you. Márcio DantasLooking for Ready!API Users
If you are a Ready!API user feel free to contact me directly. I'm looking to observe how you are using the product. I would like to capture your emotions and interactions when using the application as I'm working on improving the usability of the application. You can email me directly at veronica.clarke@smartbear.com. - Veronica {Lead Uxer}
