Ask a Question

Error notifying listener before run ReadyAPI 1.8.0

NhaNguyen
Occasional Contributor

Error 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].

 

8 REPLIES 8
TanyaYatskovska
Community Manager

Re: Error notifying listener before run ReadyAPI 1.8.0

 

 

Hi NhaNguyen,

 

According to the error, it looks like you are using DataSink in your project. When you got the error, there were some connection issues and Ready! API couldn't get access to your datasource. Perhaps, that were temporary issues. Anyway, I suggest that you double-check your DataSink settings.

 

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
NhaNguyen
Occasional Contributor

Re: Error notifying listener before run ReadyAPI 1.8.0

Hi ,

Actually, I can run DataSink individual without error. I attach the image about excel file, Could you take a look?

 

NhaNguyen
Occasional Contributor

Re: Error notifying listener before run ReadyAPI 1.8.0

I downgraded the readyAPI version to 1.5.0, it works now

TanyaYatskovska
Community Manager

Re: Error notifying listener before run ReadyAPI 1.8.0

Sounds like an issue in v.1.8 😞

Could you please report it to our Customer Care Team? They will investigate the issue and our R&D Team will try to fix it.

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
NhaNguyen
Occasional Contributor

Re: Error notifying listener before run ReadyAPI 1.8.0

it continue to appear on version 1.9.0

when do you fix it?

TanyaYatskovska
Community Manager

Re: Error notifying listener before run ReadyAPI 1.8.0

Hi Nhanguyen,

 

 

Have you reported the issue to our Customer Care Team as I suggested? I suggest that you contact them to learn the approximate terms of when the issue is fixed.

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
NhaNguyen
Occasional Contributor

Re: Error notifying listener before run ReadyAPI 1.8.0

yes, I did. However I have just did.

NhaNguyen
Occasional Contributor

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. 

2016-12-05_1013
Free online storage and sharing with Screencast.com. 2 GB of storage and 2 GB of bandwidth per month for free. We won't compress, alter or take ownership of your content.
cancel
Showing results for 
Search instead for 
Did you mean: