We have just upgraded our Qlik Sense environment from the November 2018 Patch 2 to the September 2019 release. A number of our apps are giving me this error now when I attempt to reload the data:
The following error occurred:
Unable to get column information for the fields that are used in the query: Object reference not set to an instance of an object.
The error occurred here:
SQL SELECT DISTINCT PERIOD_VALUE ,PERIOD_START_DT_LAST_12 ,PERIOD_END_DT_LAST_12 ,PERIOD_START_DT ,PERIOD_END_DT ,YEAR_DT ,1 as My_Count ,AS_OF_DATE INTO #DATE_TABLE --drop table #DATE_TABLE FROM (SELECT 'CY' PERIOD_VALUE ,DATEADD(MONTH, -11, PERIOD_END_DT) PERIOD_START_DT_LAST_12 ,EOMONTH(PERIOD_END_DT) PERIOD_END_DT_LAST_12 ,DATEADD(MONTH, -23, PERIOD_END_DT) PERIOD_START_DT ,EOMONTH(A.PERIOD_END_DT) PERIOD_END_DT ,YEAR(PERIOD_END_DT) YEAR_DT ,CAST(DATEADD(DAY, -1, GETDATE()) AS DATE) AS_OF_DATE FROM (SELECT DATEADD(DAY, -(DAY(GETDATE()) - 1), CAST(GETDATE() AS DATE)) PERIOD_END_DT) A UNION SELECT 'PY' PERIOD_VALUE ,DATEADD(MONTH, -23, PERIOD_END_DT) PERIOD_START_DT_LAST_12 ,EOMONTH(DATEADD(MONTH, -12, PERIOD_END_DT)) PERIOD_END_DT_LAST_12 ,DATEADD(MONTH, -35, PERIOD_END_DT) PERIOD_START_DT ,EOMONTH(DATEADD(MONTH, -12, PERIOD_END_DT)) PERIOD_END_DT ,YEAR(DATEADD(MONTH, -12, PERIOD_END_DT)) YEAR_DT ,CAST(DATEADD(YEAR, -1, DATEADD(DAY, -1, GETDATE())) AS DATE) AS_OF_DATE FROM (SELECT DATEADD(DAY, -(DAY(GETDATE()) - 1), CAST(GETDATE() AS DATE)) PERIOD_END_DT) A) A
We are using the Microsoft SQL Server connection type (connected to a SQL Server 2016 database). The connections work, I can use the data connector tool to look at the database structure and data. No changes were made to the app itself.
Any ideas what could be causing this error?
