Skip to Content

webi error when using stored procedure

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

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

    Add comment
    10|10000 characters needed characters exceeded

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07 at 02:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded