Qlikview 11.20 SR19 CRITICAL TROUBLE

[barakovskikh]

Hi! Beginning with QV 11.20 SR 16 and upper application confuses fields and data during calculations.

1. Open the application

2. Reload document

3. = Bug (See 1 screnshot in attachment) <- Field 1 = Field 2 & '|' & Field 3

4. Do not close document and reload again (See 2 screnshot in attachment) = all good!

Bug actual for desktop (QV) and server (QVB) load

Spoiler

tmp:
NoConcatenate
LOAD * Inline [
x,y,z
];

Concatenate(tmp)
LOAD
RowNo() as x
,RowNo()*-1 as y
,RowNo() as z
AutoGenerate(100000);

DATA:
NoConcatenate
LOAD
x & '|' & y as KEY,
x,
y,
fabs(z) as z
Resident tmp;

drop Table tmp;

First load after open document

Second load after open document

[Brett_Bleess]

Alexandr, please be patient, this is not something that is going to happen in a day or two, this may be a few weeks in order to get things looked at and a determination as to what will be done etc. just to set proper expectations.  I will update as soon as I have further information, or the person to whom I reached out will comment directly once he can get to things, I learned he is on the road at the moment.  

Regards,
Brett

[ToniKautto]

I am not able to replicate this with 11.20 SR16 on Windows 2012 R2. 

@barakovskikh would you be able to run systeminfo in Powershell and share the details with me, so that I can see if our servers have any significant difference? It woudl also be good if you can share a sample QVW with the issue present. 

Thanks

[barakovskikh]

HI @ToniKautto !

In the attachment of the application, if you open it immediately evident that the data is not correct.

Reproduced a problem on different systems, but the syslog enclosed under a spoiler below.

Algorithm:

1. Open

2 do Nothing, just push the reload.

3. Get bug.

4. The second update will be correct

P.S  Sometimes the problem is not reproduced with first time. You need to close the file, open it again, and update it again.

PLS See short video on other system (11.20 SR19 and Windows 10) 

http://skrinshoter.ru/v/260919/YnxhisKQ?a

Spoiler

Host Name: QLIKV02
OS Name: Microsoft Windows Server 2012 R2 Standard
OS Version: 6.3.9600 N/A Build 9600
OS Manufacturer: Microsoft Corporation
OS Configuration: Member Server
OS Build Type: Multiprocessor Free
Registered Owner: Windows User
Registered Organization:
Product ID: 00252-70000-00000-AA535
Original Install Date: 09.12.2015, 1:46:38
System Boot Time: 23.09.2019, 12:32:59
System Manufacturer: FUJITSU
System Model: PRIMERGY RX500 S7
System Type: x64-based PC
Processor(s): 4 Processor(s) Installed.
[01]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
[02]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
[03]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
[04]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
BIOS Version: FUJITSU Rev.01.26.D3039, 27.11.2014
Windows Directory: C:\Windows
System Directory: C:\Windows\system32
Boot Device: \Device\HarddiskVolume1
System Locale: ru;Russian
Input Locale: en-us;English (United States)
Time Zone: (UTC+03:00) Moscow, St. Petersburg
Total Physical Memory: 524 134 MB
Available Physical Memory: 187 859 MB
Virtual Memory: Max Size: 655 206 MB
Virtual Memory: Available: 310 651 MB
Virtual Memory: In Use: 344 555 MB
Page File Location(s): D:\pagefile.sys
Logon Server: \\RU-MOW-D2-SDC01
Hotfix(s): 212 Hotfix(s) Installed.
[01]: KB2959936
[02]: KB2894852
[03]: KB2894856
[04]: KB2896496
[05]: KB2919355
[06]: KB2920189
[07]: KB2928120
[08]: KB2933826
[09]: KB2938066
[10]: KB2938772
[11]: KB2949621
[12]: KB2954879
[13]: KB2965500
[14]: KB2966407
[15]: KB2966826
[16]: KB2966828
[17]: KB2967917
[18]: KB2968296
[19]: KB2971203
[20]: KB2971850
[21]: KB2972103
[22]: KB2973448
[23]: KB2975061
[24]: KB2976627
[25]: KB2977629
[26]: KB2977765
[27]: KB2978041
[28]: KB2978126
[29]: KB2987107
[30]: KB2989647
[31]: KB2989930
[32]: KB2999226
[33]: KB3000483
[34]: KB3000850
[35]: KB3003057
[36]: KB3004365
[37]: KB3012702
[38]: KB3013172
[39]: KB3013791
[40]: KB3014442
[41]: KB3019978
[42]: KB3021910
[43]: KB3023219
[44]: KB3023222
[45]: KB3023266
[46]: KB3024751
[47]: KB3024755
[48]: KB3030947
[49]: KB3031044
[50]: KB3032663
[51]: KB3033446
[52]: KB3035126
[53]: KB3036612
[54]: KB3037576
[55]: KB3037579
[56]: KB3037924
[57]: KB3038002
[58]: KB3042085
[59]: KB3043812
[60]: KB3044374
[61]: KB3044673
[62]: KB3045634
[63]: KB3045685
[64]: KB3045717
[65]: KB3045719
[66]: KB3045755
[67]: KB3045999
[68]: KB3046017
[69]: KB3046737
[70]: KB3054169
[71]: KB3054203
[72]: KB3054256
[73]: KB3054464
[74]: KB3055323
[75]: KB3055343
[76]: KB3055642
[77]: KB3059317
[78]: KB3060681
[79]: KB3060793
[80]: KB3061512
[81]: KB3063843
[82]: KB3071756
[83]: KB3072307
[84]: KB3074228
[85]: KB3074545
[86]: KB3074548
[87]: KB3077715
[88]: KB3078405
[89]: KB3078676
[90]: KB3080149
[91]: KB3082089
[92]: KB3084135
[93]: KB3086255
[94]: KB3087041
[95]: KB3087137
[96]: KB3091297
[97]: KB3094486
[98]: KB3095701
[99]: KB3097992
[100]: KB3097997
[101]: KB3098779
[102]: KB3099834
[103]: KB3100473
[104]: KB3100773
[105]: KB3102467
[106]: KB3103616
[107]: KB3103696
[108]: KB3103709
[109]: KB3108326
[110]: KB3109103
[111]: KB3109560
[112]: KB3109976
[113]: KB3110329
[114]: KB3115224
[115]: KB3121261
[116]: KB3121461
[117]: KB3123245
[118]: KB3126434
[119]: KB3126587
[120]: KB3127222
[121]: KB3133043
[122]: KB3133690
[123]: KB3134179
[124]: KB3134813
[125]: KB3134815
[126]: KB3137728
[127]: KB3138602
[128]: KB3138910
[129]: KB3138962
[130]: KB3139164
[131]: KB3139398
[132]: KB3139914
[133]: KB3140219
[134]: KB3140234
[135]: KB3145384
[136]: KB3145432
[137]: KB3146604
[138]: KB3146723
[139]: KB3146751
[140]: KB3147071
[141]: KB3155784
[142]: KB3156059
[143]: KB3159398
[144]: KB3161949
[145]: KB3162343
[146]: KB3172614
[147]: KB3172729
[148]: KB3173424
[149]: KB3175024
[150]: KB3178539
[151]: KB3179574
[152]: KB4014505
[153]: KB4014510
[154]: KB4014598
[155]: KB4014604
[156]: KB4022717
[157]: KB4025333
[158]: KB4034672
[159]: KB4038793
[160]: KB4040967
[161]: KB4040972
[162]: KB4040981
[163]: KB4041687
[164]: KB4048961
[165]: KB4052978
[166]: KB4054522
[167]: KB4093115
[168]: KB4095515
[169]: KB4095875
[170]: KB4096236
[171]: KB4096417
[172]: KB4103715
[173]: KB4284878
[174]: KB4338419
[175]: KB4338424
[176]: KB4338605
[177]: KB4338824
[178]: KB4339093
[179]: KB4343205
[180]: KB4343888
[181]: KB4344145
[182]: KB4344153
[183]: KB4344166
[184]: KB4344178
[185]: KB4457026
[186]: KB4457034
[187]: KB4457045
[188]: KB4457056
[189]: KB4457143
[190]: KB4457426
[191]: KB4462941
[192]: KB4467703
[193]: KB4470499
[194]: KB4470602
[195]: KB4471322
[196]: KB4480964
[197]: KB4483469
[198]: KB4483484
[199]: KB4487028
[200]: KB4489883
[201]: KB4493467
[202]: KB4495586
[203]: KB4495615
[204]: KB4499165
[205]: KB4503290
[206]: KB4506962
[207]: KB4506977
[208]: KB4506996
[209]: KB4507005
[210]: KB4507434
[211]: KB4507457
[212]: KB4507448
Network Card(s): 7 NIC(s) Installed.
[01]: Intel(R) I350 Gigabit Network Connection
Connection Name: Embedded GbE 1
DHCP Enabled: Yes
DHCP Server: 255.255.255.255
IP address(es)
[01]: 169.254.175.27
[02]: fe80::d17f:421e:db41:af1b
[02]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Slot8 Port 2
Status: Media disconnected
[03]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Slot8 2 Port 1
DHCP Enabled: No
IP address(es)
[01]: 192.168.200.205
[02]: fe80::21ca:9c27:24e1:b49a
[04]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Modular LAN 2
DHCP Enabled: Yes
DHCP Server: 255.255.255.255
IP address(es)
[01]: 169.254.255.60
[02]: fe80::5c78:820a:688d:ff3c
[05]: Intel(R) Advanced Network Services Virtual Adapter
Connection Name: Ethernet
Status: Hardware not present
[06]: Intel(R) I350 Gigabit Network Connection
Connection Name: Embedded GbE 2
DHCP Enabled: Yes
DHCP Server: 255.255.255.255
IP address(es)
[01]: 169.254.195.157
[02]: fe80::dd24:84fe:839e:c39d
[07]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Slot10 Port 1
DHCP Enabled: No
IP address(es)
[01]: 10.1.1.8
Hyper-V Requirements: VM Monitor Mode Extensions: Yes
Virtualization Enabled In Firmware: Yes
Second Level Address Translation: Yes
Data Execution Prevention Available: Yes

[barakovskikh]

HI @ToniKautto !

In the attachment of the application, if you open it immediately evident that the data is not correct.

Reproduced a problem on different systems, but the syslog enclosed under a spoiler below.

Algorithm:

1. Open
2. do Nothing, just push the reload.
3. Get bug.

P.S  Sometimes the problem is not reproduced with first time. You need to !CLOSE! the file, open it again, and reload it again.

PLS See short video on other system (11.20 SR19 and Windows 10) <- I sent it in to pm

Spoiler

Host Name: QLIKV02
OS Name: Microsoft Windows Server 2012 R2 Standard
OS Version: 6.3.9600 N/A Build 9600
OS Manufacturer: Microsoft Corporation
OS Configuration: Member Server
OS Build Type: Multiprocessor Free
Registered Owner: Windows User
Registered Organization:
Product ID: 00252-70000-00000-AA535
Original Install Date: 09.12.2015, 1:46:38
System Boot Time: 23.09.2019, 12:32:59
System Manufacturer: FUJITSU
System Model: PRIMERGY RX500 S7
System Type: x64-based PC
Processor(s): 4 Processor(s) Installed.
[01]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
[02]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
[03]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
[04]: Intel64 Family 6 Model 45 Stepping 7 GenuineIntel ~2701 Mhz
BIOS Version: FUJITSU Rev.01.26.D3039, 27.11.2014
Windows Directory: C:\Windows
System Directory: C:\Windows\system32
Boot Device: \Device\HarddiskVolume1
System Locale: ru;Russian
Input Locale: en-us;English (United States)
Time Zone: (UTC+03:00) Moscow, St. Petersburg
Total Physical Memory: 524 134 MB
Available Physical Memory: 187 859 MB
Virtual Memory: Max Size: 655 206 MB
Virtual Memory: Available: 310 651 MB
Virtual Memory: In Use: 344 555 MB
Page File Location(s): D:\pagefile.sys
Logon Server: \\RU-MOW-D2-SDC01
Hotfix(s): 212 Hotfix(s) Installed.
[01]: KB2959936
[02]: KB2894852
[03]: KB2894856
[04]: KB2896496
[05]: KB2919355
[06]: KB2920189
[07]: KB2928120
[08]: KB2933826
[09]: KB2938066
[10]: KB2938772
[11]: KB2949621
[12]: KB2954879
[13]: KB2965500
[14]: KB2966407
[15]: KB2966826
[16]: KB2966828
[17]: KB2967917
[18]: KB2968296
[19]: KB2971203
[20]: KB2971850
[21]: KB2972103
[22]: KB2973448
[23]: KB2975061
[24]: KB2976627
[25]: KB2977629
[26]: KB2977765
[27]: KB2978041
[28]: KB2978126
[29]: KB2987107
[30]: KB2989647
[31]: KB2989930
[32]: KB2999226
[33]: KB3000483
[34]: KB3000850
[35]: KB3003057
[36]: KB3004365
[37]: KB3012702
[38]: KB3013172
[39]: KB3013791
[40]: KB3014442
[41]: KB3019978
[42]: KB3021910
[43]: KB3023219
[44]: KB3023222
[45]: KB3023266
[46]: KB3024751
[47]: KB3024755
[48]: KB3030947
[49]: KB3031044
[50]: KB3032663
[51]: KB3033446
[52]: KB3035126
[53]: KB3036612
[54]: KB3037576
[55]: KB3037579
[56]: KB3037924
[57]: KB3038002
[58]: KB3042085
[59]: KB3043812
[60]: KB3044374
[61]: KB3044673
[62]: KB3045634
[63]: KB3045685
[64]: KB3045717
[65]: KB3045719
[66]: KB3045755
[67]: KB3045999
[68]: KB3046017
[69]: KB3046737
[70]: KB3054169
[71]: KB3054203
[72]: KB3054256
[73]: KB3054464
[74]: KB3055323
[75]: KB3055343
[76]: KB3055642
[77]: KB3059317
[78]: KB3060681
[79]: KB3060793
[80]: KB3061512
[81]: KB3063843
[82]: KB3071756
[83]: KB3072307
[84]: KB3074228
[85]: KB3074545
[86]: KB3074548
[87]: KB3077715
[88]: KB3078405
[89]: KB3078676
[90]: KB3080149
[91]: KB3082089
[92]: KB3084135
[93]: KB3086255
[94]: KB3087041
[95]: KB3087137
[96]: KB3091297
[97]: KB3094486
[98]: KB3095701
[99]: KB3097992
[100]: KB3097997
[101]: KB3098779
[102]: KB3099834
[103]: KB3100473
[104]: KB3100773
[105]: KB3102467
[106]: KB3103616
[107]: KB3103696
[108]: KB3103709
[109]: KB3108326
[110]: KB3109103
[111]: KB3109560
[112]: KB3109976
[113]: KB3110329
[114]: KB3115224
[115]: KB3121261
[116]: KB3121461
[117]: KB3123245
[118]: KB3126434
[119]: KB3126587
[120]: KB3127222
[121]: KB3133043
[122]: KB3133690
[123]: KB3134179
[124]: KB3134813
[125]: KB3134815
[126]: KB3137728
[127]: KB3138602
[128]: KB3138910
[129]: KB3138962
[130]: KB3139164
[131]: KB3139398
[132]: KB3139914
[133]: KB3140219
[134]: KB3140234
[135]: KB3145384
[136]: KB3145432
[137]: KB3146604
[138]: KB3146723
[139]: KB3146751
[140]: KB3147071
[141]: KB3155784
[142]: KB3156059
[143]: KB3159398
[144]: KB3161949
[145]: KB3162343
[146]: KB3172614
[147]: KB3172729
[148]: KB3173424
[149]: KB3175024
[150]: KB3178539
[151]: KB3179574
[152]: KB4014505
[153]: KB4014510
[154]: KB4014598
[155]: KB4014604
[156]: KB4022717
[157]: KB4025333
[158]: KB4034672
[159]: KB4038793
[160]: KB4040967
[161]: KB4040972
[162]: KB4040981
[163]: KB4041687
[164]: KB4048961
[165]: KB4052978
[166]: KB4054522
[167]: KB4093115
[168]: KB4095515
[169]: KB4095875
[170]: KB4096236
[171]: KB4096417
[172]: KB4103715
[173]: KB4284878
[174]: KB4338419
[175]: KB4338424
[176]: KB4338605
[177]: KB4338824
[178]: KB4339093
[179]: KB4343205
[180]: KB4343888
[181]: KB4344145
[182]: KB4344153
[183]: KB4344166
[184]: KB4344178
[185]: KB4457026
[186]: KB4457034
[187]: KB4457045
[188]: KB4457056
[189]: KB4457143
[190]: KB4457426
[191]: KB4462941
[192]: KB4467703
[193]: KB4470499
[194]: KB4470602
[195]: KB4471322
[196]: KB4480964
[197]: KB4483469
[198]: KB4483484
[199]: KB4487028
[200]: KB4489883
[201]: KB4493467
[202]: KB4495586
[203]: KB4495615
[204]: KB4499165
[205]: KB4503290
[206]: KB4506962
[207]: KB4506977
[208]: KB4506996
[209]: KB4507005
[210]: KB4507434
[211]: KB4507457
[212]: KB4507448
Network Card(s): 7 NIC(s) Installed.
[01]: Intel(R) I350 Gigabit Network Connection
Connection Name: Embedded GbE 1
DHCP Enabled: Yes
DHCP Server: 255.255.255.255
IP address(es)
[01]: 169.254.175.27
[02]: fe80::d17f:421e:db41:af1b
[02]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Slot8 Port 2
Status: Media disconnected
[03]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Slot8 2 Port 1
DHCP Enabled: No
IP address(es)
[01]: 192.168.200.205
[02]: fe80::21ca:9c27:24e1:b49a
[04]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Modular LAN 2
DHCP Enabled: Yes
DHCP Server: 255.255.255.255
IP address(es)
[01]: 169.254.255.60
[02]: fe80::5c78:820a:688d:ff3c
[05]: Intel(R) Advanced Network Services Virtual Adapter
Connection Name: Ethernet
Status: Hardware not present
[06]: Intel(R) I350 Gigabit Network Connection
Connection Name: Embedded GbE 2
DHCP Enabled: Yes
DHCP Server: 255.255.255.255
IP address(es)
[01]: 169.254.195.157
[02]: fe80::dd24:84fe:839e:c39d
[07]: Intel(R) 82599 10 Gigabit Dual Port Network Connection
Connection Name: Slot10 Port 1
DHCP Enabled: No
IP address(es)
[01]: 10.1.1.8
Hyper-V Requirements: VM Monitor Mode Extensions: Yes
Virtualization Enabled In Firmware: Yes
Second Level Address Translation: Yes
Data Execution Prevention Available: Yes  

[ToniKautto]

Thanks for the sample file. I am not able to replicate the issue with the file. 

Your video shows opening a file with data and then reloading. Are you able to provide a copy of this file that has the issue before you reload and correct the problem?

Thanks

[barakovskikh]

In attachment qvw file in the post above already with incorrect data.

Have you tried downloading multiple times like the video? Sometimes you need to do it 4-5 times!

1. shaking my sample above

2. Open

3. Reload

4. if mistakes there is no, then close app

5. repeat steps 2,3,4

[marcus_sommer]

Just a short addition: It might be difference in regard to the reproduce if only the file is closed/opened/reloaded or if QV as application is also closed between the trials.

- Marcus

[barakovskikh]

You need to repeat this with closing the QV application!

In this case, I'm sure that I have the error will be repeated, not always the first time, sometimes you need to repeat the process several times.

Algorithm

1 Open my sample from the post above

2 Reload

3 If there is no error with the data then CLOSE APP QV!!!

4 Repeat steps 1-3

P.S Sometimes the error the first time, sometimes with 3-5

[ToniKautto]

I have probably repeated that sequence about 15 times now, still can see anything going wrong here. 

[barakovskikh]

Sorry, my English is very bad, could you rephrase what you mean? Were you able to reproduce the problem or not?

Above were other people who could reproduce.

Are you sure you're doing what I described?

Your version of QV dowloaded from public repository ?