ApplyMap error: map_id not found but mapping is there

[matthewp]

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

[Anil_Babu_Samineni]

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

[matthewp]

Yes, applymaps are after the mapping tables

[Anil_Babu_Samineni]

Remove square bracket over here? Try this

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

[Chanty4u]

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

[antoniotiman]

Probably

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

[Chanty4u]

yes first mapping table then after applymap

[matthewp]

still the same error

[matthewp]

Thats what i have

[Anil_Babu_Samineni]

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]