Error while running Web Intelligence document from Infoview

system · December 30, 2009, 7:12am

Hi,

We are getting the following error while running / refreshing Web Intelligence document from Infoview. However if we run the same document from Web Intelligence Rich Client it is running fine.

The ‘CREATE TABLE’ command is not allowed within a multi-statement transaction in the ‘tempdb’ database.
. (WIS 10901)

The universe on which WebI document is created is a stored procedure (SP) based universe and we have created some temp tables inside the SP. We have also ran this SP in sybase itself and it is running fine over there.

We are using Business Objects XI 3.1 and sybase version 12.5 as database.

Can anybody help us out in resolving this error.

Thanks & Regards,
Rajeev Bhardwaj

Rajeev Bhardwaj (BOB member since 2009-12-30)

system · December 30, 2009, 12:08pm

Hi,
Cant you create that temp table before hand and then run the procedure?

Omkar Paranjpe (BOB member since 2006-02-13)

system · December 30, 2009, 12:54pm

Hi Omkar,

Thanks a lot for your suggestion.

We won’t be able to create temp tables outside the SP. We are using #tables so that it can store the session data and specific to the parameters that users has passed in that instance.

Thanks,
Rajeev Bhardwaj

Rajeev Bhardwaj (BOB member since 2009-12-30)

system · December 31, 2009, 6:10am

Hi,
In the TEMP table you can add the some session specific details and then display that data into the report if CREATE TABLE is giving some error.

Omkar Paranjpe (BOB member since 2006-02-13)

system · January 6, 2010, 1:42pm

Hi,

I got the solution of my problem.

We have to make following entry in sybase.sdo file

AutoCommit

We will have to restart the services first before starting / using Info View.

Thanks,
Rajeev Bhardwaj

Rajeev Bhardwaj (BOB member since 2009-12-30)

system · April 30, 2010, 5:56am

Hi Rajeev,

Can you please help me out ,how to find sybase .sdo file ?

I am also running the same issue

Thanks
Pratip

pratip (BOB member since 2007-04-06)

system · April 30, 2010, 7:14am

Hi,

It should be sybase.sbo file and not sybase.sdo.

Go to universe connection in universe designer.
Click on test.
Click on details.
You will see the path to sybase.sbo file in your installation directory.
It should be something like:

programfiles–>businessobjects11.5–>win32x–>dataaccess–>connection server–>sybase

gaurav S (BOB member since 2010-04-22)

system · April 30, 2010, 8:31am

Thanks Very much gaurav.

Pratip

pratip (BOB member since 2007-04-06)