topic Re: SQL error after upgrading to February 2019 in Connectivity & Data Prep

SQL error after upgrading to February 2019

parayu — Fri, 03 May 2019 07:45:24 GMT

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

Re: SQL error after upgrading to February 2019

parayu — Fri, 03 May 2019 10:59:48 GMT

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

Re: SQL error after upgrading to February 2019

Anda_P — Wed, 08 May 2019 08:44:09 GMT

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

Re: SQL error after upgrading to February 2019

mnickolqlik — Wed, 18 Sep 2019 09:58:24 GMT

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-disabled-Please-contact-your-system-administrator-to-enable-it?articleId=Connector-reply-error-Executing-non-SELECT-queries-is-disabled-Please-contact-your-system-administrator-to-enable-it

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

Best regards,

The Fitness Captain