1 Reply Latest reply on Feb 20, 2020 3:02 AM by Arnon Shimoni

    Error while creating extract from Tableau with SQream DB

    Gatik Vij

      Hello everyone,

       

      We are trying to connect to SQream DB with Tableau Desktop and create an extract but getting the following error.

       

      An error occurred while communicating with the Other Databases (ODBC) data source 'table1 (public.table1) (tablename)’.

       

      Bad Connection: Tableau could not connect to the data source.

      Error Code: 9F80FB23

      [SQream DB Server][UltraLight] (1040) ..\SQream-cpp-connector.cc:103 in sqream::connection_t::read(): socket failed to read content

      Unable to create extract

      SELECT "table1"."accountid" AS "accountid",

        "table1"."accountname" AS "accountname",

        "table1"."actualdonetime" AS "actualdonetime",

        "table1"."actualsender" AS "actualsender",

        "table1"."author" AS "author",

        "table1"."bearer" AS "bearer",

        "table1"."broadcastflag" AS "broadcastflag",

        "table1"."broadcastid" AS "broadcastid",

        "table1"."broadcastname" AS "broadcastname",

        "table1"."bufferid" AS "bufferid",

        "table1"."circleid" AS "circleid",

        "table1"."circlename" AS "circlename",

        "table1"."contenttype" AS "contenttype",

        "table1"."countrycode" AS "countrycode",

        "table1"."countryname" AS "countryname",

        "table1"."deliveryflag" AS "deliveryflag",

        "table1"."dlrstatusflag" AS "dlrstatusflag",

        "table1"."dndflag" AS "dndflag",

        "table1"."enterpriseid" AS "enterpriseid",

        "table1"."enterprisename" AS "enterprisename",

        "table1"."failedcode" AS "failedcode",

        "table1"."faileddesc" AS "faileddesc",

        "table1"."freefield1" AS "freefield1",

        "table1"."freefield2" AS "freefield2",

        "table1"."gmtrequestflag" AS "gmtrequestflag",

        "table1"."groupaccountid" AS "groupaccountid",

        "table1"."groupaccountname" AS "groupaccountname",

        "table1"."hashmessageid" AS "hashmessageid",

        "table1"."hashresponseid" AS "hashresponseid",

        "table1"."id" AS "id",

        "table1"."insert_datetime" AS "insert_datetime",

        "table1"."intflag" AS "intflag",

        "table1"."joinid" AS "joinid",

        "table1"."lastupdatetime" AS "lastupdatetime",

        "table1"."listenerapiflag" AS "listenerapiflag",

        "table1"."messageid" AS "messageid",

        "table1"."messagelanguage" AS "messagelanguage",

        "table1"."messagetext" AS "messagetext",

        "table1"."misdate" AS "misdate",

        "table1"."mnpretrycount" AS "mnpretrycount",

        "table1"."msisdn" AS "msisdn",

        "table1"."operatorid" AS "operatorid",

        "table1"."operatorname" AS "operatorname",

        "table1"."operatorseries" AS "operatorseries",

        "table1"."priority" AS "priority",

        "table1"."receivedsdate" AS "receivedsdate",

        "table1"."receivedsender" AS "receivedsender",

        "table1"."requestreceivedtime" AS "requestreceivedtime",

        "table1"."responseid" AS "responseid",

        "table1"."rowid" AS "rowid",

        "table1"."shardedmsisdn" AS "shardedmsisdn",

        "table1"."siurl" AS "siurl",

        "table1"."slafailedcode" AS "slafailedcode",

        "table1"."slafaileddesc" AS "slafaileddesc",

        "table1"."slafaileddescenum" AS "slafaileddescenum",

        "table1"."slastatus" AS "slastatus",

        "table1"."slastatusdesc" AS "slastatusdesc",

        "table1"."smscid" AS "smscid",

        "table1"."smscname" AS "smscname",

        "table1"."smscount" AS "smscount",

        "table1"."smscredits" AS "smscredits",

        "table1"."source" AS "source",

        "table1"."sourceaccountid" AS "sourceaccountid",

        "table1"."status" AS "status",

        "table1"."statusdesc" AS "statusdesc",

        "table1"."statusdescenum" AS "statusdescenum",

        "table1"."subauthor" AS "subauthor",

        "table1"."subenterpriseid" AS "subenterpriseid",

        "table1"."subenterprisename" AS "subenterprisename",

        "table1"."submittime" AS "submittime",

        "table1"."templateid" AS "templateid",

        "table1"."templatetimingflag" AS "templatetimingflag"

      FROM "public"."table1" "table1"