Windows Server 2012 R2 x Qlikview 12.20.20700

[fabio_vallone]

Good morning.

I have installed qlikview 12 server on a server running Windows Server 2012 R2 and I am experiencing a slow connection problem with Oracle database through ODBC (Oracle 10g and 11 were tested). In the previous release, with Qlikview Server 11.20 SR17 and Windows Server 2008, this problem did not occur; I checked the Qlikview Server notes and found no known issues between platforms; does anyone know what is needed, or recommended, to configure in Windows Server 2012 R2 for the connection to Oracle to working normally? Thank you very much.

[fabio_vallone]

I did it... 380k lines. SQL Developer: 27 seconds... Qlikview Desktop: 4minutes and 08 seconds...

[fabio_vallone]

Someone need to use this Windows patch to solve ODBC conection?

https://support.microsoft.com/pt-br/help/3147071/connection-to-oracle-database-fails-when-you-use-mi...

[olivierrobin]

in SQL dev, all rows were retrieved ? no only the 1st ones ?

[fabio_vallone]

All... CTRL+End used...

[olivierrobin]

well, no more ideas for the moment ...

[fabio_vallone]

Thank you for your attention, Olivier!

[Miguel_Angel_Baeyens]

Check with Qlik Support. Another thing you could try is using the same version of QlikView Desktop on the other computer and see whether the load takes the same time.

[fabio_vallone]

Ok, I will do that. Thanks, Miguel!

[fabio_vallone · Accepted solution]

Hi !

I could not solve my issue; the solution was to execute a downgrade to Windows Server 2008; in this server, Qv12 runs normally. Thanks to all.

[Miguel_Angel_Baeyens]

That's a massive loss! Did Qlik Support tell you anything or troubleshoot? If it were my case, I cannot simply downgrade all servers to a lower version of the OS.