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

**Ji ZHANG**Jan 16, 2018 12:54 AM

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:

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