Error while inserting stored procedure in universe

[Former Member]

Hi,

I am using BO XI R 3.1. I've inserted few stored procedures in the universe and also able to see the table values after giving the paramteters. But while i try to insert some stored procedures and after giving the parameter value am seeing the error message as 'This class does not exist (unv0037) error. The database is sqlserver 2005. I was able to run the stored procedure and not seeing any error in database.

Could any one suggest the steps for resolving this issue.

Thanks,

Eswar

Edited by: Eswar Rao on May 18, 2010 1:48 PM

[Former Member]

I've resolved this error by changing the option set no count off in database

[Former Member]

Hi,

Can any one please respond on my issue. Kindly let me know if any information is required on the same.

Thanks,

Eswar

[former_member793810]

Hi Eswar,

I don' know exact answer but I was reading this thread and found that it may help you resolve your issue.

[;

Good Luck,

Bashir Awan

[Former Member]

Hi Bashir,

Thanks for the response.

I was able to create the universe based on stored procedure however when i try to insert some stored procedures it is not showing any columns and also no display of data in table values.

When using Deski directly to create the report on stored procedures it is showing the message as sql connection error no column present or no data to be fetched.

I believe there is an issue with stored procedure seeing the message.

Eswar

[Former Member]

Check if you are stored procedure is compiled properly and it returns data while invoked outside BO.

[Former Member]

Yes, i was able to see the data for stored procedure while i run in database and see no issue.

I would like to know what changes need to done to the sql in stored procdure when it contains cursors and temp tables and also temp tables being dropped after the data fetch is being done.

I would appreciate more inputs and suggestions.