search

OSBI / saiku

Saiku Analytics - The Worlds Greatest Open Source OLAP Browser
http://community.meteorite.bi
Apache License 2.0
1.31k stars 663 forks source link

Cannot connect to OLAP XMLA Datasource #680

Open NicolasBreval opened 5 years ago

NicolasBreval commented 5 years ago

Is this a bug report?

Yes, it's a bug report.

Environment

  1. java -version: 1.8.0_191
  2. node -v (If you use Node.js proxy for Saiku):
  3. npm -v (If you use Node.js proxy for Saiku):
  4. yarn --version (If you use Node.js proxy for Saiku and if you use Yarn):

Then, specify:

  1. Operating system: Windows 10 Pro
  2. Browser and version (if relevant):
  3. Saiku plugin to Pentaho or Saiku Standalone: Saiku Standalone
  4. Saiku CE or Saiku EE: Saiku CE
  5. Saiku version:

Steps to Reproduce

(Write your steps here:)

  1. Create Datasource with Schema (described in "Actual behavior")
  2. Try to create new query
  3. Datasource not respond to query and server prints error in prompt (described in "Actual behavior")

Expected Behavior

I thought it would connect properly.

Actual Behavior

When I saw that the query was not completed, the server returned the following error:

ERROR [SecurityAwareConnectionManager] Error connecting: roles-xmla_olapren java.lang.RuntimeException: org.olap4j.OlapException: This connection encountered an exception while executing a query. at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(DeferredNamedListImpl.java:96)

type=OLAP name=roles-xmla_olapren driver=org.olap4j.driver.xmla.XmlaOlap4jDriver location=jdbc:xmla:Server=http://localhost/OLAPREN/msmdpump.dll username=admin password=admin security.enabled=true security.type=passthrough