topic ApplyMap error: map_id not found but mapping is there in QlikView

ApplyMap error: map_id not found but mapping is there

matthewp — Thu, 17 Aug 2017 09:41:30 GMT

NOTE: this reload worked correctly before we upgraded to the latest QV software QV Server upgraded from 12.0 SR1 to 12.10 SR7.

I am getting the following error:

ApplyMap error: map_id not found

LOAD *,

ApplyMap('Amap',Alink,'Missing') as [POAN],

ApplyMap('Cmap',[POCC],'') as [POCCN],

ApplyMap('Smap',STlink,'') as [POSTN],

ApplyMap('Pmap',Plink,'') as [POPN],

ApplyMap('ASmap',ASlink,'') as [POASN]

And the mapping tables which are loaded before this are:

Amap:

Mapping LOAD

[AC] & '!' & [AA] as Alink,

[AD]

FROM

[$(vDetailsQVDDirectory)\PAC.qvd]

(qvd);

Cmap:

Mapping LOAD

[BCC],

[BD] as [CCD]

FROM

[$(vDetailsQVDDirectory)\PACB.qvd]

(qvd);

Smap:

Mapping LOAD

[CC] & '!' & [CCC] as STlink,

[CD]

FROM

[$(vDetailsQVDDirectory)\PACC.qvd]

(qvd);

Pmap:

Mapping LOAD

[DC] & '!' & [DCD] as Plink,

[DD]

FROM

[$(vDetailsQVDDirectory)\PACD.qvd]

(qvd);

ASmap:

MAPPING LOAD

[FC] & '!' & [FA] as ASlink2,

FROM

[$(vDetailsQVDDirectory)\PACF.qvd]

(qvd);

Re: ApplyMap error: map_id not found but mapping is there

Anil_Babu_Samineni — Thu, 17 Aug 2017 10:01:39 GMT

Are you loading ApplyMap statements after mapping table? If so, Should work. If not, do that?

Re: ApplyMap error: map_id not found but mapping is there

matthewp — Thu, 17 Aug 2017 10:04:19 GMT

Yes, applymaps are after the mapping tables

Re: ApplyMap error: map_id not found but mapping is there

Anil_Babu_Samineni — Thu, 17 Aug 2017 10:06:29 GMT

Remove square bracket over here? Try this

ApplyMap('Cmap',POCC,'') as [POCCN],

Re: ApplyMap error: map_id not found but mapping is there

Chanty4u — Thu, 17 Aug 2017 10:08:37 GMT

try to debug the script by commenting one by one applymap statement and check in which table it causing the error?

Re: ApplyMap error: map_id not found but mapping is there

antoniotiman — Thu, 17 Aug 2017 10:09:29 GMT

Probably

[$(vDetailsQVDDirectory)\PAC.qvd] is wrong.

Re: ApplyMap error: map_id not found but mapping is there

Chanty4u — Thu, 17 Aug 2017 10:09:36 GMT

yes first mapping table then after applymap

Re: ApplyMap error: map_id not found but mapping is there

matthewp — Thu, 17 Aug 2017 10:11:25 GMT

still the same error

Re: ApplyMap error: map_id not found but mapping is there

matthewp — Thu, 17 Aug 2017 10:11:49 GMT

Thats what i have

Re: ApplyMap error: map_id not found but mapping is there

Anil_Babu_Samineni — Thu, 17 Aug 2017 10:16:45 GMT

I have not seen this fields in your Mapping table? Will you?

LOAD *,

ApplyMap('Amap',Alink,'Missing') as [POAN],

ApplyMap('Cmap',[POCC],'') as [POCCN],

ApplyMap('Smap',STlink,'') as [POSTN],

ApplyMap('Pmap',Plink,'') as [POPN],

ApplyMap('ASmap',ASlink,'') as [POASN]

Re: ApplyMap error: map_id not found but mapping is there

matthewp — Thu, 17 Aug 2017 10:27:12 GMT

Checked variable and its correct.

Also deleted variable and used SET in the script and still failed

Re: ApplyMap error: map_id not found but mapping is there

antoniotiman — Thu, 17 Aug 2017 10:31:13 GMT

Can You provide log of loading doc ?