Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
A customer of mine got the following error when trying to reload her script in Qlik Sense Desktop.
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
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.
Can you provide the actual script she is running that is blowing up?
My apologies for the delay, Mark.
These are the connections:
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.
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.