Issue with executing stored procedures that use temp tables

[system]

Hi all,

I’m currently working migrating our existing 6.5.1 environment onto XI3.1 on one of our test machines.

Windows 2003 server
SQL Server 2000 datasources and CMS database

We have numerous reports that call stored procedures that in turn use temp tables (#tablename), we applied a hotfix within 6.5.1 in order for these to run.

I have searched through BOB and found the following post;

120×120 10.4 KB

Hi guys! today I was lucky and managed to make stored procedures working in WebI. I’m glad to share this ‘know how’ and say goodby to DeskI Change parameter Force SQLExecute in odbc.sbo to Always Add parameter Force SQLExecute = Always into oledb.sbo Create query in WebI with the same structure your SP returns Change SQL to following set nocount on /*SELECT any_field FROM any_table*/ exec your_stored_procedure @prompt('enter value','A',<other prompt parameters>) you can even use tem…

I thought that this was my answer, but after updating the sbo files on the application server I still have the issue. I restarted the server many times.

Any advice would be great as the only option I can see is to rebuilt these reports via traditional Business Objects ways, i.e. make a universe and then the report.

Regards,

Matt

---

mds (BOB member since 2006-05-17)

[system]

Hi Moderators,

Could you please move this topic into the XI servers discussion, I posted it into the wrong group.

Cheers

---

mds (BOB member since 2006-05-17)