Variables don't work properly in QV12

[Anonymous]

Hi,

I have problem loading data in QV12. The document works fine in QV11 and doesn't assign values to variables properly in QV12. There many vars in load script looping. Somewhere vars don't get values or get values of previous loop. Tested on different machines and win platforms. Is it a bug or...? Any idea?

[marcus_sommer]

AFAIK nothing had changed by the variable-handling. Please provide the script which creates/assigned the variables.

- Marcus

[Anonymous]

Hm-m, I realy don't know how to provide it. It's a big script like a loading consol with several thouthand lines of code and hundreds of variables used in looping sql connections. In short, there are many loops one in the other. Variables get values from excel and in some parts of code like

FOR Each ВидДвижения in '+1', '-1'

  LET РегистрБухгалтерии.Типовой.Счет  = if(ВидДвижения = '+1', '$(РегистрБухгалтерии.Типовой.СчетДт)', '')
      [Таблица0]:
      select
      ,$(НомерБазы)+$(|)+$(РегистрБухгалтерии.Типовой.Организация)+$(|)   as [Организации.Ссылка]
      ,$(НомерБазы)+$(|)+$(РегистрБухгалтерии.Типовой.Субконто2)+$(|)     as [Склады.Ссылка]
      ,$(НомерБазы)+$(|)+$(РегистрБухгалтерии.Типовой.Субконто1)+$(|)     as [Номенклатура.Ссылка]
      ,$(ВидДвижения)                                                     as [ВидДвижения]
   from $(РегистрБухгалтерии.Типовой)                                     as Типовой      (nolock)
      inner join $(ПланСчетов.Типовой)                                    as ПланСчетов   (nolock)        ;

NEXT ВидДвижения

upper variable ВидДвижения  doesn't get value '+1' or '-1'. SQL part is not important, I provided it for example

[marcus_sommer]

I believe it will be quite difficult with such script-parts to detect an issue with the variables and think you will need to check each of them within the debugger - whereby could imagine that a quite earlier part from the variable-generation failed, maybe an include-variable is missing or something similar.

- Marcus

[Anonymous]

Ya, but as I sad this script works fine in 11 version every day and many month. Trying to load it in 12 get errors. Noticed that some vars are empty, i.e   FOR Each Var in... doesn't create Var. And  somewhere vars have values of previous creating.

[marcus_sommer · Accepted solution]

You could try to change your QV 12 release (AFAIK SR2 was quite buggy). Otherwise I'm out of ideas unless to post it here: QlikBug and contact the qoncierge service or the customer portal: QlikView Support launches Qoncierge Service.

- Marcus

[Anonymous]

Indeed I tried all releases, including SR5 - the same behavior. May be QlikBug will clarify something).  Thank you Marcus.

[Anonymous]

The bug is fixed in qv 12.10