SQL error after upgrading to February 2019

[parayu]

Hello guys,

I upgraded Qlik Sense to February 2019 and right after that I started to receive this error:

The following error occurred:

QVX_UNEXPECTED_END_OF_DATA: 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 a.Date

             ,a.MeasurementPeriodId

INTO #MeasurementPeriod

FROM [EDW_XSA].[trg].[MeasurementPeriod] a

The problem comes from that INTO #MeasurementPeriod statement. If I comment it, the script runs without issues. 

Does anyone face this problem also? 

Thank you,

Bogdan

[parayu]

It looks like the Microsoft SQL Server connector is creating this error. I created an ODBC connector to the same database and it looks like the error is gone. Anyway this looks like a bug to me. Please let me know if you encounter the same issue.

Thanks

[Anda_P]

The solution is to downgrade ODBC Connector Package to the previous version (November 2018). Doing so, the Microsoft SQL Server connector  should work properly.

[mnickolqlik]

Hello together,

I suggest reading the related Qlik Knowledge base article instead of recommending downgrading a connector ...

Read this:

https://support.qlik.com/articles/000055503

Article Number: 000055503 | Last Modified: 2019/08/26

and this:

https://support.qlik.com/articles/Basic/Connector-reply-error-Executing-non-SELECT-queries-is-disabl...

Article Number: 000064538 | Last Modified: 2019/09/06

Best regards,

The Fitness Captain