Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
EugeniaCastillaFragoso
Partner - Contributor III
Partner - Contributor III

MapID not found in QMC reload but the document reloads just fine using Desktop Software

Hello to whomever is reading!

I have the following problem. I created a QlikView document. I reload it in my desktop version and it all goes well. 

All the maps are created, all the tables look good,.. etc

 

HOWEVER, when I try to reload the file via QMC, the reload fails within 50 seconds. I generated a log file to see what was going on, and apparently, maps id's can not be found!

 

 

I don't understand, as the version of the desktop software and the QMC is the same, obviously, and the maps are generated correctly; and the document reloads fine in the desktop. I just don't get it. 

 

The maps are named after variables, that is the only thing that makes them "weird".

My  map--->

COMERCIAL_$(contador):
MAPPING LOAD SlpCode,NomComercial;
SQL SELECT SlpCode, upper(SlpName) as NomComercial FROM $(cx_BBDD)OSLP (NOLOCK);

Where i call them AFTER creating them--->
WHERE /*LEN(U_N1)>0 and*/ not exists(ClaveJoin,UPPER(CardCode)&'-'&ApplyMap('COMERCIAL_$(contador)',SlpCode,'*** SIN DESCRIPCION ***'))

 

 

 

3 Replies
marcus_sommer

There are a lot of possible reasons why the qmc-load and the desktop-load return different results, for example different rights in regard to any section access or accessing any files or databases or within different variables- and/or regional-settings.

In your case it may just be the creation/content of the variable: $(contador). If you look within the log - are all expected mapping tables created with the right names? Helpful might be also to show the variable-content within the progress-window and the log with statements like:

TRACE $(contador);

- Marcus

EugeniaCastillaFragoso
Partner - Contributor III
Partner - Contributor III
Author

Hi Marcus,

Yes, on the log file I can see that every map has been created (there should be 4 maps, so COMERCIAL_1, COMERCIAL_2, COEMRCIAL_3 and COMERCIAL_4.

Furthermore, the variable $(contador) is created within the script: let contador = 1

marcus_sommer

Ok, the mappings are created like expected. What happens when they are called - probably also within a loop and maybe within any iteration $(contador) is <1 or >4 or just empty respectively the variable didn't exists anymore because by let var = null(); the variable will be removed - and if any of it happens the mapping-call will fail.

- Marcus