topic Re: QMC 12.1 task reload error in QlikView

QMC 12.1 task reload error

Mon, 26 Jan 2026 18:19:17 GMT

Hi guys,

Recently i am hitting some task reload issue in QMC.

As per below is the error it capture in the QVW log. The error shows failed to connect to my MYSQL database.

2017-05-15 07:00:33 0037 ODBC CONNECT32 TO *** (XUserId *** ***, XPassword *** ***)

2017-05-15 07:00:33 Error: Unknown GenericConnect error

2017-05-15 07:00:33 Unknown GenericConnect error

2017-05-15 07:00:33 Execution Failed

This issue started after i upgraded my QV server from 11.2 to 12.1.

Currently we are using 12.1 SR6.

I have enable server logging at MYSQL but it did not capture any error on this.

Any idea what is this error message about? It does not have error code that i can search for.

Appreciate any kind feedback on this.

Thanks in advance!

Chong Thai

Re: QMC 12.1 task reload error

anandsai4u — Wed, 17 May 2017 07:49:27 GMT

Hi Chong Thai,

After upgraded the version, did you established the connection again instead of using old one...?

Thanks & Regards

Anand Sai

Re: QMC 12.1 task reload error

Wed, 17 May 2017 08:19:42 GMT

Hi Anand Sai,

Yes. I did established the connection again.

I thought that was the root cause too, but unfortunately the issue still persists.

Thanks!

Chong Thai

Re: QMC 12.1 task reload error

anandsai4u — Wed, 17 May 2017 10:18:00 GMT

Hi Chong Thai,

Can you please confirm whether are you using any Qlik ODBC Connector Package or something...?

Thanks & Regards

Anand Sai

Re: QMC 12.1 task reload error

sanjay006 — Wed, 17 May 2017 10:19:26 GMT

please check your tnsname.ora file.

Re: QMC 12.1 task reload error

Thu, 18 May 2017 06:19:09 GMT

Hi Sanjay,

We are using MYSQL 5.6.34, unfortunately i cant find tnsname.ora file.

Thanks,

Chong Thai

Re: QMC 12.1 task reload error

Thu, 18 May 2017 06:24:50 GMT

Hi Ananda,

We are using MySQL ODBC 5.1 connector to connect into our MYSQL.

I have recently upgraded to MYSQL ODBC 5.3 but it still hit the same issue.

This issue does not happen every time, it happened intermittently which is weird for us.

Thanks,

Chong Thai

Re: QMC 12.1 task reload error

Mon, 22 May 2017 02:00:13 GMT

Anyone encounter the same issue?

I am using MYSQL Community Server 5.6.34.

Thanks in advance!

Re: QMC 12.1 task reload error

Peter_Cammaert — Mon, 22 May 2017 20:37:42 GMT

Maybe you should ask Qlik Support for help. The Qlik ODBC Connector package requires the paying MySQL edition (Enterprise?) which is properly supported. But since it worked with QV11.20, it shouldn't cause any proplems with QV12.

Re: QMC 12.1 task reload error

aftenier — Tue, 01 Aug 2017 20:32:19 GMT

I have the same problem.

But here we use Oracle 11g and QlikView 12.10 SR7 (12.10.20500.0)...

No solution for now...

Re: QMC 12.1 task reload error

aftenier — Thu, 17 Aug 2017 14:23:34 GMT

Here we can provisionally resolve with the script below:

___________________________________________________________________________________

SET ErrorMode = 0;

LET ScriptErrorCount = 0;

LET vTentativas_Conexao_BD = 0;

LET vMax_Tentativas_Conexao_BD = 5;

SET vStatus_Conexao_BD = CARGA OK;

//Tenta conexão:

OLEDB CONNECT64 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxx;Data Source=oraprd11;Extended Properties=""] (XPassword is xxxx);

//Em caso de erro tenta novamente por até x vezes cfe parâmetro:

IF $(ScriptErrorCount) > 0 THEN

FOR vTentativas_Conexao_BD = 1 TO $(vMax_Tentativas_Conexao_BD)

IF $(ScriptErrorCount) > 0 THEN

LET ScriptErrorCount = 0;

LET vStatus_Conexao_BD = 'Erros: ' & '$(vTentativas_Conexao_BD)';

//Aguarda 5 segundos para nova tentativa de conexão e tenta novamente:

SLEEP 5000;

OLEDB CONNECT64 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxx;Data Source=oraprd11;Extended Properties=""] (XPassword is xxxxx);

ENDIF

//Sai do script em caso de sucesso (passar pela conexão novamente sem erros):

EXIT SCRIPT WHEN $(ScriptErrorCount) = 0;

ENDIF

SET ErrorMode = 1;

___________________________________________________________________________________