Skip to Content
author's profile photo Former Member
Former Member

No data available - Execute on BI Platform

Dear all,

we are facing a strange mistake I hope somebody else has already seen and solved.

We are using a universe as datasource and everything works fine in local execution mode. But if we try "Execute on BI Platform", we get an error "no data available". Error log says:

Cannot load InfoProvider "DSL/ ...... " (data provider "DS_1": No service implementation available)

But what's really strange is: It only shows this error if I filter the data in a special way. We have separated our data in quarters, and only for one company in one quarter it does not work. The query retrieves perfect results in Web Intelligence and on SQL Server, but in Design Studio it lacks.

Is anyone familiar with that or similar issues?

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 12, 2015 at 11:25 AM

    Hi Daniel,

    We got a similar error also having an SQL Server as a source.

    Our problem was that the data source was setup to be run on background. When we tried to open and setup the Initial View, it gave the same error

    Cannot load InfoProvider "DSL/ ...... " (data provider "DS_1": No service implementation available)

    After trial and error, we discovered that the issue was with the background processing and the initial view of the datasource


    What we did was:

    1) setup data source to Load in Script = false

    2) setup the initial view (even if you don't want to set something in the initial view, just move the measures from columns to rows and viceversa)

    3) setup data source to Load in Script = true

    4) open initial view to check that it shows data


    Now it works fine. Strange, but it works fine.

    Hope it helps

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 11, 2015 at 12:52 PM

    Is the BI add-on for Design Studio installed on the BI Platform?

    Did you upload the Design Studio application to the BI Platform?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2015 at 02:35 PM

    Hi,

    this is a known problem which has been fixed just recently. Please have a look at SAP note 2216929. The fix will be delivered with 1.5 SP2.

    Regards,

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2015 at 09:54 PM

    Hi

    I've had a similar error when trying run on a BI platform using a UNX as a data source. Works fine when run locally but fails with a "No connection factory for type DSL\DSL". So the clue is the DSL part. So I created another APS in the CMC but in addition to the Analysis Application Service added the DSL Bridge Service (UNX universes use this).

    Started new APS, stopped the original one, restarted the DS client and was able to successfully run my DS document on the BI Platform.

    Why is it that when the DS App extension is installed on the BI platform, the install process does not configure APS servers?

    Surely the whole point is to run the DS document from the BO Portal and have it available to BO users?

    Cheers

    Jon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.