topic Re: ApplyMap bug - apps hanging on 12.1 SR2 / SR3 in QlikView

ApplyMap bug - apps hanging on 12.1 SR2 / SR3

jrepucci15 — Mon, 26 Jan 2026 18:19:17 GMT

Update: Qlik confirmed the bug - will be fixed in v12.20 and released at the end of 2017.

edit: changed title to include: "ApplyMap bug - " and added "/SR3"

I just stood up a new server (w2012, QV12.1 SR2) and moved my apps from my w2008 QV11.2 SR9 server.

Three apps run just fine on the new server, but one hangs all the time. The QV Mgmt status shows it as running, but it should only take a few minutes and I've let it run as long as 40 minutes before I kill it.

The TaskLog.txt does not show anything useful (Slow down logging. Log every <300> seconds).

When I run the app manually, it hangs as shown below.

And when I abort the app, the QV development app itself hangs and I have to kill it as well.

Any thoughts?

output from Script Execution Progress

================ Start of GenTransaction transform ===================

GenTransaction_Transform1 << GenTransactionC_Extract 25,780 Lines fetched

GenTransaction_Transform1 << GenTransactionA_Extract 322,935 Lines fetched

GenTransaction_Transform1 << GenTransactionB_Extract 371,716 Lines fetched

GenTransaction_Transform1 << CurrentBudget_Transform 422,428 Lines fetched

------------ Store GenTrans1 -----------

--------- Drop GenTrans1 -----------

Code snippet:

FROM $(vExpTransformPath)\CurrentBudget_Transform.qvd (qvd);

STORE GenTransaction_Transform1 into $(vExpTransformPath)\GenTransaction_Transform1.qvd (qvd);

Trace ------------ Store GenTrans1 -----------;

DROP Table GenTransaction_Transform1;

Trace --------- Drop GenTrans1 -----------;

>>>> hangs here >>>>>>

GenTransaction_Transform2:

Load // preceding load

...

Load

...

FROM $(vExpTransformPath)\GenTransaction_Transform1.qvd (qvd);

Trace --------- Just after load GenTrans2 from GenTrans1 -----------;

Re: apps hanging on 12.1 SR2

Chip_Matejowsky — Mon, 20 Feb 2017 20:03:12 GMT

Hi John,

The default timeout value for tasks is 1440 seconds, so if you are certain that the reload should run in a few minutes, I would change the timeout value accordingly so the task will end without your intervention. Then you may consult the task log for more clues as to why.

Hope this helps

-Chip

Re: apps hanging on 12.1 SR2

jrepucci15 — Mon, 20 Feb 2017 20:20:05 GMT

The app in question takes about 2-3 minutes on my current production servers. On the new server it ended after 6 hours due to timeouts. The log did not show anything useful other than "timeout".

20170219T053113.283-0600 Information Reloading..........

20170219T054613.735-0600 Information Slow down logging. Log every <1200> seconds.

20170219T054613.735-0600 Information Reloading

20170219T060219.199-0600 Information DistributeTask[c2e8bd3d-caa4-4f2f-adac-cdd89c44ce5b] ("Expenses and Projects/Insight-Expenses-Transform.qvw"): TryAbort. Triggered by 'RunTimeTrigger'. Id:0000000a-000a-000a-0a0a-161616161616. ExecID:2be86c92-4487-4906-816c-25a21d8e682c

20170219T060229.223-0600 Warning The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).

20170219T060229.242-0600 Information Killing the QlikView Engine. ProcessID=3508

20170219T060229.246-0600 Information Reload was aborted.

Re: apps hanging on 12.1 SR2

jrepucci15 — Mon, 20 Feb 2017 21:45:34 GMT

I've been able to convince myself that the issue due is one expression in a load. While the code works just fine in 11.2, the expression causes QV12 to hang. If I comment that expression, I can get past it. Now to review that code.

Re: apps hanging on 12.1 SR2

rwunderlich — Mon, 20 Feb 2017 22:45:41 GMT

What is the suspected expression?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: apps hanging on 12.1 SR2

jrepucci15 — Tue, 21 Feb 2017 01:48:48 GMT

Hi Rob,

QV 12.1 SR2 hangs if this expression is included, but QV11.2 SR9 accepts this.

The mapping loads work in the expression just above this one.

I built this 2 years ago; I'm trying to decode it to prove that the logic is correct and documenting what it is supposed to do.

IF( Index(Comment,'Sup:') > 0,

// IF the comment contains “Sup:”plier, build key using supplier
GlYear & '_' & GlPeriod & '_' &

       ApplyMap('ValidateMasterProjectNumber_Map' & '-' & GlCode,
               Subfield(TRIM( MID(SubField(Comment,'Sup:',2),INDEX(SubField(Comment, 'Sup:',2) ,' ',1)) ),' ',1),
                'No Project'),

      // if the comment contains “Stk:” stock code, build key using StockCode
IF( Index(Comment, 'Stk:') > 0,
     ApplyMap( 'ValidateMasterProjectNumber_Map',
          ApplyMap('Map_StockCodeToProjectNumber',
                    Trim(SubField(Comment, 'Stk:',2)),
                'No Project'),
           'No Project'),
GlYear & '_' & GlPeriod & '_' &

     ApplyMap('ValidateMasterProjectNumber_Map' & '-' & GlCode,
          TRIM(SubField(Comment,',',5)),
           'No Project') // if comment does not contain either, return this
)    // end of 2nd IF
) // end of first IF
AS ProjAcctKey

Re: apps hanging on 12.1 SR2

Chip_Matejowsky — Tue, 21 Feb 2017 02:49:00 GMT

Hi John,

I would ensure the QVS Events log is set to High Verbosity and then check the log for any warnings such as "SE_LOG: when AAALR(1072.471418) is greater than 1.000000, we suggest using new row applicator to improve time and mem efficiency." If there, then a change can be made in the QlikView Server Settings.ini to accommodate the warning.

-Chip

Re: apps hanging on 12.1 SR2

rwunderlich — Tue, 21 Feb 2017 03:49:43 GMT

John, Just to clarify. We are talking about a hang in reload, not in a document session, correct?

Chip, AAALR only applies to to a document session, right?

-Rob

Re: apps hanging on 12.1 SR2

rwunderlich — Tue, 21 Feb 2017 03:53:22 GMT

John,

I think this would be a good one to take to QT Support.

-Rob

Re: apps hanging on 12.1 SR2

jrepucci15 — Tue, 21 Feb 2017 14:21:17 GMT

Rob - Correct - this is hanging during reload.

Chip - just changed logging from med to high and I will re-run the app and see if I get anything interesting.

Re: apps hanging on 12.1 SR2

jrepucci15 — Tue, 21 Feb 2017 15:37:09 GMT

While I attempt to open a ticket (arghhh), for your viewing enjoyment, here is a small example program that works in 11 but hangs during reload in 12.

Re: apps hanging on 12.1 SR2

jrepucci15 — Tue, 21 Feb 2017 20:05:34 GMT

Getting closer to finding the issue.

If I append anything to the end of the Mapping Load table name in the ApplyMap, it hangs.

I've tried both Null() and '' in addition to my original string.

ApplyMap('ValidateMasterProjectNumber_Map' & '',

'ABCD123',

'No Project')

Re: apps hanging on 12.1 SR2

rwunderlich — Wed, 22 Feb 2017 00:33:18 GMT

Interesting bug. QV12.10 ApplyMap() does not seem to tolerate an expression for the mapname. Just hangs and spins some CPU. The following code runs fine under 11.20, but hangs when run in QV12.10 SR3.

MyMap:

Mapping

LOAD * INLINE [

from, to

x, 1

y, 2

];

Data:

LOAD *,

ApplyMap(('My' & 'Map'), Val1) as Val2

INLINE [

Val1

];

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: apps hanging on 12.1 SR2

Wed, 22 Feb 2017 06:26:20 GMT

Maybe they changed the behavior of ApplyMap in v12.10. It seems they are stricter now on checking the mapping table. Previously my script will run if the mapping table is missing. But in v12.10, it will give the "map_id not found" error. I guess this might related to the problem that you are getting.

Re: apps hanging on 12.1 SR2

jrepucci15 — Wed, 22 Feb 2017 16:17:38 GMT

Issue also exists in v12.10, SR3.

Khim, I like the fact that Qlik added validation of the ApplyMap string. I have had a few cases where I had mis-typed the map name and QV processed it without giving me any error messages.

I do have a few instances of ApplyMap(Currency & 'toEURCurrency_Map',

If this bug does not get addressed in the next few weeks. I will either revert our new servers back to v11 or spend a lot of time rewriting code.

Re: apps hanging on 12.1 SR2

Anonymous — Fri, 24 Feb 2017 08:48:33 GMT

Hi Rob,

We upgraded yesterday from QV11.2 SR12 to QV12.1 SR3 and same issue with applymap.

Is Qlik looking at correcting this bug?

How do we get around it?

Kind regards

Chris

Re: apps hanging on 12.1 SR2

jrepucci15 — Fri, 24 Feb 2017 13:52:32 GMT

Chris,

I submitted a ticket on this issue through my QV var. if/when I get updates, I'll post them here.

John

Re: ApplyMap bug - apps hanging on 12.1 SR2 / SR3

Chip_Matejowsky — Wed, 01 Mar 2017 13:00:47 GMT

Hi Rob,

The AAALR warnings can indicate significant performance issues because when it is returned, the system is typically not performing efficiently. I have experienced issues where QV Publisher tasks failed upon the distribution phase (Server distribution, not Folder distribution) because of QVS resource issues. So, just want to ensure that QVS is able to receive the distribution from Pub.

-Chip

Re: ApplyMap bug - apps hanging on 12.1 SR2 / SR3

rwunderlich — Wed, 01 Mar 2017 13:26:06 GMT

Thanks for that explanation Chip.

-Rob

Re: ApplyMap bug - apps hanging on 12.1 SR2 / SR3

jrepucci15 — Mon, 13 Mar 2017 17:34:23 GMT

Qlik said the bug is fixed and will be released at the end of the year in v12.20.

So, good news - fixed,

bad news - not available any time soon.

I had to reprogram around all of my instances of this bug. I'm not able to wait nine months.