Cekay
6 years agoContributor
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