There may be several reason for this and we need to know if you used different connection parameters for BO and for running the SQL. ‘No data to fetch’ error in Business Objects doesn’t mean this literally…If you exceed query governance time either in your database or in Business Objects control,
you may get this error. After running your query directly you get the result in BO : may be due to the fact the result is available in buffer in Database and so it fetches quickly.
Suggestion :
Try simplifying the query to see if it returns data in BO. Increase query governance time in either BO or Database.
Hope it helps.
-Durgesh
HI
I have a BO Report, when running it first time after import it fails → no data to fetch…
I take the sql with the same parameters and run it directly against oracle -