ContributionsMost RecentMost LikesSolutionsRemove ssl keystore settings via a groovy setting from within a composite settings.xml file I've created a script that will set the different certs in the keystore for a composite project. The script is run at the test suite level. However even after deselecting the previous ssl cert from the test script, it still appears to be referenced in the settings.xml for the composite project. Other than removing from the settings.xml, can I do this programmitically to ensure that I always remove any pre-existing setting to ensure I set the correct ssl settings. Re: Call a groovy assertion script form an external file Hi, Although using readyAPI, I prefer to have a solution that can be utilised for SOAPUI (open source) as well. Call a groovy assertion script form an external file I'm new to readyAPI and would like to know if it is possible to call a groovy script as a external file that can then be used by all test cases? My soap based response include a success response code that is in all responses, I want to verify that response code is included in every response. Rather than adding the script to every request, can we specify a single external file to be called instead? Re: Executing Ready API composite project via maven Resolved the issue, was incorrect path specified and that you should specify the settings.xml Re: Executing Ready API composite project via maven Hi, I'm attempting to run a ready api composite project (2.3.0) using soap-maven plugin (4.6.4) and will result in a no protocol exception error. I modified the pom.xml file to have the following: <projectFile>${project.build.directory}/${soapuixml}-soapui-project</projectFile> <outputFolder>${project.build.directory}/surefire-reports</outputFolder> <reportFormat>HTML</reportFormat> <testSuite>${project.build.directory}/${soapuixml}-soapui-project/${testSuite}</testSuite> Should the project be referencing an actual file like the settings.xml file? or should I reference the project file as ${soapui}-soapui-project? Both fail and return failed to load SOAPUI project file. Reason being that the soapui project file does not exist as such in the composite project. Re: Ready API and Jenkins Licensing issuesRaised a support and was advised that jenkins needs to be run under the same account as soapui.Ready API and Jenkins Licensing issues I am attempting to run ReadyAPI via Jenkins, after registering the license. I can see from the console log that the SOAPUI is activated. 10:41:00,550 INFO [DefaultSoapUICore] All plugins loaded 10:41:01,421 DEBUG [LicenseManagerServiceImpl] Trying to initialize license for SoapUI 10:41:01,422 DEBUG [LicenseManagerServiceImpl] No license found for SoapUI 10:41:01,431 DEBUG [LicenseManagerServiceImpl] Trying to initialize license for SoapUI 10:41:01,431 DEBUG [LicenseManagerServiceImpl] No license found for SoapUI 10:41:01,434 DEBUG [LicenseManagerServiceImpl] License host for SoapUI: GH-8VXR3H2 10:41:01,439 DEBUG [LicenseManagerServiceImpl] License host for SoapUI: GH-8VXR3H2 10:41:01,444 DEBUG [LicenseManagerServiceImpl] Trying to initialize license for LoadUI 10:41:01,445 DEBUG [LicenseManagerServiceImpl] No license found for LoadUI 10:41:01,448 DEBUG [LicenseManagerServiceImpl] License host for LoadUI: GH-8VXR3H2 10:41:01,456 DEBUG [LicenseManagerServiceImpl] Trying to initialize license for Secure 10:41:01,457 DEBUG [LicenseManagerServiceImpl] No license found for Secure 10:41:01,479 DEBUG [LicenseManagerServiceImpl] Trying to initialize license for ServiceV 10:41:01,479 DEBUG [LicenseManagerServiceImpl] No license found for ServiceV 10:41:01,483 DEBUG [LicenseManagerServiceImpl] License host for Secure: GH-8VXR3H2 10:41:01,484 DEBUG [LicenseManagerServiceImpl] License host for ServiceV: GH-8VXR3H2 However I still get a error. See stack trace below: :41:01,655 ERROR [SoapUIProTestCaseRunner] java.util.NoSuchElementException: No line found 10:41:01,656 ERROR [SoapUI] An error occurred [No line found], see error log for details 10:41:01,658 ERROR [errorlog] java.util.NoSuchElementException: No line found java.util.NoSuchElementException: No line found at java.util.Scanner.nextLine(Unknown Source) at com.smartbear.ready.license.util.CommandLineUtils.readLine(CommandLineUtils.java:70) at com.smartbear.ready.license.headless.HeadlessLicenseInstaller.installLicense(HeadlessLicenseInstaller.java:32) at com.smartbear.ready.license.LicenseManagerServiceImpl.a(LicenseManagerServiceImpl.java:311) at com.smartbear.ready.license.CombinedSoapUILicenseManagerService.promptForLicenseInHeadlessMode(CombinedSoapUILicenseManagerService.java:203) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.runRunner(SoapUIProTestCaseRunner.java:90) at com.smartbear.ready.cmd.runner.AbstractSoapUIRunner.run(AbstractSoapUIRunner.java:264) at com.smartbear.ready.cmd.runner.AbstractSoapUIRunner.runFromCommandLine(AbstractSoapUIRunner.java:164) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.init(SoapUIProTestCaseRunner.java:81) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.main(SoapUIProTestCaseRunner.java:77) java.util.NoSuchElementException: No line found at java.util.Scanner.nextLine(Unknown Source) at com.smartbear.ready.license.util.CommandLineUtils.readLine(CommandLineUtils.java:70) at com.smartbear.ready.license.headless.HeadlessLicenseInstaller.installLicense(HeadlessLicenseInstaller.java:32) at com.smartbear.ready.license.LicenseManagerServiceImpl.a(LicenseManagerServiceImpl.java:311) at com.smartbear.ready.license.CombinedSoapUILicenseManagerService.promptForLicenseInHeadlessMode(CombinedSoapUILicenseManagerService.java:203) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.runRunner(SoapUIProTestCaseRunner.java:90) at com.smartbear.ready.cmd.runner.AbstractSoapUIRunner.run(AbstractSoapUIRunner.java:264) at com.smartbear.ready.cmd.runner.AbstractSoapUIRunner.runFromCommandLine(AbstractSoapUIRunner.java:164) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.init(SoapUIProTestCaseRunner.java:81) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.main(SoapUIProTestCaseRunner.java:77) Build step 'Execute Windows batch command' marked build as failure Finished: FAILURE Any ideas as to what I'm doing wrong? Re: How to include datetime in a groovy sql query I modified the SQL query to do the following: CONVERT(VARCHAR(23),(DATEADD(month, -2, GETDATE())), 121) instead of actual date value. Re: How to include datetime in a groovy sql query Apologies for not stating that I am using SQL server and not Oracle How to include datetime in a groovy sql query I am new to groovy scripting, I am attempting to run this simple query, that will return a count which is then used in a compare. The query is below: row = sql.firstRow('SELECT count(*) FROM [DB].[dbo].[view] where LastUpdated > \'2016-06-18 03:04:02.550\') Whenever I run the query it will return the error message below: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: Script14.groovy: 9: expecting ''', found '\n' @ line 9, column 137. > \'2016-06-18 03:04:02.550\') ^ org.codehaus.groovy.syntax.SyntaxException: expecting ''', found '\n' @ line 9, column Any ideas as to what I doing wrontg? Solved