Hello! 

Kylin 2.0
JDBC 2.0
Microstrategy 10.4 Linux

I am trying to connect using Microstrategy, a BI tool. I am using the GUI to
pick the tables. I can see the metadata for the tables in our new Kylin
environment but when I select on a table I get an error.

..
        2017-08-22 18:01:44.623+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:CastorServer][PID:39561][THR:2096690944][Catalog
Server 2][Error][0x80041404] Database error <3>:
JdbcCatalogWrapper::ExecTables failed. Disconnected.
Error type: Unknown exception. Jdbc operation attempted:
MIX_JdbcCatalog_execTables.
2017-08-22 18:01:51.199+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:][PID:18423][THR:4031174400][JdbcWrapper][Error]
JdbcUnknowException occur. Error Message: , Java Trace:
java.lang.UnsupportedOperationException
        at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaResultSet.previous(AvaticaResultSet.java:461)
        at com.microstrategy.database.Jdbc.JdbcCatalog.execTables(Unknown
Source)
, Connection String:
JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_mart_rat_session_summary;UID=ADMIN;,
Statement String:
2017-08-22 18:01:51.200+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:CastorServer][PID:39561][THR:2107197184][Database
Classes][Error] JdbcCatalogWrapper::ExecTables failed. Disconnected.
Error type: Unknown exception. Jdbc operation attempted:
MIX_JdbcCatalog_execTables. Connection String:
JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_mart_rat_session_summary;UID=ADMIN;.
2017-08-22 18:01:51.205+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:CastorServer][PID:39561][THR:2107197184][Catalog
Server 2][Error][0x80041404] Database error <3>:
JdbcCatalogWrapper::ExecTables failed. Disconnected.
Error type: Unknown exception. Jdbc operation attempted:
MIX_JdbcCatalog_execTables.
2017-08-22 18:01:56.157+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:][PID:18491][THR:249493248][JdbcWrapper][Error]
JdbcUnknowException occur. Error Message: , Java Trace:
java.lang.UnsupportedOperationException
        at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaResultSet.previous(AvaticaResultSet.java:461)
        at com.microstrategy.database.Jdbc.JdbcCatalog.execTables(Unknown
Source)
, Connection String:
JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_mart_rat_session_summary;UID=ADMIN;,
Statement String:
2017-08-22 18:01:56.158+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:CastorServer][PID:39561][THR:2107197184][Database
Classes][Error] JdbcCatalogWrapper::ExecTables failed. Disconnected.
Error type: Unknown exception. Jdbc operation attempted:
MIX_JdbcCatalog_execTables. Connection String:
JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_mart_rat_session_summary;UID=ADMIN;.
2017-08-22 18:01:56.163+09:00
[HOST:ared302.db.rakuten.co.jp][SERVER:CastorServer][PID:39561][THR:2107197184][Catalog
Server 2][Error][0x80041404] Database error <3>:
JdbcCatalogWrapper::ExecTables failed. Disconnected.
Error type: Unknown exception. Jdbc operation attempted:
MIX_JdbcCatalog_execTables.

Any thoughts would be welcome.

regards,



--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/Unknown-exception-Jdbc-operation-attempted-MIX-JdbcCatalog-execTables-tp8777.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Reply via email to