MS SQL Analysis Service

Hi,

I'm getting the following error when i try to connect with database connector using jdbc4olap driver to our MS SQL analysis server. 

ERROR Database Connector   5:73       Execute failed: Could not create connection to database: Connect 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
 

Any help pl?

Rajesh

Hi Rajesh,

It looks like you do not have the privileges to establish the connection with MS SQL Analytics.

Would it be possible for you to share the full log file with the stacktrace of the error?

Thank you,

Cheers,

Vincenzo

Thanks Vince. Same credentials work on Excel or PowerBI. 

Here is the error: 

ERROR Database Connector 0:48 Execute failed: Could not create connection to database: Connect 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:310)

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

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

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

at org.jdbc4olap.jdbc.OlapNonRegisteringDriver.connect(OlapNonRegisteringDriver.java:79)

at org.knime.core.node.port.database.DatabaseWrappedDriver.connect(DatabaseWrappedDriver.java:81)

at org.knime.core.node.port.database.connection.CachedConnectionFactory.createConnection(CachedConnectionFactory.java:320)

at org.knime.core.node.port.database.connection.CachedConnectionFactory.createConnection(CachedConnectionFactory.java:301)

at org.knime.core.node.port.database.connection.CachedConnectionFactory$1.call(CachedConnectionFactory.java:225)

at org.knime.core.node.port.database.connection.CachedConnectionFactory$1.call(CachedConnectionFactory.java:1)

at org.knime.core.util.ThreadUtils$CallableWithContextImpl.callWithContext(ThreadUtils.java:344)

at org.knime.core.util.ThreadUtils$CallableWithContext.call(ThreadUtils.java:244)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

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)

... 18 more

Caused by: com.sun.xml.messaging.saaj.util.JaxmURI$MalformedURIException: Host is not a well formed address!

at com.sun.xml.messaging.saaj.util.JaxmURI.setHost(JaxmURI.java:940)

at com.sun.xml.messaging.saaj.util.JaxmURI.initializeAuthority(JaxmURI.java:615)

at com.sun.xml.messaging.saaj.util.JaxmURI.initialize(JaxmURI.java:392)

at com.sun.xml.messaging.saaj.util.JaxmURI.<init>(JaxmURI.java:186)

at com.sun.xml.messaging.saaj.util.JaxmURI.<init>(JaxmURI.java:170)

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

... 19 more

caused by: unknown

 

Hi,

this seems to be a problem with the host address

Caused by: com.sun.xml.messaging.saaj.util.JaxmURI$MalformedURIException: Host is not a well formed address!

Bye

Tobias