Skip to Content
0

webi error when using stored procedure

Aug 21, 2017 at 02:05 PM

37

avatar image

Hi All,

I created a universe against stored proc in BI 4.1 UDT. Everything parses and i am able to view data in Universe and exported it. But Webi is throwing " MS SQL Native client error . Object was open ".

Universe connection is fine ... Any insight into what could possibly cause this issue would be so helpful.

Thanks everyone.

Pali.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Aug 21, 2017 at 02:21 PM
0

Are the ODBC setting on the server the same as the local ones being used by the UDT?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

where can I check the setting on server..?

Thanks.

Pali

0
avatar image
Former Member Aug 21, 2017 at 03:14 PM
0

You'll need to login to the server directly and check that the ODBC settings are there, and are the same

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 07 at 02:49 PM
0

Hello ,

i have the same Problem : BOXI 3.1 + SQL ( Stored Procedure )

Test cnx on server : Ok

, i can see the data , but when i use Webi or Webi rich Client , i have the error : "Microsoft SQL Native Client 10.0: Object was Open ( WIW 10901)

Thank for your help

Share
10 |10000 characters needed characters left characters exceeded