Hi, When I calling a database query via DB Query Reader, I get an error “The statement did not return a result set”. Has anyone had such a problem? What could it be?
Welcome to Knime forum. The message you’ve got is a warning not an error. It is possible that query return no result. If this is not expected, please provide more details.
1 Like
It’s error. The same code called in SQL Sever Management Studio works correctly, and after pasting to the Query Reader in Knime it throws out the error. So far, I have had no problem with that.
Hello @WojK,
welcome to KNIME Community!
You get this error upon execution? Can you share query? If I got it right you do this on a regular basis (copying queries from SQL Sever Management Studio to KNIME) and worked fine till this one?
Br,
Ivan
Hi,
Yes, it is execute regulary and I only had such an error once
@WojK it is very difficult to tell what is going on without further details:
- what kind of system and database are we talking about
- could you provide a log file set to DEBUG to
- if possible could you provide a minimal example of your workflow reproducing the error
- which code did you execute on what kind of data (types)
1 Like
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.