Try out following
run the query maually on the database editor and see if any results are fetched
in case results are fetched, it is issue with adapter other wise check SQL query with DBA Team and follow the same process again,still if you receive the same error,it is the issue in database
Check below link which gives you more info
http://www-01.ibm.com/support/docview.wss?uid=swg1IC81493
Thanks
Sai