topic Re: Windows Server 2012 R2 x Qlikview 12.20.20700 in QlikView

Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 13:04:32 GMT

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.

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

Miguel_Angel_Baeyens — Wed, 04 Jul 2018 13:31:21 GMT

Does it happen only when extracting with QlikView? Does it happen with Toad or any other similar tool?

Does the driver version match the RDBMS version?

Is it exactly the same configuration than in the previous computer (e.g.: buffer size, x64 vs 32 bit DSN)?

Are there any firewall, UAC or otherwise security or network settings different in this computer than to the previous?

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:11:18 GMT

Does it happen only when extracting with QlikView? Does it happen with Toad or any other similar tool?

Testing by SQL Developer, it runs normally. In Desktop version, slow; in QMC version, slower. (note: all services were configured to initialize with user Admin of AD, not by admin local of server).

Does the driver version match the RDBMS version?

Yes, 11 both

Is it exactly the same configuration than in the previous computer (e.g.: buffer size, x64 vs 32 bit DSN)?

How can I see this configuration in old server, to compare?

Are there any firewall, UAC or otherwise security or network settings different in this computer than to the previous?

How can I see this configuration in old server, to compare?

Are there some incompatibility of QV 12 Server x Windows Server 2012? I don't find the "Win2012andUp.exe" file when seek for QV 12 Server instalation, only "x64.exe" file, instead of QV 11.20.

Thanks a lot!

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

olivierrobin — Wed, 04 Jul 2018 14:17:20 GMT

hello

when I migrated last year from qv10 on w2008 to qv12 on w2012, I didn't notice anything.

verify that you use 64 bits driver and connect (instead of connect32) in qlik applications

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:28:15 GMT

Did you use ODBC connection with Oracle 11g? I will verify if my QMC is using QVConnect64 or 32. Thanks.

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:29:25 GMT

The services runs normally... my problem is only the ODBC connection... very slow, 6x a 8x slower than before.

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

olivierrobin — Wed, 04 Jul 2018 14:31:32 GMT

it was 11g

for connect, it is in Qlik scripts not in QMC

ODBC CONNECT TO

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:31:42 GMT

Yes, QVConnect64...

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:35:03 GMT

Yes, but the extraction progress is too slow... i just want to know some insight from seek issues.

My connection string from qlikview script (QV12, inside the Server):

ODBC CONNECT TO xxxxx (XUserId is yyyy, XPassword is zzzzz);

Thanks

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

olivierrobin — Wed, 04 Jul 2018 14:35:04 GMT

you could just make a test, to determine if it the access to the DB or the process done by QV

could you create a simple qvw with just an ODBC connect, a load from a sql query (so that there is no other processing)

and see if it is longer or not

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:51:15 GMT

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

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:53:58 GMT

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-microsoft-odbc-or-ole

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

olivierrobin — Wed, 04 Jul 2018 14:54:33 GMT

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

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 14:55:20 GMT

All... CTRL+End used...

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

olivierrobin — Wed, 04 Jul 2018 15:01:31 GMT

well, no more ideas for the moment ...

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 04 Jul 2018 16:50:30 GMT

Thank you for your attention, Olivier!

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

Miguel_Angel_Baeyens — Thu, 05 Jul 2018 07:03:47 GMT

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.

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Thu, 05 Jul 2018 10:17:33 GMT

Ok, I will do that. Thanks, Miguel!

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

fabio_vallone — Wed, 18 Jul 2018 10:45:20 GMT

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.

Re: Windows Server 2012 R2 x Qlikview 12.20.20700

Miguel_Angel_Baeyens — Mon, 30 Jul 2018 07:03:05 GMT

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.