| Author |
Message |
moorthy1974
Forum Member
Joined: 18 Jul 2008
Posts: 19
|
 Posted: Tue Aug 19, 2008 11:20 am
Post subject: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
Hi,
We have a sybase Free Hand SQL based reports in 5x, which runs fine and gives proper output. But after migration to Xi R2 deski, the same report with same connection / prompts, it gives an error "No column or data to fetch (DA0005)".
Let me know in case if you come across this error and any resolution for the same.
Cheers ... |
|
| Back to top |
|
|
looksmee
Forum Enthusiast
Joined: 08 Feb 2006
Posts: 2441
Location: Bangalore
|
Posted: Thu Aug 21, 2008 4:18 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
Hi
Check whether the connection parameter is correct and the values available in the table..? Also create a new connection, point your report to the newly created connection and check the availability of data...
Regards
Siva.M |
|
| Back to top |
|
|
rahul
Principal Member
Joined: 25 May 2005
Posts: 101
|
Posted: Tue Aug 26, 2008 4:03 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
I have the same error.. " No column or data to fetch ".
This is for a DeskI report migrated from 6.5 to XIR2. Works fine in 6.5.
The source is a freehand sql block which in turn calls a stored procedure.
Have seen the exact same error in 6.5 but it was a bug. Was fixed with one of the service packs.
Seeing it again in XIR2 makes me wonder if its another bug....
Will check with BO. |
|
| Back to top |
|
|
Pragna
Senior Member
Joined: 25 Jul 2007
Posts: 90
|
Posted: Tue Aug 26, 2008 8:10 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
Hi,
Depending on the middleware used for connection need the following changes done to the .sbo file:-
Location:-C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\*.sbo
<Parameter Name="ForceSQLExecute">Always</Parameter>.
Trying logging off from Deski and relogin.
Regards,
Pragna |
|
| Back to top |
|
|
rahul
Principal Member
Joined: 25 May 2005
Posts: 101
|
Posted: Wed Aug 27, 2008 1:34 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
Hi Pragna
This option
| Code: | | <Parameter Name="ForceSQLExecute">Always</Parameter>. |
is available only in odbc.sbo for MS SQLserver configuration.
This is not available in oracle or sybase.sbo files.
I did attempt to add this in myself for odbc.sbo, but it didnt work. |
|
| Back to top |
|
|
Pragna
Senior Member
Joined: 25 Jul 2007
Posts: 90
|
Posted: Wed Aug 27, 2008 1:54 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
While testing the connection for the universe,In the details section the path of the .sbo file is mentioned.
If its odbc.sbo then u need to modify the .sbo file
Regards,
Pragna |
|
| Back to top |
|
|
rahul
Principal Member
Joined: 25 May 2005
Posts: 101
|
Posted: Wed Aug 27, 2008 2:06 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
The source of this report is a free hand sql.
Am looking at the correct sbo file
| Code: | | C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\oracle\oracle.sbo |
I verified it in the connection>test>details as you mentioned.
Still the issue is that oracle.sbo file doesnt have the ForceSQLExecute option. Probably it is not supported by Oracle.
new info:
I checked the busobj.exe trace logs.
They show an Oracle error:
ORA-01008 not all variables bound
So thats the real error behind "No column or data to fetch" |
|
| Back to top |
|
|
anuraga
Forum Member
Joined: 15 Apr 2009
Posts: 7
|
Posted: Thu Apr 16, 2009 7:44 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
Hi Rahul,
Can you tell me where I can find this busobj.exe trace logs.
I did search in my pc and got busobj.exe but its a Deski report and does'nt open too..
With wht name and whr can i find this trace log....
Thanks in advance
Anu |
|
| Back to top |
|
|
rahul
Principal Member
Joined: 25 May 2005
Posts: 101
|
Posted: Fri Apr 17, 2009 12:14 am
Post subject: Re: Free Hand SQL Error: No column or data to fetch (DA0005) |
|
|
Hi Anu,
Here is the procedure for turning on DeskI tracing:
| Quote: | To enable tracing, modify both the cs.cfg and BO_trace.ini, and create new environment variables.
To modify the cs.cfg and BO_trace.ini files
1. Open the cs.cfg file in a text editor such as Notepad. The file is located in <installation directory>:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer.
2. Scroll to the following parameter at the bottom of file:
<Traces ClassID="csTRACELOG" Active="No">
3. Change Active="No" to Active="Yes". This enables the tracing utility. The parameter now appears as follows:
<Traces ClassID="csTRACELOG" Active="Yes">
4. Save and close the file.
5. Navigate to the BO_trace.ini file located in <installation directory>:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\scripts\preconf.
6. Copy BO_trace.ini.
7. Create a new folder under the root of the installation directory named botrace. Paste the BO_trace.ini file in this folder.
8. Open the BO_trace.ini file with a text editor such as Notepad. Replace everything in the file with this following text:
active = true;
importance = xs;
size = 10000;
keep = true;
9. Save the file. It may be necessary to clear the read-only option in File Properties so that it can be saved.
To create the environment variables
1. Right-click My Computer > click Properties > Advanced tab > Environment Variables.
2. Click New in the System variables section. The New System Variable dialog box appears.
3. Create the three following environment variables:
Variable Name: BO_TRACE_CONFIGDIR
Variable Value: c:\botrace
Variable Name: BO_TRACE_CONFIGFILE
Variable_Value: c:\botrace\BO_trace.ini
Variable Name: BO_TRACE_LOGDIR
Variable Value: c:\botrace
4. Click OK > OK to exit the dialog boxes.
Open Desktop Intelligence or Universe Designer. A log file is generated in the C:\botrace directory. Each time a new application session is started, a new log file is produced.
|
|
|
| Back to top |
|
|
|
