cancel
Showing results for 
Search instead for 
Did you mean: 

Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with listeners

SOLVED
Contributor

Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with listeners

Ready API Pro 1.5.0 throws BadSqlGrammarException error when it finishes running test cases that contain listeners.  This causes the steps in the test case window to remain greyed out and to be unresponsive to mouse clicks.  It also breaks running in a loop--you only get through the first loop then the exception makes it stop.  You can still manually play the test case again, but you'll get the error at the end every time.

 

These are test cases that work perfectly fine in Ready API 1.3.1 and earlier, even after trying to run them in 1.5.0.

 

Work Around: Go back to Ready API 1.3.1.

 

Error:

EST 2015:ERROR:Error notifying listener after run
   org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from test_step_run_history where execution_id = ?]; nested exception is org.h2.jdbc.JdbcSQLException: Column "icon_path" not found [42122-176]

 

See the attached file for the full stack trace.

1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Re: Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with liste

FYI: This appears to be fixed in Ready API 1.7

View solution in original post

5 REPLIES 5
Community Manager

Re: Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with liste

Hi,

Thanks for reporting the issue. I've submitted it to our R&D team. While we are waiting the news from them, could you please check if the issue persists in the latest nightly build? https://support.smartbear.com/downloads/readyapi/nightly-builds/

---------
Tanya Gorbunova
SmartBear Community Manager

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

Re: Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with liste

Yes, the problem still happens on the 1.5.0 nightly build.

Community Manager

Re: Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with liste

Thanks for checking this, kbw.

Our Dev team informed me that the investigation may take some time. Could you please start working with our Support Team? Also, please send them the problematic project as our R&D haven’t reproduced the issue in our test lab.

 

---------
Tanya Gorbunova
SmartBear Community Manager

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

Re: Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with liste

Sure, I'll try to pare down the project while still retaining the problem, to make it easier to examine.  Might take me a couple days before I can squeeze in the time to do that, before I can submit the support ticket.

Contributor

Re: Defect: Ready API Pro 1.5 throws BadSqlGrammarException error when running test cases with liste

FYI: This appears to be fixed in Ready API 1.7

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors