SOAP Connection Error

[Former Member]

Hello experts

When I am trying to connect JDBC to BW i got the below error

java.sql.SQLException: Connect error: Connection initialization error:Error in soap call: java.security.PrivilegedActionException: com.sun.xml.messaging.saaj.SOAPExceptionImpl: Message send failed

Caused by: null

Cause Stack Trace: java.security.PrivilegedActionException: com.sun.xml.messaging.saaj.SOAPExceptionImpl: Message send failed

at java.security.AccessController.doPrivileged(Native Method)

at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:140)

at org.jdbc4olap.xmla.XmlaConn.discover(XmlaConn.java:262)

at org.jdbc4olap.xmla.XmlaConn.discoverDatasource(XmlaConn.java:302)

at org.jdbc4olap.xmla.XmlaConn.<init>(XmlaConn.java:108)

at org.jdbc4olap.jdbc.OlapConnection.<init>(OlapConnection.java:68)

at org.jdbc4olap.jdbc.OlapDriver.connect(OlapDriver.java:87)

at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)

at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:368)

at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)

at java.lang.Thread.run(Unknown Source)

Caused by: com.sun.xml.messaging.saaj.SOAPExceptionImpl: Message send failed

at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:344)

at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection$PriviledgedPost.run(HttpSOAPConnection.java:169)

... 12 more

Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: protocol = http host = null

at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.getHeaderField(Unknown Source)

at java.net.HttpURLConnection.getResponseCode(Unknown Source)

at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:311)

... 13 more

Caused by: java.lang.IllegalArgumentException: protocol = http host = null

at sun.net.spi.DefaultProxySelector.select(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.followRedirect(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)

... 15 more

Caused by: unknown

Caused by: unknown

Caused by: uknown

at org.jdbc4olap.jdbc.OlapDriver.connect(OlapDriver.java:89)

at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)

at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:368)

at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)

at java.lang.Thread.run(Unknown Source)

Can you please guide me.

Thanks

[markus_doehr2 · Accepted solution]

> Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: protocol = http host = null

It seems you omitted the hostname somewhere....

Markus

[Former Member · Accepted solution]

thanks all

Where can give the name?? I am trying to connect JDBC to bw using SquirreL

Thanks

[Former Member]

Hi

Give SOAP IP Address/hostname correctly

Fixed soap address location URL pattern to be properly replaced in runtime:

- <soap:address location='http:unknown-location-uri'/>

+ <soap:address location='REPLACE_WITH_ACTUAL_URL'/>

and aslo check all parameters in jco.

Regards,

Srini Nookala

[Former Member]

I thought the problem is with the web services of SOAP in BW.

is itn't??

Can you tell me more specific

Rao

[Former Member]

Hi,

This problem is based on Java Stack.

Check with links

1. http://help.sap.com/javadocs/NW04S/current/bi/installation.html

2. https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/92d80512-0a01-0010-32a3-cd3735bd...

3. http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm

Regards,

Srini Nookala