2 Replies Latest reply on Apr 2, 2018 4:13 AM by Ji ZHANG

    Latest Tableau 10.5 is unable to open workbook linking SQLite database created in Tableau 10.4

    Ji ZHANG

      I got the following error while opening a workbook linking to SQLite database after I upgrade to Tableau 10.5 yesterday.

       

      May I ask if anybody has experienced similar problem, what does it mean and how to solve this issue?

       

      Shall I roll back to v10.4 if the recent upgrade has problems?

       

      PS: I just rolled back to v10.4 which has no such issue using the same workbook and SQLite database. So I assume this is an issue particular to v10.5. Hope the Tableau development team can check and solve this issue.

       

      The error message:

      Image 5.png

       

      Here is the info showing in the Debug window:

      SELECT "t0"."sum_cooling_energy_use_considering_cooling_COP__kWh___copy__ok" AS "TEMP_Calculation_BBCIBFBHHDAEHGCHHIE__CAGFAGJCJC__A_",
        "t0"."sum_energy_use___cooling_considering_cooling_COP__copy__ok" AS "TEMP_Calculation_BBCIBFBHHDAEHGCHHIE__DEFJHHBJEI__A_",
        "t0"."TEMP_Calculation_BBCIBFBHHDAEHGCHHIE__DFBAGCHEHA__A_" AS "TEMP_Calculation_BBCIBFBHHDAEHGCHHIE__DFBAGCHEHA__A_",
        "t2"."X_measure__E" AS "TEMP_Calculation_BBCIBFBHHDAHJCCEDEB__JIFEHJDBE__A_",
        "t0"."sum_electric_energy_for_lights__kWh___copy__ok" AS "TEMP_energy_use___electricity_for_electric_equipment__kWh___copy___CFJFAAIJGA__A_",
        "t0"."sum_Calculation_BBCIBFBHHDAEDEBCJJJ_ok" AS "TEMP_energy_use___electricity_for_lights__kWh___copy___CAJADAFIIB__A_",
        "t0"."sum_Calculation_BBCIBFBHHDAEDEBCJJJ_ok" AS "sum_Calculation_BBCIBFBHHDAEDEBCJJJ_ok",
        "t0"."sum_cooling_energy_use_considering_cooling_COP__kWh___copy__ok" AS "sum_cooling_energy_use_considering_cooling_COP__kWh___copy__ok",
        "t0"."sum_electric_energy_for_lights__kWh___copy__ok" AS "sum_electric_energy_for_lights__kWh___copy__ok",
        "t0"."sum_energy_use___cooling_considering_cooling_COP__copy__ok" AS "sum_energy_use___cooling_considering_cooling_COP__copy__ok"
      FROM (
        SELECT SUM((CASE WHEN ("ReportDataDictionary"."Name" = 'Electricity:Building') THEN (CASE WHEN 1000 = 0 THEN NULL ELSE (CASE WHEN 3600 = 0 THEN NULL ELSE "ReportData"."Value" / 3600 END) / 1000 END) ELSE 0 END)) AS "TEMP_Calculation_BBCIBFBHHDAEHGCHHIE__DFBAGCHEHA__A_",
          SUM((CASE WHEN ("ReportDataDictionary"."Name" = 'Zone Lights Electric Energy') THEN (CASE WHEN 1000 = 0 THEN NULL ELSE (CASE WHEN 3600 = 0 THEN NULL ELSE "ReportData"."Value" / 3600 END) / 1000 END) ELSE 0 END)) AS "sum_Calculation_BBCIBFBHHDAEDEBCJJJ_ok",
          SUM((CASE WHEN ("ReportDataDictionary"."Name" = 'Zone Ideal Loads Supply Air Total Heating Energy') THEN (CASE WHEN 1000 = 0 THEN NULL ELSE (CASE WHEN 3600 = 0 THEN NULL ELSE (CASE WHEN 3 = 0 THEN NULL ELSE "ReportData"."Value" / 3 END) / 3600 END) / 1000 END) ELSE NULL END)) AS "sum_cooling_energy_use_considering_cooling_COP__kWh___copy__ok",
          SUM((CASE WHEN ("ReportDataDictionary"."Name" = 'Zone Electric Equipment Electric Energy') THEN (CASE WHEN 1000 = 0 THEN NULL ELSE (CASE WHEN 3600 = 0 THEN NULL ELSE "ReportData"."Value" / 3600 END) / 1000 END) ELSE 0 END)) AS "sum_electric_energy_for_lights__kWh___copy__ok",
          SUM((CASE WHEN ("ReportDataDictionary"."Name" = 'Zone Ideal Loads Supply Air Total Cooling Energy') THEN (CASE WHEN 1000 = 0 THEN NULL ELSE (CASE WHEN 3600 = 0 THEN NULL ELSE (CASE WHEN 4.5 = 0 THEN NULL ELSE "ReportData"."Value" / 4.5 END) / 3600 END) / 1000 END) ELSE NULL END)) AS "sum_energy_use___cooling_considering_cooling_COP__copy__ok"
        FROM "ReportDataDictionary"
          INNER JOIN "ReportData" ON ("ReportDataDictionary"."ReportDataDictionaryIndex" = "ReportData"."ReportDataDictionaryIndex")
          INNER JOIN "Time" ON ("ReportData"."TimeIndex" = "Time"."TimeIndex")
          LEFT JOIN "Zones" ON ("ReportDataDictionary"."KeyValue" = "Zones"."ZoneName")
        GROUP BY 1
      ) "t0"
        CROSS JOIN (
        SELECT SUM("t1"."X_measure__C") AS "X_measure__E"
        FROM (
          SELECT MIN("Zones"."FloorArea") AS "X_measure__C",
            "Zones"."ZoneIndex" AS "ZoneIndex"
          FROM "ReportDataDictionary"
            INNER JOIN "ReportData" ON ("ReportDataDictionary"."ReportDataDictionaryIndex" = "ReportData"."ReportDataDictionaryIndex")
            INNER JOIN "Time" ON ("ReportData"."TimeIndex" = "Time"."TimeIndex")
            LEFT JOIN "Zones" ON ("ReportDataDictionary"."KeyValue" = "Zones"."ZoneName")
          GROUP BY 2
        ) "t1"
        GROUP BY 1
      ) "t2"
      

       

      Message was edited by: Joe Smith