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.