Skip to Content

Design-time query not available (WIS 00000)-After upgrade of BW systems

Hello Experts,

We are getting below error while trying to create webi or crystal reports from SAP BW backend.

Design-time query not available (WIS 00000)

Our BW systems are upgraded to SAP BW 7.3 SP 12 recently and queries which were working before upgrade also giving this error now. We are in SAP BI 4.1 SP 05.

Please let me know if we need to implement any specific note or setting in SAP BW side to avoid this error message. I referred SAP Note: 1940100 which mentions about supported BW versions for this performance improvement option.

Minimum and Recommended BW versions

Ensure that your BW server meets the following requirements:

BW 7.30 SP8 or BW 7.31 SP5+, plus all the SAP notes listed below.

OR

BW 7.30 SP10, 7.31 SP08 and 7.40 SP05

Does it mean our current version is not supporting this? What will be the impact if we try below workaround mentioned in same note?

Workaround:

Adding the below parameter to the Adaptive Processing Server(s) that have the DSL Bridge service will disable the Design Time Services

functionality in the BICs driver. This should revert the behavior back to the BI 4.0 behaviour for View (Web) mode and Modify (RIA) mode. In BI 4.0,

the Design Time Service was not utilized and Webi retrieved the metadata for the query definition in other ways.

-Dsap.sl.bics.useDesignTimeServices=false

Request your valuable feedback on this.

thanks in advance.

Regards,

Nikhil Joy

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 23, 2015 at 05:06 PM

    Nikhil,

    This is know issues, you need to add this parameter to the DSL Bridge Server in order to work with Design at RunTime Queries.

    http://service.sap.com/sap/support/notes/2060126

    http://service.sap.com/sap/support/notes/1940100

    http://service.sap.com/sap/support/notes/1892705

    Regards,

    Ajay

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ajay,

      thanks for your reply.

      As far as I know, this is a performance improvement mechanism available in BI 4.1. Adding parameters to DSL bridge will make it work like BI 4.0.

      What is the impact of this work around? is it recommended?

      Could you please clarify?

      Regards,

      Nikhil Joy

  • Posted on Aug 19, 2016 at 10:49 AM
    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.