search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
252 stars 88 forks source link

ODBC driver causes failed refresh of dashboards in Power BI #446

Open Michael11l opened 4 months ago

Michael11l commented 4 months ago

We used clickhouse db on our server and use data from there in power bi, but we are not able to refresh it everytime, it refreshes around 50%of the time successfully. To connect to this data we use gateway from microsoft and odbc driver from CH. Microsoft checked all logs in their services and didn't find that something was wrong on their side and they advised to contact you. The message error is: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ERROR [HY000] Incomplete input stream, expected at least 17 more bytes"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Deposits and users data. FYI @support@clickhouse.com (Sante) ClickHouse Case #00013258

brucezzchen commented 2 months ago

Our situation is the same, and the error happens randomly

SpencerTorres commented 2 months ago

Similar error message here https://github.com/ClickHouse/clickhouse-odbc/issues/419

ashish135906 commented 1 month ago

Same happening with us too. @mshustov Are issues being resolved actively?

mshustov commented 1 month ago

To start the investigation, we need more information to reproduce the problem:

  1. ClickHouse and driver versions
  2. OS
  3. query log for the period when the problem happens
  4. the driver logs for the period when the problem happens. The logging might be enabled via DriverLog and DriverLogFile DSN parameters: https://github.com/ClickHouse/clickhouse-odbc/blob/2f55d016420af9dfbd503ba122c0c1549c180363/packaging/odbc.ini.sample#L36-L37
  5. DDL for a query target table