Need a special offer?Find out if your project fits.
+

Kylin Mondrian Integration with FlexMonster facing Error while creating SQL connection issue

Resolved
Vidyasagar Gudapati asked on February 13, 2017

Hello,

Am trying to connect Flexmonster to Kylin through Mondrian as JDBC connection.
As I tried with MySQL and Postgres by providing JDBC Connection params and succeeded, i would like to try similar fashion with Kylin JDBC. 

I tried JDBC connectivity through Java JDBC Code and it is working fine. But Am facing below issue when trying with flexmonster.config :

vidya@localhost:~/PMondrian/server$ java -jar flexmonster-proxy-mondrian-4.jar 
[2017-02-13 14:08:28] INFO: Flexmonster Data Speed Accelerator for Pentaho Mondrian 4.4
[2017-02-13 14:08:28] INFO: Version 2.303
[2017-02-13 14:08:28] INFO: 
log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
log4j:WARN Please initialize the log4j system properly.
[2017-02-13 14:08:28] INFO: Reading config...
[2017-02-13 14:08:28] INFO: Reading config - OK
[2017-02-13 14:08:28] INFO: Loading JDBC driver...
[2017-02-13 14:08:28] INFO: Driver path: jar:file:./kylin-jdbc-1.0-incubating.jar!/
[2017-02-13 14:08:28] INFO: Driver class name: org.apache.kylin.jdbc.Driver
[2017-02-13 14:08:28] INFO: Loading JDBC driver - OK
[2017-02-13 14:08:28] INFO: 
[2017-02-13 14:08:28] INFO: Testing connection...
[2017-02-13 14:08:28] INFO: 
[2017-02-13 14:08:28] INFO: Starting server...
2017-02-13 14:08:28.361:INFO::main: Logging initialized @210ms
2017-02-13 14:08:28.446:INFO:oejs.Server:main: jetty-9.2.z-SNAPSHOT
2017-02-13 14:08:29.580:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@2a1f3166{/,null,AVAILABLE}
2017-02-13 14:08:29.590:INFO:oejs.ServerConnector:main: Started ServerConnector@65b32b8f{HTTP/1.1}{0.0.0.0:50007}
2017-02-13 14:08:29.590:INFO:oejs.Server:main: Started @1439ms
[2017-02-13 14:08:29] INFO: Starting server - OK
[2017-02-13 14:08:29] INFO: Server is running at http://localhost:50007/
[2017-02-13 14:08:35] INFO: Handshaking...
[2017-02-13 14:08:35] INFO: Loading dimensions...
[2017-02-13 14:08:36] SEVERE: Mondrian Error:Internal error: Error while creating SQL connection: 
Jdbc=jdbc:kylin://localhost:7070/AdventureWorks?JdbcUser=admin&JdbcPassword=KYLIN
Any help will be much appreciated. 
Thanks in advance! 
 

4 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster February 13, 2017

Hello Vidyasagar,
Thank you for your question. We have noticed that your connection string is a little bit different from the one we have in our documentation. Could you please replace 'JdbcUser' with 'user' and 'JdbcPassword' with 'password' ? Here is an example -

Jdbc=jdbc:kylin://localhost:7070/AdventureWorks?user=admin&password=KYLIN;JdbcDrivers=org.apache.kylin.jdbc.Driver;

If the issue still occurs please try to separate username and password with ';' like in the following example:

Jdbc=jdbc:kylin://localhost:7070/AdventureWorks;JdbcUser=admin;JdbcPassword=KYLIN;JdbcDrivers=org.apache.kylin.jdbc.Driver

Please let us know if it solves your issue.
Best regards,
Dmytro.

Public
Vidyasagar Gudapati February 14, 2017

Hello Dmytro,
 
Thanks for your response. 
 
I have tried to change Connection URL as you mentioned:
[2017-02-14 10:08:37] INFO: Flexmonster Data Speed Accelerator for Pentaho Mondrian 4.4
[2017-02-14 10:08:37] INFO: Version 2.303
[2017-02-14 10:08:37] INFO: 
log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
log4j:WARN Please initialize the log4j system properly.
[2017-02-14 10:08:37] INFO: Reading config...
[2017-02-14 10:08:37] INFO: Reading config - OK
[2017-02-14 10:08:37] INFO: Loading JDBC driver...
[2017-02-14 10:08:37] INFO: Driver path: jar:file:./kylin-jdbc-1.0-incubating.jar!/
[2017-02-14 10:08:37] INFO: Driver class name: org.apache.kylin.jdbc.Driver
[2017-02-14 10:08:37] INFO: Loading JDBC driver - OK
[2017-02-14 10:08:37] INFO: 
[2017-02-14 10:08:37] INFO: Testing connection...
[2017-02-14 10:08:37] INFO: jdbc:kylin://localhost:7070/AdventureWorks&user=admin&password=KYLIN
[2017-02-14 10:08:38] SEVERE: Data Source connection - FAILED
[2017-02-14 10:08:38] SEVERE: java.io.IOException: org.apache.commons.httpclient.methods.PostMethod@280b532e failed, error code 401 and response: <html><head><title>Apache Tomcat/7.0.69 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 401 - Unauthorized</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Unauthorized</u></p><p><b>description</b> <u>This request requires HTTP authentication.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.69</h3></body></html>
 
I somehow believe it is connecting to RestAPI Client rather as JDBC Connection. 
 
Looking forward to hear from you.
 
Best Regards,
Vidy

Public
Vidyasagar Gudapati February 14, 2017

Hello Dmytro,
 
It is working finally. 
 
CONNECTION_STRING=JDbc=jdbc:kylin://localhost:7070/AdventureWorks;JdbcUser=admin;JdbcPassword=KYLIN;JdbcDrivers=org.apache.kylin.jdbc.Driver;
This is what it made work! 
 
But am facing new issue here:
 
SEVERE: Mondrian Error:Internal error: Reading row count from table [null, null, PRODUCT]; sql=[select count(*) from "PRODUCT"]
 
I think this is something we need to do with Mondrian XML file. 
 
Best Regards,
Vidy

Public
Tanya Gryshko Tanya Gryshko Flexmonster February 14, 2017

Hello Vidy,
Thanks for the update. It seems that the problem is with Mondrian XML file.
Regards,
Tanya

Please login or Register to Submit Answer