Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
timpoismans
Specialist
Specialist

Connector connect error

Hi all.

A customer of mine got the following error when trying to reload her script in Qlik Sense Desktop.

Error Qlik Reload.PNG

I know it's in Dutch, so a rough translation below:

Connector connect error: Error starting QvConnect process: Can't load "numerator name data" (=tellernaamgegevens) because an invalid index was read from the register.

I have no clue why things are going wrong, it has worked perfectly without issue for months.

The only difference is that my client updated her Qlik Sense Desktop to the February version and troubles started to arise since then.

Has anyone ever experienced this before? Or does anyone have any idea on what's going on?

Thanks in advance.

Kind regards,

Tim Poismans

1 Solution

Accepted Solutions
timpoismans
Specialist
Specialist
Author

Rolling back to an older version of Qlik Sense Desktop (Older than February 2018 Pack 1) worked as a temporary fix.

In the process of updating the client the latest version again, to see if the issue is solved.

View solution in original post

3 Replies
rittermd
Master
Master

Can you provide the actual script she is running that is blowing up?

timpoismans
Specialist
Specialist
Author

My apologies for the delay, Mark.

These are the connections:

Connections.PNG

And then follows the script, my apologies if it's too long:

LIB CONNECT TO [Oracle_DETKPD01];

F_CATEGORIE:

SELECT *

FROM "SRG"."F_CATEGORIE";

Store F_CATEGORIE into 'Lib://RawQvd/F_CATEGORIE.qvd'(qvd);

Drop table F_CATEGORIE;

/*=====================================================================================

=====================================================================================*/

B_WERFTYPE:

SELECT *

FROM "SRG"."B_WERFTYPE";

Store B_WERFTYPE into 'Lib://RawQvd/B_WERFTYPE.qvd'(qvd);

Drop table B_WERFTYPE;

/*=====================================================================================

=====================================================================================*/

F_COSTCENTER:

SELECT *

FROM "SRG"."F_COSTCENTER";

Store F_COSTCENTER into 'Lib://RawQvd/F_COSTCENTER.qvd'(qvd);

Drop table F_COSTCENTER;

/*=====================================================================================

=====================================================================================*/

B_VORDSTAAT:

SELECT *

FROM "SRG"."B_VORDSTAAT";

Store B_VORDSTAAT into 'Lib://RawQvd/B_VORDSTAAT.qvd'(qvd);

Drop table B_VORDSTAAT;

/*=====================================================================================

=====================================================================================*/

F_OPZOEKING:

SELECT *

FROM "SRG"."F_OPZOEKING";

Store F_OPZOEKING into 'Lib://RawQvd/F_OPZOEKING.qvd'(qvd);

Drop table F_OPZOEKING;

/*=====================================================================================

=====================================================================================*/

B_BESTSTAAT:

SELECT *

FROM "SRG"."B_BESTSTAAT";

Store B_BESTSTAAT into 'Lib://RawQvd/B_BESTSTAAT.qvd'(qvd);

Drop table B_BESTSTAAT;

/*=====================================================================================

=====================================================================================*/

B_FASE:

SELECT *

FROM "SRG"."B_FASE";

Store B_FASE into 'Lib://RawQvd/B_FASE.qvd'(qvd);

Drop table B_FASE;

/*=====================================================================================

=====================================================================================*/

F_PROJECT:

SELECT *

FROM "SRG"."F_PROJECT";

Store F_PROJECT into 'Lib://RawQvd/F_PROJECT.qvd'(qvd);

Drop table F_PROJECT;

/*=====================================================================================

=====================================================================================*/

F_INDREK:

SELECT *

FROM "SRG"."F_INDREK";

Store F_INDREK into 'Lib://RawQvd/F_INDREK.qvd'(qvd);

Drop table F_INDREK;

/*=====================================================================================

=====================================================================================*/

X_ADRES:

SELECT *

FROM "SRG"."X_ADRES";

Store X_ADRES into 'Lib://RawQvd/X_ADRES.qvd'(qvd);

Drop table X_AdX_ADRESres;

/*=====================================================================================

=====================================================================================*/

G_LANDPLAAT:

SELECT *

FROM "SRG"."G_LANDPLAAT";

Store G_LANDPLAAT into 'Lib://RawQvd/G_LANDPLAAT.qvd'(qvd);

Drop table G_LANDPLAAT;

/*=====================================================================================

=====================================================================================*/

F_BOEKING:

SELECT *

FROM "SRG"."F_BOEKING";

Store F_BOEKING into 'Lib://RawQvd/F_BOEKING.qvd'(qvd);

Drop table F_BOEKING;

/*=====================================================================================

=====================================================================================*/

F_DOCUMENT:

SELECT *

FROM "SRG"."F_DOCUMENT";

Store F_DOCUMENT into 'Lib://RawQvd/F_DOCUMENT.qvd'(qvd);

Drop table F_DOCUMENT;

/*=====================================================================================

=====================================================================================*/

K_AFSCHATTING:

SELECT *

FROM "SRG"."K_AFSCHATTING";

Store K_AFSCHATTING into 'Lib://RawQvd/K_AFSCHATTING.qvd'(qvd);

Drop table K_AFSCHATTING;

/*=====================================================================================

=====================================================================================*/

B_ORDER:

SELECT *

FROM "SRG"."B_ORDER";

Store B_ORDER into 'Lib://RawQvd/B_ORDER.qvd'(qvd);

Drop table B_ORDER;

/*=====================================================================================

=====================================================================================*/

B_ORDERLIJN:

SELECT *

FROM "SRG"."B_ORDERLIJN";

Store B_ORDERLIJN into 'Lib://RawQvd/B_ORDERLIJN.qvd'(qvd);

Drop table B_ORDERLIJN;

/*=====================================================================================

=====================================================================================*/

B_ARTIKELLIJN:

SELECT *

FROM "SRG"."B_ARTIKELLIJN";

Store B_ARTIKELLIJN into 'Lib://RawQvd/B_ARTIKELLIJN.qvd'(qvd);

Drop table B_ARTIKELLIJN;

/*=====================================================================================

=====================================================================================*/

B_ARTIKELLEV:

SELECT *

FROM "SRG"."B_ARTIKELLEV";

Store B_ARTIKELLEV into 'Lib://RawQvd/B_ARTIKELLEV.qvd'(qvd);

Drop table B_ARTIKELLEV;

/*=====================================================================================

=====================================================================================*/

B_WERF:

SELECT *

FROM "SRG"."B_WERF";

Store B_WERF into 'Lib://RawQvd/B_WERF.qvd'(qvd);

Drop table B_WERF;

/*=====================================================================================

=====================================================================================*/

X_FINPROLOG:

SELECT *

FROM "SRG"."X_FINPROLOG";

Store X_FINPROLOG into 'Lib://RawQvd/X_FINPROLOG.qvd'(qvd);

Drop table X_FINPROLOG;

/*=====================================================================================

=====================================================================================*/

B_LOONNAC:

SELECT *

FROM "SRG"."B_LOONNAC";

Store B_LOONNAC into 'Lib://RawQvd/B_LOONNAC.qvd'(qvd);

Drop table B_LOONNAC;

/*=====================================================================================

=====================================================================================*/

B_CALCDEF:

SELECT *

FROM "SRG"."B_CALCDEF";

Store B_CALCDEF into 'Lib://RawQvd/B_CALCDEF.qvd'(qvd);

Drop table B_CALCDEF;

/*=====================================================================================

=====================================================================================*/

M_MATERIEEL:

SELECT *

FROM "SRG"."M_MATERIEEL";

Store M_MATERIEEL into 'Lib://RawQvd/M_MATERIEEL.qvd'(qvd);

Drop table M_MATERIEEL;

/*=====================================================================================

=====================================================================================*/

F_PKLASSE:

SELECT *

FROM "SRG"."F_PKLASSE";

Store F_PKLASSE into 'Lib://RawQvd/F_PKLASSE.qvd'(qvd);

Drop table F_PKLASSE;

/*=====================================================================================

=====================================================================================*/

MANPOWER:

SELECT *

FROM "SRG"."MANPOWER";

Store MANPOWER into 'Lib://RawQvd/MANPOWER.qvd'(qvd);

Drop table MANPOWER;

/*=====================================================================================

=====================================================================================*/

DEPARTMENTS:

SELECT *

FROM "SRG"."DEPARTMENTS";

Store DEPARTMENTS into 'Lib://RawQvd/DEPARTMENTS.qvd'(qvd);

Drop table DEPARTMENTS;

/*=====================================================================================

=====================================================================================*/

PAYCODES:

SELECT *

FROM "SRG"."PAYCODES";

Store PAYCODES into 'Lib://RawQvd/PAYCODES.qvd'(qvd);

Drop table PAYCODES;

/*=====================================================================================

=====================================================================================*/

B_WERFACT:

SELECT *

FROM "SRG"."B_WERFACT";

Store B_WERFACT into 'Lib://RawQvd/B_WERFACT.qvd'(qvd);

Drop table B_WERFACT;

/*=====================================================================================

=====================================================================================*/

B_MUTNAC:

SELECT *

FROM "SRG"."B_MUTNAC";

Store B_MUTNAC into 'Lib://RawQvd/B_MUTNAC.qvd'(qvd);

Drop table B_MUTNAC;

/*=====================================================================================

=====================================================================================*/

M_MUTLIJN:

SELECT *

FROM "SRG"."M_MUTLIJN";

Store M_MUTLIJN into 'Lib://RawQvd/M_MUTLIJN.qvd'(qvd);

Drop table M_MUTLIJN;

/*=====================================================================================

=====================================================================================*/

M_FACTUUR:

SELECT *

FROM "SRG"."M_FACTUUR";

Store M_FACTUUR into 'Lib://RawQvd/M_FACTUUR.qvd'(qvd);

Drop table M_FACTUUR;

/*=====================================================================================

=====================================================================================*/

M_MUTBON:

SELECT *

FROM "SRG"."M_MUTBON";

Store M_MUTBON into 'Lib://RawQvd/M_MUTBON.qvd'(qvd);

Drop table M_MUTBON;

/*=====================================================================================

=====================================================================================*/

M_LEVERBON:

SELECT *

FROM "SRG"."M_LEVERBON";

Store M_LEVERBON into 'Lib://RawQvd/M_LEVERBON.qvd'(qvd);

Drop table M_LEVERBON;

/*=====================================================================================

=====================================================================================*/

M_BESTELBON:

SELECT *

FROM "SRG"."M_BESTELBON";

Store M_BESTELBON into 'Lib://RawQvd/M_BESTELBON.qvd'(qvd);

Drop table M_BESTELBON;

/*=====================================================================================

=====================================================================================*/

M_BESTELLIJN:

SELECT *

FROM "SRG"."M_BESTELLIJN";

Store M_BESTELLIJN into 'Lib://RawQvd/M_BESTELLIJN.qvd'(qvd);

Drop table M_BESTELLIJN;

/*=====================================================================================

=====================================================================================*/

M_WFACTUURLIJN:

SELECT *

FROM "SRG"."M_WFACTUURLIJN";

Store M_WFACTUURLIJN into 'Lib://RawQvd/M_WFACTUURLIJN.qvd'(qvd);

Drop table M_WFACTUURLIJN;

/*=====================================================================================

=====================================================================================*/

B_MANNAC:

SELECT *

FROM "SRG"."B_MANNAC";

Store B_MANNAC into 'Lib://RawQvd/B_MANNAC.qvd'(qvd);

Drop table B_MANNAC;

/*=====================================================================================

=====================================================================================*/

F_AFSCHRIJVING:

SELECT *

FROM "SRG"."F_AFSCHRIJVING";

Store F_AFSCHRIJVING into 'Lib://RawQvd/F_AFSCHRIJVING.qvd'(qvd);

Drop table F_AFSCHRIJVING;

Exit Script;

The script has been working for months without issue, so I don't know what could have caused the error.

timpoismans
Specialist
Specialist
Author

Rolling back to an older version of Qlik Sense Desktop (Older than February 2018 Pack 1) worked as a temporary fix.

In the process of updating the client the latest version again, to see if the issue is solved.