Map ID not found and reload failer in server...

[vishalgoud]

Complete Strange and Magical

we have a separate extractor to extract the all the dimension tables, when i reload in my local dev server reload was successful without any issues.

But reload failed in Test server after deployment with ' apply map error , Map id not found'

we are loading all the mapping tables in the scirp using text file (include load) all the mapping tables are available in that text file.

But Surprisingly the mapping table that am referring in the script is not available in that text file in  dev , test and prod as well. verfied couple of times.

but still reload working in Dev server and failing in test server, PFB server log.  Please help with this is prority task.

ApplyMap('BaseCategory', BASE_CATEGORY_NAME, 'Other')    as BASE_CATEGORY,

if(BASE_CATEGORY_KEY=1 or BASE_CATEGORY_KEY = 3 or BASE_CATEGORY_KEY = 9,'1')  | as FLAG_BASE_CONTRACT

20171214T150018.580+0000 Information   2017-12-14 15:00:16      Error: ApplyMap error:

20171214T150018.581+0000 Information   2017-12-14 15:00:16      map_id not found

20171214T150018.582+0000 Information   2017-12-14 15:00:16     

20171214T150018.584+0000 Information   2017-12-14 15:00:16      ApplyMap error:

20171214T150018.585+0000 Information   2017-12-14 15:00:16      map_id not found

20171214T150018.586+0000 Information   2017-12-14 15:00:16    

[martinpohl · Accepted solution]

are prod and test server the same QV Version? error map_id not found is new with QV 12(.1 ?)

can you post the complete document log?

maybe there is another table with same fields so the mapping table get a new name?

regards

[shiveshsingh]

If mapping load is missing in QV11 then also apply map will not throw error while reloading.

But in QV12, it will throw error. You need to make mapping tables again or remove applymap part if it is of no use.

[vishalgoud]

Thanks Martin for the Quick response,

Yes got to know that there is version upgrade in test server, as am new to team no such info has been provided, after this i enquired that and it worked for me, Thank you again.

[vishalgoud]

Thank you Singh.

your reply helped me to understand the issue.

[vishalgoud]

Hi Martin,

Sorry to open the thread again. Just need a clarification about limitation of inline mapping table in qv 12.

as i told earlier our dev is Qv 11 and our test env is Qv 12 , now we are testing the app in test env.

Lot of errors coming like map_id missing. my colleague is saying that inline loads itself will not work we have to load them using excel or csv.i dont have access to test it.

all inline loads are having problem in Qv 12 ?? or only inline tables which are used as a mapping tables are not working in Qv 12 ?? and also any other issues we may face if we do testing in Qv12 env.

Please provide your points on the above, as we have many inline loads which are used as mapping tables.

it is really mess for me to take an action with this and was didnt find any docs related this.

[shiveshsingh]

Hi Vishal

what do you mean by all inline loads having problem in QV12? Is it not getting loaded?

Inline load is of course working in QV12 and if you are not having mapping tables for applymap, then only missing map id error would come.

You can refer release notes for qv12 as well