Ash Burton

Mobile | Web | Data

Mobile Payments, Android, iOS, Mobile Web, HTML5, Multichannel Customer Service, Web Services, IVR, Business Intelligence, Telecoms, Radio, Photography, Running, Gaming

Business Objects DeskI: DA0005 "No column or data to fetch"

This is just a quick tip to help people fix an odd error I encountered whilst runing a Freehand SQL query against a MySQL 5 database, I'd used prompted queries against MySQL previously so that wasn't an issue  - I'm speculating a little but in my case the data provider used subqueries and both the inner and outer query were prompted which is a little unusual. 

The error I received was DA0005 "No column or data to fetch"...

The solution came from the brilliant BOB Forums (original post here), the solution was to edit the odbc.sbo file which on my default installation found in:  

C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\odbc

You'll need to add the following in the relevant section, in my case I added it under Generic, Generic ODBC and MySQL 5. 

<Parameter Name="ForceSQLExecute">Always</Parameter>

After closing and restarting DeskI everything was fine, please bear in mind that if you're running a client/server installation and your Inforview users need to run the report you'll need to change the settings on the server too.