Skip to Content

How to refresh Business Intellegince Web Services automatically in BI4.0

I built a Web services from a web intelligence  report and published it. This Web service which is using this web intelligence report uses a Bex connection,

which contains one filter condition based on calendar date. When I set the web intelligence report to automatically refresh on open the BIWS connection is getting failed throwing an error ERR_WIS_30270. I need to know what are the possibilties of refreshing the BIWS connection automatically which picks the latest data in any othere way ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Oct 29, 2013 at 11:05 AM

    Hi there,

    This particular issue has been catered in ADAPT01666501 available in SAP BI 4.0 SP5 patch 6.

    Description: The following error message appears when you refresh a QaaWS connection with Date

    type prompt in a dashboard:

    An internal error occurred while calling 'answerPromptsEx' API. (Error: ERR_WIS_30270)

    New Behaviour: This problem is resolved.

    Regards,

    Abhishek

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2013 at 03:29 PM

    Does anybody has answer to this Question?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2013 at 05:18 PM

    Hi,

    I don't think the changing the webi document setting 'refresh on open' should cause a bi web-service (i.e. published webi table block) to error.

    this doesn't sounds quite right..  Where is the web service being used, and what SP and Patch version are you using?

    Regards

    H

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Henry,

      We can't go for higher versions of Fix packs or service packs since we have large user base and re-testing has to be done by all the user if anything got upgraded according to company policies. That can be ruled out. This problem is only for a particular instance so I don't think they would accept it.

  • Apr 15, 2013 at 08:49 PM

    Hi,

    Would you please check if you are passing the right date format to WebI prompts? This is the reason you are getting this error.

    Add comment
    10|10000 characters needed characters exceeded

    • As said earlier,¬†¬† you should check how the prompts are constructed etc.

      Some trace logs with High level of detail should also help to see what is going on

      Please follow Henry's advice as well, SP04 plain is a bit old...

      Thanks

      Simone

  • Apr 18, 2013 at 09:16 PM

    Hi All,

    The issue is definitely with the prompt at BEX query I removed it in the BEX query the web services runs fine.As of now I am good with the issue, Any suggestions on BI web services capability of handling BEX prompts is highly appreciable.

    Thanks to everyone who helped me to find solutions about this.

    Thanks,

    Navin

    Add comment
    10|10000 characters needed characters exceeded