topic Re: QvConnect in QlikView

QvConnect

Wed, 25 Nov 2020 16:16:04 GMT

What is QvConnect and what could cause it to stop working.

I had fire a dialog after a manual reload in QV Desktop at the end of the load.

This has happened twice on the same document.

QvConnect 12.0.20001.0

Thanks

Oli

Re: QvConnect

avinashelite — Thu, 12 May 2016 10:40:52 GMT

check this

How to use QVConnect? | Qlik Community

Re: QvConnect

Thu, 12 May 2016 11:18:01 GMT

Hi,

QVConnect is a new component delivered with QlikView 10. However its actually the data connectivity component used from script execution. We've made it a separate execution component from qv.exe to provide more stability and management over data connections vs. the qlikview execution engine. You will notice two components - QVConnect and QVConnect32 that is used for 32 bit data connectivity in your script (e.g. running on a 64 bit machine and have to connect to a mix of 64 and 32 bit data sources. 'Force 32' checkbox in script makes the script statement(s) use the QVConnect32 process.

Re: QvConnect

Thu, 12 May 2016 11:30:04 GMT

Hi Avinash

Thanks for the info.

Would you have any idea would could be causing it to stop?

Oli

Re: QvConnect

avinashelite — Thu, 12 May 2016 11:51:06 GMT

Their might be lot of reasons

1.Changes in the data sources.

2.Load on data base

3.web services down and might not be running properly

4.Permissions issues

etc

Re: QvConnect

Peter_Cammaert — Thu, 12 May 2016 11:53:29 GMT

Big synthetic key table being created? Are you sure it is QvConnect that stopped working? Can you tell us how you found out?

Re: QvConnect

avinashelite — Thu, 12 May 2016 13:06:30 GMT

Hi pcammaert‌

I didn't get you....could please correct me if am wrong in my comment??

Re: QvConnect

Thu, 12 May 2016 13:07:45 GMT

This is how I know is QvConnect:

http://postimg.org/image/c4sznkm2p/

Re: QvConnect

Peter_Cammaert — Sat, 14 May 2016 09:55:02 GMT

Sorry Avinash, my fault. I was talking to the OP and continuing your list of possible causes along the way. I should have prefixed my comment with the name of the person I was talking to.

Re: QvConnect

avinashelite — Sat, 14 May 2016 18:23:48 GMT

no problem pcammaert‌ , your always welcome to correct the mistakes

Re: QvConnect

Mon, 16 May 2016 11:59:37 GMT

I haven't had much opportunity to work on the document since your reply; however, do you think this could potentially be the problem:

CUSTOM CONNECT TO "Provider=C:\Program Files\QlikView\QvsAdminDataProvider.dll;host=localhost;XUserId=OSCVNZC;XPassword=SJEcTAC;";

tmpDocumentAttribute:

LOAD

DocPath,

AttributeName,

AttributeValue

WHERE

wildmatch(DocPath,'*'&$(ThisDoc)) >0

;

SQL

SELECT

DocPath,

AttributeName,

AttributeValue

FROM

DocAttributes

;