NhaNguyen
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Re: Error notifying listener before run ReadyAPI 1.8.0
the guideline below comes from Natalie Borovykh - SmartBear Customer Care. It works fine for me :) Please try the following steps: 1. On the SoapUI NG tab, double-click a project and check the "Compare" or "History" screen. Do you see the "Test Run History Disabled" message on them (see: http://screencast.com/t/eDWaD300USH)? If so, back up the DB, and then update it. Does this resolve the issue? 2. If it doesn't, close Ready! API, navigate to the C:\Users\<User>\.readyapi folder, and delete the 'db' folder along with its content. Try to reproduce the issue again.4.9KViews0likes0Comments:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building
I try to run soapui, I alway got error message as below: someone give me any advise? I use ReadyAPI 1.5.0 , java jdk1.8.0_102 ERROR:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target ERROR:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.ssl.Alerts.getSSLException(Unknown Source) at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source) at sun.security.ssl.Handshaker.fatalSE(Unknown Source) at sun.security.ssl.Handshaker.fatalSE(Unknown Source) at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source) at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source) at sun.security.ssl.Handshaker.processLoop(Unknown Source) at sun.security.ssl.Handshaker.process_record(Unknown Source) at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source) at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source) at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source) at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source) at org.apache.http.conn.ssl.SSLSocketFactory.createLayeredSocket(SSLSocketFactory.java:552) at org.apache.http.conn.ssl.SSLSocketFactory.createLayeredSocket(SSLSocketFactory.java:433) at org.apache.http.impl.conn.DefaultClientConnectionOperator.updateSecureConnection(DefaultClientConnectionOperator.java:217) at org.apache.http.impl.conn.AbstractPoolEntry.layerProtocol(AbstractPoolEntry.java:243) at org.apache.http.impl.conn.AbstractPooledConnAdapter.layerProtocol(AbstractPooledConnAdapter.java:152) at org.apache.http.impl.client.DefaultRequestDirector.establishRoute(DefaultRequestDirector.java:800) at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:614) at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:445) at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57) at com.eviware.soapui.impl.wsdl.support.http.HttpClientSupport$Helper.execute(HttpClientSupport.java:233) at com.eviware.soapui.impl.wsdl.support.http.HttpClientSupport.execute(HttpClientSupport.java:323) at com.eviware.soapui.impl.wsdl.submit.transports.http.HttpClientRequestTransport.submitRequest(HttpClientRequestTransport.java:295) at com.eviware.soapui.impl.wsdl.submit.transports.http.HttpClientRequestTransport.sendRequest(HttpClientRequestTransport.java:225) at com.eviware.soapui.impl.wsdl.WsdlSubmit.run(WsdlSubmit.java:119) 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: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.validator.PKIXValidator.doBuild(Unknown Source) at sun.security.validator.PKIXValidator.engineValidate(Unknown Source) at sun.security.validator.Validator.validate(Unknown Source) at sun.security.ssl.X509TrustManagerImpl.validate(Unknown Source) at sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source) at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source) ... 29 more Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source) at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source) at java.security.cert.CertPathBuilder.build(Unknown Source) ... 35 more1.6KViews0likes0CommentsError notifying listener before run ReadyAPI 1.8.0
Hi Smart bear team, My project shows error :Error notifying listener before run. However yesterday it doesn't show any error, I don't know what error? My project hasn't yet connect JDBC The issue doesn't appear for other project. (this project haven't yet connect to JDBC also) Please let me know what's error and how to resolve it. I'm using readyapi 1.8.0 Thu Sep 15 10:19:28 ICT 2016:WARN:Not storing test run data for TestSuite 'Main' since there is no repository. Thu Sep 15 10:19:28 ICT 2016:WARN:Not storing test run metadata for TestSuite 'Main' since there is no repository. Thu Sep 15 10:19:28 ICT 2016:WARN:Not storing test run data for TestCase 'DataDrivenTest' since there is no repository. Thu Sep 15 10:19:28 ICT 2016:WARN:Not storing test step run data (latest runs) for TestCase 'DataDrivenTest' since there is no database repository. Thu Sep 15 10:19:28 ICT 2016:ERROR:Error notifying listener before run org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select h.*, r.*, (select count(*) > 0 from test_step_run_history sh where h.execution_id = sh.execution_id) as has_runs from test_run_history h left join saved_run r on h.execution_id = r.execution_id where model_item_id = ? and (r.saved is NULL or r.saved=false) order by id desc limit ?]; nested exception is org.h2.jdbc.JdbcSQLException: Column "project_id" 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.JdbcTestRunHistoryEntryRepository.findLatestNonArchivedRuns(JdbcTestRunHistoryEntryRepository.java:209) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.a(DefaultLatestRunsProvider.java:333) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.getLatestRuns(DefaultLatestRunsProvider.java:140) at com.eviware.soapui.impl.support.PerformanceHintTestRunListener.a(PerformanceHintTestRunListener.java:86) at com.eviware.soapui.impl.support.PerformanceHintTestRunListener.beforeRun(PerformanceHintTestRunListener.java:71) at com.smartbear.ready.license.LicenseAnnotationMethodInterceptor.invoke(LicenseAnnotationMethodInterceptor.java:43) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.notifyBeforeRun(AbstractTestCaseRunner.java:317) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:117) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:128) 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 "project_id" 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.JdbcTestRunHistoryEntryRepository$TestRunHistoryEntryRowMapper.mapRow(JdbcTestRunHistoryEntryRepository.java:258) at com.smartbear.ready.db.repository.jdbc.JdbcTestRunHistoryEntryRepository$TestRunHistoryEntryRowMapper.mapRow(JdbcTestRunHistoryEntryRepository.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 Thu Sep 15 10:19:28 ICT 2016:WARN:Not storing test run data for TestCase 'CreateShipmentSOAPTemplate' since there is no repository. Thu Sep 15 10:19:28 ICT 2016:WARN:Not storing test step run data (latest runs) for TestCase 'CreateShipmentSOAPTemplate' since there is no database repository. Thu Sep 15 10:19:28 ICT 2016:ERROR:Error notifying listener before run org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select h.*, r.*, (select count(*) > 0 from test_step_run_history sh where h.execution_id = sh.execution_id) as has_runs from test_run_history h left join saved_run r on h.execution_id = r.execution_id where model_item_id = ? and (r.saved is NULL or r.saved=false) order by id desc limit ?]; nested exception is org.h2.jdbc.JdbcSQLException: Column "project_id" 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.JdbcTestRunHistoryEntryRepository.findLatestNonArchivedRuns(JdbcTestRunHistoryEntryRepository.java:209) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.a(DefaultLatestRunsProvider.java:333) at com.eviware.soapui.impl.wsdl.history.DefaultLatestRunsProvider.getLatestRuns(DefaultLatestRunsProvider.java:140) at com.eviware.soapui.impl.support.PerformanceHintTestRunListener.a(PerformanceHintTestRunListener.java:86) at com.eviware.soapui.impl.support.PerformanceHintTestRunListener.beforeRun(PerformanceHintTestRunListener.java:71) at com.smartbear.ready.license.LicenseAnnotationMethodInterceptor.invoke(LicenseAnnotationMethodInterceptor.java:43) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.notifyBeforeRun(AbstractTestCaseRunner.java:317) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:117) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:128) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.start(AbstractTestRunner.java:74) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCase.run(WsdlTestCase.java:665) at com.eviware.soapui.impl.wsdl.WsdlTestCasePro.run(WsdlTestCasePro.java:91) at com.eviware.soapui.impl.wsdl.WsdlTestCasePro.run(WsdlTestCasePro.java:1) at com.eviware.soapui.model.testsuite.TestCase$run$1.call(Unknown Source) at Script1.run(Script1.groovy:48) at com.eviware.soapui.support.scripting.groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:91) at com.eviware.soapui.support.scripting.groovy.SoapUIProGroovyScriptEngineFactory$SoapUIProGroovyScriptEngine.run(SoapUIProGroovyScriptEngineFactory.java:79) at com.eviware.soapui.impl.wsdl.teststeps.WsdlGroovyScriptTestStep.run(WsdlGroovyScriptTestStep.java:155) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:221) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:46) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:144) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:128) 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 "project_id" 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.JdbcTestRunHistoryEntryRepository$TestRunHistoryEntryRowMapper.mapRow(JdbcTestRunHistoryEntryRepository.java:258) at com.smartbear.ready.db.repository.jdbc.JdbcTestRunHistoryEntryRepository$TestRunHistoryEntryRowMapper.mapRow(JdbcTestRunHistoryEntryRepository.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) ... 33 more Thu Sep 15 10:19:29 ICT 2016:WARN:Test Monitor: Trying to unregister a non-existing test model item [model item ID: 598de8bc-ddc0-4736-8288-d7a37e5d50f3].5.3KViews0likes8CommentsCan I use the license for jenkins, which is license using on my computer
I have a license , which I install on personal computer for development soapui script. Now, I need run the script on jenkins server, which is on server. (on server, we just run soapui script only, we don't need code) Can I use the license on jenkins server?Solved3.3KViews0likes5Comments