2 Replies Latest reply on May 26, 2017 2:02 AM by Smbdy Smbdy

    "Information type out of range" with custom driver

    Smbdy Smbdy

      I'm developing a custom JDBC driver with Calcite framework and using Easysoft (also tried Openlink) odbc-jdbc bridge on Win 7 32 bit.

       

      The odbc connection works in general, I've tested with Microsoft ODBC Testing Tool and was able to query data.

       

      When I set up a new connection in Tableau there is no panel with tables/schema search.

      Screen Shot 2017-05-16 at 8.27.00 PM.png

       

      Looking at the logs I see a few errors about not being able to execute prepared statements with TOP/Subqueries/Creating Tables/etc that in my understanding is okay. Those are transformed into driver compatibility warnings on Tableau UI.

       

      One error that looks suspicious is below. How can I troubleshoot it? How to understand what is causing an issue?

       

      {"ts":"2017-05-16T01:32:12.546","pid":2424,"tid":"330","sev":"info","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"msg","v":"GenericODBCProtocol: DBMS Server version: 1.11.0","ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.546","pid":2424,"tid":"330","sev":"info","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"msg","v":"GenericODBCProtocol: driver version: 02.05.0000","ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.546","pid":2424,"tid":"330","sev":"info","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"msg","v":"GenericODBCProtocol: driver ODBC version: 03.51","ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.546","pid":2424,"tid":"330","sev":"info","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"msg","v":"GenericODBCProtocol: ODBC Driver Manager version: 03.80.0000","ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.797","pid":2424,"tid":"330","sev":"warn","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"database-error","v":{"error-records":[{"error-desc":"[Easysoft][ODBC-JDBC Gateway][Calcite]Information type out of range","error-record":1,"native-error":0,"sql-state":"HY096","sql-state-desc":"SQLSTATE_API_GETINFO_INVALID_TYPE"}],"file":"d:\\tc\\builds\\tableau-17-q1\\tableau-17-q1.17.0328.0755\\modules\\connectors\\tabmixins\\main\\db\\ODBCProtocolImpl.cpp","line":6178,"protocol":"4af01e0","retcode":-1,"retcode-desc":"SQL_ERROR"},"ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.805","pid":2424,"tid":"330","sev":"info","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"construct-protocol","v":{"attributes":{":odbc-hwnd":"",":odbc-prompt":"",":protocol-customizations":"",":thread-session":"0","class":"genericodbc","dbname":"","odbc-connect-string-extras":"","odbc-dbms-name":"Calcite","odbc-driver":"Easysoft ODBC-JDBC Gateway","odbc-dsn":"Easysoft mine","odbc-suppress-connection-pooling":"","odbc-use-connection-pooling":"","password":"********","port":"","server":"","username":"admin"},"created":"5/16/2017 1:32:10 AM","created-elapsed":1.927,"disconnected":false,"id":0,"this":"0x04af01e0"},"ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.806","pid":2424,"tid":"149c","sev":"info","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"protocol-added-to-group","v":{"group":{"attributes":{":odbc-hwnd":"",":odbc-prompt":"2",":protocol-customizations":"","class":"genericodbc","dbname":"","odbc-connect-string-extras":"","odbc-dbms-name":"","odbc-driver":"Easysoft ODBC-JDBC Gateway","odbc-dsn":"Easysoft mine","odbc-suppress-connection-pooling":"","odbc-use-connection-pooling":"","password":"","port":"","server":"","username":""},"closed-protocols-count":"0","connection-limit":"1","group-id":"0","in-construction-count":"0","protocols-count":"1","this":"0x04ab61f0"},"protocol-id":"0"},"ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}

      {"ts":"2017-05-16T01:32:12.807","pid":2424,"tid":"149c","sev":"warn","req":"-","sess":"-","site":"{2DFFD58A-1263-42E5-814C-303FD9F66F32}","user":"-","k":"connection-info-mismatch","v":{":odbc-hwnd":"<empty>",":odbc-prompt":"(MISMATCH) <empty> <=> 2",":protocol-customizations":"<empty>",":thread-session":"(MISMATCH) 0 <=> <missing>","class":"genericodbc","dbname":"<empty>","odbc-connect-string-extras":"<empty>","odbc-dbms-name":"(MISMATCH) Calcite <=> <empty>","odbc-driver":"Easysoft ODBC-JDBC Gateway","odbc-dsn":"Easysoft mine","odbc-suppress-connection-pooling":"<empty>","odbc-use-connection-pooling":"<empty>","password":"(MISMATCH) ******** <=> <empty>","port":"<empty>","server":"<empty>","username":"(MISMATCH) admin <=> <empty>"},"ctx":{"client-type":"desktop","procid":"6008","tid":"6048","version":"10200.17.0328.0755"}}