topic Re: Strange Mapping Load and ApplyMap in QlikView

Strange Mapping Load and ApplyMap

michelivor — Tue, 13 Mar 2018 18:00:20 GMT

Hi,

I found one thing today that I've never seen before and can't understand. Re-writing a script as part of migrating an QV environment to a new server and QDF for a customer. I stumbled upon a script where the ApplyMap (for a certain map) was before the Mapping Load.

Checking the log, yes ApplyMap was some 350 rows before Mapping Load.

ErrorMode is set to 1 (default)
No Subroutines or Included scripts.

Anyone who can give me a hint how this can work, something I haven’t thought of???

Regards

//Michel

Re: Strange Mapping Load and AppplyMap

sunny_talwar — Tue, 13 Mar 2018 18:06:29 GMT

And this runs without any errors?

Re: Strange Mapping Load and AppplyMap

michelivor — Tue, 13 Mar 2018 18:10:10 GMT

Yes, it shure does...

Re: Strange Mapping Load and AppplyMap

sunny_talwar — Tue, 13 Mar 2018 18:11:43 GMT

Any hiddent script which might have another mapping load? The hidden script are usually at the beginning and they won't even show up on the log file

Re: Strange Mapping Load and AppplyMap

michelivor — Tue, 13 Mar 2018 18:18:19 GMT

No, not that either.

I have a couple of times, when designing the UI, ended up where I have had to throw away an object due it crashed. Throwing it away and re-writing it will do the trick but never with the script, never during my 15y developing QV apps.

Re: Strange Mapping Load and AppplyMap

sunny_talwar — Tue, 13 Mar 2018 18:20:17 GMT

My experiences is far less than yours, but I have not heard of something like this before... so I am in the same boat as you are....

Would it be possible to share the snippet of the log file?

Re: Strange Mapping Load and AppplyMap

michelivor — Tue, 13 Mar 2018 18:23:02 GMT

Not at the moment, I'm not at the office right now.

See if I can do it tomorrow.

Re: Strange Mapping Load and ApplyMap

Peter_Cammaert — Tue, 13 Mar 2018 22:01:43 GMT

Any chance that this code in the wrong order is embedded in SUBroutines?

Re: Strange Mapping Load and ApplyMap

Peter_Cammaert — Tue, 13 Mar 2018 22:03:27 GMT

BTW ApplyMap before Mapping Load works in all version of QlikView before 12.10. It won't produce any errors and neither will it produce any decent output. Just NULL values.

Re: Strange Mapping Load and ApplyMap

binujose1982 — Tue, 13 Mar 2018 22:33:05 GMT

Hi Michel,

As Peter mentioned, ApplyMap before mapping Load works in all version of QlikView before 12.10.

I have faced this issue when, I migrate Qlikview 11 to 12. As a quick fix, i moved Maaping load script just before the apply map statement.

Hope this will help you..

Regards,

Binu

Re: Strange Mapping Load and ApplyMap

michelivor — Wed, 14 Mar 2018 06:19:09 GMT

Hi Peter,

No, as I wrote there are no SUBs or scripts included.

Re: Strange Mapping Load and ApplyMap

michelivor — Wed, 14 Mar 2018 06:24:32 GMT

Hi Peter,

Yeh, U got it.

The new environment is QV12.2 and the old is 11.2... ...remember that now, that's why it works w/o errors on the old server but not on the new.

Brg

//Michel

Re: Strange Mapping Load and ApplyMap

vishalgoud — Wed, 14 Mar 2018 22:27:04 GMT

I faced the same issue, our test env is Qv 12 where as Dev and Prod are Qv 11.

While am testing the app there was no mapping field in a apply map, it started throwing error. i was bit afraid that why this error coming in testing which is not coming in Dev and Prod. and yes

Qv 12 will through an error if Some thing missing in the Apply map. where as Qv 11 will not through any Error.

Re: Strange Mapping Load and ApplyMap

Anonymous — Mon, 19 Mar 2018 00:52:01 GMT

Hi,

Just wondering. Are you executing your load through a Desktop reload? or triggering a job with the QMC?

We have just moved from v11 to v12 and found that an ApplyMap that worked fine under v11 does not return values under v12, but, only if it is triggered by the QMC.

cheers,

Re: Strange Mapping Load and ApplyMap

michelivor — Sat, 24 Mar 2018 20:30:12 GMT

Hi Christopher,

It dosen't matter if it is through QMC or Desktop, it is the QV12 which is more sensitiv. While QV11 will create field with a Null() value, QV12 will exit the script if the Mapping Load isn't done when ApplyMap is used.

Brg

Michel