Problem BW query Iview

[Former Member]

Dear all,

I created BW query report iview. While trying to view the preview i am getting the following error,

<b>"Application URL ':///sap/bw/BEx' is not valid! Please check the protocol and host entries for system 'sap_bw'.."</b>

Before that i created a system for BW. Please help me out.

Thanks in advance,

Chandrasekhar.

[Former Member · Accepted solution]

HI Chandrashekhar,

Please check the values for the properties for the system created in EP:

1. In the "connector"-subview maintain

• APplication host (ip adres or FQDN of the BW system)

• Gateway host: <HOSTNAME> (mostly the same as application host)

• Gateway service: <SERVICE> eg. sapgw00

• Client :

• System ID :

• System Name ID : <system name>

• System No : <system no>

• System Type : SAP_BW (make sure to change this from SAP_R to SAP_BW)

• Remote host type : 3

2. In the "WAS"-subview maintain

WAS-Hostname : <hostname/IP of WAS beneath BW-system>:<portno of WAS beneath BW-system> ; eg myserver.mycompany.com:8000

Path : /sap/bw/BEx

protocol : http

Please see:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2f/741a403233dd5fe10000000a155106/frameset.htm">Creating BW Systems in the Portal</a>

HOpe this helps,

Regards,

Siddhartha

Message was edited by: Siddhartha Jain

[Former Member]

Hi Chandrasekhar,

Check out following properties in BW system:

WAS protocol=http

WAS Path = /sap/bw/Bex

WAS Host Name = <BW Server>:<Port>

also in iView provide appropriate query parameters.

Revert back to me for any further help.

with regards,

Amol

[Former Member]

Thanks for your solution.

Now I am getting one more error,while trying for preview i am getting the following.

<b>"Web application processing terminated"</b>

In query string what we have to give???

Thanks

Chandra

[Former Member]

Hi Chandra,

Suppose u have following test URL of BW report

"http://<BW Server with FQDN>:<Port>/sap/bw/BEx?sap-language=EN&bsplanguage=EN&cmd=ldoc&INFOCUBE=0BBP_SC&QUERY=0BBP_SC_Q004"

then in BEx query string under Iview properties enter the URL part which comes after "?" i.e. sap-language=EN&bsplanguage=EN&cmd=ldoc&INFOCUBE=0BBP_SC&QUERY=0BBP_SC_Q004.

Actually iView will ceate the whole URL as

WAS protocol + WAS hostname + WAS path + BEx Query String

So ultimately u will get the above mentioned BW test url.

With regards,

Amol.

[Former Member]

Thanks Amol,

Its working fine.

regards,

Chandra