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.

[Miguel_Angel_Baeyens]

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?

[fabio_vallone]

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!

[olivierrobin]

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

[fabio_vallone]

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

[fabio_vallone]

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

[olivierrobin]

it was 11g

for connect, it is in Qlik scripts not in QMC

ODBC CONNECT TO

[fabio_vallone]

Yes, QVConnect64...

[fabio_vallone]

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

[olivierrobin]

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