Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

matthewp
Contributor III

ApplyMap error: map_id not found but mapping is there

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);

11 Replies

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
matthewp
Contributor III

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

Yes, applymaps are after the mapping tables

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

Remove square bracket over here? Try this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Chanty4u
Esteemed Contributor III

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

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

antoniotiman
Honored Contributor III

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

Probably

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

Chanty4u
Esteemed Contributor III

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

yes first mapping table then after applymap

matthewp
Contributor III

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

still the same error

matthewp
Contributor III

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

Thats what i have

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

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]

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)