Re: Unknown exception. Jdbc operation attempted: MIX_JdbcCatalog_execTables

[Li Yang <li...@apache.org>]

The direct cause is Kylin JDBC ResultSet does not support the previous()
operation.

Is there any way to workaround in MSTR avoiding calling previous()? Or
maybe try connect via ODBC.

On Tue, Aug 22, 2017 at 5:53 PM, alantt <al...@rakuten.com> wrote:

> 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.
>