Forum Discussion

Cekay's avatar
Cekay
Contributor
5 years ago
Solved

Strange error "TEST_STEP_LEARNING_RUN"

Hello everyone.

 

I have to admit, that I don't check the error logs in SoapUI on a daily base, so I can't say for how long I recieve this error. However, I can say 2 weeks ago, everything was fine and there was no such errormessage. I didn't make any major changes in my testcases. I just added some more requests.

 

The error appears when I am running a teststep with GET call. If I perform a JDBC teststep, I don't get following error. Both teststeps are finished successfully, so I am not sure, whats the problem is. Please help? =)

 

Thanks

Cekay

 

  • Fri Jun 07 07:37:58 CEST 2019: ERROR: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is org.h2.jdbc.JdbcSQLException: Tabelle "TEST_STEP_LEARNING_RUN" nicht gefunden Table "TEST_STEP_LEARNING_RUN" not found; SQL statement: INSERT INTO test_step_learning_run () VALUES() [42102-197] at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.command.Parser.readTableOrView(Parser.java:5920) at org.h2.command.Parser.readTableOrView(Parser.java:5897) at org.h2.command.Parser.parseInsert(Parser.java:1220) at org.h2.command.Parser.parsePrepared(Parser.java:431) at org.h2.command.Parser.parse(Parser.java:335) at org.h2.command.Parser.parse(Parser.java:307) at org.h2.command.Parser.prepareCommand(Parser.java:278) at org.h2.engine.Session.prepareLocal(Session.java:611) at org.h2.server.TcpServerThread.process(TcpServerThread.java:271) at org.h2.server.TcpServerThread.run(TcpServerThread.java:165) at java.lang.Thread.run(Unknown Source)
  • org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is org.h2.jdbc.JdbcSQLException: Tabelle "TEST_STEP_LEARNING_RUN" nicht gefunden
  • Table "TEST_STEP_LEARNING_RUN" not found; SQL statement:
  • INSERT INTO test_step_learning_run () VALUES() [42102-197]
  • at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
  • at org.h2.message.DbException.get(DbException.java:179)
  • at org.h2.message.DbException.get(DbException.java:155)
  • at org.h2.command.Parser.readTableOrView(Parser.java:5920)
  • at org.h2.command.Parser.readTableOrView(Parser.java:5897)
  • at org.h2.command.Parser.parseInsert(Parser.java:1220)
  • at org.h2.command.Parser.parsePrepared(Parser.java:431)
  • at org.h2.command.Parser.parse(Parser.java:335)
  • at org.h2.command.Parser.parse(Parser.java:307)
  • at org.h2.command.Parser.prepareCommand(Parser.java:278)
  • at org.h2.engine.Session.prepareLocal(Session.java:611)
  • at org.h2.server.TcpServerThread.process(TcpServerThread.java:271)
  • at org.h2.server.TcpServerThread.run(TcpServerThread.java:165)
  • at java.lang.Thread.run(Unknown Source)
  • 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.update(JdbcTemplate.java:943)
  • at org.springframework.jdbc.core.simple.AbstractJdbcInsert.executeInsertAndReturnKeyHolderInternal(AbstractJdbcInsert.java:436)
  • at org.springframework.jdbc.core.simple.AbstractJdbcInsert.executeInsertAndReturnKeyInternal(AbstractJdbcInsert.java:417)
  • at org.springframework.jdbc.core.simple.AbstractJdbcInsert.doExecuteAndReturnKey(AbstractJdbcInsert.java:386)
  • at org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey(SimpleJdbcInsert.java:137)
  • at com.smartbear.ready.db.repository.jdbc.ml.JdbcTestStepLearningRunEntryRepository.internalAdd(JdbcTestStepLearningRunEntryRepository.java:119)
  • at com.smartbear.ready.db.repository.jdbc.ml.JdbcTestStepLearningRunEntryRepository.lambda$0(JdbcTestStepLearningRunEntryRepository.java:100)
  • at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  • at com.smartbear.ready.db.repository.jdbc.ml.JdbcTestStepLearningRunEntryRepository.addWithLimit(JdbcTestStepLearningRunEntryRepository.java:99)
  • at com.smartbear.ready.db.repository.TestStepLearningRunEntryRepository.addWithLimit(TestStepLearningRunEntryRepository.java:47)
  • at com.eviware.soapui.impl.wsdl.ml.SingleLearningRunsDataCollector.afterSubmit(SingleLearningRunsDataCollector.java:50)
  • at com.eviware.soapui.impl.wsdl.WsdlSubmit.notifyListenersAfterSubmit(WsdlSubmit.java:111)
  • at com.eviware.soapui.impl.wsdl.WsdlSubmit.run(WsdlSubmit.java:157)
  • 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: Tabelle "TEST_STEP_LEARNING_RUN" nicht gefunden
  • Table "TEST_STEP_LEARNING_RUN" not found; SQL statement:
  • INSERT INTO test_step_learning_run () VALUES() [42102-197]
  • at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
  • at org.h2.message.DbException.get(DbException.java:179)
  • at org.h2.message.DbException.get(DbException.java:155)
  • at org.h2.command.Parser.readTableOrView(Parser.java:5920)
  • at org.h2.command.Parser.readTableOrView(Parser.java:5897)
  • at org.h2.command.Parser.parseInsert(Parser.java:1220)
  • at org.h2.command.Parser.parsePrepared(Parser.java:431)
  • at org.h2.command.Parser.parse(Parser.java:335)
  • at org.h2.command.Parser.parse(Parser.java:307)
  • at org.h2.command.Parser.prepareCommand(Parser.java:278)
  • at org.h2.engine.Session.prepareLocal(Session.java:611)
  • at org.h2.server.TcpServerThread.process(TcpServerThread.java:271)
  • at org.h2.server.TcpServerThread.run(TcpServerThread.java:165)
  • at java.lang.Thread.run(Unknown Source)
  • at org.h2.engine.SessionRemote.done(SessionRemote.java:623)
  • at org.h2.command.CommandRemote.prepare(CommandRemote.java:85)
  • at org.h2.command.CommandRemote.(CommandRemote.java:51)
  • at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:493)
  • at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)
  • at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:76)
  • at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1229)
  • at org.springframework.jdbc.core.simple.AbstractJdbcInsert.prepareStatementForGeneratedKeys(AbstractJdbcInsert.java:529)
  • at org.springframework.jdbc.core.simple.AbstractJdbcInsert.access$000(AbstractJdbcInsert.java:62)
  • at org.springframework.jdbc.core.simple.AbstractJdbcInsert$1.createPreparedStatement(AbstractJdbcInsert.java:440)
  • at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:638)
  • ... 18 more
  • After I restarted SoapUI 3 or 4 times the issue has been fixed. oO

    There are no error messages now. Its friday :D SoapUi is ready for weekend

1 Reply

  • Cekay's avatar
    Cekay
    Contributor

    After I restarted SoapUI 3 or 4 times the issue has been fixed. oO

    There are no error messages now. Its friday :D SoapUi is ready for weekend