topic Re: Internal engine error when exporting a straight table with conditions for showing columns in App Development

Internal engine error when exporting a straight table with conditions for showing columns

sgrubic — Mon, 16 Jul 2018 14:17:57 GMT

Hello, everyone,

In Qlik Sense June 2018 (both Desktop and Enterprise), while exporting data from a straight table, we get "Internal engine error", which occasionally causes the Qlik Sense Engine Service to crash. This only happens for certain combinations of the number and order of shown/hidden columns (see image below; also shown in qvf).

For example, in a straight table with five dimensions and one measure, if any one dimension is hidden, then exporting works fine. If there are two hidden dimensions, then exporting only works if the bottommost dimension isn't hidden. If there are three hidden dimensions, then all three of them should be at the top for export to work. If there are more than three hidden dimensions, exporting never works, regardless of the column order. In all these cases, the one measure wasn't hidden.

Steps to reproduce:

Make an app with five dimensions and one measure.
Put them all in a table.
Set "Show column if" to "0" for a combination of columns. (It seems like you're more likely to get the error if there are fewer visible columns.)
Right-click the table, click Export, and then Export data.

Can anyone confirm this behavior; perhaps even explain it?

Thanks!

Re: Internal engine error when exporting a straight table with conditions for showing columns

petter — Mon, 16 Jul 2018 23:04:18 GMT

If I were you I would contact Qlik Support immediately...

Re: Internal engine error when exporting a straight table with conditions for showing columns

sgrubic — Tue, 17 Jul 2018 15:17:16 GMT

I took your advice and they said there are two bugs regarding this issue already reported, and in "Ready for verification" state. I'll post here when there are any news.

Re: Internal engine error when exporting a straight table with conditions for showing columns

vinodkumarv27 — Thu, 09 Aug 2018 13:08:46 GMT

Hi,

Did you get any update from them. Looks like, bug is not fixed yet!!!

Thanks

Re: Internal engine error when exporting a straight table with conditions for showing columns

sgrubic — Fri, 10 Aug 2018 07:29:29 GMT

Hey,

Their support said the fix should be included in Qlik Sense September 2018 release (but they don't have any fixed dates yet).

Re: Internal engine error when exporting a straight table with conditions for showing columns

Anonymous — Thu, 16 Aug 2018 08:43:45 GMT

Any updates on this error?

Thanks

Re: Internal engine error when exporting a straight table with conditions for showing columns

sgrubic — Mon, 20 Aug 2018 11:53:31 GMT

Nope, still waiting for September 2018 release.

Re: Internal engine error when exporting a straight table with conditions for showing columns

sgrubic — Tue, 28 Aug 2018 13:04:02 GMT

They've updated their answer:

"The fix will be included in Qlik Sense June 2018 Patch 1 that should come out soon and as well it will be included in QS September 2018."

Re: Internal engine error when exporting a straight table with conditions for showing columns

vinodkumarv27 — Wed, 29 Aug 2018 05:00:36 GMT

Hi Stevan,

Do you have ticket number with you?

Thanks,
Vinod Kumar V

Re: Internal engine error when exporting a straight table with conditions for showing columns

sgrubic — Fri, 31 Aug 2018 07:34:10 GMT

Sure. Qlik Support ticket ID is 01449644.

The two bugs it refers to are:

QLIK-89754
QLIK-89563

Re: Internal engine error when exporting a straight table with conditions for showing columns

sofiene_1920 — Fri, 07 Sep 2018 15:12:36 GMT

Hello,

It was fixed in june update 2018.

Best regards,

Sofiene